Home
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
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
Excel Questions
Word Questions
PowerPoint Test
>
PowerPoint
Contact Us