 |
 |
Excel Quiz |
| Question 1) |
The advantage of using a spreadsheet is:
| a) calculations can be done automatically. | b) changing data automatically updates calculations (as long as Excel is not set to calculate manually). |
| c) more flexibility | d) all of the above |
| Question 2) |
The intersection of a row and a column is called:
| a) data. | b) a field. |
| c) a cell. | d) an equation. |
| Question 3) |
When you are typing an equation into a cell the first thing that must be entered is
| a) the first cell referenced | b) parenthesis |
| c) quotation marks | d) an equal sign |
| Question 4) |
Labels are used in a spreadsheet to:
| a) tell the computer what we are doing. | b) help us identify the information. |
| c) do the calculations. | d) set up the equations. |
| Question 5) |
The cell labeled F5 refers to
| a) row F column 5 | b) column F row 5 |
| c) functions available in cells | d) Function key F4 |
| Question 6) |
There are three types of data found in a spreadsheet.
| a) data, words, numbers | b) equations, data, numbers |
| c) words, numbers, labels | d) numbers, formulas, labels |
| Question 7) |
The formula =B2+A3 is located in cell b3. If this was copied and pasted into cell D4 the resulting formula would be:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 2 | 4 | 5 | 5 |
| 2 | 3 | 3 | 4 | 6 |
| 3 | 5 | =B2+A3 | 3 | 8 |
| 4 | 4 | 3 | 4 | ???????? |
| a) =C2+C3 | b) =D3+C3 |
| c) =D3+C4 | d) none of the above |
| Question 8) |
A constant is another name for this type of data:
| a) number | b) equation | c) formula | d) description |
| Question 9) |
I found this to be:
| a) too easy. | b) not too bad. |
| c) good. | d) very good. |