wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Functions, Formulas, OH My

Total questions: 50

Worksheet time: 38mins

Name
Class
Date
1.

In Google Sheets, rows are identified by

a)

Letters

b)

Numbers

2.

In a spreadsheet, what is the small box where a row and column meet called?

a)

Compartment

b)

File

c)

Cell

d)

Formula

3.

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

4.

Which of the following options will allow all text to fit into one cell without spilling into the next column?

a)

Overflow

b)

Text wrapping

c)

Clip

5.

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

6.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
7.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
8.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
9.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
10.
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
11.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
12.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
13.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
14.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
15.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
16.
Google Sheets is used to?
a)
Add numbers.
b)
Make charts (graphs).
c)
Put information in columns and rows.
d)
All of the above.
17.
Why would you want to change the column width?
a)
to make sure the title is visible
b)
to make sure headings are always visible
c)
to make sure all of the numbers are visible
d)
All of the Above
18.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
19.
What adds all of the numbers in a range of cells?
a)
Auto Difference function
b)
Sum function
c)
AutoAverage function
d)
Autototalizer
20.
Identify this cell (highlighted)
a)
A3
b)
C3
c)
C1
d)
C U L8R
21.
An Sheets document is called a?
a)
Work page
b)
Work paper
c)
Slide
d)
Spreadsheet
22.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
23.
It is essential for a business owner to track their expenses and income by using a spreadsheet application like Google Sheets.
a)
True
b)
False
24.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
25.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
 =B1+B2
d)
=sum(B1-B2)
26.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
27.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
28.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
29.
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)
30.
It is possible to change the color of a cell border.
a)
True
b)
False
31.
The only colors you can change your sheet tabs to are red, blue, green, or yellow.
a)
True
b)
False
32.
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
33.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
34.

Google Sheets is used to? (Select ALL that apply?)

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

35.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

36.

A formula that will add up a column of numbers

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

37.

To fill a cellwith color using the paint bucket tool

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

38.

The dot at the bottom of each cell while it is active

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

39.

What always start with an = sign

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

40.

A visual representation of data

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

41.

The horizontal and vertical lines on the spreadsheet

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

42.

To highlight a set of cells

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

43.

Tabs that identify the worksheets in a workbook

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

44.

A collection of worksheets

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

45.

A strip of icons used to perform certain functions is...

a)

Conjunction Junction (What's your function)

b)

a Toolbar

c)

the Hollywood Walk of Fame

d)

the Ion Icons

46.

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

47.

Where would you click to select an entire row?

a)

On the column letter

b)

On the row number

c)

On any cell in that row

d)

On any cell in that column

48.
If you want to calculate something in a cell, the first symbol you must enter in that cell is?
a)
Plus sign
b)
Open parenthesis
c)
Equal sign
d)
Divide sign
49.

Information typed into a spreadsheets is called

a)

data

b)

info

c)

research

d)

text

50.

What is the name of this button?

a)

Function button

b)

the backwards 3 button

Similar Resources on Wayground

ĐỀ CƯƠNG_GHK2_TIN7

50 questions

ĐỀ CƯƠNG_GHK2_TIN7

quiz

Worksheet

•

7th Grade

Computer basics

50 questions

Computer basics

quiz

Worksheet

•

5th - 9th Grade

Semester Exam: App Creators

50 questions

Semester Exam: App Creators

quiz

Worksheet

•

8th Grade

KUIS Jaringan Komputer dan Internet

50 questions

KUIS Jaringan Komputer dan Internet

quiz

Worksheet

•

7th Grade - University

TIK KELAS 6

55 questions

TIK KELAS 6

quiz

Worksheet

•

6th Grade

Computing Heroes Quiz KS3

53 questions

Computing Heroes Quiz KS3

quiz

Worksheet

•

5th - 10th Grade

Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 LV2 _2024)

50 questions

Chủ đề 1: CĂN BẢN VỀ CÔNG NGHỆ (GS6 LV2 _2024)

quiz

Worksheet

•

7th Grade

YEAR 7 BASELINE TEST

50 questions

YEAR 7 BASELINE TEST

quiz

Worksheet

•

6th Grade