_______ display a graphic in the cell representing the cell value in relation to other cell
values.
Give this one a try later!
Icon sets
A _______ is text that appears at the top of every page.
Give this one a try later!
Header
Splitting your worksheet will undo the _______ command.
, Give this one a try later!
Freeze Panes
When you enter a formula with more than one mathematical operation, the formula is
not necessarily calculated left to right because Excel calculations follow the
mathematical rules called the _______.
Give this one a try later!
Order of Operations
Assuming that cell A1 contains the location of an employee, and cell B1 contains the
employee's current salary, which formula could reasonably be used to calculate a 5%
increase for employees working from New York or from San Francisco with all other
employees receiving no salary increase?
Give this one a try later!
=IF( OR( A1="NY", A1="SF"), B1*5%, 0 )
=IF(G22="x", SUM(H22:J22)," ") will display ______ if G22 is not equal to "x".
Give this one a try later!
A blank cell
values.
Give this one a try later!
Icon sets
A _______ is text that appears at the top of every page.
Give this one a try later!
Header
Splitting your worksheet will undo the _______ command.
, Give this one a try later!
Freeze Panes
When you enter a formula with more than one mathematical operation, the formula is
not necessarily calculated left to right because Excel calculations follow the
mathematical rules called the _______.
Give this one a try later!
Order of Operations
Assuming that cell A1 contains the location of an employee, and cell B1 contains the
employee's current salary, which formula could reasonably be used to calculate a 5%
increase for employees working from New York or from San Francisco with all other
employees receiving no salary increase?
Give this one a try later!
=IF( OR( A1="NY", A1="SF"), B1*5%, 0 )
=IF(G22="x", SUM(H22:J22)," ") will display ______ if G22 is not equal to "x".
Give this one a try later!
A blank cell
