Excel Intermediate 2013 Quiz

Reviewed by Godwin Iheuwa
Godwin Iheuwa, MS, Computer Science |
Computer Expert
Review Board Member
Godwin is a proficient Database Administrator currently employed at MTN Nigeria. He holds as MS in Computer Science from the University of Bedfordshire, where he specialized in Agile Methodologies and Database Administration. He also earned a Bachelor's degree in Computer Science from the University of Port Harcourt. With expertise in SQL Server Integration Services (SSIS) and SQL Server Management Studio, Godwin's knowledge and experience enhance the authority of our quizzes, ensuring accuracy and relevance in the realm of computer science.
, MS, Computer Science
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.
| By Cay1117
C
Cay1117
Community Contributor
Quizzes Created: 5 | Total Attempts: 48,930
Questions: 29 | Attempts: 48,007

Settings

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)

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.

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 (.)

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.

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

C. Cell Ranges
Explanation
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.

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.

• C.

Formats

• D.

Characters

Explanation
"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

A. Charts
Explanation
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.

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.

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.

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.

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.

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.

• B.

Initial Values Row

• C.

Start Row

• D.

Footer Row

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

• C.

A drop-down arrow

• D.

A subtotal

C. A drop-down arrow
Explanation
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

A. Ascending
Explanation
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.

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

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

C. 32
Explanation
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

B. VLOOKUP
Explanation
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

A. HLOOKUP
Explanation
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

C. The “Sparkline Tools” contextual tab
Explanation
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

D. Format
Explanation
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

C. Chart Styles
Explanation
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

A. Plot Area
Explanation
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

C. Move Chart
Explanation
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

D. Chart Elements
Explanation
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

B. Walls
Explanation
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

B. WordArt Styles
Explanation
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:

Godwin Iheuwa |MS, Computer Science |
Computer Expert
Godwin is a proficient Database Administrator currently employed at MTN Nigeria. He holds as MS in Computer Science from the University of Bedfordshire, where he specialized in Agile Methodologies and Database Administration. He also earned a Bachelor's degree in Computer Science from the University of Port Harcourt. With expertise in SQL Server Integration Services (SSIS) and SQL Server Management Studio, Godwin's knowledge and experience enhance the authority of our quizzes, ensuring accuracy and relevance in the realm of computer science.

Quiz Review Timeline +

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

• Current Version
• Jun 17, 2024
Quiz Edited by
ProProfs Editorial Team

Expert Reviewed by
Godwin Iheuwa
• Oct 27, 2015
Quiz Created by
Cay1117

Related Topics