Home
MS Office Tests
Excel Tests
>
Excel - Basic
>
Excel - Basic 1 - General
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
Job Test Downloads
Blog
Contact Us
United Computer Consultants
Excel Knowledge Test
Beginner Level 3
Functions
Complete the test first, then listen to the answers by clicking
on the audio player at the bottom of the page.
*
Indicates required field
Name
*
First
Last
Email
*
What is wrong with this..... =Sum(A1+A2
*
Function does not exist
= sign not needed
Missing parenthesis
What name is given to data within brackets
*
Arguments
Chart information
Exclusions
What does the colon mean...=Sum(A1:A7)
*
Exclude some cells
Include all cells between A1 and A7 inclusive
Does not mean anything
Do ALL functions require arguments?
*
Yes
No
Not sure
The "Count" function...
*
Counts everything in selected cells
Only counts selected cells containing numbers
Only counts selected cells containing text
Tick the two functions requiring arguments
*
Vlookup
Today
Average
The "Counta" function....
*
Counts selected cells containing anything
Counts selected cells with text and blank cells
Counts all selected cells except for blank cells
What separates arguments?
*
A forward slash
A semi-colon
A comma
The "Countblank" function....
*
Counts every blank cell in the worksheet
Only counts any blank cells in the selected cells
Deletes data from cells to make them blank
Tick the incorrect formulas (hint: there are two)
*
=sum(a2:b3,100d6)
=today()
=countblank(f5/f9)
Click here to join the mailing list to receive software tips and tricks
Use the audio player above to hear answers and helpful tips
✕
