Excel Intermediate 2013 Quiz
(375).jpg "Excel Intermediate 2013 Quiz - Quiz")
Here is an interesting quiz about 'Excel Intermediate 2013' that is designed to test your knowledge of this subject. Do you have a good understanding of Excel Intermediate 2013? If your answer is yes, then you must take this quiz and see how well you can score. Sounds fun, right? So, let's start the quiz then! We wish you all the best and hope that you'll find this quiz interesting.
- 1.
From the following list, select the choice that is a 3D formula in Excel.
- A.
=SUM(Sheet1!A1,A2,A3)
- B.
=SUM(Sheet2!C2-Sheet2!D3)
- C.
=SUM(Sheet3!$A:$A)
- D.
=SUM(Sheet1:Sheet2!A1)
Correct Answer
D. =SUM(Sheet1:Sheet2!A1)Explanation
The correct answer is "=SUM(Sheet1:Sheet2!A1)". This formula calculates the sum of the values in cell A1 from Sheet1 to Sheet2 in Excel. The use of the colon (:) between "Sheet1" and "Sheet2" indicates a range of sheets, making it a 3D formula.Rate this question:
-
- 2.
From the following list of choices, select the choice that BEST describes the PRIMARY purpose of using named ranges in Excel.
- A.
They can simplify the process of finding a particular range of cells.
- B.
They can simplify the process of referencing cell ranges in formulas.
- C.
They can simplify the process of data entry within a cell range.
- D.
They can resolve the problem of circular cell address referencing in formulas.
Correct Answer
B. They can simplify the process of referencing cell ranges in formulas.Explanation
Named ranges in Excel can simplify the process of referencing cell ranges in formulas. By assigning a name to a specific range of cells, users can easily refer to that range in formulas instead of manually entering the cell references. This not only makes the formulas more readable and easier to understand, but also allows for easier editing and maintenance of the formulas. Additionally, named ranges can be used across multiple worksheets and workbooks, providing consistency and efficiency in formula usage.Rate this question:
-
- 3.
From the following list, select the character that is NOT allowed in range names.
- A.
Underscore (_)
- B.
Hyphen (-)
- C.
Space ( )
- D.
Period (.)
Correct Answer
D. Period (.)Explanation
The character that is NOT allowed in range names in Excel is the period (.) You can use underscores, hyphens, and spaces, but periods are not allowed in range names. Excel treats periods as a special character reserved for other purposes, such as separating worksheet names from cell references.Rate this question:
-
- 4.
From the following list, select the choice that BEST describes the function of the “Cell Styles” button in Excel.
- A.
It allows you to apply preset styles to selected cells.
- B.
It allows you to convert selected cells into a table while also applying a selected table format.
- C.
It allows you to apply formatting based on cell values in a table.
- D.
It allows you to convert selected cells into a PivotTable and then apply PivotTable formatting.
Correct Answer
A. It allows you to apply preset styles to selected cells.Explanation
The "Cell Styles" button in Excel allows users to apply preset styles to selected cells. This means that users can easily format their cells by choosing from a variety of predefined styles, such as headings, titles, or data formats. This feature saves time and effort as users do not have to manually format each cell individually.Rate this question:
-
- 5.
From the following list, select the choice that is NOT one of the choices shown in the drop-down menu that appears when you click the “Conditional Formatting” button within the Ribbon.
- A.
Top/Bottom Rules
- B.
Highlight Cell Rules
- C.
Cell Ranges
- D.
Data Bars
Correct Answer
C. Cell RangesExplanation
The correct answer is Cell Ranges because it is not one of the choices shown in the drop-down menu that appears when you click the "Conditional Formatting" button within the Ribbon. The other options - Top/Bottom Rules, Highlight Cell Rules, and Data Bars - are all choices that are available in the drop-down menu for conditional formatting.Rate this question:
-
- 6.
From the following list of choices, select the choice that BEST describes the purpose of using the Paste Special feature in Excel.
- A.
It allows you to paste special characters, such as the trademark symbol, into a worksheet.
- B.
It allows you to copy data from a Microsoft Word table and paste it into Excel worksheet.
- C.
It allows you to copy cells and then paste only selected elements into a new location.
- D.
It allows you to paste links between Microsoft Access and Microsoft Excel into a workbook.
Correct Answer
C. It allows you to copy cells and then paste only selected elements into a new location.Explanation
The purpose of using the Paste Special feature in Excel is to copy cells and then paste only selected elements into a new location. This feature allows users to choose specific formatting options, such as values, formulas, formats, or comments, to paste into the desired location. It provides more control and flexibility when copying and pasting data in Excel.Rate this question:
-
- 7.
From the following list, select the choice that is NOT an available option within the “Paste” section of the “Paste Special” dialog box.
- A.
All
- B.
Comments
- C.
Formats
- D.
Characters
Correct Answer
B. CommentsExplanation
"Comments" is not an available option within the "Paste" section of the "Paste Special" dialog box in Excel. The other options, "All," "Formats," and "Characters," are typically available for pasting specific elements of the copied data. "Comments" is not a standard option in the Paste Special dialog for the "Paste" section.Rate this question:
-
- 8.
From the following list, select the name of the item that is NOT one of the items that become locked and unable to be altered after sharing an Excel workbook.
- A.
Charts
- B.
Pictures
- C.
Macros
- D.
Named Ranges
Correct Answer
A. ChartsExplanation
Charts in Excel are not one of the items that become locked and unable to be altered after sharing an Excel workbook. When you share a workbook in Excel, items like macros, pictures, and named ranges can become locked or protected, but charts can still be edited and modified by other users who have access to the shared workbook.Rate this question:
-
- 9.
From the following list, select the name of the checkbox option that you can check or uncheck within the “Share Workbook” dialog box to share or remove sharing from a workbook.
- A.
Share workbook and allow changes by other users.
- B.
Allow changes by more than one user at a time. This also allows workbook merging.
- C.
Allow reviewing and commentary by other users.
- D.
Share the workbook and allow user review.
Correct Answer
A. Share workbook and allow changes by other users.Explanation
The checkbox option that you can check or uncheck within the "Share Workbook" dialog box to share or remove sharing from a workbook is "Share the workbook and allow changes by other users." Checking this option enables sharing, and unchecking it removes sharing permissions for other users in the workbook.Rate this question:
-
- 10.
From the following list, select the choice that BEST describes the purpose of auditing workbooks in Excel.
- A.
Auditing allows you to trace relationships between worksheets.
- B.
Auditing allows you to trace formula references between cells.
- C.
Auditing allows you to spot financial errors in workbooks.
- D.
Auditing allows you to trace relationships between workbooks.
Correct Answer
B. Auditing allows you to trace formula references between cells.Explanation
The purpose of auditing workbooks in Excel is to trace formula references between cells. This means that auditing helps in identifying and tracking the formulas used in different cells, allowing users to understand how the data is calculated and ensuring accuracy in calculations. By auditing, users can easily identify any errors or discrepancies in the formulas, helping to maintain the integrity of financial data and ensuring accurate analysis.Rate this question:
-
- 11.
From the following list, select the choice that BEST describes the purpose of using cell validation in Excel worksheets.
- A.
It allows you to see changing values in cells that you cannot actively view within the worksheet.
- B.
It allows you to check if cell references being displayed by auditing arrows that point to external workbooks are correct and valid.
- C.
It allows you to restrict the range of values that can be entered into selected cells in a worksheet.
- D.
It allows you to validate that the functions used by formulas in Excel are backward-compatible with previous versions of Excel.
Correct Answer
C. It allows you to restrict the range of values that can be entered into selected cells in a worksheet.Explanation
Cell validation in Excel allows you to restrict the range of values that can be entered into selected cells in a worksheet. This means that you can set specific criteria or conditions for the data that can be entered into a cell, such as only allowing numbers between a certain range, or only allowing text of a certain length. By using cell validation, you can ensure that the data entered into your worksheet is accurate and meets your specified requirements.Rate this question:
-
- 12.
From the following list, select the choice that BEST describes the purpose of outlining workbooks in Excel.
- A.
Outlining allows you to better organize the flow of ideas in a workbook.
- B.
Outlining allows you to outline the impact of scenarios on worksheet data.
- C.
Outlining allows you to create collapsible/expandable cell groupings in a worksheet.
- D.
Outlining allows you to outline the cell dependency references in a worksheet.
Correct Answer
C. Outlining allows you to create collapsible/expandable cell groupings in a worksheet.Explanation
Outlining in Excel allows users to create collapsible/expandable cell groupings in a worksheet. This feature helps in organizing and managing large amounts of data by grouping related cells together. It allows users to collapse or expand these groups, making it easier to navigate and analyze data. This feature is particularly useful when working with complex workbooks that contain multiple sheets and extensive data.Rate this question:
-
- 13.
From the following list, select the choice that BEST describes the purpose of consolidating data in Excel.
- A.
Data consolidation allows you to perform a mathematical calculation on data gathered from multiple worksheets and/or workbooks.
- B.
Data consolidation allows you to create a consolidated workbook by performing a selected function upon all worksheets in the workbook.
- C.
Data consolidation allows you to perform a consolidation of data that is gathered from multiple,external Microsoft Access tables.
- D.
Data consolidation allows you to perform a mathematical calculation on data gathered from multiple, external Microsoft Word tables.
Correct Answer
A. Data consolidation allows you to perform a mathematical calculation on data gathered from multiple worksheets and/or workbooks.Explanation
The purpose of consolidating data in Excel is to perform a mathematical calculation on data gathered from multiple worksheets and/or workbooks. This means that you can combine and analyze data from different sources in order to perform calculations such as summing, averaging, or finding the maximum or minimum values. This feature is useful for organizing and analyzing large amounts of data in a single location.Rate this question:
-
- 14.
From the following list, select the term that is used to refer to the column name data that is stored within the topmost row of an Excel table.
- A.
Header Row
- B.
Initial Values Row
- C.
Start Row
- D.
Footer Row
Correct Answer
A. Header RowExplanation
The term used to refer to the column name data that is stored within the topmost row of an Excel table is the "Header Row." This row typically contains labels or names for each column in the table, allowing users to easily identify and understand the data in each column.Rate this question:
-
- 15.
When you define a table in Excel, what item is added to the top of each column within the table?
- A.
A command button
- B.
A field menu
- C.
A drop-down arrow
- D.
A subtotal
Correct Answer
C. A drop-down arrowExplanation
When you define a table in Excel, a drop-down arrow is added to the top of each column within the table. This drop-down arrow allows you to filter and sort the data in that column, making it easier to analyze and manipulate the information in the table.Rate this question:
-
- 16.
From the following list, select the choice that is an available method of sorting field data within an Excel table.
- A.
Ascending
- B.
Opposing
- C.
Reversing
- D.
Increasing
Correct Answer
A. AscendingExplanation
Ascending is the correct answer because it is a method of sorting field data within an Excel table. When data is sorted in ascending order, it is arranged from smallest to largest or from A to Z, depending on the type of data. This allows for easier analysis and organization of the data within the table.Rate this question:
-
- 17.
From the following list of choices, select the choice that any table that uses the “AutoFilter” feature MUST possess for the feature to function properly.
- A.
An applied sort order
- B.
A custom sort order
- C.
A list AutoFormat
- D.
A header row
Correct Answer
D. A header rowExplanation
A header row is necessary for the "AutoFilter" feature to function properly because it provides the column names or labels that the feature uses to filter and sort the data in the table. Without a header row, the feature would not know which columns to apply the filters to, making it impossible to use the "AutoFilter" feature effectively.Rate this question:
-
- 18.
From the following list, select the choice that BEST describes the purpose of creating data tables within Excel.
- A.
Data tables allow you to change variables in a formula to view different possible outcomes.
- B.
Data tables allow you to change filters in a table to view different possible outcomes.
- C.
Data tables allow you to change scenarios in a worksheet to view different possible outcomes.
- D.
Data tables allow you to change functions in a formula to view different possible outcomes.
Correct Answer
A. Data tables allow you to change variables in a formula to view different possible outcomes.Explanation
Data tables in Excel allow users to change variables in a formula to view different possible outcomes. By inputting different values into the data table, users can see how the formula's result changes accordingly. This is useful for conducting sensitivity analysis or exploring different scenarios. Data tables do not involve changing filters in a table or scenarios in a worksheet, nor do they allow users to change functions in a formula.Rate this question:
-
- 19.
From the following list, select the MAXIMUM number of cells that are allowed to change within a single scenario in Excel.
- A.
13
- B.
23
- C.
32
- D.
52
Correct Answer
C. 32Explanation
In Excel, the maximum number of cells that can be changed within a single scenario is 32. This means that when creating a scenario or making changes to existing data, you can modify up to 32 cells at once. It is important to note that this limit is specific to scenarios and does not apply to other operations or functions in Excel.Rate this question:
-
- 20.
From the following list, select the function within Excel that allows you to look up values in a table that is structured in rows with a “header column” at the left end of the table.
- A.
HLOOKUP
- B.
VLOOKUP
- C.
RLOOKUP
- D.
CLOOKUP
Correct Answer
B. VLOOKUPExplanation
The function within Excel that allows you to look up values in a table structured with a "header column" at the left end of the table is VLOOKUP. "V" stands for vertical, indicating that the function searches for values in the vertical direction (columns) of the table, making it suitable for tables with the structure you described.Rate this question:
-
- 21.
From the following list, select the function within Excel that allows you to look up values in a table that is structured in columns with a “header row” at the top of the table.
- A.
HLOOKUP
- B.
VLOOKUP
- C.
RLOOKUP
- D.
CLOOKUP
Correct Answer
A. HLOOKUPExplanation
The function within Excel that allows you to look up values in a table structured with a "header row" at the top of the table is HLOOKUP. "H" stands for horizontal, indicating that the function searches for values in the horizontal direction (rows) of the table, making it suitable for tables with this structure.Rate this question:
-
- 22.
What is the name of the tab that appears in the Ribbon when you select a sparkline and allows you to modify the attributes of the selected sparkline?
- A.
The “Modify Chart” tab
- B.
The “Edit Sparklines” tab
- C.
The “Sparkline Tools” contextual tab
- D.
The “Sparkline Charting” contextual tab
Correct Answer
C. The “Sparkline Tools” contextual tabExplanation
The correct answer is the "Sparkline Tools" contextual tab. This tab appears in the Ribbon when a sparkline is selected and allows the user to modify the attributes of the selected sparkline. It provides various options and tools specifically designed for working with sparklines, such as changing the type, style, and color of the sparkline, as well as adjusting its axis and data source.Rate this question:
-
- 23.
From the following list, select the choice that is the name of one of the tabs that appear within the“Chart Tools” contextual tab within the Ribbon when you have a chart selected in Excel 2013.
- A.
Chart Data
- B.
Options
- C.
Trendlines
- D.
Format
Correct Answer
D. FormatExplanation
The "Format" tab is one of the tabs that appear within the "Chart Tools" contextual tab within the Ribbon when a chart is selected in Excel 2013. This tab allows the user to format various aspects of the chart such as the chart style, chart elements, chart layout, and chart styles. By selecting this tab, the user can easily customize the appearance of the chart to meet their specific needs and preferences.Rate this question:
-
- 24.
From the following list, select the name of the button group that appears within the “Chart Tools” contextual tab within the Ribbon that contains a listing of the various preset chart formats that you can apply to a selected chart within a worksheet in Excel 2013.
- A.
Chart AutoFormats
- B.
Chart Formatting
- C.
Chart Styles
- D.
Chart Design
Correct Answer
C. Chart StylesExplanation
The "Chart Styles" button group appears within the "Chart Tools" contextual tab within the Ribbon in Excel 2013. It contains a listing of the various preset chart formats that you can apply to a selected chart within a worksheet.Rate this question:
-
- 25.
From the following list, select the name of the object that you can choose from the “ChartElements” drop-down within the Ribbon to select ONLY the area within the chart where the actual data is being plotted in Excel 2010:2007.
- A.
Plot Area
- B.
Chart Area
- C.
Data Table
- D.
Legend
Correct Answer
A. Plot AreaExplanation
The correct answer is Plot Area. In Excel 2010/2007, the Plot Area is an object that can be selected from the "ChartElements" drop-down within the Ribbon. It specifically refers to the area within the chart where the actual data is being plotted. By selecting the Plot Area, you can make changes or apply formatting specifically to the data area of the chart.Rate this question:
-
- 26.
From the following list, select the name of the button that you can click within the “Chart Tools”contextual tab within the Ribbon that allows you to change the placement of a selected chart within a workbook in Excel 2010:2007.
- A.
Change Chart…
- B.
Location
- C.
Move Chart
- D.
Chart Placement
Correct Answer
C. Move ChartExplanation
The button that allows you to change the placement of a selected chart within a workbook in Excel 2010/2007 is "Move Chart".Rate this question:
-
- 27.
From the following list of choices, select the name of the drop-down that appears within the“Current Selection” button group on the “Format” tab of the “Chart Tools” contextual tab in the Ribbon, and that allows you to select objects within a chart.
- A.
Select Object
- B.
Shape Styles
- C.
WordArt Styles
- D.
Chart Elements
Correct Answer
D. Chart ElementsExplanation
The drop-down within the "Current Selection" button group on the "Format" tab of the "Chart Tools" contextual tab in the Ribbon that allows you to select objects within a chart is called "Chart Elements".Rate this question:
-
- 28.
From the following list of choices, select the name of the button group in the “Chart Tools”contextual tab within the Ribbon that contains the “Plot Area” button in Excel 2010:2007.
- A.
Properties
- B.
Walls
- C.
Background
- D.
Insert
Correct Answer
B. WallsExplanation
The button group in the "Chart Tools" contextual tab within the Ribbon that contains the "Plot Area" button in Excel 2010 and 2007 is called "Walls." This button group allows you to format and customize the walls, such as side walls, of 3D charts.Rate this question:
-
- 29.
From the following list of choices, select the name of the button group in the “Chart Tools” contextual tab that contains a listing of premade formats that you can apply to text objects within a chart in Excel 2010:2007.
- A.
Labels
- B.
WordArt Styles
- C.
Title Styles
- D.
Text Styles
Correct Answer
B. WordArt StylesExplanation
The correct answer is "WordArt Styles" because in Excel 2010/2007, the "Chart Tools" contextual tab includes a button group called "WordArt Styles" that contains premade formats specifically designed for text objects within a chart. This button group allows users to easily apply different styles to their text objects, enhancing the visual appearance of the chart.Rate this question:
-
- 30.
You have a dataset in Excel with a column containing dates in the format "dd-mmm-yyyy" (e.g., 15-Mar-2023). You want to extract the month as a number (e.g., 3 for March) into a separate column. Which of the following formulas would achieve this?
- A.
=MONTH(A1)
- B.
=TEXT(A1, "mm")
- C.
=VALUE(MID(A1, 4, 3))
- D.
=MONTH(DATEVALUE(A1))
Correct Answer
A. =MONTH(A1)Explanation
Excel's MONTH function extracts the month as a number from a date. However, it requires a valid date serial number as input. Since your dates are in a text format ("dd-mmm-yyyy"), you need to convert them to date values first. The DATEVALUE function does this.
Here's why the other options won't work:
=MONTH(A1): This will return an error because A1 is not a recognized date value.
=TEXT(A1, "mm"): This will extract the month as text ("03"), not a number.
=VALUE(MID(A1, 4, 3)): This extracts the "Mar" text and tries to convert it to a number, resulting in an error.
Only option d) correctly converts the text to a date value and then extracts the month as a number. This question tests your understanding of date formats, text functions, and date/time functions in Excel, making it suitable for an intermediate level.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
-
Nov 14, 2024Quiz Edited by
ProProfs Editorial Team
Expert Reviewed by
Godwin Iheuwa -
Oct 27, 2015Quiz Created by
Cay1117
Back to top