Quiz
How much can you remember about Excel? Level 1.
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (30)
1What would you type in a cell to add 6 and 5?
- A6+5
- B=6+5
- C6+5=
2When creating a chart, it is best to use as much data as possible from your spreadsheet.
- ATrue
- BFalse
3What symbol would you use to divide?
- A~
- B/
- C^
- D\
4What can you use the AutoFill handle for?
(the black box at the bottom right of a cell)- ATo copy formulas down or across your spreadsheet
- BTo automatically enter series like days of the week or months of the year
- CTo create your own numbered list
- DIt can only be used to copy formulas
5What is a cell reference?
- AThe column letter and row number
- BWhat is inside it
6What symbol would you use to multiply?
- Ax
- B*
- C~
- D#
7Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.
- A=SUM(A1:A15)/15
- B=AVERAGE(A1:A15)
- C=AVERAGE(A1+A15)
- D=SUM(AVERAGE(A1-A15)
8What is the best way to add the cells in A1 and B1 together?
- A=SUM(A1:B1)
- B=A1+B1
- C=SUM(A1+B1)
9Choose the best chart to use when comparing two sets of numbers.
- APie
- BBar
- CScatter
- DColumn
- EAll of the above, it doesn't make that much difference as long as you label it
10Pie charts are best to use when you are trying to compare parts of a whole.
- ATrue
- BFalse
11You should always include a Legend on every chart you create.
- ATrue
- BFalse
12A good chart should include which of the following?
- ATitle
- BX Axis Label
- CY Axis Label
- DLegend (if more than one series is being displayed)
- EAll of the above
13Sometimes 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.
- ATrue
- BFalse
14You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
- ATrue
- BFalse
15How can you improve the look of your spreadsheet?
- AAdd colour
- BAdd shading
- CAdd borders
- DMerge and Centre your heading
- EFormat cells to currency where appropriate
- FAll of the above
16How can you improve the look of your column, bar or scatter chart?
- AAdd shading
- BChange colours of the series
- CAdd a chart title
- DAdd X & Y axis titles
- EAll of the above
17Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.
- ATrue
- BFalse
18If a column heading is really wide compared to the data inside it, what is the best way to format this?
- AMerge and Centre
- BWrap Text
19What would you type in your cell to display 50%?
- A50 then format it to %
- B50%
- C.5 then format it to 50%
20Excel can round your decimal places up or down for you.
- ATrue
- BFalse
21You can create a chart quickly by pressing which function key?
- AF11
- BF4
22Absolute Cell References are used when you need to refer back to a single cell when dragging down a formula.
- ATrue
- BFalse
23Ascending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
24Descending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
25If you want to display just some of the data from your spreadsheet which feature can you use?
- AFilter
- BFind and Replace
26Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.
- ATrue
- BFalse
27You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- ATrue
- BFalse
28What 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?
- A-
- B<
29You should select the whole column you want to sort before pressing the Sort button.
- ATrue
- BFalse
30You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
- ATrue
- BFalse
Information
- Description
- The quiz will check your overall understanding of Excel. This does not contain Level 2 elements.
- Author
- Deleted user
- Language
- English
- Views
- 19
- History
- Created on 22 Mar 2017 · updated on 22 Mar 2017
- Tags