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?
-
<
You should select the whole column you want to sort before pressing the Sort button.
You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
What would you type in a cell to add 6 and 5?
6+5
=6+5
6+5=
What symbol would you use to divide?
~
/
^
\
What can you use the AutoFill handle for? (the black box at the bottom right of a cell)
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
What is a cell reference?
The column letter and row number
What is inside it
What symbol would you use to multiply?
x
*
#
Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.
=SUM(A1:A15)/15
=AVERAGE(A1:A15)
=AVERAGE(A1+A15)
=SUM(AVERAGE(A1-A15)
What is the best way to add the cells in A1 and B1 together?
=SUM(A1:B1)
=A1+B1
=SUM(A1+B1)
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.
How can you improve the look of your spreadsheet?
Add colour
Add shading
Add borders
Merge and Centre your heading
Format cells to currency where appropriate
All of the above
Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.
If a column heading is really wide compared to the data inside it, what is the best way to format this?
Merge and Centre
Wrap Text
What would you type in your cell to display 50%?
50 then format it to %
50%
.5 then format it to 50%
Excel can round your decimal places up or down for you.
Ascending is -
Largest to Smallest Z to A
Smallest to Largest A to Z
Descending is -
If you want to display just some of the data from your spreadsheet which feature can you use?
Filter
Find and Replace
Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.
You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
When using the SUM function your answer has to be next to the figures you are adding up.
What is the intersection of a row and a column is called?
Worksheet
Cell
Chart
Sum