Microsoft Office Tutorials and References

In Depth Information

**Summary**

Brain Training

Let’s try a quiz to see what you’ve learned. There might be multiple right answers.

1.
If a cell has a formula in it but you

want the calculated values always to

be whole numbers, you should:

(a)
=B1

(b)
=B1 \ 2

(c)
=B1+B2) * 3

(a) Format the cell so it has no decimal

places

(d)
=B1 / 3

(b) Use ROUND to round the cell to the

nearest whole number

4.
If you want to copy a formula to a

different row but want to still refer

to cell B2, you could:

(c) Make sure you only enter whole

numbers into your spreadsheet

(a) Use the Home ribbon when you

paste it

(d) Format the cell as a percentage

(b) Change the cell reference to $B$2

2.
To make sure your spreadsheet is

ﬂ exible, it’s a good idea to:

(c) Change the cell reference to $B2

(d) Take the number that’s in cell B2 and

write it into the formula

(a) Put as many of your basic numbers as

possible into formulae

(b) Put as much of your information as

possible on screen in cells

5.
If you want to know the total of

three cells that are next to each

other, you could:

(c) Use formulae to link cells that will

always be closely related

(a) Use SUM to total them

(d) Do stretching exercises by changing

the column widths regularly

(b) Write a formula that adds them up

(c) Select the cells and look at the

bottom of the screen

3.
Which of these formula is valid (at

least one will produce an error):

(d) Check the headings

Answers

Q1
– b

Q2
– b and c

– a and d
Q3

Q4
– b

– a, b and c
Q5