Microsoft Office Software Training

Skills Tests

If you are unsure about which level course you should be taking, click on the appropriate link below and answer the simple questions to be given a guide.
Microsoft Word Skills Test
Microsoft Excel Skills Test
Microsoft Access Skills Test
Microsoft Powerpoint Skills Test
Microsoft Outlook Skills Test

Microsoft Excel Skills Test

Please take the following test:
Which is not a kind of chart?
Pie
0

Scatter
0

Line
0

Distribution
2

How might you average a column of figures?
Aver function
0

Autosum button
2

Total the column then divide by the number of entries
0

Don't know
0

How can you alter the height of a row?
Drag the divider between row headers
2

Use the format menu row command
2

Right click the row and type a height
1

Don't know
0

Which function shows just the current date?
Today
2

Now
1

Date
0

Don't know
0

What kind of reference is $C4?
Absolute
0

Mixed
2

Relative
0

Don't know
0

To automatically copy formulae from one cell to another you would use
The Autocopy button
0

Copy and Paste
1

The Autofill button
2

Don't know
0

What formula do you need to count numbers in an excel 2007 table?
Don’t need one - turn on the totals row and use the drop button
2

The Count function
1

The Numbercount formula
0

Don't know
0

You have several rows containing headings in a distinctive style, and you need to change their font. Would you -
Highlight each of them and choose a different font in turn
1

Use the find & replace command
2

Create and apply a style
1

Don't know
0

What kind of entry is the number 01522 999999?
Number
0

Text
2

Telephone Number
0

Don't know
0

To display several different options on a spreadsheet without duplicating the figures we might use
Goal Seeking
0

Futurecasting
0

Scenarios
2

Evaluations
0

To summarize a large spreadsheet to show aggregate totals the best tool would be.
Pivot Table
2

The Autosum function
0

The Vlookup formula
0

Don't know
0

Thank you for taking the test.
Intec Business Colleges plc, Old School, Pennington Court, Rugby, Warwickshire, CV21 2BB, UK. VAT Number: 695223026 Company Number: 2494959
tel:01788 575090 fax:01788 575411 email:tracey.chaplin@getoncourse.net