wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheet Programs Quiz

Total questions: 29

Worksheet time: 15mins

Name
Class
Date
1.

To select a worksheet cell, you click it.

a)

True

b)

False

2.

You can format a worksheet so that negative numbers appear in red.

a)

True

b)

False

3.

In most spreadsheet programs, a file can hold only one worksheet.

a)

True

b)

False

4.

To view a worksheet in a workbook, just click the worksheet's tab.

a)

True

b)

False

5.

You can move a worksheet to a new location within its workbook, but a worksheet cannot be moved to a different workbook.

a)

True

b)

False

6.

The data series 10, 8, 6, 4 decreases by an increment of 2.

a)

True

b)

False

7.

The data series can be made up of text, numbers or dates

a)

True

b)

False

8.

When you want to total the values in a group of cells, you start by selecting the cell where the total will appear

a)

True

b)

False

9.

If data is too wide to fit in a cell, part or all the data will be hidden and there is no way to view it

a)

True

b)

False

10.

The COUNT function counts the number of cells in a worksheet

a)

True

b)

False

11.

A function's argument is the data that the function must use

a)

True

b)

False

12.

If you want to use a cell range in a function, you must name each of the cells in the range

a)

True

b)

False

13.

Before you format a cell, you should do this to it

a)

enter data in it

b)

select it

c)

delete it

d)

none of the above

14.

How do you select an entire column of cells in a worksheet?

a)

hold down the control key while you click each cell in the column

b)

click any cell in the column

c)

hold down the shift key while you click the last cell in the column

15.

In a spreadsheet program, a group of cells is called a

a)

series

b)

range

c)

reference

d)

chart

16.

This term refers to the typeface used for data in a worksheet cells.

a)

point

b)

style

c)

text

d)

font

17.

To show this type of number in a worksheet, you might place it in parentheses

a)

negative

b)

currency

c)

decimal

d)

percentage

18.

You can format this in a worksheet by giving it a background color or a border

a)

currency

b)

text

c)

font

d)

cell

19.

To change a column's width, you can drag this

a)

its heading's left edge

b)

its lower-right corner

c)

its heading's right edge

d)

its border

20.

To change a worksheet's name, double-click this.

a)

tab

b)

frame

c)

heading

d)

none of the above

21.

This is a set of data that changes by a constant value

a)

data series

b)

data set

c)

data string

d)

data fill

22.

This spreadsheet feature can enter a data series automatically.

a)

autoseries

b)

autocell

c)

autoenter

d)

autofill

23.

A data series is a set of data that changes by a ____________ value.

a)

constant

b)

random

c)

substitute

d)

odd

24.

If you want a column to automatically resize itself to accommodate its longest data, do this:

a)

double-click its heading's right edge

b)

select it

c)

drag its border

d)

double-click its heading's left edge

25.

This type of chart shows changes over time emphasizing fixed points in time

a)

column

b)

line

c)

bar

d)

pie

26.

This type of chart shows different parts in relation to the whole

a)

bar

b)

pie

c)

line

d)

column

27.

In a function, a symbol such as @ or = acts as the function's

a)

argument

b)

name

c)

keyword

d)

identifier

28.

This term describes a cell reference that changes when it is copied or moved

a)

absolute

b)

incremental

c)

relative

d)

flexible

29.

This type of cell reference does not change when you copy or move it

a)

decremental

b)

absolute

c)

incremental

d)

relative