Microsoft Excel Quiz Questions with Answers

Microsoft Excel multiple choice questions (MCQ) for objective, competitive exams. Here are objective type questions in Excel for practice. These Excel questions are for beginners. You can use these questions to test knowledge of your students if you're a Trainer or Teacher.

Here are Excel Quiz questions with answers :

An Excel file is generally called a / an

A. E-Spreadsheet

B. Worksheet

C. Workbook ✔️

D. Sheet

In Excel, which one denoted a range from B1 through E5

A. B1 - E5

B. B1:E5 ✔️

C. B1 to E5

D. B1$E5

How many sheets are there, by default, when we create a new Excel file?

A. 1

B. 3 ✔️

C. 5

D. 10

The basic unit of a worksheet into which you enter data in Excel is called a

A. cell ✔️

B. table

C. box

D. column

What type of chart is good for a single series of data?

A. Column Chart

B. Line Chart

C. Pie Chart ✔️

D. Cone Chart

What type of chart is useful for comparing parts of a whole?

A. Pie Chart ✔️

B. Column Chart

C. Line Chart

D. Dot Graph

The feature of MS Excel quickly completes a series of data

A. Auto Complete

B. Auto Fill ✔️

C. Fill Handle

D. Sorting

What type of chart is useful for showing trends or changes over time?

A. Pie Chart

B. Column Chart

C. Line Chart ✔️

D. Dot Graph

The Greater Than sign > is an example of which operator.

A. Arithmetic

B. Logical ✔️

C. Conditional

D. Greater

In Excel, Columns are labelled as

A. A, B, C, etc ✔️

B. 1,2,3 etc

C. A1, A2, etc.

D. $A$1, $A$2, etc.

Which function in Excel checks whether a condition is true or not?

A. SUM

B. COUNT

C. IF ✔️

D. AVERAGE

Which one is not a Function in MS Excel ?

A. SUM

B. AVG ✔️

C. MAX

D. MIN

What type of chart will you use to compare performance of two employees?

A. Column Chart

B. Line Chart ✔️

C. Pie Chart

D. Dot Chart

What type of chart is useful for comparing values over categories?

A. Pie Chart ✔️

B. Column Chart

C. Line Chart

D. Dot Graph

What is the intersection of a column and a row on a worksheet called?

A. Column

B. Value

C. Address

D. Cell ✔️

This is not a function category in Excel

A. Logical

B. Text

C. Financial

D. Data series ✔️

Typed text showed in active cell and also in

A. Formula bar ✔️

B. Ribbon

C. Title bar

D. Scroll bar

Another name for a pre-programmed formula in Excel is

A. Cell

B. Graph

C. Function ✔️

D. Range

Which term is used to join the selected cells into one cell?

A. Filter

B. Wrap

C. Pivot

D. Merge ✔️

What is the default extension of a saved file in MS Excel?

A. .xlsx ✔️

B. .xlsm

C. .xlsb

D. .xltx

A paragraph.

Watch video instead ?

Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Steps to Turn On Offline Access for Google Docs, Sheets and Slides

Image
You aren't connected to the Internet but still want to work on Google Docs files? Then follow below steps to create, edit or view Google Docs, Sheets and Slides files while you're offline. Connect to the internet. Open or Install Google Chrome browser. Install Google Docs Offline Chrome extension. ( Click Here to Open Install Page ) Open Google Drive Click on Settings Check the box next to "Create, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline. Done Now you can click on File menu of any Google Docs, Sheets and Slides file and click Make available offline to use that file offline. Alternatively, you can right click on files in Google Drive and then click on Available offline. Watch detailed video on this:
Read more