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.
Return to top of page.
Ocean Lakes ES Home Index More Practice Questions>>>