Test
Checking your Excel knowledge.
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 (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.
- AVerdadero
- BFalso
3You can sort more than one column at a time by choosing Custom Sort from the Sort menu.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
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.
- AVerdadero
- BFalso
21You need to be careful when using Find/Replace as sometimes it can replace text you didn't want it to.
- AVerdadero
- BFalso
22When using the SUM function your answer has to be next to the figures you are adding up.
- AVerdadero
- BFalso
23What is the intersection of a row and a column is called?
- AWorksheet
- BCell
- CChart
- DSum
Información
- Descripción
- The quiz will check your overall understanding of Excel.
- Autor
- Liz Riggs
- Idioma
- English
- Visitas
- 147
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test