wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Review

Total questions: 100

Worksheet time: 5hrs 26mins

Name
Class
Date
1.

Columns on a spreadsheet run _______________.

a)

vertically

b)

diagonally

c)

horizontally

d)

really, really fast

2.

Rows on a spreadsheet 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.

Spreadsheets work much like the game ________________.

a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
7.

Which symbol tells the computer you want to create an equation or formula?

a)
$
b)
+
c)
=
d)
-
8.

What does this icon represent?

a)

sheets

b)

slides

c)

docs

d)

classroom

9.

What number should be in cell E1 (based on the formula)?

a)

1

b)

2

c)

5

d)

9

10.

What is the name of this cell?

a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
11.

This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 

a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
12.

Select ______________ from the functions drop-down menu to add a set of numbers. 

a)
average
b)
count
c)
max
d)
sum
13.

Text wrapping in Sheets means the text will be on more than 1 line within the cell.

a)
True
b)
False
14.

You can have multiple sheets within the same Google Sheet document.

a)
True
b)
False
15.

You cannot give an exact size for a row height or column width.

a)
True
b)
False
16.

It is possible to insert images in Google Sheets

a)
True
b)
False
17.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

18.

A visual representation of data

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

19.

To highlight a set of cells

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

20.

Tabs that identify the worksheets in a workbook

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

21.

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)
22.

What is the name of a vertical section of a spreadsheet as selected in the image?

a)
row
b)
cell
c)
column
d)
format
23.

Which of the following is NOT a spreadsheet?

a)

Google Sheets

b)

Microsoft Excel

c)

Google Docs

d)

none of these

24.

Rows run ____________.

a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
25.

Columns run _______________.

a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
26.

Which cursor allows you to drag and fill a series?

a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)
Arrow
27.

Which cursor would you use to auto fit content in a column?

a)
vertical line with arrows pointing left and right
b)
plus sign
c)
hand
d)
white arrow
28.

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
29.

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

a)
True
b)
False
30.

The column and row letter of a cell

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

31.

The procedure to select certain information in a spreadsheet

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

32.

The horizontal and vertical lines on the spreadsheet

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

33.

A number that can be entered into a cell

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

34.

What is the command line above the sheet called where you can enter formulas, text, etc.

a)
autofill
b)
label
c)
column
d)
formula or entry bar
35.

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

36.

If I want to add a Chart, one way is to select the ____________ tab.

a)
Home
b)
Insert
c)
Page Layout
d)
Data
37.

Arranging objects in a certain sequence or order according to specific rules is..

a)

Sort/Filter

b)

Annoying

c)

Search

d)

Seek

38.

What is this icon used for?

a)

Adjusting the Border Style of Selected Cells

b)

Connect Four

c)

4 Square

d)

Rubic's Cube

39.

This button is used to...

a)

merge cells together into on larger cell.

b)

move rectangles to the middle.

c)

point things together.

d)

put some arrows in boxes.

40.

What is the name of this button?

a)

Formula

b)

Function

c)

Cell Address

d)

Sort/ Filter

41.

What is the name of this button?

a)

the "M" button

b)

the backwards 3 button

c)

Function button

d)

the math button

42.

Which one of these functions gives the result shown in the picture?

a)

=COUNTIF(D5:D13,"<>10")

b)

=COUNTIF(D5:D13,"<15")

c)

=COUNTIF(D5:D13,"=16")

d)

=COUNTIF(D5:D13,">=10")

e)

=COUNTIF(D5:D13,">=15")

43.

a method of limiting the entries and responses used in a spreadsheet

a)

Sort

b)

Row

c)

Data Validation

d)

Filter Views

44.

keeps a row/column from moving when scrolling on a sheet making it easier to align data with its correct heading

a)

Column

b)

Filter

c)

Row

d)

Freeze Row/Column

45.

Which item is FALSE regarding charts in Google Sheets?

a)

You can create pie and line charts.

b)

Charts can't be inserted on their own sheet.

c)

You can change the chart title.

d)

You can put a background color on your chart.

46.

Text wrapping in Sheets means the text will be on more than 1 line within the same cell.

a)

True

b)

False

47.

A grid that organizes data

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

48.

A collection of worksheets

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

49.

One page of a spreadsheet

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

50.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

51.

The correct formula to add cell B1 and B2 is

a)
AddB1+C1
b)
=sum(B1+C1)
c)
 =B1+B2
52.

Which icon will change the color of the text?

a)
b)
c)
d)
53.

Why is data validation used ?

a)

(A) to control the type of data entered

b)

(B) to ensure data entered meets requirements

c)

Both (A) & (B)

d)

None of the above

54.

You can collaborate with others on Google Sheets?

a)

True

b)

False

55.

Filters typically occur by...

a)

Columns

b)

Rows

56.

I can select filter views by...

a)

Color

b)

Condition

c)

Values

d)

All of the These

e)

None of These

57.

Spreadsheets help you...

a)

Analyze Data

b)

Make Calculations

c)

Collect and Find the information you need

d)

None of These

e)

All of These

58.

B1 is a?

a)

row

b)

column

c)

cell

d)

sheet

59.

What number is in D1?

a)
1
b)
2
c)
blank
d)
4
60.

What value would you get if you put in the formula: =A1*B1

a)
2
b)
3
c)
4
d)
Error
61.

All formulas in Google Sheets begin with the following symbol:

a)
+
b)
-
c)
=
d)
%
62.

What value would you get if you put in the formula: =B1+C1

a)
2
b)
3
c)
4
d)
Error
63.

What number should be in E1 (based on the formula shown)?

a)
1
b)
3
c)
5
d)
9
64.

Which is the correct formula to add cells A1 thru A5?

a)

=SUM(A1+A5)

b)

=SUM(A1:A5)

c)

=A1+A5

d)

=SUM(A1:A4)

65.

When you sort information, it can only be sorted by the first column of information.

a)

True

b)

False

66.

You can adjust the size of columns in Sheets.

a)

True

b)

False

67.

Merging cells automatically centers the text within the merged cells.

a)
True
b)
False
68.

You are able to change the colors shown in a chart.

a)

True

b)

False

69.

What is the name of the selected cell?

a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
70.

You can only apply a border to the bottom of cells in Google Sheets

a)

True

b)

False

71.

The only colors you can change your sheet tabs to are red, blue, green, or yellow.

a)
True
b)
False
72.

Which of the following is a correctly named cell?

a)
8B
b)
B8
c)
8-B
d)
BB-8
73.

The little triangle in the top right corner of a cell means there is a ________ with that cell.

a)
formula
b)
number
c)
letter
d)
note
74.

Which of the following can you do in a spreadsheet?

a)

Sort in alphabetical order

b)

Sort in number order

c)

Sort in reverse alphabetical order

d)

Sort in reverse number order

e)

All of these can be done using spreadsheets

75.

To create a simple chart, you would click on Insert, then...?

a)

Chart

b)

Image

c)

Drawing

d)

Form

76.

Google Sheets is used to?

a)

Add numbers

b)

Put information in columns and rows

c)

Create charts

d)

All of the above

77.

Double clicking between 2 columns will?

a)

Resize

b)

Delete

c)

Copy

d)

Fill

78.

Why would you want to change the column width?

a)

To make sure all of the numbers are visible

b)

To make sure the title is visible

c)

To make sure all of the headings are visible

d)

All of the above

79.

What is horizontal (left to right)

a)

Columns

b)

Rows

c)

Format

d)

Sum

80.

What is the vertical section of a spreadsheet?

a)

Rows

b)

Columns

c)

Format

d)

Addition

81.

If I want to fill a cell with a particular color, what button would I push?

a)

Text color

b)

Format tab

c)

Fill color

d)

Font style

82.

What are the small rectangles called in a spreadsheet?

a)

Home

b)

Squares

c)

Cells

83.

A sheets document is called a?

a)

Google Document

b)

Google Slide

c)

Spreadsheet

84.

What is this icon used for?

a)

Bold

b)

Brighten

c)

Beware

d)

Buffer

85.

What is this icon used for?

a)

Rubic's cube

b)

Adjusting the border style of selected cells

c)

Connect 4

d)

4 Square

86.

What is this icon used for?

a)

Moving your zeros

b)

Adding or taking away decimals

c)

Changing direction

d)

Adding 10ths and 100ths

87.

Columns are labeled by?

a)

Letters

b)

Numbers

c)

Symbols

88.

Rows are labeled by?

a)

Numbers

b)

Letters

c)

Symbols

89.

What is the title of this Google Spreadsheet Document?

a)

Hurricanes vs. Year

b)

Hurricanes

c)

Year

d)

Unnamed

90.

What is the name of the spreadsheet?

a)

Hurricanes

b)

Sheet 1

c)

Unnamed

d)

Hurricanes vs. Year

91.

What is the name of the cell pointed to by the red arrow?

a)

4

b)

B4

c)

4B

d)

1960

92.

How would you format a large amount of text to fit in a single cell?

a)

Overflow

b)

Wrap

c)

Clip

d)

It's not possible.

93.

Rows are identified by a...

a)

Number

b)

Letter

c)

Name

d)

Nothing

94.

A column is identified by a ...

a)

Number

b)

Letter

c)

Name

d)

Nothing

95.

Oops, you forgot to add a row to the top of your spreadsheet, you should click on ...?

a)

Edit then delete row

b)

File then Save As

c)

Insert then Row Above

d)

Insert then Row Below

96.

Oops, you need to delete an entire row, you should select the row then ...?

a)

Press backspace

b)

Press delete

c)

Press "ctrl" and "x" at the same time

d)

Right click, then select "delete row"

97.

How would you select a range of cells?

a)

While holding down the shift key, click on the desired cells

b)

Click on each desired cell

98.

If you wanted to cut data from one cell and paste it into another, you would...?

a)

Press backspace and then retype the data

b)

Press "ctrl x" & "ctrl v"

99.

To merge two cells into one, you would select the two cells, click on Insert and then Merge cells.

a)

True

b)

False

100.

To sum all the data in a column, you could use the following:

a)
b)
c)
d)

Similar Resources on Wayground

Quiz Remedi TIK semester 1

100 questions

Quiz Remedi TIK semester 1

quiz

Worksheet

•

8th Grade

IGCSE ICT Revision

100 questions

IGCSE ICT Revision

quiz

Worksheet

•

KG - 9th Grade

Spring 2023 Culinary FINAL

99 questions

Spring 2023 Culinary FINAL

quiz

Worksheet

•

8th Grade

KS3 Assessment 01

105 questions

KS3 Assessment 01

quiz

Worksheet

•

8th Grade

UJIAN TULIS TIK KELAS 6 SEMESTER 2

100 questions

UJIAN TULIS TIK KELAS 6 SEMESTER 2

quiz

Worksheet

•

6th Grade

Computer

100 questions

Computer

quiz

Worksheet

•

8th Grade

IC3_GS6_L2_CD1_HaySai

102 questions

IC3_GS6_L2_CD1_HaySai

quiz

Worksheet

•

7th Grade

UKK TIK 7 2024

103 questions

UKK TIK 7 2024

quiz

Worksheet

•

7th Grade