True/False
Indicate whether the
statement is true(a) or false.(b)
|
|
|
1.
|
Conditional formats are dynamic, so a cell’s appearance will change to
reflect its current value.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
2.
|
The contents of an active cell are displayed in the ____.
a. | toolbar | c. | name box | b. | menu bar | d. | formula bar |
|
|
|
Case 2
Sam is a distributor of ceramics. He uses Excel 2007 to
record his inventory and order forms. Sam’s worksheet for his company’s monthly orders
needs to display summary information including total number of items ordered, and the amount of
revenue generated from those orders.
|
|
|
3.
|
Sam wants to now find out how much money he will make on his largest order,
which is currently in row E. Cell E4 contains the number of items ordered and cell E5 contains the
price per item. An appropriate formula would be ____.
a. | =E4+E5 | c. | =E4*E5 | b. | =E5/E4 | d. | =E4^E5 |
|
|
|
4.
|
Cell D5 has the value 3.259 entered in it. You decide to format the cell
to percent with no decimal places. _____ would be displayed in the cell.
a. | 3.26 | c. | 33% | b. | 3.259% | d. | 326% |
|
|
|
5.
|
Every function has to follow ____.
a. | a formula | c. | syntax | b. | directions | d. | a format |
|
|
|
6.
|
When you copy a formula that contains an absolute reference to a new location,
the reference
____.
a. | is updated automatically | c. | becomes bold | b. | does not
change | d. | has a dotted outline
in its cell |
|
|
|
7.
|
A data series contains values divided into 10 categories. Which chart
would be better for displaying this data?
a. | pie | c. | line | b. | column | d. | area |
|
|
|
8.
|
If you have not already done so, open the Timov workbook located in Excel,
Tutorial 3, Review folder with your data files. In cell C20 enter a formula to calculate Sergei
& Ava’s total pay for Month 1. Copy the formula to cells D20 through N20. Go to Cell
G20. What is their salary for month 5?
a. | 7,000 | c. | 8,900 | b. | 7,700 | d. | it’s
blank |
|
|
|
9.
|
If you have not already done so, open the Timov workbook located in Excel,
Tutorial 3, Review folder with your data files. Select cells C21 through N21. Apply conditional
formatting, top/bottom rule, top 10 items, light red with dark red text. Is cell J21 light red
with dark text?
|
|
|
10.
|
If you have not already done so, open the Timov workbook located in Excel,
Tutorial 3, Review folder with your data files. Select cells B21 through B25 and D21 though
D25. Insert a 2D column chart. Which column is tallest?
a. | Other | c. | Car Payment | b. | Health Insurance | d. | Taxes |
|