# Spreadsheets - Year 9 L1

Quiz by Jon Rogers, updated more than 1 year ago
 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
• Row
• Cell
• Column

### Question 2

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

### Question 3

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

### Question 4

Question
• +
• =
• *
• 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]
• multiply
• divide
• subtract

### Question 6

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

### Question 7

Question
The correct formula to add up the numbers in this spreadsheet is:
• =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:
• =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.
• graphs
• column
• pie

### Question 10

Question
Formatting means...
• 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

### Similar

Project Communications Management
Common Technology Terms
Network Protocols
Computing
Abstraction
HTTPS explained with Carrier Pigeons
Introduction to the Internet
Useful String Methods
Web Designing & Development Full Tutorial
LAN and WAN
RESTful Web Services with Express Framework and mongoose.