Chapter 10 - Spreadsheets

Descrição

GCSE ICT (Unit 1) Quiz sobre Chapter 10 - Spreadsheets, criado por Kara Martin em 26-05-2016.
Kara Martin
Quiz por Kara Martin, atualizado more than 1 year ago
Kara Martin
Criado por Kara Martin mais de 8 anos atrás
69
4

Resumo de Recurso

Questão 1

Questão
What are 3 benefits of using a spreadsheet?
Responda
  • 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

Questão 2

Questão
What is a cell?
Responda
  • 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

Questão 3

Questão
What are the 4 main formulae in a spreadsheet?
Responda
  • Add
  • Subtract
  • Multiply
  • Divide
  • IF
  • CountIF

Questão 4

Questão
What data types may you need when formatting cells?
Responda
  • Currency, number, date, text
  • Day, month, year, time
  • Place, food, time, year

Questão 5

Questão
A cell reference can be written as follows, (B4) or (G5:M6)
Responda
  • True
  • False

Questão 6

Questão
You can make a scatter graph on a spreadsheet
Responda
  • True
  • False

Semelhante

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