A
B
C
D
E
100
The best tool to use to copy bold, Times New Roman 12 pt, and blue font color from one subheading to all other subheadings is the: a. Copy and Paste buttons. b. Copy and Paste Special buttons. c. Format Painter button. d. Highlight button.
What is c. Format Painter button.
100
Where is the status bar located in Office 2007? a. At the bottom b. Under the title bar c. On the left d. On the right
What is a. At the bottom
100
To provide your viewers with an explanation of the representations of the colors utilized in the data series in your chart, provide a: a. note. b. legend. c. diagram. d. pop-up comment box.
What is b. legend.
100
What is the standard shape of markup balloons? a. Squares b. Circles c. Rectangles d. Triangles
What is b. Circles
100
All __________ in Excel begin with an equal (=) sign. a. dates b. formulas c. Macros d. textual phrases
What is b. formulas
200
The power of Excel comes from its functions and __________ which enable accurate and quick calculations. a. charts b. styles c. formulas d. formats
What is c. formulas
200
Dragging a corner sizing handle while holding the Shift key: a. rotates the image. b. deletes the image. c. changes the height of the object. d. resizes the image, but keeps the proportion intact.
What is d. resizes the image, but keeps the proportion intact.
200
The Page Number command is in the __________ group. a. Header & Footer b. Text c. Page Setup d. Paragraph
What is a. Header & Footer
200
A formula in Excel begins with a(n): a. $. b. /. c. *. d. =.
What is d. =.
200
To display items in a chart based on percentages, use a __________ chart. a. cluster b. pie c. box d. column
What is b. pie
300
If an image or document on the Internet is deemed __________, it is freely available for use by the general population. a. educational exclusion b. public domain c. public property d. fair use
What is b. public domain
300
How can you save a file as a different type? a. Use the File version as box b. Use the File type box c. Use the Save As type box d. Use the Save As version box
What is c. Use the Save As type box
300
The _____ perform(s) actual calculations and is (are) often called the "brain(s)" of the computer. a. central processing unit (CPU) b. motherboard c. memory d. input devices
What is a. central processing unit (CPU)
300
To organize a set of files that all pertain to the same project, put them in a: a. program. b. view. c. box. d. folder.
What is d. folder.
300
Word 2007 is a: a. work production program. b. wordsmithing program. c. word processing program. d. word processor and database.
What is c. word processing program.
400
The Undo button is located on the: a. Title bar. b. Shortcut menu. c. Quick Access Toolbar. d. Dialog Box Launcher.
What is c. Quick Access Toolbar.
400
Table data can be __________ to arrange it in a logical order. a. formatted b. programmed c. plotted d. sorted
What is d. sorted
400
The __________ function can be used to find an answer located in a vertical table. a. SEARCH b. VLOOKUP c. HLOOKUP d. FIND
What is b. VLOOKUP
400
What do you use to view portions of a document not currently visible on the screen? a. End key b. Vertical ruler c. Scrollbars d. Standard toolbar
What is c. Scrollbars
400
The Font Color tool is located in the __________ group on the Home ribbon. a. Insert b. Styles c. Font d. Paragraph
What is c. Font
500
All of the following are reasons to save an existing file with the Save As command EXCEPT to: a. save it as a different file type. b. save it with a new name. c. have it save automatically over the previous version. d. save it to a new location.
What is c. have it save automatically over the previous version.
500
=$E2+$C3-G$4 is an example of a formula using __________ cell references. a. mixed b. constant c. absolute d. relative
What is a. mixed
500
To make information unreadable to users, __________ it. a. encrypt b. hide c. sort d. highlight
What is a. encrypt
500
To display similar data in a single column, with each series of data distinguished by a different color, use a: a. pie chart. b. stacked column chart. c. 3D column chart. d. box diagram.
What is b. stacked column chart.
500
To force a new page, insert a: a. hard page break. b. soft page break. c. hard line break. d. hard return.
What is a. hard page break.
M
e
n
u