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

Prevent the formula from being moved or copied

Prevent the cell reference from changing when the formula is copied or moved

Ensure the cell reference changes when the formula is copied or moved

Make sure that the result of the formula is zero

The shortcut key to change a relative reference into an absolute reference is:

10 points

SHIFT + F7

F5

ALT + F5

F4

A Named Range can be used instead of an Absolute Reference:

10 points

True

False

A Range Name cannot contain spaces:

10 points

True

False

A Named Range can be used as part of a formula or function:

10 points

True

False

To count a list of surnames in the range A2:A7 which of the following functions could be used?

10 points

=COUNT(A2:A7)

=COUNTA(A2:A7)

=COUNTTEXT(A2:A7)

=COUNTITEM(A2:A7)

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

=CAPS(A2)

=FIRSTCAP(A2)

=UPPER(A2)

=PROPER(A2)

Which function will round Fred’s grade average to 81 with no decimal places?

10 points

=ROUND(”Fred”,0)

=ROUNDUP(A2,B2)

=ROUNDUP(B2,0)

=ROUND(A2,0)

If you want the cell to always display the current date, which function would you use?

10 points

=DAY()

=CURRENTDATE()

=DATE()

=TODAY()