Y6 - Data & Information  - Intro to Spreadsheets

Y6 - Data & Information - Intro to Spreadsheets

5th Grade

10 Qs

quiz-placeholder

Similar activities

Creating Quantitative Exercise and Organogram Word Processing

Creating Quantitative Exercise and Organogram Word Processing

5th Grade

10 Qs

Ms. Excel

Ms. Excel

5th Grade

15 Qs

Play with Scratch - 1

Play with Scratch - 1

5th - 6th Grade

15 Qs

Latihan TIK Kls 5

Latihan TIK Kls 5

5th Grade

15 Qs

Administrasi Infrastruktur Jaringan

Administrasi Infrastruktur Jaringan

1st - 10th Grade

10 Qs

Hari 3 - Kuis Coding & Perkenalan AI - Fitri Yanti

Hari 3 - Kuis Coding & Perkenalan AI - Fitri Yanti

1st - 12th Grade

12 Qs

Which of these softwares???

Which of these softwares???

4th - 5th Grade

13 Qs

Digcit 5-6

Digcit 5-6

5th - 6th Grade

10 Qs

Y6 - Data & Information  - Intro to Spreadsheets

Y6 - Data & Information - Intro to Spreadsheets

Assessment

Quiz

Computers

5th Grade

Practice Problem

Hard

Created by

Tom McNeil

Used 9+ times

FREE Resource

AI

Enhance your content in a minute

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

10 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Q1. Which of these statements are true about spreadsheets? (Tick all that apply)

When using formulas with cell references, changing one cell can change another

Calculations can be used on any data type in a spreadsheet

Data can be calculated using different operations within the spreadsheet

Charts can be produced using the data held in spreadsheets

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Q2. The picture is an example section of a spreadsheet. How much does one kiwi cost?

£3

£9.50

£0.80

£2.40

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Q3. Using the picture, which of the following is the correct cell reference for the subtotal of grapefruit?

D5

A5

£1.00

D1

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

Q4. Using the picture, which formula is the correct formula to calculate the subtotal for bananas?

=B3xC3

=B3*C3

=C3*D3

=C3xD3

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Q5. What does this operator mean in a spreadsheet  /  ?

Divide

Multiply

Add

Subtract

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

Q6.  Which of these would make suitable column headings in a spreadsheet for a local supermarket? (Tick all that apply)

Cost

£4.62

Apples

Item

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Q7.  Which number format has been applied to this piece of data? 

12:05:00

Date

Italics

Duration

Currency

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?