True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
When data is too wide to fit in a cell, the part that does not fit will be
deleted.
|
|
|
2.
|
To access the AutoFill Options shortcut menu, double-click the column head of
the data column you want to fill.
|
|
|
3.
|
Cell references must be entirely absolute or entirely relative.
|
|
|
4.
|
You can only insert photos and clip art that are stored in the Office
Collections folder.
|
|
|
5.
|
The AutoCheck feature automatically corrects common typing mistakes as you enter
text.
|
|
|
6.
|
Dates are automatically formatted in the default style dd-mm-yy.
|
|
|
7.
|
The only alignment option for page numbers is centered.
|
|
|
8.
|
To remove cell data, you can simply press the Delete key.
|
|
|
9.
|
You cannot create a new presentation based on an existing presentation.
|
|
|
10.
|
When resizing a graphic, you can see the effects of the change on your screen as
you drag the sizing handle.
|
|
|
11.
|
You can use multiple fonts in one document.
|
|
|
12.
|
You can only add new slides when the presentation is displayed in Normal
view.
|
|
|
13.
|
If you have labels at the top of your columns, you must sort them along with
other data.
|
|
|
14.
|
It is possible to pause a print job in the middle of printing.
|
|
|
15.
|
Most PowerPoint design templates are available in only one color scheme.
|
|
|
16.
|
When you create a callout, the AutoShape is automatically formatted as a text
box so you can add text inside the object.
|
|
|
17.
|
To apply an AutoFormat, you must first select the range of cells to be
formatted.
|
|
|
18.
|
Using too many fonts or too many different formats generally makes the text
harder to read.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
19.
|
To adjust where a text column stops, you can insert a ____ break.
a. | hard page | c. | soft page | b. | soft column | d. | hard column |
|
|
|
20.
|
To move the insertion point to the last cell with data in a row, you would
____.
a. | press Ctrl + right arrow | c. | triple-click | b. | press
F5 | d. | either a or
b |
|
|
|
21.
|
To sort data in Excel, you must indicate the ____ you want to sort.
a. | row | c. | header | b. | column | d. | numbers |
|
|
|
22.
|
The symbol that tells Excel what mathematical operation to carry out is the
____.
a. | operator | c. | argument | b. | operand | d. | function |
|
|
|
23.
|
A note inserted at the bottom of a page on which it is referenced is called a(n)
____.
a. | endnote | c. | superscript | b. | page note | d. | footnote |
|
|
|
24.
|
You can use a formatting code to insert ____ in a header or footer.
a. | the date | c. | the filename | b. | page numbers | d. | all of the
above |
|
|
|
25.
|
To display the number of entries containing values in a range of cells, you
would use the ____ function.
|
|
|
26.
|
Fonts are measured in ____.
a. | points | c. | centimeters | b. | pixels | d. | inches |
|
|
|
27.
|
The intersection of a single row and a single column is called a ____.
a. | cell | c. | field | b. | cell reference | d. | frame |
|
|
|
28.
|
When you ____ cells, you combine several cells into a single cell.
a. | merge | c. | span and center | b. | split | d. | merge and span |
|
|
|
29.
|
____ view gives you an overall picture of your presentation by displaying your
slides as thumbnails.
a. | Slide | c. | Normal | b. | Outline | d. | Slide Sorter |
|
|
|
30.
|
____ determine the changes in the display that occur as you move from one slide
to another in Slide Show view.
a. | Entrance effects | c. | Emphasis effects | b. | Exit effects | d. | Slide
transitions |
|
|
|
31.
|
Information that repeats at the bottom of each page is called a ____.
a. | footnote | c. | footer | b. | footlight | d. | footline |
|
|
|
32.
|
To select an entire row, you would ____.
a. | click the Select Row button on the Standard toolbar | b. | double-click in any
cell in the row | c. | click the row number at the left of the screen | d. | press Ctrl + right
arrow |
|
|
|
33.
|
To show how individual items relate to a whole unit, you would create a(n) ____
chart.
a. | area | c. | bar | b. | pie | d. | scatter |
|
|
|
34.
|
Documents created in PowerPoint are called ____.
a. | slidesheets | c. | presentations | b. | transparencies | d. | datashows |
|
|
|
35.
|
The page setup settings you select will apply to ____.
a. | only the current worksheet | b. | all worksheets you create until you change the
settings | c. | all the worksheets in a workbook | d. | new one-page
worksheets |
|
|
|
36.
|
To create an absolute cell reference, insert a(n) ____ before the column letter
and/or row number.
|
|
|
37.
|
When showing your slide show, you can move to the next slide by ____.
a. | clicking the mouse button | c. | pressing the down arrow
key | b. | pressing the spacebar | d. | all of the above |
|
|
|
38.
|
If you want to reverse a recent action in PowerPoint, use the ____
command.
a. | Undo | c. | Do Over | b. | Mistake | d. | Redo |
|
|
|
39.
|
The Sort command is in the ____ menu.
a. | Tools | c. | Format | b. | Edit | d. | Data |
|
|
|
40.
|
To shrink a cell’s contents to fit within the cell, you would select an
option from the ____ tab of the Format Cells dialog box.
a. | Fit | c. | Data | b. | Number | d. | Alignment |
|
|
|
41.
|
To insert a callout balloon or arrow to emphasize text in a slide, you would use
a(n) ____.
a. | ArtWord | c. | arrow effect | b. | AutoShape | d. | none of the
above |
|
|
|
42.
|
To make a global change or addition to all the slides in a presentation, you
would change ____.
a. | every slide | c. | the Slide Master | b. | the Apply to Slide Show box | d. | a theme |
|
Completion
Complete each
statement.
|
|
|
43.
|
When you enter data in a cell in a worksheet, it also appears in the
____________________ Bar.
|
|
|
44.
|
The Sort buttons are available on the ___________________ toolbar in
Excel.
|
|
|
45.
|
The ____________________ is a value, cell reference, range, or text that acts as
an operand in a function formula.
|
|
|
46.
|
The Insert Function button is located on the ____________________.
|
|
|
47.
|
____________________ boxes allow you to place text anywhere on a slide, even
outside a placeholder.
|
|
|
48.
|
You change a slide layout in ____________________ view.
|
|
|
49.
|
A single-column heading spread across multiple columns in a Word document is
called a(n) ____________________.
|
|
|
50.
|
Text that is printed at the bottom of every worksheet page but does not display
in the worksheet window is called a(n) ___________________.
|
|
|
51.
|
In the Print Preview window, the mouse pointer appears as a(n)
____________________.
|
|
|
52.
|
To give a worksheet a new name, you can right-click the ____________________ and
then select Rename from the shortcut menu.
|
|
|
53.
|
The number or cell reference in a formula is the _____________________.
|
|
|
54.
|
You should use ____________________ only to highlight relevant information, not
to “decorate” a slide.
|
|
|
55.
|
The ____________________ provides a frame-like boundary between your drawing and
the rest of the document and helps you arrange your drawing and keep parts of your drawing
together.
|
|
|
56.
|
A(n) ____________________ is used to gather, organize, and summarize text and
numeric data.
|
|
|
57.
|
To show comparisons among individual items, you would create a(n)
____________________ chart.
|
|
|
58.
|
____________________ in a worksheet are identified by numbers.
|
|
|
59.
|
A selected group of cells is called a(n) ____________________.
|
|
|
60.
|
Excel’s ___________________ will complete a series of numbers that follow
a set pattern.
|