What are 3 benefits of using a spreadsheet?

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

A cell is each individual rectangle in the spreadsheet

A cell is a title of a piece of work

Quiz

Chapter 10 - Spreadsheets

Kara Martin 6 questions 4.7 (6 ratings)

Take the quiz

1What are 3 benefits of using a spreadsheet?
1. AAutomatic recalculation
2. BGraphs and charts can be drawn using the data
3. CReplication: Once the data is correctly entered you can drag it down
4. DSpreadsheets can take a long time to complete
2What is a cell?
1. AA cell is each individual rectangle in the spreadsheet
2. BA cell is a point in a graph
3. CA cell is a title of a piece of work
3What are the 4 main formulae in a spreadsheet?
1. AAdd
2. BSubtract
3. CMultiply
4. DDivide
5. EIF
6. FCountIF
4What data types may you need when formatting cells?
1. ACurrency, number, date, text
2. BDay, month, year, time
3. CPlace, food, time, year
5A cell reference can be written as follows, (B4) or (G5:M6)
1. ATrue
2. BFalse
6You can make a scatter graph on a spreadsheet
1. ATrue
2. BFalse

Description: GCSE ICT (Unit 1) Quiz on Chapter 10 - Spreadsheets, created by Kara Martin on 26/05/2016.
Author: Kara Martin
Language: English
Views: 122
Tags: unit 1 gcse revision ict gcse ict ict unit 1 gcse
Rating: 4.7 out of 5 · 6 ratings
Rate this quiz
Rate this quiz