null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
5565134
Chapter 10 - Spreadsheets
Description
GCSE ICT (Unit 1) Quiz on Chapter 10 - Spreadsheets, created by Kara Martin on 26/05/2016.
No tags specified
unit 1
gcse
revision
ict
gcse ict
ict
unit 1
gcse
Quiz by
Kara Martin
, updated more than 1 year ago
More
Less
Created by
Kara Martin
over 8 years ago
69
4
0
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
Want to create your own
Quizzes
for
free
with GoConqr?
Learn more
.
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
Browse Library