Excel Intermediate 2013
Settings
CLICK HERE to access the training videos for this course.
- 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
- 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 withina workbook in Excel 2010:2007.
- A.
(A) Change Chart…
- B.
(B) Location
- C.
(C) Move Chart
- D.
(D) Chart Placement
- 27.From the following list of choices, select the name of the drop-down which appears within the“Current Selection” button group on the “Format” tab of the “Chart Tools” contextual tab in theRibbon and that allows you to select objects within a chart.
- A.
(A) Select Object
- B.
(B) Shape Styles
- C.
(C) WordArt Styles
- D.
(D) Chart Elements
- 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.
(A) Properties
- B.
(B) Walls
- C.
(C) Background
- D.
(D) Insert
- 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 achart in Excel 2010:2007.
- A.
(A) Labels
- B.
(B) WordArt Styles
- C.
(C) Title Styles
- D.
(D) Text Styles
Back to top