Name ID-2950 Quiz #6
Directions: This quiz is to be done by yourself – no group collaborations are allowed. It is due at the start of the next class period. Place the letter of the correct choice on the line provided.
1. The file extension for Excel is
A. xlsB. excelC. ppt
D. docE. htm
2. To make Excel multiply the contents of cells A1 and B1, in cell C1, you could type:
A. A1B1B. =A1B1C. =A1*B1
3. To make Excel recognize numbers as currency, the best way is to
A. use FormatB. use EditC. use File
D. use InsertE. use Data
4. To make Excel use the same type of formula for a group of cells, the easiest way is to
A. type the formula in each cell
B. copy the formula in each cell
C. drag the formula through the cells
5. What is the purpose of the command =MIN(D2:F2)?
A. It adds the values of cells D2 through F2
B. It averages the values of cells D2 through F2
C. It finds the minimum value of cells D2 through F2
D. It doesn’t do anything
6. In the command =C4+C4*$A$4, the purpose of the dollar signs is to
A. to show that money is being calculated
B. to use absolute referencing
C. to use relative referencing
D. to make the command look pretty
7. Which ribbon allows one to begin to create graphs after the data is typed?
A. HomeB. InsertC. View
D. Page LayoutE. Data
8. If you typed the following into Excel and then tried to make a bar graph, what will
happen in Step 2 of the process:
Age / Frequency10 / 5
20 / 6
30 / 9
40 / 3
50 / 2
A. A correct bar graph will appear, assuming you selected it.
B. Two sets of bars will appear.
C. Excel will not allow you to make the graph.
9. Here is a graph for the above table:
What is wrong with it?
A. nothing is wrong
B. the legend of frequency needs to be removed
C. the title isn’t correct
D. the values on the x axis are not correct
10. To make the bars of a histogram connect together,
A. You can’t make them connect together
B. Make the gap width equal to 100
C. Make the gap width equal to 0
D. Make the gap width equal to -100