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
TestsFiles
Blog
Contact Us
Privacy Policy
United Computer Consultants
Excel Knowledge Test
Beginner Level 1
General
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 an Excel "function"?
*
A meeting at Microsoft
A pre-written formula
A cell containing data
An error message
How many rows are there in a worksheet in Excel 2007, 2010, and 2013
*
100
2,345,000
1,048,576
16,384
Which function adds numbers?
*
Vlookup
Average
If
Sum
How many worksheets appear by default in a new file?
*
1
2
3
4
What symbol precedes all formulas?
*
$
&
=
?
#
When the right mouse button is clicked a .... appears
*
Menu
Formula
Chart
New worksheet
Email program
Which keyboard shortcut enters the current date?
*
Shift-*
Ctrl-;
Ctrl-)
How many columns are there in a worksheet in Excel 2007, 2010 and 2013?
*
23,480
16,384
256
A cell is populated with data after typing by ...(click all that apply)
*
Pressing the Enter key
Clicking on another cell
Pressing Ctrl-Enter
Excel is great for ...... (click all that apply)
*
Budgeting
Writing a novel
Creating charts
Click the graphic to subscribe BEFORE submitting your answers
Submit my answers
Click the audio player above to hear answers and helpful tips