wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

ICT Years 3 & 4 - Spreadsheet Software

Total questions: 50

Worksheet time: 2hrs 40mins

Name
Class
Date
1.

What is a correct name for a cell?

a)

C3

b)

Cell3

c)

Field3

d)

C3PO

2.

What are spreadsheets used for?

a)

To store, search and sort information.

b)

To calculate data and create charts

3.

Which is the correct formula to multiply?

a)

=B6*C6

b)

B6*C6

c)

B6C6*

d)

*B6C6

4.

Which is the correct formula to divide?

a)

B6/C6

b)

=B6/C6

c)

/B6C6

d)

B6C6/

5.

What can you NOT do with spreadsheets?

a)

Increase the column width

b)

Increase the row height

c)

Make text within a cell bold, underlined or Italic

d)

Animate text within a cell

6.

What function do you use to add cells together?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

7.

Name this

a)

Cell

b)

Row

c)

Column

8.

Name this

a)

Cell

b)

Row

c)

Column

9.

Name this

a)

Cell

b)

Row

c)

Column

10.
 A spreadsheet program is used to store data in: 
a)
a. a database.
b)
b. a text document.
c)
c. rows and columns.
d)
d. letters and numbers.
11.
Spreadsheet columns are easily identified by:
a)
a. Roman numerals.
b)
b. numbers.
c)
c. letters.
d)
d. colors.
12.
Spreadsheet rows are easily identified by:
a)
a. numbers.
b)
b. letters.
c)
c. Roman numerals.
d)
d. colors.
13.
Which of the following is an example of a cell reference?
a)
a. Column C
b)
b. =SUM
c)
c. Row 1
d)
d. A5
14.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
15.
The cell that is currently selected
a)
Cell reference
b)
Cell range
c)
Label
d)
Active cell
16.
The intersection of a row and a column
a)
Cell reference
b)
Cell range
c)
Cell
d)
Active cell
17.
A single page in Excel is called a:
a)
worksheet
b)
workbook
c)
spreadsheet
18.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
19.
What is the purpose of spreadsheets?
a)
a. To present information on different engaging slides
b)
b. To deliver a speech to a crowd
c)
c. To perform basic and complex math computations in an organized way
d)
d. To excel your research papers and citations
20.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
21.
Which career(s) or places of employment involve the use of a spreadsheet at work?
a)
Accountant
b)
Hospital
c)
All Choices
d)
Shop Keeper
22.
I can find the lowest number in a range with the ... function
a)
MIN
b)
MAX
c)
AVERAGE
d)
COUNT
23.
What is displayed in cell A6?
a)
Monday
b)
Tuesday
c)
Wednesday
d)
Thursday
24.

What can contain a label, information or formula?

a)

A row

b)

A column

c)

A cell

d)

A spreadsheet

25.

What is identified by letters on a spreadsheet?

a)

Row

b)

Column

c)

Cell

d)

Spreadsheet

26.

What should every formula start with?

a)

A Cell

b)

*

c)

=

d)

Function

27.

What is identified by numbers on a spreadsheet?

a)

Row

b)

Column

c)

Cell

d)

Spreadsheet

28.

What is a worksheet?

a)

A page in a spreadsheet

b)

A sheet to show calculations

c)

A blank document

d)

A photocopy

29.

How should you format money in a spreadsheet?

a)

Pounds

b)

£

c)

$

d)

Currency

30.

Which of the labels points to a cell?

a)

A

b)

B

c)

C

d)

D

e)

E

31.

Which of the labels points to row labels?

a)

A

b)

B

c)

C

d)

D

e)

E

32.

Which of the labels points to column labels?

a)

B

b)

C

c)

D

d)

E

e)

F

33.

Which of the labels points to the font?

a)

B

b)

C

c)

D

d)

E

e)

F

34.

Which of the labels points to the formula bar?

a)

B

b)

C

c)

D

d)

E

e)

F

35.

What word does the cell B2 contain?

a)

Hello

b)

School

c)

Excel

d)

Lesson

36.

What is the cell reference of the cell containing the value "Hello"?

a)

B2

b)

D2

c)

B4

d)

D4

37.

What is the cell reference of the cell containing the value "School"?

a)

B2

b)

D2

c)

B4

d)

D4

38.

Columns go

a)

across

b)

diagonally

c)

up and down

39.

These go from side to side (horizontally)

a)

rows

b)

columns

c)

tables

40.

If something is in column B and row 5, what would it's cell address be?

a)

5B

b)

B5

c)

CBR5

41.

The small boxes on a spreadsheet are called

a)

cells

b)

boxes

c)

rows

d)

columns

42.

What do all calculations start with?

a)

=

b)

(

c)

-

d)

\

43.

What symbol should be used to perform an adding calculation?

a)

+

b)

-

c)

*

d)

/

44.

What symbol should be used to perform a subtraction calculation?

a)

-

b)

*

c)

+

d)

/

45.

What symbol should be used to perform a multiplying calculation?

a)

+

b)

-

c)

*

d)

/

46.

What symbol should be used to perform a division calculation?

a)

/

b)

-

c)

*

d)

+

47.

What software do we use to create spreadsheets?

a)

Word

b)

PowerPoint

c)

Sway

d)

Publisher

e)

Excel

48.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

49.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

50.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)

Similar Resources on Wayground

CAT - Gr 10 - Hardware & Software

50 questions

CAT - Gr 10 - Hardware & Software

quiz

Worksheet

•

KG - University

KỸ THUẬT ĐIỀU CHỈNH MỘT ĐOẠN VĂN BẢN

51 questions

KỸ THUẬT ĐIỀU CHỈNH MỘT ĐOẠN VĂN BẢN

quiz

Worksheet

•

5th Grade

STEM DECATHLON CHALLANGE SMKNI

50 questions

STEM DECATHLON CHALLANGE SMKNI

quiz

Worksheet

•

4th - 8th Grade

Scratch G5 2

45 questions

Scratch G5 2

quiz

Worksheet

•

5th Grade

SOAL SEMESTER 1 KELAS 9 BAHASA INDONESIA 2020/2021

50 questions

SOAL SEMESTER 1 KELAS 9 BAHASA INDONESIA 2020/2021

quiz

Worksheet

•

3rd Grade - University

ADVANCED FEATURES OF MS - WORD - 1

45 questions

ADVANCED FEATURES OF MS - WORD - 1

quiz

Worksheet

•

5th - 6th Grade

Reading Comprehension

45 questions

Reading Comprehension

quiz

Worksheet

•

5th Grade

Computer Systems

51 questions

Computer Systems

quiz

Worksheet

•

4th Grade