Excel Assessment - Advanced Level
Quiz-summary
0 of 13 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
Information
Loading test…
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
| Average score |
|
| Your score |
|
Categories
- C) Advanced 0%
-
Hmmm… it can get quite lonely at the top ! – not many people even try this level, so well done! We’re glad to see you here!
Your score is shown above – you need at least 50 points to pass – did you make it??
Next Steps:
1) Click on the “Review your answers…” button below to check our explanations for each question against your answer
2) Have you done the Outlook Assessments? Go to your Dashboard and start them there
3) Return to your dashboard and review answers from there – and download your certificate (Dashboard)
While you are here, can we ask for a favour?
Click here to Challenge a friend! by email
| Pos. | Name | Entered on | Points | Result |
|---|---|---|---|---|
| Table is loading | ||||
| No data available | ||||
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- Answered
- Review
-
Question 1 of 13
1. Question
Caroline wants to check out the effect of different GP and Expense percentages and ratios using the Scenario tool. The figures she has are in column B, and in column C she has inserted some new figures, but she would like these figures to be set up as a scenario. The scenario dialogue box is showing in the picture, complete the settings required to set up the figures in column C as a scenario:
- The address of the first cell in the Scenario dialogue box should be (B2, $B$2) and the value set to (0.37, 37%) The address of the second cell in the Scenario dialogue box should be (B4, $B$4) and the value set to (0.18, 18%)
Correct
Incorrect
-
Question 2 of 13
2. Question
Caroline is about to create a PivotTable using the information above. Is this data ready to use in a PivotTable?
Correct
Incorrect
-
Question 3 of 13
3. Question
Caroline has created this PivotTable and her boss is asking to see the detail of the transactions that make up the $3938.62 sales to Aenean. What is the quickest way to do this?
Correct
Incorrect
-
Question 4 of 13
4. Question
Dates have been added to the column labels, but Caroline wants to the PivotTable column labels to be subtotals by month, not by each date. How does she do that?
Correct
Incorrect
-
Question 5 of 13
5. Question
What is shown in the image above?
Correct
Incorrect
-
Question 6 of 13
6. Question
Observe the PivotTable field panel above and indicate which one of the images below is the matching PivotTable
Correct
Incorrect
-
Question 7 of 13
7. Question
Below is a simple macro that displays a message. Fill in the missing parts.
-
(Sub, sub) HelloMessage()
MsgBox "Hello"
(End, end) Sub
Correct
Incorrect
-
(Sub, sub) HelloMessage()
-
Question 8 of 13
8. Question
It is a good idea to include comments in your VBA code to explain what each section does. Below is a macro, add a comment that says “Display completed message” in the space provided.
This comment needs to be typed in without the quote marks, and exactly as it’s written here.
-
MyDataObj.SetText HTMLCode
MyDataObj.PutInClipboard
('Display completed message)
MsgBox "HTML Code generated"
End Sub
Correct
Incorrect
-
MyDataObj.SetText HTMLCode
-
Question 9 of 13
9. Question
You have a macro and you want to tell VBA about a variable and what sort of data it will represent – complete the line of code below.
- (Dim, DIM, dim) MyWS as String
Correct
Incorrect
-
Question 10 of 13
10. Question
Below is a simple loop statement – complete the missing parts
-
For (Each) cell (In) Selection.Cells
MyNum = cell.Value
If MyNum < 5 Then
MsgBox "Your number is less than 5"
Else
MsgBox "Your number is greater than 5"
End If
Next (cell)
Correct
Incorrect
-
For (Each) cell (In) Selection.Cells
-
Question 11 of 13
11. Question
Below is a IF/ELSE statement taken from a macro, complete the missing parts.
-
(If) MyNum < 5 (Then)
MsgBox "Your number is less than 5"
(Else)
MsgBox "Your number is greater than 5"
(End If)
Correct
Incorrect
-
(If) MyNum < 5 (Then)
-
Question 12 of 13
12. Question
Take a look the image above. Caroline is trying to work out how many calls she has to make to hit her sales target of $350.000,00. She knows that for every 100 calls she makes, 16 will purchase her product, and the average order value is $1.500,00. Below are the different values that need to be entered into the Goal Seek dialogue box to calculate this – assign them to the right slots.
Sort elements
- $B$5
- 350000
- $B$3
- $B$1
-
Set Cell:
-
To Value:
-
By changing cell:
-
Not used:
Correct
Incorrect
-
Question 13 of 13
13. Question
Caroline has this data and she would like to enter a formula in cell M129 that will give her the total of the cells that are visible when she applies the AutoFilter. Complete the formula below:
- = (SUBTOTAL)( (9),M2:M128)
Correct
Incorrect
Lost your password?