Excel Access Final Reveiw 21-40 Question Preview (ID: 19971)


Excel Access Final Reveiw 21-40. TEACHERS: click here for quick copy question ID numbers.

Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
a) name box
b) address box
c)
d)

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) workbook
b) entry
c)
d)

Where can you find the Insert Function button in Microsoft Excel?
a) formula bar
b) status bar
c)
d)

Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
a) wrap text
b) orientation
c)
d)

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

Which view is the default view used in Microsoft Excel?
a) normal
b) page layout
c)
d)

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
a) hide
b) freeze
c)
d)

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
a) currency
b) date
c)
d)

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
a) sheet option
b) page setup
c)
d)

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
a) format as table
b) conditional formatting
c)
d)

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
a) break
b) effects
c)
d)

Trey would like to outline the cell range A1:F20. Which formatting style should he select?
a) borders
b) cell style
c)
d)

Which term describes the blank portions of a page that fall outside the main body of the printed document?
a) margins
b) frames
c)
d)

What defines the color of the characters in an Microsoft Excel worksheet?
a) font color
b) cell color
c)
d)

Which command do you use to reduce the margin between the border and the text in an indented cell?
a) decrease indent
b) alignment
c)
d)

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
a) scale
b) hide
c)
d)

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
c)
d)

What command do you use to apply a background color to cells in a worksheet?
a) fill color
b) borders
c)
d)

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) print titles
b) page break
c)
d)

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
a) cell style
b) fill color
c)
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: 19971 in the upper right hand corner or click here.

TEACHERS / EDUCATORS
Log In | Sign Up / Register

Help / Support / FAQ




Gaming Links