Spreadsheets - Year 9 L1

Beschreibung

Quiz am Spreadsheets - Year 9 L1, erstellt von Jon Rogers am 18/08/2017.
Jon Rogers
Quiz von Jon Rogers, aktualisiert more than 1 year ago
Jon Rogers
Erstellt von Jon Rogers vor mehr als 7 Jahre
569
0

Zusammenfassung der Ressource

Frage 1

Frage
Label the key sections of a spreadsheet by dragging and dropping the labels
Antworten
  • Row
  • Cell
  • Column

Frage 2

Frage
The correct cell reference for this cell is:
Antworten
  • A1
  • 6B
  • B6
  • 5B

Frage 3

Frage
Label the Cell References correctly
Antworten
  • B3
  • C8
  • E5
  • G14
  • A20

Frage 4

Frage
All formulas (and functions) start with...
Antworten
  • +
  • =
  • *
  • A cell reference

Frage 5

Frage
Some of the important symbols in a spreadsheet are below. Drag and drop their meanings into place. + [blank_start]add[blank_end] - [blank_start]subtract[blank_end] * [blank_start]multiply[blank_end] / [blank_start]divide[blank_end]
Antworten
  • add
  • multiply
  • divide
  • subtract

Frage 6

Frage
The symbol for the function menu ( or "Autosum" dropdown) looks like
Antworten
  • Σ
  • M
  • +
  • =f(x)

Frage 7

Frage
The correct formula to add up the numbers in this spreadsheet is:
Antworten
  • =add(A1:A5)
  • =A1+A2+A3+A4
  • =SUM(A1:A5)
  • =(A1:A5)

Frage 8

Frage
The correct formula to calculate the average of the numbers in this spreadsheet is:
Antworten
  • =MEAN(A1:A5)
  • =AVERAGE(A1:A5)
  • =A1+A2+A3+A4+A5/5
  • =AVE(A1:A5)

Frage 9

Frage
A spreadsheet can create many types of [blank_start]graphs[blank_end] or charts. Some of these include line graphs, [blank_start]column[blank_end] (or "bar") charts and [blank_start]pie[blank_end] charts.
Antworten
  • graphs
  • column
  • pie

Frage 10

Frage
Formatting means...
Antworten
  • Making a spreadsheet for some dude called Matt
  • Changing numbers to see what happens
  • Changing how the spreadsheet looks
  • Changing the words to describe what the numbers mean
Zusammenfassung anzeigen Zusammenfassung ausblenden

ähnlicher Inhalt

Common Technology Terms
Julio Aldine Branch-HCPL
Project Communications Management
farzanajeffri
Network Protocols
Shannon Anderson-Rush
Abstraction
Shannon Anderson-Rush
Computing
Kwame Oteng-Adusei
HTTPS explained with Carrier Pigeons
Shannon Anderson-Rush
Introduction to the Internet
Shannon Anderson-Rush
Construcción de software
CRHISTIAN SUAREZ
Historical Development of Computer Languages
Shannon Anderson-Rush
Useful String Methods
Shannon Anderson-Rush
Web Designing & Development Full Tutorial
Nandkishor Dhekane