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 Steph123
S
Steph123
Community Contributor
Quizzes Created: 5 | Total Attempts: 4,151
| Attempts: 3,425 | Questions: 30
Please wait...
Question 1 / 30
0 %
0/100
Score 0/100
1. Tables created through Excel's table feature allow users to filter columns by different values.

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.

Submit
Please wait...
About This Quiz
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... see moreprovided, you will get to polish up your understanding of using Excel. Do check it out and see how well you do! see less

Personalize your quiz and earn a certificate with your name on it!
2. Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?

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.

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

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.

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

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.

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

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.

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

Explanation

not-available-via-ai

Submit
7. 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?

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.

Submit
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.

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.

Submit
9. What does the Format Painter button do?

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.

Submit
10. What is a worksheet tab in Excel 2007?

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.

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

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.

Submit
12. What does the following error mean - #REF! ?

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.

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

Explanation

not-available-via-ai

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

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.

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

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.

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

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.

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

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.

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

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.

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

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.

Submit
20. 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.

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.

Submit
21. Which of the following Excel features allows you to summarize the data in a large 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.

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

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.

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

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.

Submit
24. How do you turn off automatic calculation for a spreadsheet?

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.

Submit
25. 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?

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.

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

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.

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

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.

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

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.

Submit
29. 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:

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.

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

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.

Submit
View My Results

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

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
Cancel
  • All
    All (30)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Tables created through Excel's table feature allow users to filter...
Which of the following buttons on the Excel toolbar will format...
Is it possible to insert an image from a file into an Excel...
Once data is entered into a cell, can it be edited?
Pivot tables allow filtering of table information by different...
A user wishes to remove a spreadsheet from a workbook. Which is the...
Which formula can add all the numeric values in a range of cells,...
Pivot tables that have been created can easily be turned into graphs...
What does the Format Painter button do?
What is a worksheet tab in Excel 2007?
Which of these will NOT select all the cells in a document?
What does the following error mean - #REF! ?
Once data in a table gets filtered, you can neither unfilter the table...
What is the function of the Formulas tab in Microsoft Excel...
Which feature in Excel allows you to view two spreadsheets in one...
For a table to work properly, the top row should have column headings.
Which of the following will NOT set text in selected cells to ITALICS?
When number signs (#####) are displayed in the cell, it means:
When changing the margins on your spreadsheet does not solve the...
Creating tables is as easy as highlighting cells that have already...
Which of the following Excel features allows you...
When you see a cell with a red triangle in the top right corner, what...
What is the keyboard shortcut (button or buttons to be pressed) for...
How do you turn off automatic calculation for a spreadsheet?
By default, each workbook automatically has 3 sheets labeled on...
Which pivot table layout allows the dragging of fields to...
Which formula will automatically change a decimal value of .5 or...
What is the keyboard shortcut (button or buttons to be pressed) to...
When working with a chart, which of the following will allow you to...
What must first be created before copying the results of an advanced...
Alert!

Advertisement