Microsoft Excel 1.04

Match it! Select the correct answer from the pull down...Good luck!

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?

What term is used when referencing cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). 'Sales' is an example of a/an:

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

How is a cell reference in a formula and its corresponding location in a worksheet identified?

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?