Quiz: Microsoft Excel Proficiency Test!
Here we have a Microsoft Excel proficiency test for you. Microsoft Office comes with a lot of tools that help in processing and inputting different types of data. One of the applications most people have a hard time with is Excel due to the many types of data it can handle. Do you know how to make the most use of it? Do take up the quiz and get to see if you might need a refresher course on using this tool.
- 1.What is the keyboard shortcut command to move the mouse pointer to cell A1
- A.
Control + Home
- B.
Control + F4 key
- C.
Name box
- D.
Control + A1
- E.
Control + Tab key
- 2.A workbook contains
- A.
1 worksheet
- B.
2 worksheets
- C.
3 worksheets
- D.
4 worksheets
- E.
No worksheets
- 3.The feature that enables you to automatically complete a list of 12 months after you key one month is
- A.
Cell style
- B.
Fill handle or Autofill
- C.
Page layout
- D.
Find
- E.
Replace
- 4.What is the default alignment for values and dates in a cell?
- A.
Justified
- B.
Left aligned
- C.
Centered
- D.
Bottom aligned
- E.
Right aligned
- 5.What command combines several cells into one cell ocupying the same screen space?
- A.
Merge and Center
- B.
Align
- C.
Freeze columns
- D.
Indent
- E.
Split
- 6.What is the keyboard shortcut to display or hide formulas?
- A.
Control + F4 key
- B.
Control + ~
- C.
Control + K
- D.
Control + P
- E.
Control +F
- 7.How would the cell reference $F$4 be described?
- A.
Mixed reference
- B.
Absolute reference
- C.
Relative reference
- D.
Additional reference
- E.
Money reference
- 8.What type of operation is being performed in the formula = A4*B5?
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
- 9.Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
- 10.What term describes a model workbook used as the basis for other workbooks?
- A.
Form
- B.
Demonstration
- C.
Template
- D.
Cell styles
- E.
Page Layout
- 11.How can you start Edit mode to edit a formula?
- A.
Tools
- B.
Format
- C.
F4
- D.
F2 or double-click cell
- E.
Find and replace
- 12.Three types of data visualization are:
- A.
Tools, Columns, Styles
- B.
Data bars, Color scales, Icon sets
- C.
Cell styles, Bold, Italics
- D.
Home, Edit, Fill
- E.
Shapes, Arrows, Clip art
- 13.Name the function that adds cell values only if they meet your criteria.
- A.
Average()
- B.
Count()
- C.
Mean()
- D.
SumIF()
- E.
Round
- 14.What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
- 15.Which logical function shows the opposite of the condition?
- A.
NOT function
- B.
False function
- C.
Nper function
- D.
Sum function
- E.
PMT function
- 16.Which financial function would help you determine how much money will be in your account at the end of a year if you make regular payments?
- A.
NPER function
- B.
Sum function
- C.
FV function
- D.
PMT function
- E.
Today function
- 17.What is the term used to describe a function inside a function?
- A.
Conditional
- B.
Argument
- C.
Nested
- D.
Double
- E.
Hyperlink
- 18.What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
- 19.Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
- 20.How would Excel display this value =ROUND(1.567) in the cell?
- A.
1
- B.
2
- C.
1.57
- D.
1.6
- 21.How can you convert days into years?
- A.
Divide days by 365.25
- B.
Multiply days by 360
- C.
Add Number of years
- D.
Format days
- 22.What does the TRUNC function do?
- A.
Formats data
- B.
Indents data
- C.
Adds numbers
- D.
Removes the decimal part of the number
- 23.What does Excel do if a function is volatile?
- A.
Renames the workbook
- B.
Closes the program
- C.
Recaculates it based on the computer where it is opened
- D.
Nothing changes
Back to top