iCheck™ Series Microsoft® Office 2010

Lesson 3: Format Data and Content

Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

1
Which of the following is NOT something you can do in the Font group on the Home tab?
A)Bold the contents of a cell.
B)Horizontally center the contents of a cell.
C)Increase the size of the font used in a row.
D)Change the background color of a cell.
2
Which tab do you use to apply a border to a group of cells?
A)Home
B)Insert
C)Page Layout
D)Data
3
A(n) ____ is a predefined set of formats that can be applied to a range of data.
A)function argument
B)gridline
C)font style
D)table style
4
To hide a row of cells, choose ____.
A)View>Row>Hide
B)View>Cells>Format
C)Home>Row>Hide
D)Home>Cells>Format>Hide & Unhide
5
In the Format Cells dialog box, which tab do you click to change the color of a cell's contents?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903631/U2L3Q5.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (95.0K)</a>

A)A
B)B
C)C
D)D
6
Before you can change the width of a column by dragging its dividing line, the pointer must appear as a ____.
A)cross
B)single arrow
C)double arrow
D)thin vertical line
7
When a number is positioned half way between the top and the bottom of a cell, it ____.
A)is vertically aligned
B)is horizontally aligned
C)has had a cell style applied to it
D)has had a table style applied to it
8
In this worksheet, "Jones Food Supply" is ____.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903631/U2L3Q8.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (165.0K)</a>

A)horizontally centered within a cell
B)centered across a selection of cells
C)vertically aligned at the top of the cell
D)had a SmartArt graphic applied to it
9
Why might you want to hide a worksheet's gridlines?
A)To save space.
B)To make the worksheet easier to read.
C)To see how the worksheet will look when it is printed.
D)To simplify adding styles to the worksheet's contents
10
Which of these is the easiest way to insert a graphical list into a worksheet?
A)WordArt
B)Text Box
C)SmartArt
D)Table Tools
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe