Excel Intermediate 2013 Quiz

29 Questions | By Cay1117 | Last updated: Mar 22, 2022 | Total Attempts: 14376

Questions

Settings

Create your own 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.

Questions and Answers

1.

From the following list, select the choice that is a 3D formula in Excel.
- A.
  
  (A) =SUM(Sheet1!A1,A2,A3)
- B.
  
  (B) =SUM(Sheet2!C2-Sheet2!D3)
- C.
  
  (C) =SUM(Sheet3!$A:$A)
- D.
  
  (D) =SUM(Sheet1:Sheet2!A1)
2.

From the following list of choices, select the choice that BEST describes the PRIMARY purpose of using named ranges in Excel.
- A.
  
  (A) They can simplify the process of finding a particular range of cells.
- B.
  
  (B) They can simplify the process of referencing cell ranges in formulas.
- C.
  
  (C) They can simplify the process of data entry within a cell range.
- D.
  
  (D) They can resolve the problem of circular cell address referencing in formulas.
3.

From the following list, select the character that is NOT allowed in range names.
- A.
  
  (A) Underscore (_)
- B.
  
  (B) Hyphen (-)
- C.
  
  (C) Space ( )
- D.
  
  (D) Period (.)
4.

From the following list, select the choice that BEST describes the function of the “Cell Styles” button in Excel.
- A.
  
  (A) It allows you to apply preset styles to selected cells.
- B.
  
  (B) It allows you to convert selected cells into a table while also applying a selected table format.
- C.
  
  (C) It allows you to apply formatting based on cell values in a table.
- D.
  
  (D) It allows you to convert selected cells into a PivotTable and then apply PivotTable formatting.
5.

From the following list, select the choice that is NOT one of the choices shown in the drop-downmenu that appears when you click the “Conditional Formatting” button within the Ribbon.
- A.
  
  (A) Top/Bottom Rules
- B.
  
  (B) Highlight Cell Rules
- C.
  
  (C) Cell Ranges
- D.
  
  (D) Data Bars
6.

From the following list of choices, select the choice that BEST describes the purpose of using the Paste Special feature in Excel.
- A.
  
  (A) It allows you to paste special characters, such as the trademark symbol, into a worksheet.
- B.
  
  (B) It allows you to copy data from a Microsoft Word table and paste it into Excel worksheet.
- C.
  
  (C) It allows you to copy cells and then paste only selected elements into a new location.
- D.
  
  (D) It allows you to paste links between Microsoft Access and Microsoft Excel into a workbook.
7.

From the following list, select the choice that is NOT an available option within the “Paste” sectionof the “Paste Special” dialog box.
- A.
  
  (A) All
- B.
  
  (B) Comments
- C.
  
  (C) Formats
- D.
  
  (D) Characters
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.
  
  (A) Charts
- B.
  
  (B) Pictures
- C.
  
  (C) Macros
- D.
  
  (D) Named Ranges
9.

From the following list, select the name of the checkbox option that you can check or uncheckwithin the “Share Workbook” dialog box in order to share or remove sharing from a workbook.
- A.
  
  (A) Share workbook and allow changes by other users.
- B.
  
  (B) Allow changes by more than one user at a time. This also allows workbook merging.
- C.
  
  (C) Allow reviewing and commentary by other users.
- D.
  
  (D) Share workbook and allow user review.
10.

From the following list, select the choice that BEST describes the purpose of auditing workbooks inExcel.
- A.
  
  (A) Auditing allows you to trace relationships between worksheets.
- B.
  
  (B) Auditing allows you to trace formula references between cells.
- C.
  
  (C) Auditing allows you to spot financial errors in workbooks.
- D.
  
  (D) Auditing allows you to trace relationships between workbooks.
11.

From the following list, select the choice that BEST describes the purpose of using cell validation inExcel worksheets.
- A.
  
  (A) It allows you to see changing values in cells that you cannot actively view within the worksheet.
- B.
  
  (B) It allows you to check if cell references being displayed by auditing arrows that point to externalworkbooks are correct and valid.
- C.
  
  (C) It allows you restrict the range of values that can be entered into selected cells in a worksheet.
- D.
  
  (D) It allows you to validate that the functions used by formulas in Excel are backward-compatiblewith previous versions of Excel.
12.

From the following list, select the choice that BEST describes the purpose of outlining workbooks inExcel.
- A.
  
  (A) Outlining allows you to better organize the flow of ideas in a workbook.
- B.
  
  (B) Outlining allows you to outline the impact of scenarios on worksheet data.
- C.
  
  (C) Outlining allows you to create collapsible/expandable cell groupings in a worksheet.
- D.
  
  (D) Outlining allows you to outline the cell dependency references in a worksheet.
13.

From the following list, select the choice that BEST describes the purpose of consolidating data inExcel.
- A.
  
  (A) Data consolidation allows you to perform a mathematical calculation on data gathered frommultiple worksheets and/or workbooks.
- B.
  
  (B) Data consolidation allows you to create a consolidated workbook by performing a selectedfunction upon all worksheets in the workbook.
- C.
  
  (C) Data consolidation allows you to perform a consolidation of data that is gathered from multiple,external Microsoft Access tables.
- D.
  
  (D) Data consolidation allows you to perform a mathematical calculation on data gathered frommultiple, external Microsoft Word tables.
14.

From the following list, select the term that is used to refer to the column name data that is storedwithin the topmost row of an Excel table.
- A.
  
  (A) Header Row
- B.
  
  (B) Initial Values Row
- C.
  
  (C) Start Row
- D.
  
  (D) Footer Row
15.

When you define a table in Excel, what item is added to the top of each column within the table?
- A.
  
  (A) A command button
- B.
  
  (B) A field menu
- C.
  
  (C) A drop-down arrow
- D.
  
  (D) A subtotal
16.

From the following list, select the choice that is an available method of sorting field data within anExcel table.
- A.
  
  (A) Ascending
- B.
  
  (B) Opposing
- C.
  
  (C) Reversing
- D.
  
  (D) Increasing
17.

From the following list of choices, select the choice that any table that uses the “AutoFilter” featureMUST possess in order for the feature to function properly.
- A.
  
  (A) An applied sort order
- B.
  
  (B) A custom sort order
- C.
  
  (C) A list AutoFormat
- D.
  
  (D) A header row
18.

From the following list, select the choice that BEST describes the purpose of creating data tableswithin Excel.
- A.
  
  (A) Data tables allow you to change variables in a formula to view different possible outcomes.
- B.
  
  (B) Data tables allow you to change filters in a table to view different possible outcomes.
- C.
  
  (C) Data tables allow you to change scenarios in a worksheet to view different possible outcomes.
- D.
  
  (D) Data tables allow you to change functions in a formula to view different possible outcomes.
19.

From the following list, select the MAXIMUM number of cells that are allowed to change within asingle scenario in Excel.
- A.
  
  (A) 13
- B.
  
  (B) 23
- C.
  
  (C) 32
- D.
  
  (D) 52
20.

From the following list, select the function within Excel that allows you to look up values in a tablethat is structured in rows with a “header column” at the left end of the table.
- A.
  
  (A) HLOOKUP
- B.
  
  (B) VLOOKUP
- C.
  
  (C) RLOOKUP
- D.
  
  (D) CLOOKUP
21.

From the following list, select the function within Excel that allows you to look up values in a tablethat is structured in columns with a “header row” at the top of the table.
- A.
  
  (A) HLOOKUP
- B.
  
  (B) VLOOKUP
- C.
  
  (C) RLOOKUP
- D.
  
  (D) CLOOKUP
22.

What is the name of the tab that appears in the Ribbon when you select a sparkline and allows youto modify the attributes of the selected sparkline?
- A.
  
  (A) The “Modify Chart” tab
- B.
  
  (B) The “Edit Sparklines” tab
- C.
  
  (C) The “Sparkline Tools” contextual tab
- D.
  
  (D) The “Sparkline Charting” contextual tab
23.

From the following list, select the choice that is a 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.
  
  (A) Chart Data
- B.
  
  (B) Options
- C.
  
  (C) Trendlines
- D.
  
  (D) Format
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 youcan apply to a selected chart within a worksheet in Excel 2013.
- A.
  
  (A) Chart AutoFormats
- B.
  
  (B) Chart Formatting
- C.
  
  (C) Chart Styles
- D.
  
  (D) Chart Design
25.

From the following list, select the name of the object that you can choose from the “ChartElements” drop-down within the Ribbon in order to select ONLY the area within the chart where theactual data is being plotted in Excel 2010:2007.
- A.
  
  (A) Plot Area
- B.
  
  (B) Chart Area
- C.
  
  (C) Data Table
- D.
  
  (D) Legend