Find the smallest value in cells B2:Z12
Give this one a try later!
=MIN(B2:Z12)
Find the total number of values listed in cells C1 through C10, excluding any that
contain text.
Give this one a try later!
=COUNT(C1:C10)
Find the average value in cells C1 through C10, assuming blank cells will be ignored
, Give this one a try later!
=AVERAGE(C1:C10)
Define syntax
Give this one a try later!
order of arguments in a function
#VALUE!
Give this one a try later!
Wrong argument type or operand
what formula could you use to add up cell C1 from Sheet1!, Sheet2!, and Sheet3!
(assuming the worksheets are adjacent and in the same workbook)
Give this one a try later!
...
When writing formulas, why is it preferable to use cell references rather than typing in
values?
Give this one a try later!
=MIN(B2:Z12)
Find the total number of values listed in cells C1 through C10, excluding any that
contain text.
Give this one a try later!
=COUNT(C1:C10)
Find the average value in cells C1 through C10, assuming blank cells will be ignored
, Give this one a try later!
=AVERAGE(C1:C10)
Define syntax
Give this one a try later!
order of arguments in a function
#VALUE!
Give this one a try later!
Wrong argument type or operand
what formula could you use to add up cell C1 from Sheet1!, Sheet2!, and Sheet3!
(assuming the worksheets are adjacent and in the same workbook)
Give this one a try later!
...
When writing formulas, why is it preferable to use cell references rather than typing in
values?
