Year 9 Spreadsheets Part 1

Year 9 Spreadsheets Part 1

8th - 9th Grade

8 Qs

quiz-placeholder

Similar activities

Basic Parts of Speech EPS

Basic Parts of Speech EPS

9th - 10th Grade

10 Qs

Encryption and Public Keys

Encryption and Public Keys

6th - 8th Grade

8 Qs

ICT Grade 8

ICT Grade 8

8th Grade

10 Qs

IT- Revision

IT- Revision

9th Grade

10 Qs

Quiz Lec2

Quiz Lec2

KG - University

10 Qs

Setting Character Position

Setting Character Position

6th - 8th Grade

10 Qs

Threats to Data

Threats to Data

9th - 12th Grade

11 Qs

HEALTH AND SAFETY 9

HEALTH AND SAFETY 9

7th - 9th Grade

11 Qs

Year 9 Spreadsheets Part 1

Year 9 Spreadsheets Part 1

Assessment

Quiz

Computers

8th - 9th Grade

Practice Problem

Hard

Created by

Tracy Mayhead

Used 11+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

8 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What do you write to perform calculations in a spreadsheet?

Computer programs

Formulae

Instructions

Sums

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is SUM an example of?

Function

Formula

Operation

Instruction

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Copy and paste

Autofill

Sum

Fill

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of an Absolute cell reference?

It copies only the cell reference, not the formulae

It copies the formula, but changes the cell reference to match

It copies the formula, but does not change the cell reference of selected references

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which is NOT a method of formatting headings to make them clearer?

Merging cells and increasing text size

Reduce the size of the text

Change the background colour of the cell

Change the colour of the text

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Why do we use Formulae for calculations in a spreadsheet?

So other cells that use this value change when the original value changes

It shows off what you know about spreadsheets

It looks better

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is a suitable formula for calculating 20% of a value?

=A2*0.20

=A2-20%

=A2-0.20

=A2*20%

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?