Take The Ultimate Quiz On Microsoft Excel!

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 Beringerj
B
Beringerj
Community Contributor
Quizzes Created: 1 | Total Attempts: 1,281
| Attempts: 1,282
SettingsSettings
Please wait...
  • 1/19 Questions

    If the cells in a Microsoft Excel worksheet contain the following values: A1 = 90 A2 = 85 A3 = 80 A4 = 75 A5 = 75 What formula should you use to calculate the average of these values?

    • =SUM(A1:A5)
    • =AVERAGE(A1:A5)
    • =MEDIAN(A1:A5)
    • =MODE(A1:A5)
Please wait...
About This Quiz

Looking for a quiz that can test your Excel knowledge? This Microsoft Excel Quiz is designed to test and enhance your knowledge of one of the most widely used spreadsheet software in the world. You will encounter questions covering a broad range of topics, including basic functions and formulas, advanced features, and more. Each question will challenge your understanding and help you identify areas where you can improve.

By the end of this quiz, you'll have a clearer picture of your Excel proficiency and the areas that might need more attention. So, grab your thinking cap and start this Microsoft Excel Quiz. It's time to see how much you really know and take your Excel skills to the next level!

Take The Ultimate Quiz On Microsoft Excel! - Quiz

Quiz Preview

  • 2. 

    If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?

    • =SUM(A1:A5)

    • =AVERAGE(A1:A5)

    • =MEDIAN(A1:A5)

    • =MODE(A1:A5)

    Correct Answer
    A. =SUM(A1:A5)
    Explanation
    The SUM function in Microsoft Excel is specifically designed to add up all the numbers in a given range of cells. It is one of the most basic and frequently used functions in Excel, allowing users to quickly calculate the total of multiple values.
    When you apply the SUM function to a range of cells, Excel performs the following steps:
    1. Identifies the Range: It identifies all the cells within the specified range (in this case, A1 to A5).
    2. Adds Up the Values: It then adds the values contained in each of those cells.

    Rate this question:

  • 3. 

    Is it possible to insert an image from a file into an Excel spreadsheet ?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    It is possible to insert an image from a file into an Excel spreadsheet. This can be done by going to the Insert tab, selecting the Picture option, and then choosing the image file from the file explorer. The image will then be inserted into the spreadsheet and can be resized or positioned as needed.

    Rate this question:

  • 4. 

    In order to multiply items in Excel you would use:

    • ^

    • @

    • *

    • #

    Correct Answer
    A. *
    Explanation
    To multiply items in Excel, the asterisk (*) symbol is used. This symbol represents the multiplication operation in Excel.

    Rate this question:

  • 5. 

    A _____________ is the intersection point of a column and a row.

    • Column

    • Row

    • Cell

    Correct Answer
    A. Cell
    Explanation
    A cell is the intersection point of a column and a row. In a table or spreadsheet, columns are vertical and rows are horizontal. Each cell represents a unique intersection point where a specific piece of data can be entered or displayed. Therefore, a cell is the correct term to describe this intersection point.

    Rate this question:

  • 6. 

    There are three worksheets with every new workbook. You can change that automatic number if you want to.  

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In Microsoft Excel, by default, every new workbook contains three worksheets. However, it is possible to change this automatic number of worksheets if desired. Therefore, the statement "There are three worksheets with every new workbook" is true.

    Rate this question:

  • 7. 

    Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge ?

    • Yes

    • No

    Correct Answer
    A. Yes
    Explanation
    An Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This means that the data from the Excel spreadsheet can be merged into a Word document, allowing for personalized and customized documents to be created. The Excel spreadsheet acts as the source of data, providing the information that is needed to populate the Word document. This functionality is commonly used for creating letters, labels, and other documents that require personalized information for each recipient.

    Rate this question:

  • 8. 

     Which sort of a program is the Microsoft Excel 2016 ?

    • Word Processing Package.

    • Graphics Package

    • Spreadsheets Package

    • Multimedia Package

    Correct Answer
    A. Spreadsheets Package
    Explanation
    Microsoft Excel 2016 is a spreadsheets package. It is a powerful tool used for creating, organizing, and analyzing data in a tabular format. Excel offers various features such as formulas, functions, charts, and graphs that allow users to perform complex calculations and data analysis. It is widely used in businesses, finance, accounting, and many other fields for tasks like budgeting, data manipulation, and creating reports. Therefore, the correct answer is spreadsheets package.

    Rate this question:

  • 9. 

    A fast way to add up this column of numbers is to click in the cell below the numbers and then:

    • Click Subtotals on the Data menu.

    • View the sum in the formula bar.

    • Click the AutoSum button on the Standard toolbar, then press ENTER.

    Correct Answer
    A. Click the AutoSum button on the Standard toolbar, then press ENTER.
    Explanation
    Clicking the AutoSum button on the Standard toolbar and then pressing ENTER is a fast way to add up the column of numbers. This feature automatically selects the range of cells above the active cell and inserts the SUM function in the formula bar, which calculates the sum of the selected cells. Pressing ENTER confirms the calculation and displays the sum in the active cell.

    Rate this question:

  • 10. 

    How do you change column width to fit the contents?

    • Single-click the boundary to the left of the column heading.

    • Double-click the boundary to the right of the column heading.

    • Press ALT and single-click anywhere in the column.

    Correct Answer
    A. Double-click the boundary to the right of the column heading.
    Explanation
    To change the column width to fit the contents, you need to double-click the boundary to the right of the column heading. This action will automatically adjust the width of the column to accommodate the widest content within it.

    Rate this question:

  • 11. 

    Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell ?

    • Count

    • Average

    • Sum

    Correct Answer
    A. Sum
    Explanation
    The formula that can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell is the SUM formula. This formula is specifically designed to add up numerical values and can exclude non-numeric values from the calculation. It is a commonly used function in spreadsheet programs to calculate the total sum of a range of cells.

    Rate this question:

  • 12. 

    On an Excel sheet the active cell is indicated by ____.

    • A dark wide border

    • A dotted border

    • A blinking border

    • None of the above

    Correct Answer
    A. A dark wide border
    Explanation
    The active cell on an Excel sheet is indicated by a dark wide border. This border helps to differentiate the active cell from the other cells on the sheet, making it easier for the user to identify and work with the selected cell. The dark wide border stands out and provides a visual indicator of the current active cell, allowing the user to input or manipulate data in that specific cell.

    Rate this question:

  • 13. 

    The formula = ((A2+B5)*5% is valid

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The given formula is not valid because it is missing a closing parenthesis after B5. The correct formula should be ((A2+B5)*5%).

    Rate this question:

  • 14. 

    ###### means: 

    • You've entered a number wrong.

    • You've misspelled something.

    • The cell is not wide enough.

    Correct Answer
    A. The cell is not wide enough.
    Explanation
    This answer suggests that the term "######" is used to indicate that the cell in question is not wide enough to display the entire content. This could be because the content entered in the cell is too long and exceeds the width of the cell, causing the displayed content to be truncated with the "######" symbol.

    Rate this question:

  • 15. 

    To add a new row, click a cell in the row immediately above where you want the new row.  

    • True

    • False

    Correct Answer
    A. False
    Explanation
    To add a new row, you need to click a cell in the row immediately below where you want the new row, not above. Therefore, the correct answer is False.

    Rate this question:

  • 16. 

    How would you Recognize the Cell Address ?

    • By Name Box

    • By Formula Bar

    • By Ribbon

    Correct Answer
    A. By Name Box
    Explanation
    To recognize the cell address, you can use the Name Box. The Name Box is located next to the Formula Bar in Microsoft Excel. It displays the cell reference or range name of the currently selected cell. By looking at the Name Box, you can easily identify the cell address of the selected cell.

    Rate this question:

  • 17. 

    Say that you want to paste a formula result — but not the underlying formula — to another cell.You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?  

    • Click the Paste button on the Standard toolbar.

    • Click the arrow on the Paste button on the Standard toolbar, then click Formulas.

    • Click the arrow on the Paste button on the Standard toolbar, then click Values.

    Correct Answer
    A. Click the arrow on the Paste button on the Standard toolbar, then click Values.
    Explanation
    After copying the cell with the formula, you would place the insertion point in the cell you want to copy to and then click the arrow on the Paste button on the Standard toolbar. From the options that appear, you would select "Values" to paste only the result of the formula without the underlying formula itself.

    Rate this question:

  • 18. 

    Which key do you press to group two or more nonadjacent worksheets? 

    • CTRL.

    • SHIFT

    • ALT

    Correct Answer
    A. SHIFT
    Explanation
    To group two or more nonadjacent worksheets, you would press the SHIFT key. Pressing SHIFT allows you to select multiple worksheets that are not next to each other in the workbook. This feature is useful when you want to perform the same action on multiple worksheets simultaneously, such as formatting or entering data. By holding down the SHIFT key and clicking on the desired worksheets, you can easily group them together and make changes that will apply to all selected worksheets.

    Rate this question:

  • 19. 

    A formula and a function are the same thing.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    While formulas and functions are related concepts in spreadsheet software like Excel or Google Sheets, they are not the same thing. A formula is a general term for an expression that performs a calculation or operation on data within a spreadsheet. A function, on the other hand, is a specific type of formula that is pre-defined by the software to perform a particular task, such as summing a range of cells (SUM function) or calculating an average (AVERAGE function). So, all functions are formulas, but not all formulas are functions.

    Rate this question:

Quiz Review Timeline (Updated): Oct 25, 2024 +

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

  • Current Version
  • Oct 25, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 24, 2016
    Quiz Created by
    Beringerj
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.