Spreadsheets - Year 9 L1

Jon Rogers
Quiz by Jon Rogers, updated more than 1 year ago
Jon Rogers
Created by Jon Rogers about 4 years ago
518
0

Description

Quiz on Spreadsheets - Year 9 L1, created by Jon Rogers on 08/18/2017.

Resource summary

Question 1

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

Question 2

Question
The correct cell reference for this cell is:
Answer
  • A1
  • 6B
  • B6
  • 5B

Question 3

Question
Label the Cell References correctly
Answer
  • B3
  • C8
  • E5
  • G14
  • A20

Question 4

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

Question 5

Question
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]
Answer
  • add
  • multiply
  • divide
  • subtract

Question 6

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

Question 7

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

Question 8

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

Question 9

Question
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.
Answer
  • graphs
  • column
  • pie

Question 10

Question
Formatting means...
Answer
  • 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
Show full summary Hide full summary

Similar

Project Communications Management
farzanajeffri
Common Technology Terms
Julio Aldine Branch-HCPL
Network Protocols
Shannon Anderson-Rush
Computing
Kwame Oteng-Adusei
Abstraction
Shannon Anderson-Rush
HTTPS explained with Carrier Pigeons
Shannon Anderson-Rush
Introduction to the Internet
Shannon Anderson-Rush
Useful String Methods
Shannon Anderson-Rush
Web Designing & Development Full Tutorial
Nandkishor Dhekane
LAN and WAN
Nathan Roberts
RESTful Web Services with Express Framework and mongoose.
Angel Martínez Rodriguez