wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Spreadsheets Lesson 1 Review

Total questions: 28

Worksheet time: 21mins

Name
Class
Date
1.

Which programs are used to calculate spreadsheets?

a)

Microsoft publisher & Google templates

b)

Microsoft excel & Google sheets

c)

Microsoft powerpoint & Google slides

d)

Microsoft word & Office 365

2.

What symbol does a formula have to start with in order for it to work?

a)

#

b)

$

c)

=

d)

@

3.

What are the Letters in a spreadsheet called?

a)

rows

b)

alphabets

c)

numbers

d)

columns

4.

Which icon represents currency?

a)

*

b)

&

c)

$

d)

@

5.

Is a column vertical or horizontal?

a)

vertical

b)

horizontal

6.
In this diagram what does the selected area represent?
a)
a Row
b)
a Cell
c)
a Column
d)
a Chart
7.
In this example, why does the value in cell G1 look slightly different from the value in the formula bar?
a)
A formula is being used in this cell.
b)
It's using the Currency number format.
c)
It's using the Date number format.
8.
Let's say you're trying to find your average grade in this spreadsheet. What's wrong with the formula in cell C11?
a)
It should use the COUNT function instead.
b)
There is nothing wrong with the formula.
c)
It should have an equals sign (=) at the beginning.
d)
It's referencing the wrong cell range.
9.
In this diagram the highlighted area represents:
a)
Columns
b)
a Graph
c)
Rows
d)
a Chart
10.
What is the cell range in this diagram?
a)
A1:F1
b)
A1:A8
c)
A1:F8
d)
A1:1A
11.

This computer application is used to create charts and graphs, budgets, and for calculating with formulas

a)

Google slides

b)

Google sheets

c)

Google Docs

d)

PowerPoint

12.

In a spreadsheet, columns are identified by

a)

letters

b)

numbers

c)

formulas

d)

cells

13.

Every formula in a spreadsheet begins with this symbol

a)

plus

b)

minus

c)

equal

d)

parenthesis

14.

To add the contents of cells B10 and B25, use this formula

a)

-B10+ B25 =

b)

=SUM(B10+B25)

c)

+B25=+B10

d)

any of these

15.
Sum, average, count, and maximum value are examples of what?
a)
Formulas
b)
Calculations
c)
Functions
d)
Spreadsheet Data
16.
Addition, subtraction, multiplication, division, and exponentiation are examples of what?
a)
Formulas
b)
Conditional Formatting
c)
Functions
d)
Spreadsheet Data
17.
What character is used in a spreadsheet formula to represent multiplication?
a)
/
b)
^
c)
*
d)
=
18.

Combining multiple cells in your spreadsheet is called:

a)

formatting

b)

aligning

c)

merging

d)

mixing

19.

Instead of resizing your column to accommodate your content, what can you use to fit your content to the size of the cell?

a)

Paint formatting

b)

Text wrapping

c)

Filtering

d)

Sorting

20.

What can the Autofill handle do?

a)

Copy cell content and/or populate cells with series (pre-defined or sequential) of content

b)

Copy cell content

c)

Populate cells with series (pre-defined or sequential) of content

d)

Overwrite copied content

21.

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

a)

Percent

b)

Currency

c)

Comma

d)

Increase Decimal

22.

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

a)

Shift + A

b)

Ctrl + A

c)

Alt + A

d)

Tab + A

23.

How can users customize spreadsheets to only display specific criteria?

a)

Copy the data

b)

Filter the data

c)

Align the data

d)

Sort the dara

24.

Which of the following is the correct reference for a cell range?

a)

A2...E15

b)

F15-J28

c)

B2;F30

d)

A7:D20

25.

Which format would be recommended for a cell that contained the data 1/24/2015?

a)

Time

b)

Date

c)

Number

d)

Currency

26.

Which of the following will place data in a specific order?

a)

Sorting

b)

Centering

c)

Filtering

d)

Copying

27.

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

a)

Column C

b)

=SUM

c)

Row 1

d)

A5

28.

A spreadsheet program is used to store data in:

a)

a database

b)

a text document

c)

rows and columns

d)

letters and numbers

Similar Resources on Wayground

Programming Techniques

30 questions

Programming Techniques

quiz

Worksheet

•

8th - 10th Grade

Placa-Mãe

25 questions

Placa-Mãe

quiz

Worksheet

•

3rd Grade - University

Operating system

25 questions

Operating system

quiz

Worksheet

•

7th Grade - University

Latihan soal tentang keyboard

25 questions

Latihan soal tentang keyboard

quiz

Worksheet

•

8th Grade

soal semester 1 kelas 8

25 questions

soal semester 1 kelas 8

quiz

Worksheet

•

7th Grade - University

Waves 6th Lesson 5

23 questions

Waves 6th Lesson 5

quiz

Worksheet

•

6th Grade

Emailing & The Internet

24 questions

Emailing & The Internet

quiz

Worksheet

•

5th - 6th Grade

Assessment Test for 3rd Qtr

25 questions

Assessment Test for 3rd Qtr

quiz

Worksheet

•

7th Grade