Excel - Intermediate 3 - UNITED COMPUTER CONSULTANTS

Home
Contact Us

Use the following links to see training videos which will assist in answering the questionnaire:
Insert a bullet point: https://youtu.be/UytAzptn63E

Excel Knowledge Test
Intermediate 3
General

* Indicates required field

Name *

First

Last

Email *

How would you group worksheets *

Click a sheet, hold down Shift, click on another Drag through the sheet tabs Copy an paste worksheets

When naming cells, what must the first character be? *

An = sign A $ sign A letter or underscore

Name two advantages of grouping sheets *

Explain the steps to insert a bullet point in a cell. *

How do you resize the formula bar? *

Click any cell below the formula bar Point at the bottom edge of the bar, drag down It cannot be resized

What do you understand by "non-contiguous"? *

There are blank cells or text in the list of values The cells are filled with color It does not mean anything in Excel It means "not together or next to each other"

Using the Alt-Enter keyboard combination... *

Selects any chart in the worksheet Selects the entire worksheet Allows word wrapping in a cell

Data can be sorted by more than one column. *

No Yes Only when a chart has been inserted

submit

Use the audio player above to hear answers and helpful tips

Go to top

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 3 General

Excel Knowledge Test
Intermediate 3
General