Question 1
Question
What symbol do you use for "less" if you had to create a formula to calculate Profit and were told this is Income less Running Costs?
Question 2
Question
You should select the whole column you want to sort before pressing the Sort button.
Question 3
Question
You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
Question 4
Question
What would you type in a cell to add 6 and 5?
Question 5
Question
What symbol would you use to divide?
Question 6
Question
What can you use the AutoFill handle for?
(the black box at the bottom right of a cell)
Answer
-
To copy formulas down or across your spreadsheet
-
To automatically enter series like days of the week or months of the year
-
To create your own numbered list
-
It can only be used to copy formulas
Question 7
Question
What is a cell reference?
Question 8
Question
What symbol would you use to multiply?
Question 9
Question
Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.
Answer
-
=SUM(A1:A15)/15
-
=AVERAGE(A1:A15)
-
=AVERAGE(A1+A15)
-
=SUM(AVERAGE(A1-A15)
Question 10
Question
What is the best way to add the cells in A1 and B1 together?
Answer
-
=SUM(A1:B1)
-
=A1+B1
-
=SUM(A1+B1)
Question 11
Question
Sometimes printing an Excel spreadsheet can be tricky because if it is too big it will go onto a second page and there's nothing you can do about that.
Question 12
Question
How can you improve the look of your spreadsheet?
Question 13
Question
Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.
Question 14
Question
If a column heading is really wide compared to the data inside it, what is the best way to format this?
Answer
-
Merge and Centre
-
Wrap Text
Question 15
Question
What would you type in your cell to display 50%?
Answer
-
50 then format it to %
-
50%
-
.5 then format it to 50%
Question 16
Question
Excel can round your decimal places up or down for you.
Question 17
Question 18
Question 19
Question
If you want to display just some of the data from your spreadsheet which feature can you use?
Question 20
Question
Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.
Question 21
Question
You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
Question 22
Question
When using the SUM function your answer has to be next to the figures you are adding up.
Question 23
Question
What is the intersection of a row and a column is called?