Chapter 10 - Spreadsheets

Description

GCSE ICT (Unit 1) Quiz on Chapter 10 - Spreadsheets, created by Kara Martin on 26/05/2016.
Kara Martin
Quiz by Kara Martin, updated more than 1 year ago
Kara Martin
Created by Kara Martin over 8 years ago
69
4

Resource summary

Question 1

Question
What are 3 benefits of using a spreadsheet?
Answer
  • 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

Question 2

Question
What is a cell?
Answer
  • 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

Question 3

Question
What are the 4 main formulae in a spreadsheet?
Answer
  • Add
  • Subtract
  • Multiply
  • Divide
  • IF
  • CountIF

Question 4

Question
What data types may you need when formatting cells?
Answer
  • Currency, number, date, text
  • Day, month, year, time
  • Place, food, time, year

Question 5

Question
A cell reference can be written as follows, (B4) or (G5:M6)
Answer
  • True
  • False

Question 6

Question
You can make a scatter graph on a spreadsheet
Answer
  • True
  • False
Show full summary Hide full summary

Similar

Germany 1918-39
Cam Burke
21 Random IT questions
Eden Goddard
GCSE ICT Edexcel Flashcards
Sarah Bramley-Dymond
Non Verbal Communication
Mursal Kharoti
Types and Components of Computer Systems
Jess Peason
Business Studies Unit 1
emily.mckechnie
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded
CUMULATIVE FREQUENCY DIAGRAMS
Elliot O'Leary
BELIEVING IN GOD- UNIT 1, SECTION 1- RELIGIOUS STUDIES GCSE EDEXCEL
Khadijah Mohammed
Input Devices
Jess Peason
MATTERS OF LIFE AND DEATH - UNIT 1, SECTION 2 - RELIGIOUS STUDIES GCSE EDEXCEL
Khadijah Mohammed