Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Review 3
Test Description: Excel review 3
Instructions: Answer all questions to get your test result.
1) Jim would like to print only the cell range A1:F20. What page setup option should he change?
A
print area
B
print titles
C
page break
D
orientation
2) John's workbooks includes 3 worksheets. Which option should he choose to print them?
A
fit to one page
B
print active sheet
C
print entire workbook
D
print selection
3) When copying values in Excel which feature automatically adjusts cell references for the new copy location?
A
certain reference
B
relative reference
C
variable reference
D
absolute reference
4) 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:b3
C
=B1+25
D
=1SBS+25
5) Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
A
=B4*C4
B
=B4xC4
C
=B4+C4
D
=B4-C4
6) jennifer is calculating her GPA. If she uses =(a1+a2+a3+a4)/4, this is an example of which type of entry?
A
functions
B
values
C
labels
D
formulas
7) 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
8) 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
9) Where can you find the insert funticon button in Excel?
A
status bar
B
shortcut menu
C
quick access toolbar
D
formula bar
10) 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
sum
B
average
C
min
D
max
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?