wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet lesson 1-2

Total questions: 20

Worksheet time: 10mins

Name
Class
Date
1.

1. A spreadsheet program is used to store data in:

a)

a. a database

b)

b. a text document

c)

c. rows and columns

d)

d. letters and numbers

2.

2. Spreadsheet rows are easily identified by

a)

a. numbers

b)

b. letters

c)

c. Roman numerals.

d)

d. colors

3.

Which of the following is an example of a cell reference?

a)

a. Column C

b)

a. =SUM

c)

b. Row 1

d)

c. A5

4.

Which button is used to format data as a percentage?

a)

a. $

b)

b. ¶

c)

c. #

d)

d. %

5.

What keyboard shortcut will select all the cells in a spreadsheet?

a)

Shift + A

b)

Ctrl + A

c)

Alt + A

d)

Tab + A

6.

1. Combining multiple cells in your spreadsheet is called:

a)

a. formatting

b)

b. aligning

c)

c. merging

d)

d. mixing

7.

Spreadsheet columns are easily identified by:

a)

a. Roman numerals

b)

a. numbers

c)

a. letters

d)

a. colors

8.

The keyboard shortcut for PASTE is:

a)

a. CTRL + A

b)

b. CTRL + V

c)

c. SHIFT + C

d)

d. SHIFT + V

9.

1. What formatting tool adds a dollar symbol, a comma separator and two default decimal places to a number?

a)

a. Percent

b)

b. Currency

c)

c. Comma

d)

d. Increase Decimal

10.

When entering numbers into a cell, your spreadsheet program automatically aligns your numbers to:

a)

1. the left side of the cell

b)

b. the top of the cell

c)

c. the right side of the cell

d)

d. the bottom of the cell

11.

Study the example. Which type of chart is shown?

a)

Bar chart

b)

Scatter chart

c)

Column chart

d)

Line chart

12.

Study the example. Which type of chart is shown?

a)

Line chart

b)

Pie chart

c)

Bar chart

d)

Column chart

13.

Which type of chart is divided into portions representing data percentages?

a)

Column chart

b)

Bar chart

c)

Line chart

d)

Pie chart

14.

Which of the following allows a user to easily sort multiple series of data?

a)

Fill handle

b)

Table

c)

Chart

d)

Function

15.

In a horizontal bar chart, which bar represents the greatest amount or value of the data being illustrated?

a)

The longest bar

b)

The shortest bar

c)

The bar at the top of the chart

d)

The bar at the bottom of the chart

16.

Ernesto's group has made a massive spreadsheet containing data from several sources. Which feature could the group use to easily sort a series of data to help improve their understanding of the information?

a)

Chart

b)

Function

c)

Range

d)

Table

17.

Which chart element identifies the data series that each color represents on the chart?

a)

Vertical axis

b)

Legend

c)

Horizontal axis

d)

Title

18.

Study the following example table:


Which statement about this table is true?

a)

All fields in this table have been sorted alphabetically.

b)

This table includes different data types and sums the values.

c)

All fields in this table use the same data type.

d)

This table can sum only one type of data.

19.

Which of the following lists the types of charts shown in the correct order?

a)

Column, pie, bar

b)

Pie, line, scatter

c)

Column, pie, line

d)

Bar, pie, line

20.

Gary wants a graphical representation of his project data that illustrates the relationships between time and height. What should Gary use to represent this data?

a)

A cell range

b)

A column

c)

A chart

d)

A table