MS Excel MCQs

Question 1

Which symbol must all formula begin with?

Accepted Answer

=

Answer

+

Answer

(

Answer

@

Question 2

Which of the following formulas is not entered correctly?

Accepted Answer

10+50

Answer

=10+50

Answer

=B7*B1

Answer

=B7+14

Question 3

Which of the following formulas will Excel not be able to calculate?

Accepted Answer

=SUM(Sales)-A3

Answer

=SUM(A1:A5)*.5

Answer

=SUM(A1:A5)/(10-10)

Answer

=SUM(A1:A5)-10

Question 4

A typical worksheet has ________ number of columns.

Accepted Answer

16384

Answer

128

Answer

256

Answer

1024

Question 5

How many characters can be typed in a single cell in Excel?

Accepted Answer

32767

Answer

256

Answer

1024

Answer

65535

Question 6

A worksheet can have a maximum of ________ number of rows.

Accepted Answer

1048576

Answer

256

Answer

1024

Answer

65535

Question 7

Which of the following is not an example of a value?

Accepted Answer

Serial Number 50771

Answer

350

Answer

May 10, 2001

Answer

0.57

Question 8

The chart wizard term data series refers to

Accepted Answer

A collection of chart data markers

Answer

A chart legend

Answer

A set of values you plot in a chart

Answer

A data label

Question 9

The Chart wizard term data categories refers to;

Accepted Answer

A horizontal axis

Answer

A chart plot area

Answer

The organization of individual values with a chart’s data series

Answer

The data range that supply chart data