Spreadsheets - Year 9 L1

Descrição

Quiz sobre Spreadsheets - Year 9 L1, criado por Jon Rogers em 18-08-2017.
Jon Rogers
Quiz por Jon Rogers, atualizado more than 1 year ago
Jon Rogers
Criado por Jon Rogers mais de 6 anos atrás
554
0

Resumo de Recurso

Questão 1

Questão
Label the key sections of a spreadsheet by dragging and dropping the labels
Responda
  • Row
  • Cell
  • Column

Questão 2

Questão
The correct cell reference for this cell is:
Responda
  • A1
  • 6B
  • B6
  • 5B

Questão 3

Questão
Label the Cell References correctly
Responda
  • B3
  • C8
  • E5
  • G14
  • A20

Questão 4

Questão
All formulas (and functions) start with...
Responda
  • +
  • =
  • *
  • A cell reference

Questão 5

Questão
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]
Responda
  • add
  • multiply
  • divide
  • subtract

Questão 6

Questão
The symbol for the function menu ( or "Autosum" dropdown) looks like
Responda
  • Σ
  • M
  • +
  • =f(x)

Questão 7

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

Questão 8

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

Questão 9

Questão
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.
Responda
  • graphs
  • column
  • pie

Questão 10

Questão
Formatting means...
Responda
  • 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

Semelhante

Project Communications Management
farzanajeffri
Common Technology Terms
Julio Aldine Branch-HCPL
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