Test
ECDL EXCEL
Este test tiene tipos de pregunta que se abren en el reproductor de siempre.
Preguntas del test (25)
1If I wanted to work out the sum/total of the cell range A1:A6 how would I type it into the formula bar?
- A=sum(A1:A6) ENTER
- B=total(A1:A6) ENTER
- Csum(A1:A6) ENTER
- Dtotal(A1:A6) ENTER
2Sorting something into ascending order means you are sorting from [blank_start]a to z[blank_end] or [blank_start]1 to 10[blank_end] for example.
- Aa to z
- B1 to 10
3To apply a percentage to a number you must use the formula tab.
- AVerdadero
- BFalso
4If the question mentions the word FORMAT you must use the format cells command on the home tab.
- AVerdadero
- BFalso
5How do you scale the page to fit one page high and two pages wide?
- AHome tab, replace command.
- BPage layout tab, scale to fit group.
- CPage layout tab, size command.
- DFile tab, print, custom scaling.
6If you are asked to add cell B5 and B7, how would you type this in? [blank_start]=B5+B7[blank_end]
- A=B5+B7
7If you were asked to divide cell B8 by B10, how would you type this in? [blank_start]=B8/B10[blank_end]
- A=B8/B10
8If you were asked to calculate the smallest value in a cell range which one would you use?
- A=counta
- B=max
- C=min
- D=count
9If you were asked to calculate the biggest value in a cell range which one would you use?
- A=max
- B=sum
- C=if
- D=min
10If you were asked to calculate whether a cell is more than or less than another cell which one would you use?
- A=average
- B=sum
- C=if
- D=count
11How would do you change the username?
- APage layout, margins
- BFile tab, options, username
- CReview tab, spelling and grammar
- DInsert tab, text box
12To rename worksheets you should double click on the appropriate sheet.
- AVerdadero
- BFalso
13Calculate the total of the following cell range B3:B11. How would this be typed in? [blank_start]=sum(B3:B11)[blank_end]
- A=sum(B3:B11)
14Calculate the average of the cell range B4:C6. How would you type this in? [blank_start]=average(B4:C6)[blank_end]
- A=average(B4:C6)
15When entering formulas into the work sheet, you must use the letter and number of the cell as the reference. e.g C4, B7, B2
- AVerdadero
- BFalso
16To insert data labels, which tab needs to be clicked on?
- ALayout tab
- BDesign tab
- CInsert tab
- DHome tab
17Cut and paste is used when something needs to be [blank_start]moved[blank_end]
- Amoved
18When editing a chart the format tab is used for...
- AInserting a title and data labels
- BChanging the shading and size of the chart
- CEditing the data on the chart
- DInserting a different chart type
19To zoom the view tab is used?
- AVerdadero
- BFalso
20It is possible to change the chart type even after it has been created?
- AVerdadero
- BFalso
21Copy and paste is used when more than [blank_start]one[blank_end] of something is needed.
- Aone
22Pictures and documents that are needed in the exam can be found in the [blank_start]z drive[blank_end]
- Az drive
23To add a title to a chart which tab do you need to be clicked on?
- ALayout
24It is possible to keep specific cells visible at all times even when scrolling?
- AVerdadero
- BFalso
25New sheets can be added using the format command
- AVerdadero
- BFalso
Información
- Descripción
- An exam to show progress.
- Autor
- Mollie Nichols
- Idioma
- English
- Visitas
- 1.483
- Etiquetas
- Valoración
- 3,0 de 5 · 1 valoración Valora este test