wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Year 9 ICT Q2 revision: spreadsheets

Total questions: 59

Worksheet time: 30mins

Name
Class
Date
1.

6. How can you use the SUM function to add a range of cells in a spreadsheet?

a)

=SUM(A1*A10)

b)

=SUM(A1+A10)

c)

=SUM(A1:A10)

d)

=SUM(A1-A10)

2.
What does cell A1 contain?
a)
Sweet
b)
Mars
c)
A1
d)
Cost
3.
What does cell B6 contain?
a)
23
b)
0.45
c)
0.50
d)
23
4.
What does cell C3 contain?
a)
23
b)
67
c)
Amount
d)
11.50
5.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
6.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
7.

What symbol do you use to add two cells' values in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

8.

What symbol do all formula start with in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

9.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
10.
Rows are identified using ________?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
11.
Which formula is the correct for adding a column of values?
a)
SUM(E4:E10)
b)
=SUM(E4:E10)
c)
=AVG(E4:E10)
d)
=MAX(E4:E10)
12.
Cells that run vertically on a spreadsheet
a)
Row
b)
Workbook
c)
Worksheet
d)
Column
13.
SUM, AVERAGE, MAX and VLOOKUP are examples of what?
a)
Functions
b)
Tables
c)
Formulae
d)
Statistical tools
14.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
15.
When you key a formula in a spreadsheet what do you key in first?
a)
Subtraction sign
b)
Equal Sign
c)
Addition sign
d)
Division sign
16.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
17.

Charts are:

a)

Graphic presentations of data from a worksheet

b)

Visual drawings of spreadsheets in a workbook

c)

Food to eat when your bored

d)

Money graphs to help organize your checks

18.

A bar chart shows the ________ among values.

a)

relationships

b)

answers

c)

cells

d)

formulas

19.

A pie chart is a _______ chart that shows the relationships among values.

a)

circle

b)

square

c)

triangle

d)

pentagon

20.

Pre-existing formulas built into a spreadsheet:

a)

Functions

b)

Formulas

c)

Cells

d)

Data

21.

Organize these options into the right categories

Categorize the following

Horizontal

Vertical

Labeled by numbers

Labeled by letters

left to right

up and down

Sum

Minimum

Average

Maximum

Count

Rows
Columns
Formulas
22.

Match the symbols:

a)

/

1.

division

b)

*

2.

multiplication

c)

+

3.

addition

d)

_

4.

subtraction

23.

Match the following:

a)

Words entered into a spreadsheet

1.

Labels

b)

Numbers, dates, or times entered into a spreadsheet

2.

Values

c)

A group of spreadsheet cells

3.

Range

d)

Vertical lines of data labeled by a letter

4.

Columns

e)

Horizontal lines of data labeled by a number

5.

Rows

24.

What is a spreadsheet?

a)

A spreadsheet is a electronic worksheet or grid that is used to organize and analyze information.

b)

A spreadsheet is a type of musical instrument played in a band class.

c)
A spreadsheet is a tool used for drawing and painting.
d)

A spreadsheet is a type of computer virus.

25.

What package do we use when creating spreadsheets?

a)

Excel

b)

PowerPoint

c)

Acess

d)

Publisher

26.

Each column is given a...

a)

Letter

b)

Number

27.

Each row is given a...

a)

Letter

b)

Number

28.

What do we use at the beginning of a formula?

a)

+

b)

=

c)

-

29.

What is a correct name for a cell?

a)

C3

b)

Cell3

c)

Field3

d)

C3PO

30.

What are spreadsheets used for?

a)

To store, search and sort information.

b)

To calculate data and create charts

31.

Which is the correct formula to multiply?

a)

=B6*C6

b)

B6*C6

c)

B6C6*

d)

*B6C6

32.

Which is the correct formula to divide?

a)

B6/C6

b)

=B6/C6

c)

/B6C6

d)

B6C6/

33.

What are the steps to create a chart?

a)

Highlight cells, click "Insert" and choose a chart

b)

Click "Insert" and choose a chart

c)

Highlight cells, click "View" and choose a chart

d)

Highlight cells, click "Data" and choose a chart

34.

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

35.

What function do you use to add cells together?

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

36.

What function do you use to find the lowest number?

a)

SUM

b)

MAX

c)

MIN

d)

AVERAGE

37.

Name this

a)

Cell

b)

Row

c)

Column

38.

Name this

a)

Cell

b)

Row

c)

Column

39.

Name this

a)

Cell

b)

Row

c)

Column

40.

What is happening in Total Sales?

a)

Replication

b)

Formatting a cell

c)

Creating a formula

d)

Using a function

41.

What is the purpose of formatting in spreadsheets?

a)

To calculate data

b)

To delete data

c)

To improve readability and presentation

42.

How can you identify a cell in a spreadsheet?

a)

By its cell reference

b)

By its colour

c)

By its size

43.

What is a common format for numerical data in spreadsheets?

a)

Currency

b)

Image

c)

Text

44.

How do you enter data in a spreadsheet cell?

a)

By clicking the cell and typing

b)

By dragging a cell

c)

By using a formula

45.

Why is it important to label the axes on a graph?

a)

To add colour

b)

To ensure data is clearly understood

c)

To make the graph look complete

46.
What does this symbol represent in MS Excel?
a)
a. Subtract
b)
b. AutoSum
c)
c. Formula
d)
d.    Average
47.

If I wanted to know the total amount of bonuses given to the employees I would write the following formula in cell D12:

a)

=sum(C2:C11)

b)

=sum(D2,D3,D4,D5,D7,D8,D9,D10,D11)

c)

=sum(D2:D11)

d)

$13,442.90

48.

If I wanted to know the average annual salary earned by the employees I would write the following formula in cell C12:

a)

=sum(C2:C11)

b)

=average(C2,C11)

c)

=average(C2:C11)

d)

=average(B2:B11)

49.
What is the correct example of a range?
a)
3B:7C
b)
B3:C7
c)
B3-C7
d)
B:3:C:7
50.
Which type of chart would be best for showing you a part of the whole?
a)
Pie
b)
Line
c)
Column
d)
Bar
51.
Which of the following is a valid formula?
a)
=C7*C8
b)
=(C7\C8)
c)
=(C7xC8)
d)
=AVERAGE(C7*C8)
52.
Which of the following is a valid formula?
a)
=sum(A1:A6)
b)
sum=(A1:A6)
c)
=sum[A1:A6]
d)
=sum(A1,A6)
53.

If an entry is £3.99 what should we format the cell as?

a)

Number

b)

Currency

c)

Text

d)

Number with 2 decimal places

54.

Which of the following formulae will multiply the values in the cells?

a)

=A1+B1

b)

=A1-B1

c)

=A1*B1

d)

=A1/B1

55.

Which feature allows a formula to be copied to another cell yet adjusting the cell reference to match?

a)

Copy and paste

b)

Autofill

c)

Sum

d)

Fill

56.

All the cells going down are called?

a)

Row

b)

Label

c)

Record

d)

Column

57.

If you are writing a formula in Excel what do you type at the start?

a)

=

b)

#

c)

:

d)

+

58.

What do you write to perform calculations in a spreadsheet?

a)

Computer programs

b)

Formulas

c)

Instructions

d)

Sums

59.

What can be used to uniquely identify each cell in a spreadsheet?

a)

Cell reference

b)

Column heading

c)

Row number

d)

Row heading

Similar Resources on Wayground

Try Out TIK Kelas 6 Pra AM

60 questions

Try Out TIK Kelas 6 Pra AM

quiz

Worksheet

•

6th Grade

ICT Lessons 1-4

61 questions

ICT Lessons 1-4

quiz

Worksheet

•

6th Grade

Analisis Data - Microsoft Excel

60 questions

Analisis Data - Microsoft Excel

quiz

Worksheet

•

8th Grade

GRADE 6 REVISION FIRST TERM

57 questions

GRADE 6 REVISION FIRST TERM

quiz

Worksheet

•

6th Grade

BIM Final

59 questions

BIM Final

quiz

Worksheet

•

7th - 8th Grade

BERPIKIR KOMPUTASIONAL

55 questions

BERPIKIR KOMPUTASIONAL

quiz

Worksheet

•

6th - 8th Grade

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

63 questions

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

quiz

Worksheet

•

7th Grade

MÔN TIN HỌC LỚP 6 - ÔN TẬP

56 questions

MÔN TIN HỌC LỚP 6 - ÔN TẬP

quiz

Worksheet

•

6th Grade