MCQs

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 251 - 260 of 1111 Questions

A worksheet can have a maximum of …. Number of rows

A 256
B 1024
C 32000
D 65535
Correct Answer

Option D: 65535


Discussion

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

A 256
B 1024
C 32000
D 65535
Correct Answer

Option D: 65535


Discussion

A typical worksheet has …. Number of columns

A 128
B 256
C 512
D 1024
Correct Answer

Option B: 256


Discussion

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

Option A: =SUM(Sales)-A3


Discussion

Which of the following formulas is not entered correctly?

A =10+50
B =B7*B1
C =B7+14
D 10+50
Correct Answer

Option D: 10+50


Discussion

Which symbol must all formula begin with?

A =
B +
C (
D @
Correct Answer

Option A: =


Discussion

What symbol is used before a number to make it a label?

A ” (quote)
B = (equal)
C _ (underscore)
D ‘ (apostrophe)
Correct Answer

Option D: ‘ (apostrophe)


Discussion

Which of the following is an absolute cell reference?

A !A!1
B $A$1
C #a#1
D A1
Correct Answer

Option B: $A$1


Discussion

Which menu option can be sued to split windows into two

A Format > window
B View > window > split
C Window > split
D View > split
Correct Answer

Option C: Window > split


Discussion

The Autosum feature

A extends a sequential series of data
B automatically adds range of cell values
C applies a boarder around the selected cells
D none of the above
Correct Answer

Option B: automatically adds range of cell values


Discussion



WhatsApp Support