0
Login

MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 81 - 90 of 336 Questions

75 Details Computer Science MS Excel Easy

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
77 Details Computer Science MS Excel Easy

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
84 Details Computer Science MS Excel Easy

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
71 Details Computer Science MS Excel Easy

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
81 Details Computer Science MS Excel Easy

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
82 Details Computer Science MS Excel Easy

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
78 Details Computer Science MS Excel Easy

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

A $
B *
C %
D &
Correct Answer

Option A: $

Discussion
82 Details Computer Science MS Excel Easy

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
78 Details Computer Science MS Excel Easy

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
80 Details Computer Science MS Excel Easy

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


Computer Science

WhatsApp Support