In Excel, by default Numeric Values appears in
Left aligned
Right aligned
Center aligned
Justify aligned
SHOW ANSWERIn Excel _____may not contain in Formula
Text Constant
Number Constant
Circular Reference
All of the above
SHOW ANSWERWhat should be adding before a fraction to avoid entering it as a date?
//
Zero
Space
None of the above
SHOW ANSWERIn Excel, a Data series is defined as what?
A collection of related data
A type of chart
A cell reference
None of the above
SHOW ANSWERText Formula
Replace cell references
Return ASCII value of characters
Concatenate and manipulate text
None of the above
SHOW ANSWERThe Name Box
Appears below the status bar
Appears to the left of the formula bar
Shows the location of the previously active cell
None of the above
SHOW ANSWERHyperlinks can be
Text
Picture
Drawing
All of the above
SHOW ANSWERTo create formula, you can use
Values and cell references
Values but not cell references
Cell references but not values
None of the above
SHOW ANSWERWhich of the following is the oldest spreadsheet package?
Excel
Starcalc
VisiCalc
None of the above
SHOW ANSWERWhich of the following is an absolute cell reference?
!A!1
$A$1
#A#1
A1
SHOW ANSWERWhat symbol is used before a number to make it a label?
“(quote)
=(equal)
–(underscore)
‘(apostrophe)
SHOW ANSWERWhich of the following formulas is not entered correctly?
=10+50
=B7*B5
=B7+14
10+15
SHOW ANSWERWhich of the following formulas will Excel Not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
SHOW ANSWER