Excel Advanced 1

Home
Contact Us

Excel Knowledge Test
Advanced Level 1
General

Complete the answers first, then use the audio player at the
bottom of the page to hear answers and helpful tips

* Indicates required field

Name *

First

Last

Email *

When using the SUMIFS command, you can only use two conditions *

True False

The IF function always requires....arguments exactly *

3 2 0

How can you see the contents of the clipboard? *

Right click on a cell Home>Clipboard group>Dialogue box launcher Double click a sheet tab

Which function would you use to change the sign of a number from negative to positive? *

SINH ABS COSH ACOS ROWS

List the steps you would take to insert a text box onto a worksheet? *

[object Object]

List the steps you would take to enable titles to be printed on each page *

Where is the "Name Box" situated *

Above the heading for column A In the Home tab>Font group There is no box called that

Which tab holds the Protect Sheet command *

Home Page Layout Review

When using the Payment (PMT) function, what is the minimum number of arguments required? *

5 4 3 6

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 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 TestAdvanced Level 1GeneralComplete the answers first, then use the audio player at thebottom of the page to hear answers and helpful tips

Excel Knowledge Test
Advanced Level 1
General

Complete the answers first, then use the audio player at the
bottom of the page to hear answers and helpful tips