UNITED COMPUTER CONSULTANTS
Home
Downloads
Excel
Word
PowerPoint
Blog
Contact Us
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 the graphic to the right to subscribe
Submit my answers
Use the audio player above to hear answers and helpful tips
Home
Downloads
Excel
Word
PowerPoint
Blog
Contact Us
