Take This Basic MS Excel Skills Quiz!

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
Learn about Our Editorial Process
| Written by Easagun
E
Easagun
Community Contributor
Total Contribution - 2 | Total attempts - 36,079
Questions: 15 | Attempts: 33,677

SettingsSettingsSettings
Take This Basic MS Excel Skills Quiz! - Quiz

Think you are an expert in MS-Excel? It's time to showcase your skills with this Basic MS Excel Skills Quiz. Microsoft Excel is a spreadsheet program used for calculations, making charts, and recording data about all sorts of business processes. Most companies with their staff have adequate knowledge of how to use this application. Take this quiz to see how well you know some Excel basics. All the best! Try to get a perfect score here! If you find the quiz informative, share it with others for their knowledge enhancement.


Questions and Answers
  • 1. 

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

    • A. 

      Click Subtotals on the Data menu.

    • B. 

      View the sum in the formula bar.

    • C. 

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

    • D. 

      All of the above

    Correct Answer
    C. Click the AutoSum button on the Standard toolbar, then press ENTER.
    Explanation
    The correct answer is "Click the AutoSum button on the Standard toolbar, then press ENTER." This option suggests using the AutoSum feature in the software to quickly add up the column of numbers. By clicking the AutoSum button and pressing ENTER, the software will automatically calculate the sum of the selected range of cells and display the result. This method saves time and effort compared to manually entering the formula or using other options mentioned in the question.

    Rate this question:

  • 2. 

    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?

    • A. 

      Click the Paste button on the Standard toolbar.

    • B. 

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

    • C. 

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

    • D. 

      None of the above

    Correct Answer
    C. Click the arrow on the Paste button on the Standard toolbar, then click Values.
    Explanation
    To paste a formula result without the underlying formula to another cell, you would first copy the cell with the formula. Then, you would place the insertion point in the cell where you want to paste the result. Next, you would click the arrow on the Paste button on the Standard toolbar. From the options that appear, you would select "Values". This will paste only the calculated result of the formula into the selected cell, without including the actual formula itself.

    Rate this question:

  • 3. 

    How do you change the column width to fit the contents?

    • A. 

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

    • B. 

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

    • C. 

      Press ALT and single-click anywhere in the column.

    • D. 

      None of the above

    Correct Answer
    B. 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. Single-clicking the boundary to the left of the column heading or pressing ALT and single-clicking anywhere in the column will not achieve the desired result. Therefore, the correct option is to double-click the boundary to the right of the column heading.

    Rate this question:

  • 4. 

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

    • A. 

      True

    • B. 

      False

    Correct Answer
    A. True
    Explanation
    By default, when a new workbook is created in Excel, it comes with three worksheets. However, it is possible to change this automatic number of worksheets if desired. Therefore, the statement that "you can change that automatic number if you want to" is true.

    Rate this question:

  • 5. 

    ###### means:

    • A. 

      You've entered a number wrong.

    • B. 

      You've misspelled something.

    • C. 

      The cell is not wide enough.

    • D. 

      None of the above

    Correct Answer
    C. The cell is not wide enough.
    Explanation
    The correct answer is "The cell is not wide enough." This means that when entering a number or text into a cell, if the cell is not wide enough to display the entire content, it will show only a portion of it. This can lead to confusion or incorrect interpretation of the data. To ensure that all the content is visible, the cell width should be adjusted accordingly.

    Rate this question:

  • 6. 

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

    • A. 

      True

    • B. 

      False

    Correct Answer
    B. False
    Explanation
    To add a new row in a table, you need to click on a cell in the row immediately below where you want the new row. Clicking on a cell in the row above will not add a new row. Therefore, the statement "To add a new row, click a cell in the row immediately above where you want the new row" is false.

    Rate this question:

  • 7. 

    Which key do you press to group two or more non-adjacent worksheets?

    • A. 

      CTRL

    • B. 

      SHIFT

    • C. 

      ALT

    • D. 

      CAPS LOCK

    Correct Answer
    B. SHIFT
    Explanation
    To group two or more non-adjacent worksheets in Microsoft Excel, you need to press the SHIFT key. This allows you to select multiple worksheets that are not next to each other in the workbook. By grouping them, you can perform actions on all the selected worksheets simultaneously, such as formatting, entering data, or applying formulas.

    Rate this question:

  • 8. 

    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.

    • A. 

      True

    • B. 

      False

    Correct Answer
    B. False
    Explanation
    To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down CTRL, and then drag the selected sheet along the row of sheet tabs.

    Rate this question:

  • 9. 

    Which formula 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?

    • A. 

      Count

    • B. 

      Average

    • C. 

      Sum

    • D. 

      Subtract

    Correct Answer
    C. Sum
    Explanation
    The correct answer is "Sum" because the SUM formula in Excel can add all the numeric values in a range of cells. It ignores any non-numeric values and only adds the numeric ones. The result of the sum can be placed in a different cell by specifying the range of cells to be summed as the argument of the SUM formula, and then referencing the cell where the sum should be displayed.

    Rate this question:

  • 10. 

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

    • A. 

      Yes

    • B. 

      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 selecting the "Insert" tab, clicking on "Pictures" and then choosing the desired 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:

  • 11. 

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

    • A. 

      Yes

    • B. 

      No

    Correct Answer
    A. Yes
    Explanation
    Yes, an Excel spreadsheet can be used as the "data source" for a Word Mail Merge. This is because Word has the capability to import data from Excel and use it to populate fields in a mail merge document. By linking the Excel spreadsheet as the data source, Word can easily merge the data into the desired document, such as letters, labels, or envelopes, saving time and effort in manually entering the data.

    Rate this question:

  • 12. 

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

    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      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 the user identify which cell is currently selected and ready for data input or manipulation. The dark wide border stands out from the other cells, making it easy to locate and work with the active cell.

    Rate this question:

  • 13. 

    A Formula and a function are the same things.

    • A. 

      True

    • B. 

      False

    Correct Answer
    B. False
    Explanation
    A formula and a function are not the same things. A formula is a mathematical expression that performs calculations, while a function is a predefined set of instructions that performs a specific task. A function can be used within a formula to carry out a specific operation, but they are distinct concepts.

    Rate this question:

  • 14. 

    In order to multiply items in Excel, you would use:

    • A. 

      ^

    • B. 

      @

    • C. 

      *

    • D. 

      #

    Correct Answer
    C. *
    Explanation
    To multiply items in Excel, you would use the asterisk symbol (*). The asterisk is the multiplication operator in Excel and is used to perform multiplication calculations between two or more cells or values. By using the asterisk symbol, you can easily multiply numbers, formulas, or cell references in Excel.

    Rate this question:

  • 15. 

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

    • A. 

      True

    • B. 

      False

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

    Rate this question:

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.