The Basics of Using Spreadsheets

Question 1

Spreadsheet

Answer 1

Electronic piece of paper divided into rows (h) and columns (v)

Question 2

What do you call the intersection of a row and a column ?

Answer 2

A ‘cell’

Question 3

A cell address consists of..

Answer 3

Its row & column reference

Question 4

Why do we use spreadsheet ?

Answer 4

► A tool for calculating, analysing & manipulating numerical data
► Make the calculation and manipulation of data easier & quicker

Question 5

What function can we use to make some changes to an existing file to which you want to save but also leave the original document intact ?

Answer 5

’ Save as ‘ - then give the amended file a new name

–> original file remains in original form
–> file with new name contains changes

Question 6

Press Enter =

Answer 6

Move to cell below

Question 7

Shift + Enter =

Answer 7

Move to cell above

Question 8

• F5
• Fn + F5
• Ctrl + G

Answer 8

Go To –> specify cell address would like to move to

Question 9

Press Tab =

Answer 9

Move to the right

Question 10

Shift + Tab =

Answer 10

Move to the left

Question 11

Press what to select a group of cells adjacent to each other

Answer 11

1) Select the 1st cell
2) Press and hold Shift
3) Using arrow keys, press further cells

Question 12

Press what to select a group of cells not adjacent to each other

Answer 12

1) Select the 1st cell
2) Press and hold Ctrl
3) Using mouse pointer, press further cells

Question 13

Select an entire row of cells at one time

Answer 13

Shift + Spacebar

Question 14

Select an entire worksheet

Answer 14

Ctrl + A

Question 15

Worksheet

Answer 15

A single page/sheet in excel

Question 16

Workbook can contain more than one…?

Answer 16

Worksheet

Question 17

What is the content of a cell ?

Answer 17

• Text
• Values
• Formulae

Question 18

How to make Excel treat number as a text ?

Answer 18

Add apostrophe (‘) before it
–> then it will be Left aligned

Question 19

What is the default alignment for Text & Values

Answer 19

Text
- left aligned
- overflow to adjacent blank cells

Number
- right aligned
- NO overflow feature

Question 20

What do you call a small square in the corner of a cell ?

Answer 20

’ Fill handle ‘

Question 21

What appears when your mouse points to fill handle ?

Answer 21

’ Black cross ‘

Question 22

What does it mean when there is red triangle at the top right corner of the cell?

Answer 22

Someone add comment to the cell

Question 23

Cell protection/locking :

Condition : All cells are locked except those specifically unlocked

Answer 23

1) Select the range to be unlocked
2) Right click, choose Format Cells
3) Click Protection tab
4) Untick ‘Locked’ & ‘Hidden’ boxes
5) Go to ‘Review’ tab
6) Click ‘Protect Sheet’

** Only cells highlighted can be changed

Question 24

Cell protection/locking :

Condition : All cells are unlocked except those specifically locked

Answer 24

1) Select the whole worksheet
2) Untick ‘Locked’ & ‘Hidden’ boxes
3) Select the range to be locked
4) Right click, Format Cell
3) Click Protection tab
4) Tick the ‘Locked’ & ‘Hidden’ boxes
5) Click on ‘Protect Sheet’

Step 5 is important !! - cells can still be changed if you skip this

** Cells highlighted CANNOT be changed

Question 25

What does the formula bar shows ?

Answer 25

• Cell address of the active cell
• Formula

Question 26

=C4 + C5

Answer 26

Add value in C4 to C5

Question 27

=C4 - 5

Answer 27

Subtract 5 from value in C4

Question 28

= C4 - C5

Answer 28

Subtract value in C5 from value in C4

Question 29

= C4*5

Answer 29

Multiplies value in C4 by 5

Question 30

= C4* 120%

Answer 30

Adds 20% to the value in C4

Question 31

= 2^2

Answer 31

2 to the power of 2

OR

2²

Question 32

= 4 ^ (1/2)

Answer 32

Square root of 4

Question 33

Ctrl + 1

Answer 33

Format cells

Question 34

Ctrl + ;

Answer 34

Enter today’s date as a numerical value

Question 35

= TODAY()

Answer 35

Enter a date which will be updated each time the spreadsheet is opened

Question 36

explain :
ROUND (value, places)

Answer 36

Value –> value to be rounded
Places -> number of places to be rounded

Question 37

Relative cell reference

Answer 37

Change when you copy formulae to other locations

Question 38

Absolute cell reference ($)

Answer 38

Maintain the original cell reference

Question 39

Shortcut to absolute a cell

Answer 39

F4

Question 40

If you use Paste special and paste, does the pasted numbers change when you change the numbers in the original source

Answer 40

NO - They have become pure numbers and do not link back to their sources

Question 41

Circular reference

Answer 41

A formula that includes a reference to its own cell address

Question 42

Precedent

Answer 42

A cell that is referred to by another cell

–> to trace cells that provide data to the formula
–> tracer arrow appears

Question 43

Dependent

Answer 43

Opposite of precedent

–> A cell that contains a formula that refers to another cell

Question 44

DIV/0

Answer 44

Attempt to divide a number by zero/blank cell

Question 45

VALUE!

Answer 45

A mathematical formula refers to a cell containing text OR ada space dalam blank cell

** Function that operates on ranges (SUM,AVERAGE) will ignore text, so this error won’t occur

Question 46

NULL!

Answer 46

Cell references within formula are not separated correctly

Etc : separate ranges by space rather than colon

= (B4:B6) ✅
= (B4 B6) ❌ - #NULL!

Question 47

REF!

Answer 47

Formula has invalid cell reference (deleted/removed)

Question 48

#######

Answer 48

A column not being wide enough to display its contents

OR

A negative number is formatted as a date/time

Question 49

NAME?

Answer 49

A formula can’t find the referenced data it needs to complete the calculation

Etc: cell reference not exist / misspelt function name

Question 50

NUM!

Answer 50

A formula contains numeric values that aren’t valid

Question 51

N/A

Answer 51

No value is available