Microsoft Excel 2010 MCQ Test: Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Steph123
S
Steph123
Community Contributor
Quizzes Created: 5 | Total Attempts: 4,099
Questions: 30 | Attempts: 3,381

SettingsSettingsSettings
Microsoft Excel 2010 MCQ Test: Quiz - Quiz


Can you pass this Microsoft Excel 2010 MCQ quiz? Microsoft excel is quite a complex tool for most users to understand out of all the Microsoft packages. One of the reasons this is true is the complex techniques involved and its ability to handle different data types. In the quiz provided, you will get to polish up your understanding of using Excel. Do check it out and see how well you do!


Questions and Answers
  • 1. 

    What is a worksheet tab in Excel 2007?

    • A.

      A worksheet tab is used to access tools associated with the worksheet

    • B.

      A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet

    • C.

      A worksheet tab is used to get help when working with Microsoft Excel 2007

    • D.

      A worksheet tab is used to move from one cell to the next cell in a worksheet

    Correct Answer
    B. A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet
    Explanation
    A worksheet tab is used to activate a worksheet by clicking on its sheet tab found at the bottom of the worksheet. This means that by clicking on a specific worksheet tab, that particular worksheet will become active and visible for editing or viewing. It allows users to easily navigate between different worksheets within the Excel workbook.

    Rate this question:

  • 2. 

    Tables created through Excel's table feature allow users to filter columns by different values.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Tables created through Excel's table feature have the ability to filter columns by different values. This means that users can easily narrow down the data they want to see by selecting specific criteria to filter by. This feature is particularly useful when working with large datasets, as it allows for quick and efficient data analysis. By selecting "True" as the answer, it indicates that the statement is correct and tables created through Excel's table feature do indeed allow users to filter columns by different values.

    Rate this question:

  • 3. 

    Pivot tables allow filtering of table information by different values in column and row headers.

    • A.

      True

    • B.

      False

    • C.

      Only when using Excel 2003 or earlier versions

    Correct Answer
    A. True
    Explanation
    Pivot tables are a powerful tool in data analysis that allow users to summarize and manipulate large amounts of data. One of the key features of pivot tables is the ability to filter the information based on different values in column and row headers. This allows users to focus on specific subsets of data and analyze it in a more meaningful way. Therefore, the statement "Pivot tables allow filtering of table information by different values in column and row headers" is true.

    Rate this question:

  • 4. 

    Creating tables is as easy as highlighting cells that have already been filled in appropriately, followed by clicking on the Insert tab and then clicking on the table button.

    • A.

      No, highlighting cells disables the ability to create tables

    • B.

      Yes, it is that simple, but the highlighted cells must have numerical data

    • C.

      No, you go to the home tab and then click on the table button

    • D.

      Yes, it is that simple, but the highlighted selection should not contain any blank cells

    Correct Answer
    D. Yes, it is that simple, but the highlighted selection should not contain any blank cells
    Explanation
    The correct answer is "Yes, it is that simple, but the highlighted selection should not contain any blank cells." This answer explains that creating tables is easy by highlighting cells that have already been filled in appropriately and then clicking on the table button. However, it adds the condition that the highlighted selection should not contain any blank cells. This implies that the cells should have numerical data and should not be left blank in order to create a table successfully.

    Rate this question:

  • 5. 

    Once data in a table gets filtered, you can neither unfilter the table nor get the table back to the original settings.

    • A.

      False, you may change filters up to three times

    • B.

      True

    • C.

      False, you may change filters as many times as you please without limits

    • D.

      False, tables cannot be filtered

    Correct Answer
    C. False, you may change filters as many times as you please without limits
  • 6. 

    Which pivot table layout allows the dragging of fields to the grid in a spreadsheet?

    • A.

      Default Pivot Table Layout

    • B.

      Classic Pivot Table Layout

    • C.

      Master Pivot Table Layout

    • D.

      Operation Geronimo Layout

    Correct Answer
    B. Classic Pivot Table Layout
    Explanation
    The Classic Pivot Table Layout allows the dragging of fields to the grid in a spreadsheet. This layout is commonly used and provides a user-friendly interface for organizing and analyzing data in a pivot table. It allows users to easily select and arrange fields in rows, columns, and values to create customized views of the data. The Classic Pivot Table Layout is a popular choice for data analysis and reporting purposes.

    Rate this question:

  • 7. 

    For a table to work properly, the top row should have column headings.

    • A.

      True

    • B.

      False, only rows may have headings

    • C.

      False

    Correct Answer
    A. True
    Explanation
    In order for a table to function effectively, it is important for the top row to contain column headings. This allows for clear organization and categorization of the data within the table. Without column headings, it would be difficult to understand the meaning and purpose of each column, making it harder to interpret and analyze the data. Therefore, it is necessary for the top row of a table to have column headings.

    Rate this question:

  • 8. 

    Pivot tables that have been created can easily be turned into graphs or charts by highlighting the whole pivot table and choosing a graph or chart that you want to create.

    • A.

      True

    • B.

      False, pivot tables do not contain enough information for graphs or charts

    • C.

      False, only regular tables may be used to create graphs or charts

    Correct Answer
    A. True
    Explanation
    Pivot tables are a powerful tool in data analysis that allows users to summarize and manipulate large amounts of data. One of the advantages of pivot tables is their ability to be easily converted into graphs or charts. By highlighting the entire pivot table, users can choose from a variety of graph or chart options to visually represent the data. This feature enhances the presentation and understanding of the data by providing a visual representation of the summarized information. Therefore, the statement that pivot tables can easily be turned into graphs or charts is true.

    Rate this question:

  • 9. 

    What is the function of the Formulas tab in Microsoft Excel 2007?

    • A.

      The Formulas tab provides links to instructions on how to write your own formulas, but will not input any formulas automatically

    • B.

      The Formulas tab contain only the most common formulas supported by Excel

    • C.

      The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab

    • D.

      The Formulas tab is used for automatic creation of a complete formula without any user interaction at all

    Correct Answer
    C. The Formulas Tab contains formula-related functions such as function library, formula auditing, defining names and calculations, all of which can be inserted into a cell from the Formulas tab
    Explanation
    The Formulas tab in Microsoft Excel 2007 contains various formula-related functions such as the function library, formula auditing, defining names, and calculations. These functions can be easily inserted into a cell from the Formulas tab.

    Rate this question:

  • 10. 

    Which of the following Excel features allows you to summarize the data in a large table?

    • A.

      Data Validation

    • B.

      Conditional Formatting

    • C.

      Pivot Table

    • D.

      Hyperlink

    Correct Answer
    C. Pivot Table
    Explanation
    A Pivot Table is an Excel feature that allows you to summarize and analyze large amounts of data in a table. It enables you to rearrange, filter, and group data to create meaningful insights and summaries. With a Pivot Table, you can easily calculate totals, averages, and other statistical measures for different categories or variables in your data set. This feature is particularly useful when dealing with large data sets or when you need to present data in a concise and organized manner.

    Rate this question:

  • 11. 

    When number signs (#####) are displayed in the cell, it means:

    • A.

      There are too many characters in the cell to be displayed with the current cell width

    • B.

      The formula in the cell is wrong

    • C.

      The decimal point placement in the cell is wrong

    • D.

      All of the above

    Correct Answer
    A. There are too many characters in the cell to be displayed with the current cell width
    Explanation
    When number signs (#####) are displayed in a cell, it means that there are too many characters in the cell to be displayed with the current cell width. This typically occurs when the content of the cell is too long to fit within the column width. To resolve this issue, you can either increase the column width to accommodate the text or reduce the amount of text in the cell.

    Rate this question:

  • 12. 

    What does the Format Painter button do?

    • A.

      Only changes the color of each cell

    • B.

      Only changes the color of a group of cells that you choose

    • C.

      Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.

    • D.

      Only copies formulas from one cell or group of cells to another.

    Correct Answer
    C. Copies the formatting of a cell, including formulas, quickly and easily from one cell or group of cells to another.
    Explanation
    The Format Painter button allows you to quickly and easily copy the formatting of a cell, including formulas, from one cell or group of cells to another. This means that you can apply the same formatting, such as font style, size, and color, as well as any formulas, to multiple cells without having to manually input them. This can save time and ensure consistency in formatting across your spreadsheet.

    Rate this question:

  • 13. 

    By default, each workbook automatically has 3 sheets labeled on the bottom tabs: Sheet 1, Sheet 2, Sheet 3. To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, what has to be done?

    • A.

      Right click on sheet 2 and select insert

    • B.

      Right click on sheet 1 and select insert

    • C.

      Right click on sheet 3 and select insert

    • D.

      None of the above

    Correct Answer
    A. Right click on sheet 2 and select insert
    Explanation
    To insert a new spreadsheet between Sheet 1 and Sheet 2 in the workbook, you need to right click on sheet 2 and select insert. This will create a new sheet between Sheet 1 and Sheet 2, shifting the existing sheets down.

    Rate this question:

  • 14. 

    When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?

    • A.

      Seperate the page into two for easier printing

    • B.

      Use the Fit to Page option

    • C.

      Highlight all cells to print and print selection

    • D.

      None of the above

    Correct Answer
    B. Use the Fit to Page option
    Explanation
    If changing the margins on the spreadsheet does not solve the problem with the printout width, using the "Fit to Page" option would be the appropriate solution. This option adjusts the size of the spreadsheet to fit within the width of the page, ensuring that all content is visible when printing. It is a useful feature when the spreadsheet is too wide to fit on a single page. Seperating the page into two for easier printing or highlighting all cells to print and printing the selection are not relevant solutions in this case.

    Rate this question:

  • 15. 

    Once data is entered into a cell, can it be edited?

    • A.

      Yes, but the file must be saved with a different file name

    • B.

      No, once a file is saved, cell data cannot be changed

    • C.

      Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing

    • D.

      No, data in a cell can only be changed by creating a copy of the original spreadsheet into a new spreadsheet

    Correct Answer
    C. Yes, even after saving a file, double-clicking on a cell where data is to be changed allows editing
    Explanation
    The correct answer is that data can be edited even after saving a file by double-clicking on a cell. This is a common feature in spreadsheet software like Microsoft Excel, where double-clicking on a cell activates the editing mode, allowing the user to modify the data. Saving the file with a different name or creating a copy of the spreadsheet is not necessary to edit the data in a cell.

    Rate this question:

  • 16. 

    A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this?

    • A.

      Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet

    • B.

      Right click on the spreadsheet tab and select DELETE

    • C.

      Right click on the spreadsheet and select INSERT - ENTIRE COLUMN

    Correct Answer
    B. Right click on the spreadsheet tab and select DELETE
  • 17. 

    What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells?

    • A.

      F3

    • B.

      F5

    • C.

      F7

    • D.

      F9

    • E.

      F11

    • F.

      F13

    Correct Answer
    E. F11
    Explanation
    Pressing the F11 key on the keyboard creates a chart from the selected cells in Microsoft Excel. This keyboard shortcut allows users to quickly generate a chart without having to go through the menu options or use the mouse. It provides a convenient and efficient way to visualize and analyze data in a graphical format.

    Rate this question:

  • 18. 

    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

    Correct Answer
    C. Sum
    Explanation
    The Sum 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. It is specifically designed to calculate the sum of a range of cells and is commonly used in Excel to perform such calculations. The Count formula, on the other hand, counts the number of cells that contain numeric values in a range, while the Average formula calculates the average of the numeric values in a range.

    Rate this question:

  • 19. 

    Which of these will NOT select all the cells in a document?

    • A.

      Clicking three times with the right mouse button in the spreadsheet

    • B.

      Using the Edit - Select All menu item

    • C.

      Pressing CTRL + A on the keyboard

    Correct Answer
    A. Clicking three times with the right mouse button in the spreadsheet
    Explanation
    Clicking three times with the right mouse button in the spreadsheet will not select all the cells in a document. This action typically activates the context menu, and does not have a built-in function to select all cells.

    Rate this question:

  • 20. 

    When you see a cell with a red triangle in the top right corner, what does this signify?

    • A.

      There is an error in the cell

    • B.

      There is a comment associated with the cell

    • C.

      The font color for text in the cell is red

    • D.

      A formula cannot be entered into the cell

    Correct Answer
    B. There is a comment associated with the cell
    Explanation
    When a cell has a red triangle in the top right corner, it signifies that there is a comment associated with the cell. This comment can be viewed by hovering over the cell or by selecting the cell and accessing the comment feature in the spreadsheet program. The red triangle serves as a visual indicator that additional information or notes are available for that particular cell.

    Rate this question:

  • 21. 

    Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

    Correct Answer
    A.
    Explanation
    The correct answer is the "Number Format" button. This button allows users to apply different number formats to selected cells, including currency format. By clicking on this button, users can easily format the selected cells to display currency values with the appropriate currency symbol, decimal places, and thousands separators. This helps in presenting financial data in a clear and organized manner.

    Rate this question:

  • 22. 

    Which of the following will NOT set text in selected cells to ITALICS?

    • A.

      Pressing CTRL + I on the keyboard

    • B.

      Using the Tools - Wizard - Web Form menu item

    • C.

      Using the Format - Cells - Font menu item

    Correct Answer
    B. Using the Tools - Wizard - Web Form menu item
    Explanation
    Using the Tools - Wizard - Web Form menu item will not set text in selected cells to ITALICS. This menu item is used to create web forms and does not have an option to change the font style to italics.

    Rate this question:

  • 23. 

    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. Excel provides the functionality to add images to enhance the visual appeal of the spreadsheet or to provide additional information. Users can easily insert an image by selecting the "Insert" tab, clicking on the "Picture" option, and then choosing the desired image file from their computer. Once inserted, the image can be resized, moved, and formatted according to the user's preference.

    Rate this question:

  • 24. 

    How do you turn off automatic calculation for a spreadsheet?

    • A.

      You cannot turn off automatic calculation - its built into the spreadsheet / workbook.

    • B.

      Right click on the spreadsheet tab and select MANUAL CALCULATION.

    • C.

      Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.

    Correct Answer
    C. Go to Office Button - Excel Options - Formulas, Select Manual in the Workbook Calculation section.
    Explanation
    To turn off automatic calculation for a spreadsheet in Excel, you need to go to the Office Button, then select Excel Options. From there, choose Formulas and select Manual in the Workbook Calculation section. This will disable the automatic calculation feature, allowing you to manually calculate the spreadsheet when needed.

    Rate this question:

  • 25. 

    What is the keyboard shortcut (button or buttons to be pressed) to Complete a cell entry and move up in the selection?

    • A.

      CTRL+TAB

    • B.

      SHIFT+TAB

    • C.

      ALT+TAB

    • D.

      SHIFT+ENTER

    • E.

      CTRL+ENTER

    • F.

      ALT+ENTER

    Correct Answer
    D. SHIFT+ENTER
    Explanation
    The keyboard shortcut to complete a cell entry and move up in the selection is SHIFT+ENTER. This shortcut allows the user to finish entering data into a cell and then move the selection up to the cell above.

    Rate this question:

  • 26. 

    When working with a chart, which of the following will allow you to change the spacing of tick marks and labels on the category axis? Click on the desired axis and go to:

    • A.

      FORMAT - SELECTED AXIS - SCALE - Select options required

    • B.

      FORMAT - CHART - AXIS - SCALE - Select options required

    • C.

      Format Tab - Format Selection - Axis Options - Select options required

    Correct Answer
    C. Format Tab - Format Selection - Axis Options - Select options required
    Explanation
    The correct answer is "Format Tab - Format Selection - Axis Options - Select options required." This option allows you to change the spacing of tick marks and labels on the category axis by accessing the Format tab, selecting the axis you want to modify, and then navigating to the Axis Options section to choose the desired options.

    Rate this question:

  • 27. 

    What does the following error mean - #REF! ?

    • A.

      The #REF! error value occurs when a cell reference is not valid.

    • B.

      The #REF! error value occurs when a cell contains a number with two decimal separators (points) present.

    • C.

      The #REF! error value occurs when a cell has been formatted as a currency but contains text.

    Correct Answer
    A. The #REF! error value occurs when a cell reference is not valid.
    Explanation
    The #REF! error value occurs when a cell reference is not valid. This means that the formula in the cell is referring to a cell that does not exist or has been deleted. It could also occur if the formula is referencing a different sheet or workbook that is not open or accessible. This error can be fixed by correcting the cell reference in the formula to refer to a valid cell.

    Rate this question:

  • 28. 

    Which feature in Excel allows you to view two spreadsheets in one window?

    • A.

      Freeze panes

    • B.

      Split

    • C.

      View side by side

    Correct Answer
    B. Split
    Explanation
    The Split feature in Excel allows you to view two spreadsheets in one window. This feature is useful when you want to compare or analyze data from two different sheets simultaneously. It divides the window into separate panes, allowing you to scroll and navigate through both sheets independently. By using the Split feature, you can easily compare and work with multiple sheets without the need for switching between different windows or tabs.

    Rate this question:

  • 29. 

    What must first be created before copying the results of an advanced filter to another location?

    • A.

      Criteria range

    • B.

      Output range

    • C.

      Setup range

    • D.

      Filter range

    Correct Answer
    A. Criteria range
    Explanation
    Before copying the results of an advanced filter to another location, the criteria range must first be created. The criteria range specifies the conditions that the data must meet in order to be copied. It defines the filters that will be applied to the data. Without a criteria range, the advanced filter cannot determine which data should be copied to the output range. Therefore, the criteria range is a necessary step in the process of copying the results of an advanced filter.

    Rate this question:

  • 30. 

    Which formula will automatically change a decimal value of .5 or greater up to the next highest whole number value?

    • A.

      ROUND

    • B.

      ROUNDUP

    • C.

      ROUNDDOWN

    • D.

      RAND

    Correct Answer
    A. ROUND
    Explanation
    The ROUND formula is used to automatically change a decimal value of .5 or greater up to the next highest whole number value. This function rounds the number to the nearest whole number, with .5 rounding up.

    Rate this question:

Quiz Review Timeline +

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Feb 19, 2013
    Quiz Created by
    Steph123
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.