Excel - Intermediate 5 - UNITED COMPUTER CONSULTANTS

Home
Contact Us

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

Excel Knowledge Test
Intermediate Level 5
General

* 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

submit

Use the audio player above to hear answers and helpful tips

Note that ads may 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 2022. All rights reserved

Home
Contact Us

Excel Knowledge Test Intermediate Level 5 General

Excel Knowledge Test
Intermediate Level 5
General