iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 3: Advanced Data Formatting

Self Checks

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

1
Which of these numbers matches this custom number format: ####.##-X
A)1,089.05X
B)1,089.05-X
C)1089.05X
D)1089.05-X
2
____ is applied only to data that meet specified criteria.
A)Custom number formatting
B)Conditional formatting
C)A sizing handle
D)A theme
3
Which of the following describes this menu?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L3Q3.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"> (43.0K)</a>
A)It allows you to create a chart based on worksheet data.
B)It can be used to apply custom formatting to a number.
C)It can be used to apply conditional formatting to a cell.
D)it can be used to modify a graphic.
4
Which of these tabs contains a button that lets you rotate a graphic?
A)Home
B)Insert
C)Data
D)Format
5
The sizing handle is used to ____.
A)scale a graphic
B)increase or decrease a graphic's brightness
C)increase or decrease a graphic's contrast
D)increase or decrease a graphic's size
6
Which of these buttons lets you increase a graphic's contrast?
A)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L3Q7a.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"> (18.0K)</a>
B)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L3Q7b.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"> (18.0K)</a>
C)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L3Q7c.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"> (18.0K)</a>
D)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L3Q7d.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"> (18.0K)</a>
7
You can change the format of most parts of a chart by ____.
A)choosing Layout>Chart
B)right-clicking the chart
C)double-clicking the chart
D)dragging part of the chart to where you want it
8
To apply several pre-defined formats, such as 3-D effects, colors, and fonts in a single step, use a ____.
A)conditional format
B)custom format
C)theme
D)rules manager
9
What is a legend?
A)A number format designed by a user.
B)The part of a chart that indicates what each color or pattern represents.
C)The title of a chart or graph.
D)A dot at the edge of a selected graphic that can be dragged to resize the graphic.
10
Which of the following is not a part of a chart that you can format on the Layout tab?
A)Chart title
B)Chart theme
C)Chart wall
D)Chart legend
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe