Excel - Intermediate 5

Home
MS Office Tests
Downloads
- Excel
- Word
- PowerPoint
Job Test Downloads
Blog
Contact Us

United Computer Consultants

Helpful video:
Learn how to avoid duplicate entries in a column: - https://youtu.be/YDkExNfYKQE

Excel Knowledge Test
Intermediate Level 5
General

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.

* Indicates required field

Name *

First

Last

Email *

What must you first do to Conditionally Format data *

Click in cell A1 Select the data Click in any cell

What must surround text that is being used in formulas *

Single quote marks Exclamation marks Double quote marks

What are "Sparklines" *

A Firefox message A small chart in a cell A formatted chart

All formulas start with an = sign. What is the alternative symbol *

* ? +

Which tab is required to create a simple macro *

Developer Page Layout References

What is the program called that enables macros to be created or edited *

Mozilla Firefox Photoshop Visual Basic

Can a trendline be inserted on a 3D chart *

Yes No

Which tab and command would you use to avoid duplicate data entries in a column *

Home>Cells>Insert Data>Data Validation Formulas>Name Manager>Define Name

Click here to join the mailing list to receive software tips and tricks

Use the audio player above to hear answers and helpful tips

Note that ads appear on various pages, which may generate income for United Computer Consultants.
Visitors to this site are free to use the ads at their discretion but in no way does United Computer Consultants request such usage.
Without exception, we abide by the rules governing the display of advertising on the site.

© United Computer Consultants 2018. All rights reserved

Excel Knowledge Test Intermediate Level 5 GeneralComplete the test first, then listen to the answers by clickingon the audio player at the bottom of the page.

Excel Knowledge Test
Intermediate Level 5
General

Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.