Excel Review 3 Question Preview (ID: 25757)


Excel Review 3. TEACHERS: click here for quick copy question ID numbers.

Jim would like to print only the cell range A1:F20. What page setup option should he change?
a) orientation
b) page break
c) print area
d) print titles

John's workbooks includes 3 worksheets. Which option should he choose to print them?
a) print selection
b) print active sheet
c) print entire workbook
d) fit to one page

When copying values in Excel which feature automatically adjusts cell references for the new copy location?
a) absolute reference
b) certain reference
c) variable reference
d) relative reference

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) =1SBS+25
d) =b1:b3

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) =B4xC4
d) =B4-C4

jennifer is calculating her GPA. If she uses =(a1+a2+a3+a4)/4, this is an example of which type of entry?
a) values
b) formulas
c) labels
d) functions

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) =b4-c4

Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
a) count
b) if
c) now
d) today

Where can you find the insert funticon button in Excel?
a) quick access toolbar
b) formula bar
c) status bar
d) shortcut menu

Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
a) average
b) max
c) min
d) sum

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: 25757 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links