Matching
|
|
|
When inserting a formula to Sum a column of
numbers, which is the correct order of steps? a. | first | c. | third | b. | second | d. | fourth |
|
|
|
1.
|
Click the Sum Ó
button
|
|
|
2.
|
Select the cells to be added so they are
surrounded by a marquee
|
|
|
3.
|
Press Enter or click the check 
button
|
|
|
4.
|
Click the cell to contain the
answer
|
|
|
(CA2) Complete the VLooup formula to calculate the Rate of Price Increase for
Display Markers so that it can be filled down to calculate the increases for rows below.  a. | May be left blank | f. | A2 | b. | 2 | g. | B2 | c. | $G$2-$H$4 | h. | C2 | d. | G2:H4 | i. | D2 | e. | $A$2 |
|
|
|
5.
|
Table_array
|
|
|
6.
|
Range_lookup
|
|
|
7.
|
Lookup_value
|
|
|
8.
|
Col_index_num
|
|
|
Match the following mouse pointers with their functions
|
|
|
9.
|
Select cell
|
|
|
10.
|
Adjust row height
|
|
|
11.
|
Move cell contents
|
|
|
12.
|
Select entire row
|
|
|
Match the mouse pointers with their functions
|
|
|
13.
|
Select entire column
|
|
|
14.
|
Edit cell contents
|
|
|
15.
|
Fill cell contents to adjacent cells
|
|
|
16.
|
Adjust column width
|
|
|
Match the functions with their purpose.
|
|
|
17.
|
To calculate the monthly payment of a $5,000 five-year car loan at 6%
interest.
|
|
|
18.
|
To calculate how much money you’ll have in a savings account if you
deposite $100 each month for 25 years at 3% interest.
|
|
|
19.
|
To calculate how much money is still owed after the first year of a $5,000
five-year loan at 6% interest.
|
|
|
Match the following mouse positions with their descriptions  a. | Select entire row | d. | Move selected
cells | b. | Adjust row height | e. | Select entire spreadsheet | c. | Edit cell
content |
|
|
|
20.
|
Position 1
|
|
|
21.
|
Position 2
|
|
|
22.
|
Position 3
|
|
|
23.
|
Position 4
|
|
|
24.
|
Position 5
|
|
|
Match the following mouse positions with their descriptions.  a. | Select entire column | c. | Fill content to adjacent
cells | b. | Adjust column width | d. | Select a cell |
|
|
|
25.
|
Position 6
|
|
|
26.
|
Position 7
|
|
|
27.
|
Position 8
|
|
|
28.
|
Position 9
|
True/False
Indicate whether the
statement is true or false.
|
|
|
29.
|
To format cells B2:B16 so they have a blue background with white text if the
sales are 8,000 or greater, a feature called conditional formatting could be used. 
|
|
|
30.
|
To place a line break within a cell, hold Alt with Enter.
|
|
|
31.
|
It’s possible to find out the number of days between two dates without
using a calendar in Excel.
|
|
|
32.
|
Every formula starts with an equal sign.
|
|
|
33.
|
(not covered) It’s possible to link the contents of one cell to another
cell using Excel.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
34.
|
Which button is used to center words acrosss several cells?
|
|
|
35.
|
(CA2) What would be the first step to display only records with the category
Supplies?  a. | Select Data-->Filter-->AutoFilter | c. | Use the Search and Copy
feature to copy all rows with Supplies as the category. | b. | Use the Search
and Remove feature to remove all rows without Supplies as the category. | d. | Sort by
Category |
|
|
|
36.
|
When formatting dollar amounts in a spreadsheet, it’s common practice to
follow these guidelines:
a. | All dollar amounts should be underlined. | d. | All dollar amounts should be in
currency style. | b. | All dollar amounts should be in comma style. | e. | Dollar amounts in the top and total rows should
be in currency style, and amounts in middle rows should be in comma style. | c. | There are no
guidelines. |
|
|
|
37.
|
(CA2) What would be the first step to calculate the subtotals by
category?  a. | Select Data-->Subtotal | c. | Sort by
Category | b. | Select File-->Subtotal | d. | Enter the subtotal formula |
|
|
|
38.
|
Every formula should start with
a. | SUM | c. | ( | b. | Cell address of the first item in the
formula | d. | = |
|
|
|
39.
|
What key is held down when selecting cells that aren’t next to each
other?
a. | Ctrl | c. | Alt | b. | Shift + Ctrl | d. | Shift |
|
|
|
40.
|
Which cells should be selected to create the pie chart?  a. | A1:E5 | c. | A1:A5 and F1:F5 | b. | A1:F6 | d. | A1:A6 and F1:F6 |
|
|
|
41.
|
Which button is used to fill a cell with a color?
|
|
|
42.
|
If the formula =$B1 * C12 is copied sideways to the cell to the right, the new
formula would be:
a. | =$B1 * D12 | c. | =$C1 * C12 | b. | =$C1 * D12 | d. | =$B1 * C12 |
|
|
|
43.
|
The correct formula to calculate the commission in Cell F2 so that it can be
filled down to cells F3 and F4 is:  a. | =B1*E2 | c. | =$B$1*E2 | b. | =B1*$E$2 | d. | =$B$1*$E$2 |
|
|
|
44.
|
What is the correct formula to calculate the percent correct?  a. | =a2/b2 | c. | =a2*b2 | b. | =b2/a2 | d. | =b2+c2 |
|
|
|
45.
|
The correct formula to calculate the bonus in Cell G2 so that it can be filled
down to cells F3 and F4 is:  a. | =IF(E2>=$B$2,0,$B$3) | c. | =IF($E$2>=B2,B3,0) | b. | =IF(E2>=$B$2,$B$3,0) | d. | =IF(E2>=B2,B3,0) |
|
|
|
46.
|
What is the correct shortcut key to insert the
current date?
a. | Ctrl + D | c. | Ctrl + ‘ | b. | Ctrl + ; | d. | Ctrl + : |
|
|
|
47.
|
(CA2) To quickly calculate what the commission rate could be changed to if you
wanted to have the total commission paid to increased from $984 to $1,500, you would:  a. | None of these | c. | increase the commission rate until the total commission reaches
$1,500. | b. | increase the total sales until the total commission reaches
$1,500. | d. | use the Goal Seak
feature. |
|
|
|
48.
|
What is the formula to calculate the interest for the first monthly of a
thirty-year loan? Assume the following is true: loan amount: $10,000; annual
interest rate: 6%; payments periods per year: 12.
a. | $10,000 * 6% / 12 | c. | $10,000 * 6% / 30 | b. | $10,000 * 6% * 12 | d. | $10,000 * 6%
*30 |
|