Excel Introduction Level 2 Quiz
Clearwater IT Training

Use this quiz to decide whether this course will be useful for you. You will be asked a series of multiple choice questions.
If you achieve a score above 70, we would suggest you take the quiz for the Excel Intermediate Level 1 . If you achieve a score of less than 70, it suggests that the Excel Introduction Level 2 course would be suitable for you. Please call Tel: 01462 222013 if you would like further information or wish to make a booking, or you can email: info@clearwatertraining.co.uk

Title *
Your answer
First Name *
Your answer
Last Name *
Your answer
Telephone Number *
Your answer
Company Name
Your answer
Absolute References are used in Excel formulae in order to:
20 points
The shortcut key to change a relative reference into an absolute reference is:
10 points
A Named Range can be used instead of an Absolute Reference:
10 points
A Range Name cannot contain spaces:
10 points
A Named Range can be used as part of a formula or function:
10 points
To count a list of surnames in the range A2:A7 which of the following functions could be used?
10 points
Captionless Image
I have someones full name in cell A2, typed in lower case. Which function could I use to capitalize the first letter of the first and last name?
10 points
Captionless Image
Which function will round Fred’s grade average to 81 with no decimal places?
10 points
Captionless Image
If you want the cell to always display the current date, which function would you use?
10 points
Submit
Never submit passwords through Google Forms.
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Additional Terms