UNITED COMPUTER CONSULTANTS
Home
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel Basic 1 - Basic Excel
Excel Basic 2 - Keyboard Shortcuts
Excel - Basic 3 - Functions
Excel - Basic 4 - Pivot Tables
Excel - Basic 5 - The IF function
Excel - Intermediate
>
Excel - Intermediate 1
Excel - Intermediate 2
Excel - Intermediate 3
Excel - Intermediate 4
Excel - Intermediate 5
Excel Advanced
>
Excel Advanced 1
Excel Advanced 2
Word Tests
>
Word - Basic
>
Word - Basic1 - General
Word - Basic 2 - Keyboard Shortcuts
Word - Basic 3 - Formatting
Word - Basic 4 - Tables
Word Tips and Tricks
Word Intermediate
>
Word - Intermediate - General
PowerPoint Tests
>
PowerPoint
Downloads
Excel
Word
PowerPoint
TestsFiles
Blog
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
Home
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel Basic 1 - Basic Excel
Excel Basic 2 - Keyboard Shortcuts
Excel - Basic 3 - Functions
Excel - Basic 4 - Pivot Tables
Excel - Basic 5 - The IF function
Excel - Intermediate
>
Excel - Intermediate 1
Excel - Intermediate 2
Excel - Intermediate 3
Excel - Intermediate 4
Excel - Intermediate 5
Excel Advanced
>
Excel Advanced 1
Excel Advanced 2
Word Tests
>
Word - Basic
>
Word - Basic1 - General
Word - Basic 2 - Keyboard Shortcuts
Word - Basic 3 - Formatting
Word - Basic 4 - Tables
Word Tips and Tricks
Word Intermediate
>
Word - Intermediate - General
PowerPoint Tests
>
PowerPoint
Downloads
Excel
Word
PowerPoint
TestsFiles
Blog
Contact Us