Excel Intermediate 2013

29 Questions

Settings
Please wait...
Excel Intermediate 2013

CLICK HERE to access the training videos for this course.


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

  • 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