What would you type in a cell to add 6 and 5?
When creating a chart, it is best to use as much data as possible from your spreadsheet.
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?
Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.
What is the best way to add the cells in A1 and B1 together?
Choose the best chart to use when comparing two sets of numbers.
All of the above, it doesn't make that much difference as long as you label it
Pie charts are best to use when you are trying to compare parts of a whole.
You should always include a Legend on every chart you create.
A good chart should include which of the following?
X Axis Label
Y Axis Label
Legend (if more than one series is being displayed)
All of the above
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.
You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
How can you improve the look of your spreadsheet?
Merge and Centre your heading
Format cells to currency where appropriate
How can you improve the look of your column, bar or scatter chart?
Change colours of the series
Add a chart title
Add X & Y axis titles
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
What would you type in your cell to display 50%?
50 then format it to %
.5 then format it to 50%
Excel can round your decimal places up or down for you.
You can create a chart quickly by pressing which function key?
Absolute Cell References are used when you need to refer back to a single cell when dragging down a formula.
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?
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.
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.