wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

TLE 6 Q1 W4 - Google Sheet

Total questions: 23

Worksheet time: 27mins

Name
Class
Date
1.

Which of the following is a correct syntax?

a)

SUM=(A2:A8,E2:E8)

b)

=SUM (A2:A8,E2:E8)

c)

SUM(A2:A8, E2:E8)=

d)

=A2:A8(SUM)

2.

Tables in spreadsheets are better than tables in word processors because they

a)

Use numbers only

b)

Can be easily updated

c)

Will have unchanging formulas

d)

Have accurate data

3.

By default, what view does Microsoft Excel open to?

a)

print

b)

normal

c)

page break preview

d)

fit to page

4.

What are spreadsheet applications most commonly used for?

a)

Storing tour computer’s configuration details

b)

Creating multimedia presentation

c)

General book-keeping

d)

Creating publishable materialism

5.

What program will we use if we want to calculate large mathematical

Equations?

a)

spreadsheet

b)

powerpoint

c)

word

d)

publisher

6.

An instruction to carry out operations on the numerical data

a)

spreadsheet

b)

row

c)

column

d)

formula

7.

What is the cell that you are working on called?

a)

Active cell

b)

value

c)

auto sum

d)

dormant

8.

What is a chart?

a)

a visual way to display and compare data

b)

a way of arranging data

c)

a calculation that describes the relationship between cells

d)

a group of cells

9.

Both a word processor and a spreadsheet

a)

System software

b)

Application software

c)

Utility software

d)

All of the above

10.

What is the name of the square or box in a spreadsheet called?

a)

block

b)

cell

c)

brick

d)

wall

11.

Where can you enter a formula in a worksheet?

a)

In the Formula Bar only

b)

In cell only

c)

in 1 or 2

d)

in the Name Box

12.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
13.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
14.
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
15.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
16.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
17.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
18.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
19.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
20.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
21.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
22.
You can not give an exact size for a row height or column width.
a)
True
b)
False
23.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format