Quiz
How much can you remember about Excel? Level 2.
Erstelle ein kostenloses Konto, um dieses Quiz zu beenden
Speichere deinen Fortschritt und sieh dir dein Endergebnis an.
oder mit deiner E-Mail registrieren
Schon ein Konto? Anmelden
Fragen in diesem 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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
12You should always include a Legend on every chart you create.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
15You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
28You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
33You can use the IF function to return one value if a condition is true and another value if it's false.
- ARichtig
- BFalsch
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
Informationen
- Beschreibung
- 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.
- Autor
- Gelöschter Nutzer
- Sprache
- English
- Aufrufe
- 19
- Verlauf
- Erstellt am 22 Mär 2017 · aktualisiert am 22 Mär 2017
- Schlagwörter