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
(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