Quiz

How much can you remember about Excel? Level 2.

Deleted user 35 questions Updated 22 Mar 2017

Take the quiz

Questions in this quiz (35)

1What would you type in a cell to add 6 and 5?
1. A6+5
2. B=6+5
3. C6+5=
2When creating a chart, it is best to use as much data as possible from your spreadsheet.
1. ATrue
2. BFalse
3What symbol would you use to divide?
1. A~
2. B/
3. C^
4. D\
4What can you use the AutoFill handle for?
(the black box at the bottom right of a cell)
1. ATo copy formulas down or across your spreadsheet
2. BTo automatically enter series like days of the week or months of the year
3. CTo create your own numbered list
4. 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.
1. A=IF
2. BIF=
3. C=AND
4. D=IF(AND
6How do you define a cell?
1. AIts co-ordinates
2. BIts column letter and row number
3. CWhat is inside it
7What symbol would you use to multiply?
1. Ax
2. B*
3. C~
4. D#
8Choose the correct formula to work out the mean (average) of the cells in the range A1 to A15.
1. A=SUM(A1:A15)/15
2. B=AVERAGE(A1:A15)
3. C=AVERAGE(A1+A15)
4. D=SUM(AVERAGE(A1-A15)
9What is the best way to add the cells in A1 and B1 together?
1. A=SUM(A1:B1)
2. B=A1+B1
3. C=SUM(A1+B1)
10Choose the best chart to use when comparing two sets of numbers.
1. APie
2. BBar
3. CScatter
4. DColumn
5. 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.
1. ATrue
2. BFalse
12You should always include a Legend on every chart you create.
1. ATrue
2. BFalse
13A good chart should include which of the following?
1. ATitle
2. BX Axis Label
3. CY Axis Label
4. DLegend (if more than one series is being displayed)
5. 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.
1. ATrue
2. BFalse
15You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
1. ATrue
2. BFalse
16How can you improve the look of your spreadsheet?
1. AAdd colour
2. BAdd shading
3. CAdd borders
4. DMerge and Centre your heading
5. EFormat cells to currency where appropriate
6. FAll of the above
17How can you improve the look of your column, bar or scatter chart?
1. AAdd shading
2. BChange colours of the series
3. CAdd a chart title
4. DAdd X & Y axis titles
5. 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.
1. ATrue
2. BFalse
19If a column heading is really wide compared to the data inside it, what is the best way to format this?
1. AMerge and Centre
2. BWrap Text
20What would you type in your cell to display 50%?
1. A50 then format it to %
2. B50%
3. C.5 then format it to 50%
21Excel can round your decimal places up or down for you.
1. ATrue
2. BFalse
22You can create a chart quickly by pressing which function key?
1. AF11
2. BF4
23Absolute Cell References are used when you need to refer back to a single cell when dragging down a formula.
1. ATrue
2. BFalse
24Ascending is -
1. ALargest to Smallest
  Z to A
2. BSmallest to Largest
  A to Z
25Descending is -
1. ALargest to Smallest
  Z to A
2. BSmallest to Largest
  A to Z
26If you want to display just some of the data from your spreadsheet which feature can you use?
1. AFilter
2. 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.
1. ATrue
2. BFalse
28You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
1. ATrue
2. 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?
1. A-
2. B<
30What is the correct format when using the IF and AND functions together?
1. A=IF(AND(question1,answer if true,answer if false,question2,answer if true, answer if false))
2. B=IF(question1,and,question2),answer if true, answer if false
3. C=IF(AND(question1,question2),answer if true,answer if false)
31What does this mean?

A1<B1
1. AA1 is greater than B1
2. 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.
1. ATrue
2. BFalse
33You can use the IF function to return one value if a condition is true and another value if it's false.
1. ATrue
2. BFalse
34What does this mean?

>=
1. AMore than
2. BAt least
3. CGreater than or equal to
4. DMeets
5. ELess than or equal to
6. FAll of the above
7. GNone of the above
35What does this mean?

<=
1. ALess than or equal to
2. BAt least
3. CMeets
4. DGreater than or equal to
5. ENo more than
6. FAll of the above
7. 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: Deleted user
Language: English
Views: 19
History: Created on 22 Mar 2017 · updated on 22 Mar 2017
Tags: user has deleted their subject information

How much can you remember about Excel? Level 2.

Create a free account to finish this quiz

Questions in this quiz (35)

Information

Feedback

What do you think of the new look?