MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 81 - 90 of 1111 Questions

Which would you choose to create a bar diagram?

A Edit, Chart
B Insert, Chart
C Tools, Chart
D Format, Chart
Correct Answer

Option B: Insert, Chart


Discussion

How many worksheets can a workbook have?

A 3
B 8
C 255
D none of above
Correct Answer

Option D: none of above


Discussion

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

A Cells
B Rows
C Columns
D Document
Correct Answer

Option D: Document


Discussion

Which language is used to create macros in Excel?

A Visual Basic
B C
C Visual C++
D Java
Correct Answer

Option A: Visual Basic


Discussion

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

A sheet3!A10
B sheet1!A10
C Sheet3.A10
D A10
Correct Answer

Option A: sheet3!A10


Discussion

Excel displays the current cell address in the ……….

A Formula bar
B Status Bar
C Name Box
D Title Bar
Correct Answer

Option C: Name Box


Discussion

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

A $
B *
C %
D &
Correct Answer

Option A: $


Discussion

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

A Ctrl+C
B Ctrl+Enter
C Ctrl+Page Up
D Ctrl+Space Bar
Correct Answer

Option D: Ctrl+Space Bar


Discussion

What does COUNTA () function do?

A counts cells having alphabets
B counts empty cells
C counts cells having number
D counts non-empty cells
Correct Answer

Option D: counts non-empty cells


Discussion

How do you wrap the text in a cell?

A Format, cells, font
B Format, cells, protection
C format, cells, number
D Format, cells, alignment
Correct Answer

Option D: Format, cells, alignment


Discussion



WhatsApp Support