The staff at SharePoint Atlanta has created our Microsoft Office Quiz to test your knowledge of programs in the Microsoft Office suite. Some of the questions may deal with programs that are part of the suite, but may have used – and might want to investigate.
Take this test and see how much MS Office information you know.
Microsoft Office Quiz
Start
Congratulations - you have completed Microsoft Office Quiz.
You scored %%SCORE%% out of %%TOTAL%%.
Your performance has been rated as %%RATING%%
Your answers are highlighted below.
Question 1
The Microsoft Office program that focuses on diagraming, flowcharts, and brainstorming is called:
A
InDesign
B
Infopath
C
Visio
D
Access
Question 2
What is the maximum number of rows that you can have in a sheet in the new versions of Excel (2007, 2010, and 2013)?
A
250,000
B
815,200
C
1,048,576
D
5,105,000
Question 3
What is the maximum number of rows that you can have in a table in Microsoft Access?
A
815,200
B
1,048,576
C
5,105,000
D
Unlimited
Question 4
Advanced filters in Microsoft Access are called:
A
Queries
B
Functions
C
Tables
D
Formulas
Question 5
Having objects or text move in and/or out of PowerPoint slides is called:
A
Custom Moves
B
Stop-Motion
C
Animation
D
CGI
Question 6
An Excel formula that contains the cell that you’re currently in, in that same formula, is called a:
A
Default Error
B
Conditional Formatting
C
If Function
D
Circular Reference
Question 7
If you want to mail letters, envelopes, or labels in Microsoft Word, but you want to pull names and addresses from a list in a program like Excel, that’s typically called a:
A
SIC Code
B
Mail Merge
C
Print Queue
D
Bulk Mailer
Question 8
In Microsoft Access, if you want to link two tables together, one of the fields that links to the other table will often be a:
A
Lookup Value
B
Parameter Value
C
Primary Key
D
Input Mask
Question 9
The popular function in Microsoft Excel that allows you to find and retrieve information from one table and properly place it in another table is called:
A
SumIf
B
VLookup
C
Concatenate
D
Subtotal
Question 10
A program that's included in the Microsoft Office suite that focuses on helping you to take notes (even from websites) is called:
A
InfoPath
B
Publisher
C
Access
D
OneNote
Once you are finished, click the button below. Any items you have not completed will be marked incorrect.
Get Results
There are 10 questions to complete.
←
List
→
Return
Shaded items are complete.
1
2
3
4
5
6
7
8
9
10
End
Return
You have completed
questions
question
Your score is
Correct
Wrong
Partial-Credit
You have not finished your quiz. If you leave this page, your progress will be lost.
