Quiz
How much can you remember about Excel? Level 2.
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 (35)
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 function do you use to analyse the contents of a cell to return one value if a condition is true and another value if it's false.
- A=IF
- BIF=
- C=AND
- D=IF(AND
6How do you define a cell?
- AIts co-ordinates
- BIts column letter and row number
- CWhat is inside it
7What symbol would you use to multiply?
- Ax
- B*
- C~
- D#
8Choose 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)
9What is the best way to add the cells in A1 and B1 together?
- A=SUM(A1:B1)
- B=A1+B1
- C=SUM(A1+B1)
10Choose 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
11Pie charts are best to use when you are trying to compare parts of a whole.
- ATrue
- BFalse
12You should always include a Legend on every chart you create.
- ATrue
- BFalse
13A 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
14Sometimes 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
15You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
- ATrue
- BFalse
16How 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
17How 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
18Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.
- ATrue
- BFalse
19If 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
20What would you type in your cell to display 50%?
- A50 then format it to %
- B50%
- C.5 then format it to 50%
21Excel can round your decimal places up or down for you.
- ATrue
- BFalse
22You can create a chart quickly by pressing which function key?
- AF11
- BF4
23Absolute Cell References are used when you need to refer back to a single cell when dragging down a formula.
- ATrue
- BFalse
24Ascending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
25Descending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
26If you want to display just some of the data from your spreadsheet which feature can you use?
- AFilter
- BFind and Replace
27Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.
- ATrue
- BFalse
28You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- ATrue
- BFalse
29What 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<
30What is the correct format when using the IF and AND functions together?
- A=IF(AND(question1,answer if true,answer if false,question2,answer if true, answer if false))
- B=IF(question1,and,question2),answer if true, answer if false
- C=IF(AND(question1,question2),answer if true,answer if false)
31What does this mean?
A1<B1- AA1 is greater than B1
- BA1 is less than B1
32When you are going to use an Excel spreadsheet as the data for a mail merge it is important to check that the headings are in Row 1 of your spreadsheet, if not, you should create a Named Range.
- ATrue
- BFalse
33You can use the IF function to return one value if a condition is true and another value if it's false.
- ATrue
- BFalse
34What does this mean?
>=- AMore than
- BAt least
- CGreater than or equal to
- DMeets
- ELess than or equal to
- FAll of the above
- GNone of the above
35What does this mean?
<=- ALess than or equal to
- BAt least
- CMeets
- DGreater than or equal to
- ENo more than
- FAll of the above
- GNone of the above
Information
- Description
- The quiz will check your overall understanding of Excel. This contains questions relevant to Level 1 learners but also some additional questions for Level 2 learners.
- Author
- Liz Riggs
- Language
- English
- Views
- 1
- History
- Created on 31 Jul 2015 · updated on 22 Mar 2017
- Tags
- Rating
- No ratings yet Rate this quiz