Term
4.
Which of the following data is sorted in ascending order?
a. trucks, motorcycles, cars, airplanes
b. apples, bananas, cherries, dates
c. 4, 3, 2, 1
d. one, two, three, four |
|
Definition
| b. apples, bananas, cherries, dates |
|
|
Term
5.
A group of related worksheets form a file called a
a. chart.
b. spreadsheet.
c. workbook.
d. cell. |
|
Definition
|
|
Term
7.
Which of the following best describes the General number format?
a. displays numbers with $, two default decimal places, and comma separators
b. displays numbers as keyed
c. displays numbers with a fixed number of decimal places
d. multiplies number keyed by 100 and displays number and two default decimal places with percent sign |
|
Definition
| b. displays numbers as keyed |
|
|
Term
9.
By default, PowerPoint opens presentations in which view?
a. Layout
b. Slide Show
c. Slide Sorter
d. Normal |
|
Definition
|
|
Term
13.
To place text on a slide, click the mouse button to position the ____ and then key the text.
a. outline
b. text box
c. placeholder
d. insertion point |
|
Definition
|
|
Term
34.
The ____ function can be used to calculate monthly payments for a loan.
a. SUM
b. NOW
c. Rate
d. PMT |
|
Definition
|
|
Term
35.
What function can determine the number of cells in a specific column that contain numbers?
a. SUM
b. PV
c. IF
d. Count |
|
Definition
|
|
Term
36.
In the following worksheet, what value would be placed in cell B10 if the Count function was applied?
a. 133
b. 724
c. 103
d. 7 |
|
Definition
|
|
Term
30.
Cell references that adjust when a formula is copied to a new location use ____.
a. absolute referencing
b. PMT
c. relative referencing
d. a function |
|
Definition
|
|
