Excel 1.04 Question Preview (ID: 38708)


Using Basic Formulas. TEACHERS: click here for quick copy question ID numbers.

Jennifer is calculating her GPA. If she uses =(A1+A2+A3+A4)/4, this is an example of which type of entry
a) formulas
b) labels
c) values
d)

Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
a) =B4/C4
b) =B4-C4
c) =B4+C4
d)

When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
a) absolute reference
b) Certain reference
c) Relative reference
d)

Joshua created a budget workbook that contains the formula =(Summary!B3). Summary is an example of a(n):
a) named range.
b) external reference
c) scope.
d)

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?
a) Worksheet Reference
b) Sheet Name
c) Calling the Sheet
d)

Tyler created a monthly sales workbook that contains the formula =SUM(Sales). Sales is an example of a(n):
a) named range
b) names manager.
c) external reference.
d)

How is a cell reference in a formula and its corresponding location in a worksheet identified?
a) Cell reference and cell location are circled
b) Cell reference and cell location are outlined in matching colors
c) Lines connect from the formula to the location
d)

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?
a) Absolute
b) mixed
c) relative
d)

Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
a) =B4+C4
b) =B4-C4
c) =B4*C4
d)

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
a) =$B$1+25
b) =B1+25
c) =1$B$+25
d)

Tyler created a monthly sales workbook that contains the formula =(January!B3). January is an example of a(n):
a) external reference.
b) named range.
c) scope.
d)

What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
a) Copy using the Quick Access Toolbar
b) Copy from the Home Ribbon
c) Copy using the Fill Handle
d)

Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 38708 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links