Test
How much can you remember about Excel? Level 1.
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
11You should always include a Legend on every chart you create.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
14You can display the formulas you have used in your spreadsheet by chosing Show Formulas from the Formulas menu.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
27You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
30You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
- AVerdadero
- BFalso
Información
- Descripción
- The quiz will check your overall understanding of Excel. This does not contain Level 2 elements.
- Autor
- Usuario eliminado
- Idioma
- English
- Visitas
- 19
- Historial
- Creado el 22 mar 2017 · actualizado el 22 mar 2017
- Etiquetas