True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
An applied cell style can be modified using character formats.
|
|
|
2.
|
The first step to inserting a column between column C and column D is to select
a cell in column C.
|
|
|
3.
|
The SUM function adds up all values of the cells in a range.
|
|
|
4.
|
A function requires arguments to perform its calculation.
|
|
|
5.
|
Pointing is the best method for entering a cell range into a function because
typing errors are avoided.
|
|
|
6.
|
The formula =SUM(A1, A7, B9) adds the values of the
cells in the range A1 through B9.
|
|
|
7.
|
An absolute cell reference changes when copied.
|
|
|
8.
|
$A$6 is an absolute cell reference.
|
|
|
9.
|
The range placed in a function by Formulas  AutoSum is always correct.
|
|
|
10.
|
Click Error
Checking  to display the reason for an error value in a
cell.
|
|
|
11.
|
A #### error value indicates the formula is trying to
divide by 0.
|
|
|
12.
|
The ROUND function only changes the way data is displayed.
|
|
|
13.
|
There is no difference between formatting and rounding.
|
|
|
14.
|
Sorting values in descending order places the values in order from lowest to
highest.
|
|
|
15.
|
The key sort column is the column that contains the values that a sort is based
on.
|
|
|
16.
|
The arguments of an IF function can only contain values.
|
|
|
17.
|
One way to fit more rows and columns on a page is to increase the
margins.
|
|
|
18.
|
The location of page breaks in a worksheet can be changed.
|
|
|
19.
|
A method for computing equal period payments for an installment loan is called
amortization.
|
|
|
20.
|
Sheet1 can print
in a different orientation than
Sheet2.
|
|
|
21.
|
Pasted data will automatically update if the source data changes.
|
|
|
22.
|
Linked cells automatically update if the source data changes.
|
|
|
23.
|
When pasting a range of cells, any existing cell contents at the new location
are automatically moved to make room for the pasted data.
|
|
|
24.
|
The process of asking What-If questions of a spreadsheet model is referred to as
a what-if analysis.
|
|
|
25.
|
When rows are inserted, Excel automatically changes the cell references in any
affected formulas.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
26.
|
What will the formula =SUM(A1:A10) change to if row 3
is deleted?
a. | it will not change | c. | =SUM(A1:A9) | b. | =SUM(B1:B10) | d. | =SUM(A1:A11) |
|
|
|
27.
|
A function performs a calculation that results in
a. | a cell reference. | c. | a range of values. | b. | a label. | d. | a single value. |
|
|
|
28.
|
A technique in which a cell is clicked to place its reference in a formula is
called
a. | selecting. | c. | formula fill. | b. | pointing. | d. | cell
referencing. |
|
|
|
|
|
|
29.
|
Using the data in the worksheet above, what will be displayed by the
formula =MAX(A2:B3)?
|
|
|
30.
|
Using the data in the worksheet above, what will be displayed by the
formula =MIN(A1:B3)?
|
|
|
31.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(A1:A3)?
|
|
|
32.
|
Using the data in the worksheet above, what will be displayed by the
formula =SUM(B1:B3)?
|
|
|
33.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(A1<A2,10,20)?
|
|
|
34.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(B1<>B2,0,–5)?
|
|
|
35.
|
Using the data in the worksheet above, what will be displayed by the
formula =IF(A1<MIN(B1:B3),1,A1)?
|
|
|
36.
|
A cell reference that does not change when it is copied is called a(n)
a. | status reference. | c. | absolute cell reference. | b. | relative cell
reference. | d. | currency
reference. |
|
|
|
37.
|
Which key can be used to create an absolute cell reference?
|
|
|
38.
|
What formula will appear in cell C7 if the formula =B6*$B$1 is copied from cell C6 to cell C7?
a. | =B6*$B$1 | c. | =B7*$B$1 | b. | =B7*$B$2 | d. | =C6*$B$1 |
|
|
|
39.
|
To enter a function into a formula without typing,
a. | click a button in the Function
Library group on the Formulas tab. | b. | double-click a cell. | c. | select the function
from Function Styles gallery. | d. | use the name
box. |
|
|
|
40.
|
Which error value indicates the formula is trying to divide by zero?
a. | #DIV/0! | c. | #NUM | b. | #REF | d. | #### |
|
|
|
41.
|
Which error value indicates the formula contains a reference that is not
valid?
a. | #DIV/0! | c. | #NUM | b. | #REF | d. | #### |
|
|
|
42.
|
What will be displayed by the formula =ROUND(C2, 0)
if the number 21.2534 is stored in C2?
a. | 22 | c. | 21 | b. | =ROUND(C2,0) | d. | 21.25 |
|
|
|
43.
|
What will be displayed by the formula
=ROUND(43.92,-1)?
a. | 43.9 | c. | 40 | b. | =ROUND(43.92,-1) | d. | #REF |
|
|
|
44.
|
What will be displayed by the formula
=ROUND(93.99,-2)?
|
|
|
45.
|
The first step when sorting data in a worksheet is to
a. | click Data  Sort A to
Z  . | c. | select the range to sort. | b. | click Data  Sort Z to A  . | d. | select the entire workbook. |
|
|
|
46.
|
The worksheet data below has been sorted in ascending order. Which column was
the key sort column when the data was sorted?  a. | column A | c. | column C | b. | column B | d. | Inventory |
|
|
|
47.
|
What will be displayed by the formula =IF("blue"<"green","sky","water")?
a. | sky | c. | blue | b. | water | d. | #DIV/O! |
|
|
|
Assume cell A1 stores a value of 5 and cell B1
stores a value of 10.
|
|
|
48.
|
What will be displayed by the formula
=IF(A1=B1,A1,"no")?
|
|
|
49.
|
What will be displayed by the formula
=IF(A1<B1,"yes","no")?
a. | yes | c. | yes no | b. | no | d. | #VALUE |
|
|
|
50.
|
Printing a worksheet in landscape orientation
a. | changes the order of the rows in the worksheet. | b. | fits more columns
and fewer rows on a page. | c. | fits more rows and fewer columns on a
page. | d. | prints the worksheet on both sides of the paper. |
|
|
|
51.
|
What can be used to control how a worksheet is divided into pages?
a. | page breaks | c. | rows | b. | columns | d. | functions |
|
|
|
52.
|
Page Layout  Print
Area  Set Print Area is used to
a. | freeze selected rows and columns. | b. | print only cells containing
formulas. | c. | print a selected part of a worksheet. | d. | print only cells containing
values. |
|
|
|
53.
|
Which formula calculates the monthly payment for a $5,000 loan taken out for 3
years at 7% interest (hint =PMT(<rate>, <nper>, <principal>)?
a. | =PMT(7%/12, 3, 5000) | b. | =PMT(7%/12, 36, –5000) | c. | =PMT(7%, 3,
5000) | d. | =PMT(7%, 3/12, -5000) |
|
|
|
54.
|
Which formula calculates the monthly payment for a $200,000 loan taken out for
30 years at 5.25% interest (hint =PMT(<rate>, <nper>, <principal>)?
a. | =PMT(5.25%/12, 30, 200000) | b. | =PMT(5%/30, 360, –200000) | c. | =PMT(5.25/12%, 30,
-200000) | d. | =PMT(.0525/12, 360,
-200000) |
|
|
|
55.
|
To make a sheet active,
a. | select the sheet name on the Home tab. | b. | click the appropriate tab at the bottom of the
Excel window. | c. | click the name box until it displays the appropriate sheet. | d. | select the sheet
name on the View
tab. |
|
|
|
56.
|
Sheet order can be changed by
a. | clicking the Insert
Worksheet tab. | b. | dragging a sheet tab to a new
location. | c. | right-clicking a sheet tab and typing a new number for the sheet. | d. | using Home  Cut and Home  Paste. |
|
|
|
57.
|
Changing the data on one sheet automatically updates the data on the other sheet
when the cells are
a. | upgraded. | c. | linked. | b. | pasted. | d. | copied. |
|
|
|
58.
|
When moving a range of cells between sheets, what needs to be selected
before Home  Paste is clicked? a. | cell A1 | b. | the Esc key | c. | a new range of
cells | d. | the upper-left cell of the range where the data is to be
pasted |
|
|
|
59.
|
Which key removes the dashed border around copied cells?
a. | the Esc key | c. | the Alt key | b. | the Ctrl key | d. | the Tab key |
|
|
|
60.
|
“What-If?” questions are answered by
a. | changing values and noting the results. | b. | inserting a series
of blank columns. | c. | using the IF function. | d. | changing the
formatting and noting the results. |
|
|
|
61.
|
Which allows different data sets to be defined and used within the same
worksheet?
a. | absolute references | c. | scenarios | b. | amortization table | d. | multiple sheets |
|
|
|
62.
|
In a worksheet sort, it is possible to sort by:
a. | Values | c. | Font Color | b. | Cell Color | d. | All of the
above |
|
|
|
63.
|
Which of the following SUM functions would add a total of 20 cells together
correctly?
a. | =SUM(A1:A10) | c. | =SUM(A1, A10, A20) | b. | =SUM(A1, A20) | d. | =SUM(A1:A10,
C1:C10) |
|
|
|
64.
|
Which of the following statements is true about a Scenario Summary?
a. | A Scenario Summary creates a report on a separate sheet. | c. | A Scenario Summary
can be printed to show ‘What-If’ Analysis information in a professional
way. | b. | A Scenario Summary will show results for several different values in the
worksheet. | d. | All of the
above |
|
Matching
|
|
|
Choose the letter that matches the relational operator name.
|
|
|
65.
|
greater than
|
|
|
66.
|
less than or equal to
|
|
|
67.
|
equal to
|
|
|
68.
|
not equal to
|
|
|
69.
|
less than
|
|
|
70.
|
greater than or equal to
|