Spreadsheet - Excel

Question 1

What are the two data types in a spreadsheet?

Answer 1

1. Labels (words or text) - default left

2. Values - (numbers) - Default right

Question 2

What is a Cell?

Answer 2

The intersection of a row or column is referred to as a Cell.

Question 3

What are the formatting feature for Labels?

Answer 3

1. Bold
2. Merge and Centre
3. Wrap text
4. Italic
5. Underline

Question 4

What are the formatting features for Values?

Answer 4

1. Bold
2. Currency style ($)
3. Comma style (,)
4. Italic
5. Underline
6. Percent style (%)

Question 5

Formulae

Answer 5

Every formula must begin with an equal sign.
eg. A2 + A5
       B5 - B10
      D3 * D5
      G5/G10
      T4 ^3

Question 6

What are two types of cell referencing?

Answer 6

Relative: The cell address changes in relation to its location. For example: A2 when copied to the next column becomes B2; if copied one row down, it becomes A3.
Absolute: The cell address does not change in relation to its location. For example: $A$2 when copied across columns or rows remain the same.

• To lock a row only : (A$2)
• To lock a column only: ($A2)
• To lock both column and row: ($A$2)

Question 7

What are two types of cell referencing?

Answer 7

Relative: The cell address changes in relation to its location. For example: A2 when copied to the next column becomes B2; if copied one row down, it becomes A3.
Absolute: The cell address does not change in relation to its location. For example: $A$2 when copied across columns or rows remain the same.

• To lock a row only : (A$2)
• To lock a column only: ($A2)
• To lock both column and row: ($A$2)

Question 8

What are the main Excel functions?

Answer 8

1. Sum
2. Average
3. Min
   4.Max
4. Count (numbers)
5. Count A (labels)
6. If
7. Date
8. Today
9. V lookup
10. Rank
11. PMT
12. Count IF
13. Product
    15 Rank