Quiz
Checking your Excel knowledge.
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 (23)
1What 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<
2You should select the whole column you want to sort before pressing the Sort button.
- ATrue
- BFalse
3You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
- ATrue
- BFalse
4What would you type in a cell to add 6 and 5?
- A6+5
- B=6+5
- C6+5=
5What symbol would you use to divide?
- A~
- B/
- C^
- D\
6What 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
7What is a cell reference?
- AThe column letter and row number
- BWhat is inside it
8What symbol would you use to multiply?
- Ax
- B*
- C~
- D#
9Choose 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)
10What is the best way to add the cells in A1 and B1 together?
- A=SUM(A1:B1)
- B=A1+B1
- C=SUM(A1+B1)
11Sometimes 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
12How 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
13Using Merge and Centre is a really good option for the Title line of your spreadsheet as it will make it stand out.
- ATrue
- BFalse
14If 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
15What would you type in your cell to display 50%?
- A50 then format it to %
- B50%
- C.5 then format it to 50%
16Excel can round your decimal places up or down for you.
- ATrue
- BFalse
17Ascending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
18Descending is -
- ALargest to Smallest
Z to A - BSmallest to Largest
A to Z
- ALargest to Smallest
19If you want to display just some of the data from your spreadsheet which feature can you use?
- AFilter
- BFind and Replace
20Freeze Panes is a handy tool when working with a large spreadsheet as it keeps your headings at the top of your screen.
- ATrue
- BFalse
21You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- ATrue
- BFalse
22When using the SUM function your answer has to be next to the figures you are adding up.
- ATrue
- BFalse
23What is the intersection of a row and a column is called?
- AWorksheet
- BCell
- CChart
- DSum
Information
- Description
- The quiz will check your overall understanding of Excel.
- Author
- Liz Riggs
- Language
- English
- Views
- 146
- Tags
- Rating
- No ratings yet Rate this quiz