Kara Martin
Quiz by , created more than 1 year ago

GCSE ICT (Unit 1) Quiz on Chapter 10 - Spreadsheets, created by Kara Martin on 26/05/2016.

69
4
0
Kara Martin
Created by Kara Martin over 8 years ago
Close

Chapter 10 - Spreadsheets

Question 1 of 6

1

What are 3 benefits of using a spreadsheet?

Select one or more of the following:

  • Automatic recalculation

  • Graphs and charts can be drawn using the data

  • Replication: Once the data is correctly entered you can drag it down

  • Spreadsheets can take a long time to complete

Explanation

Question 2 of 6

1

What is a cell?

Select one of the following:

  • A cell is each individual rectangle in the spreadsheet

  • A cell is a point in a graph

  • A cell is a title of a piece of work

Explanation

Question 3 of 6

1

What are the 4 main formulae in a spreadsheet?

Select one or more of the following:

  • Add

  • Subtract

  • Multiply

  • Divide

  • IF

  • CountIF

Explanation

Question 4 of 6

1

What data types may you need when formatting cells?

Select one of the following:

  • Currency, number, date, text

  • Day, month, year, time

  • Place, food, time, year

Explanation

Question 5 of 6

1

A cell reference can be written as follows, (B4) or (G5:M6)

Select one of the following:

  • True
  • False

Explanation

Question 6 of 6

1

You can make a scatter graph on a spreadsheet

Select one of the following:

  • True
  • False

Explanation

Previous
Next