Excel Introduction Level 1 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 150, we would suggest you take the quiz for the Excel Introduction Level 2 . If you achieve a score of less than 150, it suggests that the Excel Introduction Level 1 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

Email address *

Title *

Your answer

First Name *

Your answer

Last Name *

Your answer

Telephone Number *

Your answer

Company Name

Your answer

When you type a telephone number into a cell, the leading zero often disappears. To fix this you could:

10 points

Precede the number with an apostrophe

Precede the number with a hyphen

Set the format of the cell to number

In Excel, dates should always be typed in the format:

10 points

01/05/2017

01.05.2017

01 05 2017

In Excel time should always be typed in the format:

10 points

9:30

9.30

9 30

A Formula or Function in Excel is always preceded by an = sign

20 points

TRUE

FALSE

If you typed the following formula into a cell, what would the result be? =6-3*2

20 points

0

6

5

12

If you typed the following formula into a cell, what would the result be? =(6-3)*2

20 points

0

6

5

12

If you wanted to add the first 10 cells in column A, you could use the following function:

20 points

=ADD(A1:A10)

=SUM(A1:A10)

=TOTAL(A1:A10)

=SUM(A1-A10)

Which character does Excel use to represent division in a formula?

20 points

An asterisk *

A back slash \

A forward slash /

A percentage symbol %

Which character does Excel use to represent multiplication in a formula?

20 points

An asterisk *

The letter X

A forward slash /

A back slash \

The shortcut key for creating a chart on a new sheet is:

20 points

F8

ALT + F9

F11

ALT + F10

The Legend of a chart...

10 points

Is where you would enter the title of the chart

Displays a key to the colours used in the chart

Sets the Maximum and Minimum values

Allows you to choose the chart type

If you have changed data since you created your chart, you need to press F9 to update the link:

10 points

TRUE

FALSE

If you wanted your company logo to print on every page, you could add it to:

10 points

The Header or Footer

Heading Rows Repeat

Format Painter

Print Titles