MS Excel MCQs

Question 1

What does COUNTA () function do?

Accepted Answer

Counts non-empty cells

Answer

Counts cells having alphabets

Answer

Counts empty cells

Answer

Counts cells having number

Question 2

What is the short cut key to highlight the entire column?

Accepted Answer

Ctrl + Space Bar

Answer

Ctrl + C

Answer

Ctrl + Enter

Answer

Ctrl + Page Up

Question 3

In the formula, which symbol specifies the fixed columns or rows?

Accepted Answer

$

Answer

*

Answer

%

Answer

&

Question 4

Excel displays the current cell address in the ________

Accepted Answer

Name Box

Answer

Formula bar

Answer

Status Bar

Answer

Title Bar

Question 5

What is the correct way to refer the cell A10 on sheet3 from sheet1?

Accepted Answer

Sheet3!A10

Answer

Sheet1!A10

Answer

Sheet3.A10

Answer

A10

Question 6

Which language is used to create macros in Excel?

Accepted Answer

Visual Basic

Answer

C

Answer

Visual C++

Answer

Java

Question 7

Which of the following is not a term of MS-Excel?

Accepted Answer

Document

Answer

Cells

Answer

Rows

Answer

Columns

Question 8

How many worksheets can a workbook have?

Accepted Answer

none of above

Answer

3

Answer

8

Answer

255

Question 9

Which would you choose to create a bar diagram?

Accepted Answer

Insert, Chart

Answer

Edit, Chart

Answer

Tools, Chart

Answer

Format, Chart