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.
Questions and Answers
- 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
Correct Answer
A. Control + HomeExplanation
The keyboard shortcut command "Control + Home" is used to move the mouse pointer to cell A1. This shortcut is commonly used in spreadsheet applications such as Microsoft Excel to quickly navigate to the first cell of the worksheet. By pressing the Control key and the Home key simultaneously, the user can easily jump to the top-left cell of the active sheet.Rate this question:
-
- 2.
A workbook contains
- A.
1 worksheet
- B.
2 worksheets
- C.
3 worksheets
- D.
4 worksheets
- E.
No worksheets
Correct Answer
C. 3 worksheetsExplanation
The correct answer is 3 worksheets. This means that the workbook being referred to contains a total of three worksheets.Rate this question:
-
- 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
Correct Answer
B. Fill handle or AutofillExplanation
The correct answer is Fill handle or Autofill. This feature in Excel allows you to automatically complete a list of 12 months after you enter one month. By dragging the fill handle or using the Autofill option, Excel recognizes the pattern and fills in the remaining months accordingly. This saves time and effort in manually entering each month individually.Rate this question:
-
- 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
Correct Answer
E. Right alignedExplanation
The default alignment for values and dates in a cell is right aligned. This means that the content within the cell is aligned towards the right side of the cell. This is the standard alignment for numerical data and dates, as it allows for easy comparison and reading of the values.Rate this question:
-
- 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
Correct Answer
A. Merge and CenterExplanation
Merge and Center is the command that combines several cells into one cell occupying the same screen space. This command is useful when you want to create a single, larger cell by merging multiple adjacent cells together. It is commonly used for creating headers or titles that span across multiple columns or rows in a spreadsheet or table. By merging and centering cells, the content within the merged cell is automatically centered both horizontally and vertically, making it visually appealing and easier to read.Rate this question:
-
- 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
Correct Answer
B. Control + ~Explanation
The correct answer is Control + ~. This keyboard shortcut is used to display or hide formulas in Excel. By pressing Control + ~, the user can toggle between viewing the actual formulas in the cells or the calculated results. This is a helpful feature for users who need to review or troubleshoot formulas in their spreadsheets.Rate this question:
-
- 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
Correct Answer
B. Absolute referenceExplanation
The cell reference $F$4 is described as an absolute reference because the dollar signs before the column and row identifiers indicate that the reference is fixed and will not change when copied or filled. This means that if the cell reference $F$4 is copied to another cell, it will always refer to cell F4 and not adjust based on the new location.Rate this question:
-
- 8.
What type of operation is being performed in the formula = A4*B5?
- A.
Addition
- B.
Subtraction
- C.
Division
- D.
Percentage
- E.
Multiplication
Correct Answer
E. MultiplicationExplanation
The formula = A4*B5 indicates a multiplication operation. The asterisk (*) symbol is commonly used in mathematical formulas to represent multiplication. Therefore, the correct answer is multiplication.Rate this question:
-
- 9.
Which orientation is taller than it is wide?
- A.
Landscape
- B.
Portrait
Correct Answer
B. PortraitExplanation
Portrait orientation is taller than it is wide. This means that the height of the object or image is greater than its width. It is commonly used for photographs or paintings of individuals or objects that are taller than they are wide.Rate this question:
-
- 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
Correct Answer
C. TemplateExplanation
A template is a model workbook that serves as the basis for creating other workbooks. It provides a pre-designed structure and formatting, such as column headers, formulas, and cell styles, that can be customized and reused for different purposes. By using a template, users can save time and ensure consistency in their workbooks by starting with a predefined layout and design.Rate this question:
-
- 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
Correct Answer
D. F2 or double-click cellExplanation
To start Edit mode and edit a formula, you can either press the F2 key on your keyboard or simply double-click on the cell containing the formula. This will allow you to make changes to the formula and update it accordingly.Rate this question:
-
- 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
Correct Answer
B. Data bars, Color scales, Icon setsExplanation
The correct answer is "Data bars, Color scales, Icon sets". These are three types of data visualization that can be used to represent data in a visually appealing and informative way. Data bars are horizontal bars that are used to represent the value of a cell, with longer bars indicating higher values. Color scales use different colors to represent the magnitude of values, with a gradient from one color to another. Icon sets are small icons or symbols that are used to represent different categories or levels of data. These visualizations can help users quickly understand and interpret data.Rate this question:
-
- 13.
Name the function that adds cell values only if they meet your criteria.
- A.
Average()
- B.
Count()
- C.
Mean()
- D.
SumIF()
- E.
Round
Correct Answer
D. SumIF()Explanation
The function "SumIF()" is the correct answer because it allows you to add cell values only if they meet a specific criteria. This function takes two arguments: a range of cells to evaluate and a criteria to determine which cells to include in the sum. It is commonly used in spreadsheet applications like Microsoft Excel to perform conditional calculations.Rate this question:
-
- 14.
What function would display the highest sales amount in a column?
- A.
Min()
- B.
Avg()
- C.
Max()
- D.
Most()
- E.
Sum()
Correct Answer
C. Max()Explanation
The Max() function is used to find the maximum value in a column. In this case, it will display the highest sales amount in the column. The Min() function would display the lowest sales amount, Avg() would display the average sales amount, Most() is not a valid function, and Sum() would display the sum of all the sales amounts. Therefore, the correct function to display the highest sales amount is Max().Rate this question:
-
- 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
Correct Answer
A. NOT functionExplanation
The NOT function is the logical function that shows the opposite of the condition. It takes a single argument and returns the opposite boolean value. If the argument is true, it returns false, and if the argument is false, it returns true. Therefore, the NOT function is the correct answer as it performs the opposite operation on the condition.Rate this question:
-
- 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
Correct Answer
C. FV functionExplanation
The FV function, or Future Value function, would help determine how much money will be in your account at the end of a year if you make regular payments. This function calculates the future value of an investment based on a series of regular payments, a fixed interest rate, and a specified number of periods. It takes into account the present value of the payments and the interest earned over time to calculate the final amount.Rate this question:
-
- 17.
What is the term used to describe a function inside a function?
- A.
Conditional
- B.
Argument
- C.
Nested
- D.
Double
- E.
Hyperlink
Correct Answer
C. NestedExplanation
A nested function refers to a function that is defined within another function. This allows the inner function to access variables and parameters from the outer function, creating a hierarchical structure. This concept is often used in programming to organize code and improve code readability.Rate this question:
-
- 18.
What does a hyperlink do?
- A.
Adds another argument
- B.
Displays a website
- C.
Formats worksheet
- D.
Hides worksheets
Correct Answer
B. Displays a websiteExplanation
A hyperlink is a clickable element that, when clicked, redirects the user to another webpage or website. It is commonly used in documents, presentations, and websites to provide easy access to additional information or related content. When a hyperlink is clicked, it displays the website or webpage associated with it, allowing the user to navigate to the desired destination.Rate this question:
-
- 19.
Which function enters the current date?
- A.
Now()
- B.
Days()
- C.
DDYYMM
- D.
TODAY()
Correct Answer
D. TODAY()Explanation
The function TODAY() is used to enter the current date.Rate this question:
-
- 20.
How would Excel display this value =ROUND(1.567) in the cell?
- A.
1
- B.
2
- C.
1.57
- D.
1.6
Correct Answer
C. 1.57Explanation
Excel would display the value =ROUND(1.567) as 1.57 in the cell. The ROUND function in Excel is used to round a number to a specified number of decimal places. In this case, since no decimal places are specified in the ROUND function, Excel will round the number to the nearest whole number, resulting in 2. However, since the cell is formatted to display two decimal places, Excel will display the rounded number as 1.57.Rate this question:
-
- 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
Correct Answer
A. Divide days by 365.25Explanation
To convert days into years, you need to divide the number of days by 365.25. This is because a year is approximately 365.25 days long, taking into account leap years. By dividing the number of days by this average length of a year, you can determine the equivalent number of years.Rate this question:
-
- 22.
What does the TRUNC function do?
- A.
Formats data
- B.
Indents data
- C.
Adds numbers
- D.
Removes the decimal part of the number
Correct Answer
D. Removes the decimal part of the numberExplanation
The TRUNC function is used to remove the decimal part of a number. It essentially truncates or cuts off the decimal portion, leaving only the integer part of the number. This can be useful in situations where only whole numbers are needed or when working with financial data that requires precision without decimals.Rate this question:
-
- 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
Correct Answer
C. Recaculates it based on the computer where it is openedExplanation
If a function in Excel is marked as volatile, it means that the function can produce different results each time it is calculated, even if the input values have not changed. When a volatile function is used in a workbook, Excel will recalculate it every time any change is made to the workbook, or when the workbook is opened on a different computer. This ensures that the function always reflects the most up-to-date information and takes into account any changes in the environment where it is being used.Rate this question:
-
Back to top