Explain the difference between absolute and relative cell references.
Absolute referencing for a cell will fix that cell name/address and Relative referencing will allow cell names/addresses to be changed when formula is copied.
Describe how you would display the formulae used in a spreadsheet rather than the values.
Select the Formulas tab. In the Formula auditing section. Click on the Show Formulas icon.
Unlock this slideshow and over 4 million more with Baamboozle+