9895329
Description
Quiz by Jon Rogers, updated more than 1 year ago
|
Created by Jon Rogers
over 7 years ago
|
|
Question 1
Question
Label the key sections of a spreadsheet by dragging and dropping the labels
Answer
-
Row
-
Cell
-
Column
Question 2
Answer
-
A1
-
6B
-
B6
-
5B
Question 3
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
Want to create your own Quizzes for free with GoConqr? Learn more.