wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Excel Basics

Total questions: 8

Worksheet time: 4mins

Name
Class
Date
1.

What is a cell in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

2.

What is a function in Excel?

a)

A formula

b)

An individual space

c)

A group of data values

d)

A graph

3.

What is a range in Excel?

a)

An individual space

b)

A group of cells

c)

A graph

d)

A formula

4.

What symbol comes first when using a function?

a)

:

b)

*

c)

(

d)

=

5.

How are cells named?

a)

By row (number) and column (letter)

b)

By column (letter) and row (number)

c)

By the contents of the cell

d)

Names are randomly assigned

6.

To add the contents of cells C1, C2, C3, C4, and C5, how would the function be written?

a)

=SUM(C1-C5)

b)

=SUM(C1,C5)

c)

=SUM(C1:C5)

d)

=SUM(C1*C5)

7.

What function finds the mean of a data set?

a)

There is no function to calculate mean

b)

MEAN

c)

MEDIAN

d)

AVERAGE

8.

What is a histogram?

a)

Another name for a bar graph

b)

A line graph of a function

c)

A graph showing the frequency of values in a data set

d)

A calculation