Chapter 10 - Spreadsheets

Beschreibung

GCSE ICT (Unit 1) Quiz am Chapter 10 - Spreadsheets, erstellt von Kara Martin am 26/05/2016.
Kara Martin
Quiz von Kara Martin, aktualisiert more than 1 year ago
Kara Martin
Erstellt von Kara Martin vor mehr als 8 Jahre
69
4

Zusammenfassung der Ressource

Frage 1

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

Frage 2

Frage
What is a cell?
Antworten
  • 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

Frage 3

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

Frage 4

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

Frage 5

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

Frage 6

Frage
You can make a scatter graph on a spreadsheet
Antworten
  • True
  • False
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

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
CUMULATIVE FREQUENCY DIAGRAMS
Elliot O'Leary
Business Studies Unit 1
emily.mckechnie
BELIEVING IN GOD- UNIT 1, SECTION 1- RELIGIOUS STUDIES GCSE EDEXCEL
Khadijah Mohammed
Input Devices
Jess Peason
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded
MATTERS OF LIFE AND DEATH - UNIT 1, SECTION 2 - RELIGIOUS STUDIES GCSE EDEXCEL
Khadijah Mohammed