Excel Spreadsheets Flashcards
(10 cards)
1
Q
What is the symbol for Addition?
A
+
2
Q
What is the symbol for Subtraction?
A
-
3
Q
What is the symbol for Division?
A
/
4
Q
What is the symbol for Multiplication?
A
*
5
Q
What is the vertical set of cells on a spreadsheet called?
A
A column
6
Q
What is the horizontal set of cells on a spreadsheet called?
A
A row
7
Q
What is cell referencing?
A
A way to use the value of the cell in a formula
8
Q
How do you write the cell reference?
A
The column letter, followed by the row number. E.g. A1
9
Q
How do you write a formula?
Give example using A1, B2 and multiply them.
A
= A1 * B2
10
Q
Give an example of a SUM formula using A1, B2, C3 and D4
A
= SUM (A1:B2, C3:D4)
(This will add up A1, B2, C3 and D4)
