Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Access Final Reveiw 21-40
Test Description: Excel access final reveiw 21-40
Instructions: Answer all questions to get your test result.
1) Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
A
address box
B
name box
2) Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
A
entry
B
workbook
3) Where can you find the Insert Function button in Microsoft Excel?
A
status bar
B
formula bar
4) Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
A
orientation
B
wrap text
5) Jim would like to print only the cell range A1:F20. What page setup option should he change?
A
page break
B
print area
6) Which view is the default view used in Microsoft Excel?
A
page layout
B
normal
7) Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
A
freeze
B
hide
8) Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
A
date
B
currency
9) Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
A
page setup
B
sheet option
10) Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
A
conditional formatting
B
format as table
11) Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
A
effects
B
break
12) Trey would like to outline the cell range A1:F20. Which formatting style should he select?
A
borders
B
cell style
13) Which term describes the blank portions of a page that fall outside the main body of the printed document?
A
margins
B
frames
14) What defines the color of the characters in an Microsoft Excel worksheet?
A
font color
B
cell color
15) Which command do you use to reduce the margin between the border and the text in an indented cell?
A
alignment
B
decrease indent
16) Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
A
hide
B
scale
17) On the Home Ribbon, what do you use to change the text color of characters in a cell?
A
Font Color drop-down list
B
Fill Color drop-down list
18) What command do you use to apply a background color to cells in a worksheet?
A
borders
B
fill color
19) Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?
A
page break
B
print titles
20) Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
A
fill color
B
cell style
*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?