review

Front

The F4 shortcut within a calculation in a spreadsheets performs what task?

Back

Changes a cell reference from absolute to relative to mixed

Front

What symbol is a wildcard used in MS Excel to represent 1 just character or just 1 position in a text string?

Back

?

Front

Which tab/ribbon in MS Excel has the command/option for users to show or hide all calculations at once?

Back

FORMULAS

Front

What type of reference inside a calculation would lock the column but not the row (i.e. $B10)?

Back

mixed

Front

Which type of math would be done first =Sum(B4:B70)/B75?

Back

addition

Front

How many specific products had sales of more than 5,000?

Back

COUNTIF

Front

All of the following are reasons to create/use named ranges, except?
can make it easier to identify a range within a function,
can help with navigation to a cell or range,
serves the same purpose as absolute references,
it helps to eliminate parts of a function

Back

it helps to eliminate parts of a function

Front

All are correct use of parenthesis with MS Excel calculations, EXCEPT? Options: =SUM(F5:F100)/F1, =(A1+A3)/$B$10, =IFERROR(SUM(A1:A25),"help"), =AVERAGEIF(C1:C10), ">100", (G1:G10

Back

=AVERAGEIF(C1:C10), ">100", (G1:G10

Front

What is the correct comparison operator to find greater or equal to?

Back

>=

Front

All of the following are parts of the IF function, except? TRUE value, FALSE value, logical test

Back

criteria range