Quiz
ECDL EXCEL
This quiz has question types that open in the usual player.
Questions in this quiz (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.
- ATrue
- BFalse
4If the question mentions the word FORMAT you must use the format cells command on the home tab.
- ATrue
- BFalse
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.
- ATrue
- BFalse
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
- ATrue
- BFalse
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?
- ATrue
- BFalse
20It is possible to change the chart type even after it has been created?
- ATrue
- BFalse
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?
- ATrue
- BFalse
25New sheets can be added using the format command
- ATrue
- BFalse
Information
- Description
- An exam to show progress.
- Author
- Mollie Nichols
- Language
- English
- Views
- 1,483
- Tags
- Rating
- 3.0 out of 5 · 1 rating Rate this quiz