wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Revision 1

Total questions: 50

Worksheet time: 38mins

Name
Class
Date
1.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
2.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
3.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
4.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
5.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
6.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
7.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
8.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
9.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
10.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
11.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
12.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
13.
In a Google Spreadsheet, the numbers down the left side represent __________.
a)
Rows
b)
 Columns
c)
Headers
d)
Functions
14.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
15.

It is possible to change the color of a cell border.

a)

True

b)

False

16.

If I want to make a cell a particular color, which button would I click on?

a)

Format tab

b)

Font style

c)

Text color

d)

Fill color

17.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

18.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
19.

In Google Sheets, rows are identified by

a)

Letters

b)

Numbers

20.

In Google Sheets, columns are identified by

a)

Letters

b)

Numbers

21.

I forgot to add a column. Which menu should I use?

a)

File

b)

Edit

c)

Format

d)

Insert

22.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
23.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
24.
=B1+C1
a)
2
b)
3
c)
4
d)
Error
25.
Opening a new file in this app is called a
a)
row
b)
column
c)
cell
d)
sheet
26.
D1-C1
a)
2
b)
3
c)
4
d)
Error
27.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
28.
Which letter on the image is a Column?
a)
A
b)
B
c)
C
d)
D
29.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
30.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
31.
In a Google Spreadsheet, you can format a column by clicking on the $ sign in the toolbar to format it as ___________.
a)
Numbers
b)
Automatic
c)
Decimals
d)
Currency (money)
32.
In a Google Spreadsheet, you can widen an entire column anywhere in the sheet.
a)
True
b)
False
33.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
34.

If I wanted to add more than 5 cells together I should use which formula?

a)

=MAX(A1:A6)

b)

=SUM(A1:A6)

c)

=A1+A2+A3+A4+A5+A6

d)

=SUM(A1...A6)

35.

If I wanted to to find the lowest number in a group of numbers what formula is the best for that?

a)

=MAX(A1:G5)

b)

=MIN(A1:G5)

c)

=LOW(A1:G5)

d)

=SUM(A1:G5)

36.

What number is for bordering tool?

a)

3

b)

4

c)

9

d)

8

e)

6

37.

What number is the text color tool?

a)

3

b)

4

c)

9

d)

8

e)

6

38.

What number is the bold tool?

a)

3

b)

4

c)

9

d)

8

e)

6

39.

What number is the text size?

a)

1

b)

4

c)

2

d)

8

e)

6

40.

How do you rename the tab?

a)

7

b)

13

c)

15

d)

14

41.

a single sheet (page) of rows and columns in a workbook

a)

Cells

b)

Worksheets

c)

Row

d)

Column

42.

An equation entered into a cell on a spreadsheet is...

a)

a Math Problem

b)

Someone Else's Problem

c)

a Formula

d)

a pain in the neck

43.

What is this icon used for?

a)

Skyscrapers

b)

Arrangemnet

c)

Alignment

d)

Audio/Video Adjustment

44.

What is this icon used for?

a)

Moving your zeros

b)

Changing direction

c)

Adding or taking away decimal places

d)

Adding 10ths and 100ths

45.

What do these buttons do?

a)

Back space and move forward

b)

Look back before moving forward

c)

Undo or Redo

d)

Get Out the Way

46.

What does this button do?

a)

Makes you lean forward to read text

b)

Put selected text into Itallics

c)

Type a bunch of slanted I's

d)

Blow your text over with hurricane force winds

47.

If you click this button you will ...

a)

add to 6.

b)

start a race.

c)

count to 3.

d)

be able to change the format of a number (or way the number is listed).

48.

Clicking this button will...

a)

put a couple zeros on your numbers.

b)

slash your prices.

c)

convert your number into a percent.

d)

divide your zeros in half.

49.

A combination of a letter and a number that specifies the column and row in which a cell is located.

a)

Cell Name

b)

Cell Address

c)

Home Address

d)

Bingo

50.

This button will

a)

underline your words

b)

strike through your words

c)

Make your letters look shadowed

d)

Make your letters smaller

Similar Resources on Wayground

ms excel 2010

50 questions

ms excel 2010

quiz

Worksheet

•

7th Grade

QUIZ PseInt

50 questions

QUIZ PseInt

quiz

Worksheet

•

10th Grade

EVALUACIÓN INDIVIDUAL. LÓGICA PROPOSICIONAL.

50 questions

EVALUACIÓN INDIVIDUAL. LÓGICA PROPOSICIONAL.

quiz

Worksheet

•

9th - 12th Grade

PSAS Informatika 8

51 questions

PSAS Informatika 8

quiz

Worksheet

•

8th Grade

POSTEST TCC-GC 2 - SGSI

50 questions

POSTEST TCC-GC 2 - SGSI

quiz

Worksheet

•

1st Grade - Professio...

Ujian Sekolah TIK estise

52 questions

Ujian Sekolah TIK estise

quiz

Worksheet

•

9th Grade

Álgebra

50 questions

Álgebra

quiz

Worksheet

•

7th Grade

#3 CIW Data Analyst - Certification Prep

54 questions

#3 CIW Data Analyst - Certification Prep

quiz

Worksheet

•

9th Grade - University