Show:
A
B
C
D
E
100
To ensure that the reference to a specific cell does not change when you copy a cell, use __________ cell referencing. a. absolute b. relative c. mixed d. abstract
What is a. absolute
100
Displaying a horizontal line through the middle of text is known as: a. embossing. b. engraving. c. highlighting. d. strikethrough.
What is d. strikethrough.
100
Excel uses __________ that perform mathematical operations to produce calculated results. a. programs b. macros c. procedures d. formulas
What is d. formulas
100
When you press the Tab key from the last cell in a table, what happens? a. The cursor moves outside of the table. b. You return to the first cell of the table. c. A new column is added to the table. d. A new blank row is added.
What is d. A new blank row is added.
100
A(n) __________ is tested in an IF function to determine if it is true or false. a. formula b. condition c. option d. feature
What is b. condition
200
What button reveals nonprinting characters? a. F12 b. The Show/Hide button c. The Show button d. The Reveal Formatting button
What is b. The Show/Hide button
200
Cells must be __________ and the sheet protected to prevent edits being made to the data. a. secured b. formatted c. values d. locked
What is d. locked
200
The feature that allows a writer to continue typing until she has reached the end of a paragraph is known as: a. word processing. b. word wrap. c. hard return. d. easy return.
What is b. word wrap.
200
Which of the following would NOT be considered formatting? a. Changing the type size b. Changing the font type c. Emphasizing certain text d. Using the Thesaurus
What is d. Using the Thesaurus
200
If there are certain columns of information that you do not want to be viewed by others, __________ the columns. a. format b. freeze c. delete d. hide
What is d. hide
300
How many bits is a byte? a. 56 b. 8 c. 2 d. 1,024
What is b. 8
300
__________ show you where information separates at the bottom of one page and the top of the next. a. Page breaks b. Formatting symbols c. Paragraph tags d. Widows and Orphan settings
What is a. Page breaks
300
B5:C10 is an example of a cell: a. range. b. macro. c. location. d. style.
What is a. range.
300
When a worksheet file is active, it is: a. saved on your hard drive. b. accessible from the Web. c. in ROM. d. in RAM.
What is d. in RAM.
300
To find the smallest number in a range of cells, use the __________ function. a. MAX b. MIN c. AVERAGE d. LOW
What is b. MIN
400
To prevent a Social Security number from breaking to the next line, use: a. hard line breaks. b. nonbreaking spaces. c. nonbreaking marks. d. nonbreaking hyphens.
What is d. nonbreaking hyphens
400
The types of cell referencing available in Excel are mixed, absolute, and: a. relative. b. stationery. c. pragmatic. d. abstract.
What is a. relative.
400
When you enter data into a table that you've created, the text: a. automatically wraps in the cell. b. continues in the cell below. c. remains on one line and stretches the cell width. d. overlaps into the following cell.
What is a. automatically wraps in the cell.
400
Which of the following is NOT true about the cut, copy, and paste commands? a. Copy removes the text from its original location. b. Copy makes a duplicate. c. Cut removes the text from its original location. d. Paste places cut or copied text into a new location.
What is a. Copy removes the text from its original location.
400
A typeface that contains a narrow line or extension at the top and bottom of the primary strokes on characters is known as: a. sans serif. b. serif. c. kerning. d. monospaced.
What is b. serif.
500
To display and print a chart full-size, create it as a(n): a. separate worksheet. b. thumbnail. c. embedded chart. d. GIF image.
What is a. separate worksheet.
500
Option buttons, check boxes, and spin buttons are components of: a. styles. b. alert boxes. c. dialog boxes. d. windows.
What is c. dialog boxes.
500
The __________ pane shows all comments and editorial changes made to a document. a. Document Map b. Reference c. Reviewing d. Thumbnails
What is c. Reviewing
500
__________ column and row headings enable you to view data easily in large spreadsheets. a. Tiling b. Resizing c. Freezing d. Formatting
What is c. Freezing
500
What feature monitors all additions, deletions, and formatting changes in a document? a. Revision Marks b. References c. Track Changes d. View document
What is c. Track Changes