Microsoft Excel Questions

MCQ bookmark_border

181.

Which symbol must all formula begin with?

A

=

B

+

C

(

D

@

Correct Answer: A

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

182.

Which of the following formulas is not entered correctly?

A

=10+50

B

=B7*B1

C

=B7+14

D

10+50

Correct Answer: D

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Here in option D 10+50 there is no equal sign (=), so it is not correct.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

183.

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

A

=SUM(Sales)-A3

B

=SUM(A1:A5)*.5

C

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

D

=SUM(A1:A5)-10

Correct Answer: A

SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

184.

A typical worksheet has ________ number of columns.

A

128

B

256

C

1024

D

16384

Correct Answer: D

Excel 2003 and earlier 256
(as label 'IV') columns.
Excel 2007 and higher 16,384 (as label 'XFD') columns.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

185.

A typical worksheet has ________ number of columns.

A

128

B

256

C

1024

D

16384

Correct Answer: D

Excel 2003 and earlier 256
(as label 'IV') columns.
Excel 2007 and higher 16,384 (as label 'XFD') columns.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

186.

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

A

256

B

1024

C

65535

D

1048576

Correct Answer: D

Excel 2003 and earlier 65,536 Rows.
Excel 2007 and higher 1,048,576 Rows.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

187.

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

A

350

B

May 10, 2001

C

0.57

D

Serial Number 50771

Correct Answer: D

Serial Number 50771 is alpha numeric can not be considered as value.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

188.

The chart wizard term data series refers to

A

A chart legend

B

A collection of chart data markers

C

A set of values you plot in a chart

D

A data label

Correct Answer: B

The chart wizard term data series refers to a collection of chart data markers.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

189.

The Chart wizard term data categories refers to;

A

A chart plot area

B

A horizontal axis

C

The organization of individual values with a chart

D

The data range that supply chart data

Correct Answer: B

The Chart wizard term data categories refers to a horizontal axis.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

190.

The Chart wizard term data categories refers to;

A

A chart plot area

B

A horizontal axis

C

The organization of individual values with a chart

D

The data range that supply chart data

Correct Answer: B

The Chart wizard term data categories refers to a horizontal axis.

Check Answer report_problem Report forum Discussion