|
Spreadsheets
|
Look at each question. Try to decide which answer would best replace the question mark with the word "Yes". When you click an answer, the question mark will change to a "Yes" or "No", letting you know which answer is correct. When you finish, click "reload", and all the question marks will reappear and another person can give it a try.
| 1. For which of the following tasks would you most likely use a spreadsheet? |
Making an address book.
Drawing a picture.
Averaging your grades.
Writing a newsletter. |
![]() |
| 2. Which of the following does a spreadsheet contain? |
Columns and rows.
Circles and squares.
Fields and records.
Forms and reports. |
![]() |
| 3. The intersection of a column and a row in a spreadsheet is called a: |
Formula.
Sort.
Record.
Cell. |
![]() |
| 4. Column headings in a spreadsheet are labeled with: |
Numbers.
Letters.
Greek symbols.
Roman numerals. |
![]() |
| 5. When entering formulas in a spreadsheet, you must always start with what symbol? |
+
=
>
} |
![]() |
| 6. To add the values in cells B2 and C4, which of the following formulas should be entered? |
B2-C4
+B2:C4
=B2+C4
=B2*C4 |
![]() |
| 7. Which of the following is a function that is built into a spreadsheet? |
Formula.
Record.
Graph.
Column. |
![]() |
| 8. A group of highlighted cells is called a: |
Graph.
Cell range.
Cell address.
Field. |
![]() |
| 9. For which of the following is a formula used? |
Calculate numbers.
Make a graph.
Draw a picture.
Enter data. |
![]() |
| 10. To create a graph, you must first __________ the cells containing the data you want to graph. |
Align.
Highlight.
Bold.
Center. |
![]() |
| 11. A graph is also called a: |
Picture.
Square.
Table.
Chart. |
![]() |
| 12. Which type of graph would best show how you spent your allowance? |
Bar chart.
Pie chart.
Area chart.
Line chart. |
![]() |
| 13. Which pair of letters identifies the axes on a graph? |
X and Y.
A and B.
C and D.
V and W. |
![]() |
| 14. Which of the following commands would you use to insert a graph into a word processing document? |
Align, center.
Format, chart.
Help, insert.
Copy, paste. |
![]() |
| 15. In a bar chart, what should be viewed to determine what the colors of the bar mean? |
Pie chart.
Legend.
Row headings.
Values. |
![]() |
| 16. What chart type is the most appropriate to display changes over time? |
Bar.
Pie.
Line.
Column. |
![]() |
| Ocean Lakes ES Home | Index | More Practice Questions>>> |