MS Excel Assessment Test: Questions & Answers

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 Selena Skipper
Selena Skipper, Business teacher
Selena, a dedicated Business Teacher with 26 years of experience, currently imparts knowledge at the Cullman Area Technology Academy. Her passion lies in guiding students to discover their career paths and achieve valuable certifications.
Quizzes Created: 12 | Total Attempts: 70,031
| Attempts: 3,126
SettingsSettings
Please wait...
  • 1/25 Questions

    A cell can contain the following: 

    • Number
    • Formula
    • Text
    • All of the above
Please wait...
About This Quiz

Think you are an expert in MS Excel? How much do you know about spreadsheets, cells, columns, etc.? Can you apply formulas on cells to get desired results? Take the online quiz to test your knowledge and brush up on your basics along the way.

MS Excel Assessment Test: Questions & Answers - Quiz

Quiz Preview

  • 2. 

    A spreadsheet is a software program that allows one to: 

    • Organize data

    • Calculate answers

    • Chart data

    • All of the above

    Correct Answer
    A. All of the above
    Explanation
    A spreadsheet is a software program that offers a range of functions, including organizing data, performing calculations, and creating charts. It provides a user-friendly interface for inputting and manipulating data, making it easier to organize and analyze information. With its built-in formulas and functions, it enables users to perform various calculations and generate accurate results. Additionally, spreadsheets allow users to create visual representations of data through charts and graphs, aiding in better understanding and presentation of information. Therefore, the correct answer is "all of the above" as spreadsheets encompass all these functionalities.

    Rate this question:

  • 3. 

    An Invoice is an itemized bill. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    An invoice is a document that provides a detailed breakdown of the goods or services provided, along with the corresponding costs. It is used as a request for payment from the buyer to the seller. Therefore, an invoice can be described as an itemized bill since it includes a list of individual items or services and their respective prices.

    Rate this question:

  • 4. 

    Which is true about Functions in Excel

    • It is a predefined formula

    • There are many

    • Can be found using the Fx  button are the Autosum dropdown

    • All of the other answers are correct. 

    Correct Answer
    A. All of the other answers are correct. 
    Explanation
    The given correct answer states that all of the other answers are correct. This means that all of the statements mentioned in the question are true about Functions in Excel. Functions in Excel are indeed predefined formulas that perform specific calculations or actions. There are many different functions available in Excel for various purposes. They can be found and accessed using the Fx button or the Autosum dropdown. Therefore, the correct answer is that all of the other answers are correct.

    Rate this question:

  • 5. 

    The formula =E6-(F6+G6) directs the spreadsheet to: 

    • Add two numbers first, then subtract them from the first number

    • Multiply two numbers first, then subtract the first number

    • Subtract the first number and add the following two numbers

    • Divide the first number by the sum of the second two numbers

    Correct Answer
    A. Add two numbers first, then subtract them from the first number
    Explanation
    The formula =E6-(F6+G6) directs the spreadsheet to add the numbers in cell F6 and G6 first, and then subtract the sum from the number in cell E6.

    Rate this question:

  • 6. 

    Microsoft Excel is the only application for which one can download templates.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    This statement is false. Microsoft Excel is not the only application for which one can download templates. There are various other applications and software, both online and offline, that offer downloadable templates for different purposes. Therefore, the given statement is incorrect.

    Rate this question:

  • 7. 

    The __________________________________ preceding a formula is important because it alerts Excel that you are entering a formula and  not text. 

    • Exclamation point

    • Asterisk

    • Equal sign

    • Apostrophe

    Correct Answer
    A. Equal sign
    Explanation
    The equal sign preceding a formula is important because it alerts Excel that you are entering a formula and not text. When you start a formula with an equal sign, Excel recognizes it as a command to perform a calculation or function. Without the equal sign, Excel would interpret the formula as text and not execute any calculations.

    Rate this question:

  • 8. 

    The formula=MIN(A12:E12) will return the highest value in a range. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The formula MIN(A12:E12) will return the lowest value in a range, not the highest value. Therefore, the correct answer is False.

    Rate this question:

  • 9. 

    When pound signs (######) appear in a cell, it means you have an incorrect formula. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    When pound signs (######) appear in a cell, it means that the content of the cell is too long to fit within the width of the cell. It does not indicate an incorrect formula.

    Rate this question:

  • 10. 

    The mathematical operator used in formulas to multiply values is a forward slash. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The mathematical operator used in formulas to multiply values is actually the asterisk (*), not the forward slash (/). The forward slash is used to represent division. Therefore, the statement is false.

    Rate this question:

  • 11. 

    A defined area of the worksheet, such as (A1:A20), is called a series. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    A defined area of the worksheet, such as (A1:A20), is called a series. This is true because in Excel, a series refers to a range of cells that are selected or defined together. In this case, the range (A1:A20) includes all the cells from A1 to A20, forming a series.

    Rate this question:

  • 12. 

    Under which part of the ribbon would you find the ability to print gridlines? 

    • Insert

    • Data

    • Page Layout

    • Home

    Correct Answer
    A. Page Layout
    Explanation
    In the Page Layout part of the ribbon, you would find the ability to print gridlines. This section of the ribbon contains various options and settings related to the layout and formatting of the document or spreadsheet. One of these options is the ability to print gridlines, which can be useful when you want to include the gridlines in your printed document or spreadsheet for better readability.

    Rate this question:

  • 13. 

    Cell addresses are used to develop formulas--not the values themselves. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Cell addresses are used in formulas to refer to specific cells in a spreadsheet. By using cell addresses, formulas can perform calculations using the values contained in those cells. The values themselves are not used directly in the formulas, but rather the cell addresses are used to retrieve the values and perform the necessary calculations. Therefore, the statement that cell addresses are used to develop formulas is correct.

    Rate this question:

  • 14. 

    Which of the following would characterize or indicate the active cell on a worksheet? 

    • Heavy border around it

    • Appears in the name box

    • It will appear in the name box and also have a heavy border around it.

    Correct Answer
    A. It will appear in the name box and also have a heavy border around it.
    Explanation
    The active cell on a worksheet is characterized by appearing in the name box and having a heavy border around it. This means that the cell is currently selected and any actions or data input will affect that specific cell.

    Rate this question:

  • 15. 

    An employee ID # would be entered as a label by preceding it with an apostrophe. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Entering an employee ID # as a label by preceding it with an apostrophe is not correct. In Excel, an apostrophe is used to indicate that a value should be treated as text, not as a numeric value. However, when entering an employee ID #, it is typically entered as a numeric value without any special characters. Therefore, the correct answer is false.

    Rate this question:

  • 16. 

    When creating a Chart in Microsoft Excel, you should never select empty rows and columns. 

    • True

    • False

    Correct Answer
    A. True
    Explanation
    When creating a chart in Microsoft Excel, it is important to not select empty rows and columns because these empty cells may be included in the chart, resulting in inaccurate or misleading data representation. By selecting only the relevant data range, the chart will accurately reflect the intended information and avoid any confusion or misinterpretation.

    Rate this question:

  • 17. 

    All money amounts should be formatted to how many decimal places? 

    • One

    • Two

    • Zero

    • It depends

    Correct Answer
    A. Two
    Explanation
    Money amounts should typically be formatted to two decimal places. This is because most currencies around the world use two decimal places to represent fractions of a whole unit. It allows for accurate representation and calculation of monetary values. However, there may be certain cases or specific requirements where money amounts need to be formatted to a different number of decimal places, hence it depends on the context.

    Rate this question:

  • 18. 

    To undo a currency format in a cell, you simply click the $ sign button on the ribbon. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To undo a currency format in a cell, you do not simply click the $ sign button on the ribbon. Instead, you need to select the cell or range of cells that you want to remove the currency format from, go to the "Number" tab in the ribbon, and then select the "General" option from the list of number formats. This will remove the currency formatting and display the cell value without the $ sign.

    Rate this question:

  • 19. 

    Numbers are left-aligned in a cell. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Numbers are not left-aligned by default in a cell. In most spreadsheet software, including Microsoft Excel and Google Sheets, numbers are right-aligned in cells. This is because right-alignment makes it easier to perform calculations and read numerical data.

    Rate this question:

  • 20. 

    The y axis on a chart typically represents...

    • The horizontal scale

    • The axes titles

    • The diagonal scale

    • The vertical scale 

    Correct Answer
    A. The vertical scale 
    Explanation
    The y axis on a chart typically represents the vertical scale. The vertical scale is used to measure and display the values of the dependent variable in a chart or graph. It represents the magnitude or quantity of the data being plotted along the vertical or y-axis. By using the vertical scale, we can interpret and compare the data points on the chart based on their vertical position.

    Rate this question:

  • 21. 

    Gross pay is the amount one receives after deductions have been taken away. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The statement is false because gross pay is the total amount of money one receives before any deductions or taxes have been taken out. It represents the full amount of money earned by an individual before any deductions such as taxes, insurance premiums, or retirement contributions are subtracted from their paycheck.

    Rate this question:

  • 22. 
    To compute "Net Pay" in the following example, the formula would be: - ProProfs

    To compute "Net Pay" in the following example, the formula would be:

    • =E6-F6-G6-H6

    • =E6+F6+G6

    • =E6-(F6+G6)

    • None of the Above

    Correct Answer
    A. =E6-(F6+G6)
    Explanation
    The correct formula to compute "Net Pay" in the given example is =E6-(F6+G6). This formula subtracts the values in cells F6 and G6 from the value in cell E6 to calculate the net pay.

    Rate this question:

  • 23. 

    Under what tab on the toolbar would you go to find the Sort? 

    • Home

    • Page Layout

    • Data

    • Insert

    Correct Answer
    A. Data
    Explanation
    To find the Sort function on the toolbar, you would go to the "Data" tab. This tab typically contains options and tools related to data manipulation and analysis, such as sorting, filtering, and data validation. The Sort function allows you to arrange data in ascending or descending order based on specific criteria, making it easier to analyze and organize large sets of information.

    Rate this question:

  • 24. 

    Each cell has a unique address made up of a row number and a column letter. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Each cell in a spreadsheet does have a unique address made up of a row number and a column letter. The row number indicates the vertical position of the cell, while the column letter indicates the horizontal position. This unique address is commonly referred to as a cell reference and is used to identify and locate specific cells within a spreadsheet. Therefore, the statement is true.

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Dec 12, 2017
    Quiz Created by
    Selena Skipper
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.