If you type =Sum(B7+D7) into a cell, which of the following best describes what you have entered?

Which of the formulas is the correct way to calculate the value of A7 taken from the value of C12?

If you copy a formula from one cell into another, which type of reference will automatically adjust the cell references based on the new location?

If you have a cell in your spreadsheet that contains a formula such as =(BudgetUS!B3), what does the BudgetUS represent?

What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

If you create a spreadsheet with a cell that contains =SUM(Income) What does the (Income) represent?

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

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?

Which formula divides C3 by C7?

You need to create a formula that does not change when it is copied to cell E2. Which formula should you create?

What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?

Teachers: Create FREE classroom games with your questions Click for more info!
©2007-2024 Review Game Zone | About | Privacy | Contact | Terms | Site Map