Quiz
How much can you remember about Excel? Level 1.
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 (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.
- 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 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.
- ARichtig
- BFalsch
11You should always include a Legend on every chart you create.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
14You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
27You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- ARichtig
- BFalsch
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.
- ARichtig
- BFalsch
30You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
- ARichtig
- BFalsch
Informationen
- Beschreibung
- The quiz will check your overall understanding of Excel. This does not contain Level 2 elements.
- Autor
- Gelöschter Nutzer
- Sprache
- English
- Aufrufe
- 19
- Verlauf
- Erstellt am 22 Mär 2017 · aktualisiert am 22 Mär 2017
- Schlagwörter