Microsoft Excel Proficiency Test!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Kalexander3
K
Kalexander3
Community Contributor
Quizzes Created: 1 | Total Attempts: 843
| Attempts: 844
SettingsSettings
Please wait...
  • 1/23 Questions

    What type of operation is being performed in the formula = A4*B5?

    • Addition
    • Subtraction
    • Division
    • Percentage
    • Multiplication
Please wait...
About This Quiz


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.

Microsoft Excel Proficiency Test! - Quiz

Quiz Preview

  • 2. 

    What command combines several cells into one cell ocupying the same screen space?

    • Merge and Center

    • Align

    • Freeze columns

    • Indent

    • Split

    Correct Answer
    A. Merge and Center
    Explanation
    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:

  • 3. 

    The feature that enables you to automatically complete a list of 12 months after you key one month is

    • Cell style

    • Fill handle or Autofill

    • Page layout

    • Find

    • Replace

    Correct Answer
    A. Fill handle or Autofill
    Explanation
    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 term describes a model workbook used as the basis for other workbooks?

    • Form

    • Demonstration

    • Template

    • Cell styles

    • Page Layout

    Correct Answer
    A. Template
    Explanation
    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:

  • 5. 

    Which orientation is taller than it is wide?

    • Landscape

    • Portrait

    Correct Answer
    A. Portrait
    Explanation
    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:

  • 6. 

    Name the function that adds cell values only if they meet your criteria.

    • Average()

    • Count()

    • Mean()

    • SumIF()

    • Round

    Correct Answer
    A. 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:

  • 7. 

    What does a hyperlink do?

    • Adds another argument

    • Displays a website

    • Formats worksheet

    • Hides worksheets

    Correct Answer
    A. Displays a website
    Explanation
    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:

  • 8. 

    What function would display the highest sales amount in a column?

    • Min()

    • Avg()

    • Max()

    • Most()

    • Sum()

    Correct Answer
    A. 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:

  • 9. 

    What is the keyboard shortcut command to move the mouse pointer to cell A1

    • Control + Home

    • Control + F4 key

    • Name box

    • Control + A1

    • Control + Tab key

    Correct Answer
    A. Control + Home
    Explanation
    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:

  • 10. 

    Which function enters the current date?

    • Now()

    • Days()

    • DDYYMM

    • TODAY()

    Correct Answer
    A. TODAY()
    Explanation
    The function TODAY() is used to enter the current date.

    Rate this question:

  • 11. 

    How can you start Edit mode to edit a formula?

    • Tools

    • Format

    • F4

    • F2 or double-click cell

    • Find and replace

    Correct Answer
    A. F2 or double-click cell
    Explanation
    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. 

    How would the cell reference $F$4 be described?

    • Mixed reference

    • Absolute reference

    • Relative reference

    • Additional reference

    • Money reference

    Correct Answer
    A. Absolute reference
    Explanation
    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:

  • 13. 

    What is the term used to describe a function inside a function?

    • Conditional

    • Argument

    • Nested

    • Double

    • Hyperlink

    Correct Answer
    A. Nested
    Explanation
    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:

  • 14. 

    What does the TRUNC function do?

    • Formats data

    • Indents data

    • Adds numbers

    • Removes the decimal part of the number

    Correct Answer
    A. Removes the decimal part of the number
    Explanation
    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:

  • 15. 

    How can you convert days into years?

    • Divide days by 365.25

    • Multiply days by 360

    • Add Number of years

    • Format days

    Correct Answer
    A. Divide days by 365.25
    Explanation
    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:

  • 16. 

    Three types of data visualization are:

    • Tools, Columns, Styles

    • Data bars, Color scales, Icon sets

    • Cell styles, Bold, Italics

    • Home, Edit, Fill

    • Shapes, Arrows, Clip art

    Correct Answer
    A. Data bars, Color scales, Icon sets
    Explanation
    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:

  • 17. 

    A workbook contains

    • 1 worksheet

    • 2 worksheets

    • 3 worksheets

    • 4 worksheets

    • No worksheets

    Correct Answer
    A. 3 worksheets
    Explanation
    The correct answer is 3 worksheets. This means that the workbook being referred to contains a total of three worksheets.

    Rate this question:

  • 18. 

    What does Excel do if a function is volatile?

    • Renames the workbook

    • Closes the program

    • Recaculates it based on the computer where it is opened

    • Nothing changes

    Correct Answer
    A. Recaculates it based on the computer where it is opened
    Explanation
    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:

  • 19. 

    Which logical function shows the opposite of the condition?

    • NOT function

    • False function

    • Nper function

    • Sum function

    • PMT function

    Correct Answer
    A. NOT function
    Explanation
    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:

  • 20. 

    What is the default alignment for values and dates in a cell?

    • Justified

    • Left aligned

    • Centered

    • Bottom aligned

    • Right aligned

    Correct Answer
    A. Right aligned
    Explanation
    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:

  • 21. 

    What is the keyboard shortcut to display or hide formulas?

    • Control + F4 key

    • Control + ~

    • Control + K

    • Control + P

    • Control +F

    Correct Answer
    A. 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:

  • 22. 

    How would Excel display this value =ROUND(1.567) in the cell?

    • 1

    • 2

    • 1.57

    • 1.6

    Correct Answer
    A. 1.57
    Explanation
    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:

  • 23. 

    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?

    • NPER function

    • Sum function

    • FV function

    • PMT function

    • Today function

    Correct Answer
    A. FV function
    Explanation
    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:

Quiz Review Timeline (Updated): Nov 16, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Nov 16, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 24, 2010
    Quiz Created by
    Kalexander3
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.