Which function checks a condition?
Count
Count A
If
AVG
If we used =A1:F1 B2:B10 Excel would display the _______.
#Value!
#####
#Name
#NULL!
A____________ in a Excel sheet identifies the location of the cell in the spreadsheet.
Cell value
Cell Number
Cell Address
None of these
___________ is an electronic spreadsheet program that can be used for storing, organizing and manipulating data.
Word
Excel
Paint
Table
In__________,functions are pre-defined formulas that perform specific calculations.
MS Word
MS Paint
MS Excel
______ error occurs when the wrong type of argument or operand is used.
#Name?
#Num!
_________ can be as simple as adding two numbers or can be complex calculations needed for high end business projections.
Auto sum
Auto fill
Formulas
Value
___________making it easier to read data on larger worksheets.
Gridlines
Dark lines
