Chapter 10 - Spreadsheets

Descripción

GCSE (Unit 1) ICT Test sobre Chapter 10 - Spreadsheets, creado por Kara Martin el 26/05/2016.
Kara Martin
Test por Kara Martin, actualizado hace más de 1 año
Kara Martin
Creado por Kara Martin hace más de 8 años
69
4

Resumen del Recurso

Pregunta 1

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

Pregunta 2

Pregunta
What is a cell?
Respuesta
  • 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

Pregunta 3

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

Pregunta 4

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

Pregunta 5

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

Pregunta 6

Pregunta
You can make a scatter graph on a spreadsheet
Respuesta
  • True
  • False
Mostrar resumen completo Ocultar resumen completo

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
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
Biology Unit 1a - GCSE - AQA
RosettaStoneDecoded
Input Devices
Jess Peason
Unit 1: Business Studies GCSE
Libby Rose