GoConqr has a new look! Let us know what you think.

Sign up free

Flashcards

Excel 2016 ch 7, 8, 9

tom lou English 199 cards

Cards in this deck (199)

  1. 1A screen ____ is a portion, usually of one object or section of a window, of the screen. Select one: a. clipping b. baseline c. excision d. illustrationclipping
  2. 2A Word document often contains data stored in a(n) ____ that can then be copied and pasted into an Excel worksheet. Select one: a. table b. object c. unit d. matrixtable
  3. 3A ____ file contains data fields separated by a selected character. Select one: a. fixed b. marked c. delimited d. formatteddelimited
  4. 4A ____ is a way to qualify the data to import by specifying a matching condition or asking a question of a database. Select one: a. question b. query c. quiz d. quotaquery
  5. 5A(n) ____ contains little or no formatting. Select one: a. text file b. Web page c. Access query d. Word tabletext file
  6. 6A(n) ____ is a special-purpose workbook you can create and then use as a pattern to create new, similar workbooks or worksheets. Select one: a. guide b. program c. template d. budgettemplate
  7. 7All of the following are formats accepted for picture files EXCEPT ____. Select one: a. .bmp b. .png c. .tif d. .mp3mp3
  8. 8Because ____ help speed and simplify work, many Excel users create one for each project on which they work. Select one: a. indices b. filters c. text files d. templatestemplates
  9. 9Clicking the ____ button changes a SmartArt graphic to individual shapes that can be resized, moved, or deleted independently of the others. Select one: a. Individual Shapes b. Components c. Convert to Shapes d. Decomposeconvert to shapes
  10. 10Elements in a SmartArt graphic are grouped in ____. Select one: a. aggregates b. clusters c. levels d. fieldslevels
  11. 11Excel allows you to take a ____ of any open window and add it to a workbook. Select one: a. sneak peek b. screen shot c. quick glimpse d. cybergrabscreenshot
  12. 12Excel includes ____ types of SmartArt graphics. Select one: a. 9 b. 19 c. 90 d. 999
  13. 13For a file that does not yet have a file name, you can open the Save As dialog box to save a template by pressing the ____ keys. Select one: a. ALT+O b. CTRL+S c. SHIFT+X d. CTRL+Vctrl s
  14. 14Importing ____ provides greater flexibility to manipulate text in Excel. Select one: a. HTML b. Enhanced Metafiles c. raw data d. Microsoft Word Document objectsraw data
  15. 15In some cases, when you import data, the data will need to be ____, meaning that the rows and columns need to be switched. Select one: a. formatted b. transposed c. deleted d. none of the abovetransposed
  16. 16The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet. Select one: a. Data Wizard b. Import Wizard c. Text Import Wizard d. Content Wizardtext import wizard
  17. 17Webpages use a file format called ____. Select one: a. DOCX b. HTML c. XLSX d. PPTXhtml
  18. 18When a template is created, dummy ____ is/are used to verify the formulas in the template. Select one: a. formulas b. data c. formatting d. page layoutdata
  19. 19When Excel imports a database table, the data is placed in an Excel ____. Select one: a. row b. column c. cell d. tabletable
  20. 20Which of the following is a SmartArt graphic category? Select one: a. Triangle b. Model c. Circle d. Processprocess
  21. 21Which of the following is NOT a SmartArt graphic category? Select one: a. Matrix b. Pyramid c. Picture d. Microsoft.commicrosoft.com
  22. 22Which of the following is the path to the Find & Select button? Select one: a. (HOME tab | Fill group) b. (HOME tab | Font group) c. (HOME tab | Cells group) d. (HOME tab | Editing group)home tab
    editing group
  23. 23Which of the following is the path to the Format Painter button? Select one: a. (CLIPBOARD tab | Home group) b. (HOME tab | Clipboard group) c. (DATA tab | Paint Formats group) d. (VIEW tab | Show Formats group)home tab
    clipboard group
  24. 24Which of the following is the path to the Get Data From Web button? Select one: a. (DATA tab | Get External Data group) b. (GET EXTERNAL DATA tab | Web group) c. (VIEW tab | Launch Web Query group) d. none of the abovedata tab
    get external data group
  25. 25Which of the following is the path to the Refresh All button? Select one: a. (CONNECTIONS tab | Get External Data group) b. (VIEW tab | Refresh group) c. (DATA tab | Connections group) d. (INSERT tab | Refresh Connections group)data tab
    connections group
  26. 26Which of the following is the path to the Text to Columns button? Select one: a. (IMPORT tab | Tools group) b. (DATA tab | Data Tools group) c. (INSERT tab | Columns group) d. (DATA tab | Convert group)data tab
    data tools group
  27. 27Which of the following is the path to the ‘Get Data From Text' button? Select one: a. (DATA tab | Get External Data group) b. (HOME tab | Import Data group) c. (GET EXTERNAL DATA tab | Text group) d. (TEXT tab | Import Data group)data tab
    get external data group
  28. 28Which of the following is the path to the ‘Insert a SmartArt Graphic' button? Select one: a. (DESIGN tab | Illustrations group) b. (INSERT tab | Images group) c. (INSERT tab | Illustrations group) d. (VIEW tab | Insert SmartArt group)insert tab
    illustrations group
  29. 29Which of the following is the path to the ‘Take a Screenshot' button? Select one: a. (HOME tab | Images group) b. (INSERT tab | Illustrations group) c. (ILLUSTRATIONS tab | Insert Images group) d. (DATA tab | Insert group)insert tab
    illustrations group
  30. 30You can access the Find and Replace feature by pressing the ____ key(s). Select one: a. ALT+H b. CTRL+R c. F11 d. CTRL+Hctrl h
  31. 31You can add text to a SmartArt graphic by using the ____. Select one: a. Text Pane b. caption feature c. Content window d. Typographical dialog boxtext pane
  32. 32You can select any range of cells with entries surrounded by blank cells by clicking a cell in the range and then pressing ____. Select one: a. CTRL+ASTERISK b. SHIFT+AMPERSAND c. CTRL+SHIFT+ASTERISK d. CTRL+SHIFT+AMPERSANDctrl shift asterisk
  33. 33____ a shape within a SmartArt graphic means moving it to a higher level. Select one: a. Enhancing b. Elevating c. Promoting d. Raisingpromoting
  34. 34____ a shape within a SmartArt graphic means moving it to a lower level. Select one: a. Descending b. Demoting c. Reducing d. Rasterizingdemoting
  35. 35____ can describe any type of data. Select one: a. HTML b. XML c. XLTX d. DOCXxml
  36. 36After a template is saved, it can be used every time a similar workbook is developed. Select one: True FalseT
  37. 37By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range. Select one: True FalseF
  38. 38Deployments are most helpful when you need to create several similar or identical workbooks. _________________________ Select one: True FalseF
  39. 39Each type of graphic includes several layouts, or templates, from which to choose. Select one: True FalseT
  40. 40Excel allows you to import data from webpages. Select one: True FalseT
  41. 41Excel allows you to import formatting from a number of types of sources. _________________________ Select one: True FalseT
  42. 42In some situations, you may find that a column of data imported from Word should be split into two columns. Select one: True FalseT
  43. 43It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet. Select one: True FalseF
  44. 44It is not possible to replicate formulas after completing an import, so be sure to complete the replication before the import. Select one: True FalseF
  45. 45Saving a template is similar to saving a workbook, except that the file type, Master File is selected in the Save as type box in the Save As dialog box. _________________________ Select one: True FalseF
  46. 46SmartArt graphics may include at most one shape. Select one: True FalseF
  47. 47Some spreadsheet specialists refer to copying formulas as replacing.​ Select one: True FalseF
  48. 48The Convert Text to Columns Wizard can be used only when a range that includes two or more columns is selected. Select one: True FalseF
  49. 49The Find and Replace dialog box has two variations, one displaying minimal options and the other displaying all of the available options. Select one: True FalseT
  50. 50The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text. Select one: True FalseT
  51. 51The Import Data dialog box includes options to specify which parts of a webpage to import and how much of the HTML formatting to keep. Select one: True FalseF
  52. 52The most common use for the Convert Text to Columns Wizard is to manipulate imported data. Select one: True FalseT
  53. 53The Transpose command is located on the Copy button menu. Select one: True FalseF
  54. 54The WordArt graphic is a customizable diagram that you use to pictorially present lists, processes, and relationships.​ Select one: True FalseF
  55. 55To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu. Select one: True FalseF
  56. 56Using the screen shot feature, you can capture whole windows only. Select one: True FalseF
  57. 57Webpage column headings are imported with the data and displayed in rows. Select one: True FalseT
  58. 58When a range is transposed, the first row of the selected range becomes the first column in the destination range, and so forth. Select one: True FalseT
  59. 59When importing data into a workbook, it is common to receive text files with fields of data separated by commas. _________________________ Select one: True FalseT
  60. 60When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area. Select one: True FalseT
  61. 61When you import a table from Access into Excel, the table is formatted with the default table style for the database's theme. _________________________ Select one: True FalseF
  62. 62When you open a file based on a template, Excel names the new workbook using the template name with an appended alphabetic character, such as TemplateA. Select one: True FalseF
  63. 63You always need to pay for images you use on your website. Select one: True FalseF
  64. 64You can transpose directly from copied Word tables. Select one: True FalseF
  65. 65You often replicate formulas after completing an import because the total number of records to be imported usually is unknown. Select one: True FalseT
  66. 66You should not credit the source of an image unless you can specifically name the image creator. Select one: True FalseF
  67. 67​HTML stands for Hypertext Markup Language. Select one: True FalseT
  68. 68A ____ is a visual way to show how two variables relate to each other. Select one: a. pivotline b. guideline c. timeline d. trendlinetrendline
  69. 69A ____ is an interactive view of worksheet data. Select one: a. PivotChart report b. trendline c. PivotTable report d. 2-D column chartpivottable report
  70. 70A ____ report is an interactive chart that allows users to change the groupings that graphically present data. Select one: a. SlicerChart b. PivotChart c. TrendChart d. 2-D Column chartpivotchart
  71. 71A(n) ____ is most often thought about in terms of how a value changes over time, but can also describe the relationship between two variables. Select one: a. trend b. change c. alignment d. arrangementtrend
  72. 72Charts with ____ are often reformatted to start the vertical axis at a number other than zero. Select one: a. data layouts b. indices c. trendlines d. baselinestrendlines
  73. 73Click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box. Select one: a. Options b. Columns c. Fields d. PivotTablepivottable
  74. 74Excel treats ____ as graphic objects that can be moved, resized, and formatted. Select one: a. slicers b. PivotTables c. data markers d. PivotChartsslicers
  75. 75In a PivotTable, ____ fields correspond to summary values of original data across categories. Select one: a. category b. index c. data d. summarydata
  76. 76In PivotTables, ____ fields correspond to columns in the original data. Select one: a. row b. index c. summary d. categorycategory
  77. 77PivotTables are ____ by nature. Select one: a. static b. inactive c. attractive d. dynamicdynamic
  78. 78The +/- buttons ____ a field across categories. Select one: a. add and subtract b. expand and collapse c. multiply and divide d. none of the aboveexpand and collapse
  79. 79The summary function that calculates the number of data values in a PivotTable report is ____. Select one: a. Count b. Product c. Var d. Count Numscount
  80. 80The summary function that calculates the smallest data value in a PivotTable report is ____. Select one: a. Varp b. Min c. Max d. Averagemin
  81. 81The ____ summary function estimates the standard deviation of all of the data to be summarized in a PivotTable report. Select one: a. Sum b. Varp c. StdDev d. ProductstdDev
  82. 82The ____ value is a number from 0 to 1 that measures the strength of a trend. Select one: a. A-squared b. P-squared c. R-squared d. T-squaredr-squared
  83. 83To change the summary functions in a PivotTable, right-click a cell, point to ____, and click a command on the submenu. Select one: a. Subtotal Values By b. Summarize Values By c. Total Values By d. Calculate Values Bysummarize values by
  84. 84To create a PivotChart report directly from data, click the ____ button in the Charts group on the INSERT tab. Select one: a. Data Analysis b. PivotTable c. Charting d. PivotChartPivotTable
  85. 85Viewing a PivotTable report only for a subset that meets a selection criterion is known as ____. Select one: a. organizing b. implementing c. sorting d. filteringfiltering
  86. 86When creating a PivotTable report, the active cell should be positioned ____. Select one: a. anywhere in the range that contains the data b. in cell A1 c. anywhere outside the range that contains the data d. There is no active cell in a PivotTable report.anywhere in the range that contains the data
  87. 87Which of the following is the path to the +/- Buttons button? Select one: a. (PIVOTTABLE TOOLS DESIGN tab | Show group) b. (PIVOTTABLE TOOLS ANALYZE tab | Show group) c. (PIVOTTABLE TOOLS FORMAT tab | Show group) d. (PIVOTTABLE TOOLS DISPLAY tab | Reveal group)pivottable tools analyze tab
    show group
  88. 88Which of the following is the path to the Field Buttons button? Select one: a. (PIVOTCHART TOOLS LAYOUT tab | Show/Hide group) b. (PIVOTCHART TOOLS DESIGN tab | Show/Hide group) c. (PIVOTCHART TOOLS OPTIONS tab | Show/Hide group) d. (PIVOTCHART TOOLS ANALYZE tab | Show/Hide group)pivotchart tools analyze tabe
    show/hide group
  89. 89Which of the following is the path to the Field Headers button? Select one: a. (PIVOTTABLE TOOLS DESIGN tab | Show group) b. (PIVOTTABLE TOOLS LAYOUT tab | Show group) c. (PIVOTTABLE TOOLS ANALYZE tab | Show group) d. (PIVOTTABLE TOOLS DESIGN tab | Fields group)pivottable tools analyze tab
    show group
  90. 90Which of the following is the path to the Field List button? Select one: a. (PIVOTTABLE TOOLS LAYOUT tab | Show group) b. (PIVOTTABLE TOOLS ANALYZE tab | Show group) c. (PIVOTTABLE TOOLS DESIGN tab | Show group) d. (PIVOTTABLE TOOLS DESIGN tab | Fields group)pivottable tools analyze tab
    show group
  91. 91Which of the following is the path to the Move Chart button? Select one: a. (PIVOTCHART TOOLS LAYOUT tab | Location group) b. (PIVOTCHART TOOLS FORMAT tab | Location group) c. (PIVOTCHART TOOLS DESIGN tab | Location group) d. (PIVOTCHART TOOLS OPTIONS tab | Location group)pivotchart tools design tab
    location group
  92. 92Which of the following is the path to the PivotChart button? Select one: a. (PIVOTTABLE TOOLS DESIGN tab | Create Chart group) b. (PIVOTTABLE TOOLS ANALYZE tab | Tools group) c. (PivotChart Tools Options tab | Show group) d. (PIVOTCHART TOOLS DESIGN tab | Create Chart group)pivottable tools analyze tab
    tools group
  93. 93Which of the following is the path to the PivotChart menu? Select one: a. (INSERT tab | Charts group) b. (HOME tab | Charts group) c. (VIEW tab | Data group) d. (INSERT tab | Images group)insert tab
    charts group
  94. 94Which of the following is the path to the PivotTable button? Select one: a. (INSERT tab | Text group) b. (HOME tab | Analysis group) c. (INSERT tab | Tables group) d. (TABLES tab | Analysis group)insert tab
    tables group
  95. 95Which of the following is the path to the PivotTable Styles gallery More button? Select one: a. (INSERT tab | Table Styles group) b. (PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group) c. (HOME tab | Paint Styles group) d. (PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group)pivottable tools design tab
    pivottable styles group
  96. 96Which of the following is the path to the Refresh button? Select one: a. (PIVOTTABLE TOOLS ANALYZE tab | Data group) b. (PIVOTTABLE TOOLS DESIGN tab | Data group) c. (PIVOTTABLE TOOLS FORMAT tab | Data group) d. (PIVOTTABLE TOOLS LAYOUT tab | Data group)pivottable tools analyze tab
    data group
  97. 97Which of the following is the path to the Report Layout button? Select one: a. (PIVOTTABLE TOOLS LAYOUT tab | Design group) b. (PIVOTTABLE TOOLS DESIGN tab | Layout group) c. (PIVOTTABLE TOOLS FORMAT tab | Layout group) d. (PIVOTTABLE TOOLS DESIGN tab | Theme group)pivottable tools design tab
    layout group
  98. 98Which of the following is the path to the ‘Add Chart Element' button? Select one: a. (PIVOTCHART TOOLS DESIGN tab | Analysis group) b. (PIVOTCHART TOOLS DESIGN tab | Chart Layouts group) c. (PIVOTCHART TOOLS FORMAT tab | Analysis group) d. (PIVOTCHART TOOLS FORMAT tab | Options group)pivotchart tools design tab
    chart layouts group
  99. 99With which of the following are any selected subgroups immediately identifiable, and able to be changed with the click of a button or buttons? Select one: a. autofilters b. slicers c. filters d. pivotsslicers
  100. 100You can add a trendline to all of the following EXCEPT a(n) ____ chart. Select one: a. inventory b. pie c. scatter d. bubblepie
  101. 101You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height. Select one: a. SLICER TOOLS FORMAT b. SLICER TOOLS LAYOUT c. SLICER TOOLS OPTIONS d. SLICER TOOLS DESIGNslicer tools options
  102. 102You can click the ____ button in the Filter group on the PivotChart Tools Analyze tab to display the Insert Slicer dialog box. Select one: a. Add Slicer b. Apply Slicer c. Insert Slicer d. Process Slicerinsert slicer
  103. 103You can connect ____ to more than one PivotTable to filter the data. Select one: a. PivotCharts b. slicers c. field lists d. row headingsslicers
  104. 104You can display the Move Chart dialog box by clicking the Move Chart button in the Location group on the ____. Select one: a. PIVOTCHART TOOLS LAYOUT tab b. PIVOTTABLE TOOLS DESIGN tab c. PIVOTTABLE TOOLS LAYOUT tab d. PIVOTCHART TOOLS DESIGN tabpivotchart tools design tab
  105. 105You can filter the PivotTable report by ____. Select one: a. Total 2014 Sales b. Revenue Venue c. Total 2015 Sales d. Average 2014 Salesrevenue value
  106. 106____ are a visual filter used to make PivotCharts and PivotTables easier to interpret. Select one: a. Slicers b. Trenders c. Charters d. Markersslicers
  107. 107____ reports are visual representations of PivotTables. Select one: a. PivotChart b. Slicer c. Data Marker d. Calculated fieldpivotchart
  108. 108All summary functions are available from the shortcut menu of a cell in the PivotTable report. Select one: True FalseF
  109. 109All types of Excel charts can have a trendline added to them. Select one: True FalseF
  110. 110Before you add a trendline to a chart, you need to determine the data series to analyze. Select one: True FalseT
  111. 111By default, a PivotChart report will be created on its own chart sheet in a workbook. Select one: True FalseF
  112. 112Changes in the view of a PivotChart report are automatically reflected in the PivotTable report. Select one: True FalseT
  113. 113Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles. Select one: True FalseT
  114. 114Excel needs the blank rows above a PivotTable to remain blank, for any filters added in the PivotTable Fields task pane. Select one: True FalseT
  115. 115Filtering cannot happen independently of cell selection. Select one: True FalseF
  116. 116Formatting techniques that work for regular tables of data behave in the same fashion in PivotTable reports. Select one: True FalseF
  117. 117PivotChart reports often are used to represent changes in one set of data over time. _________________________ Select one: True FalseF
  118. 118PivotTable fields can be one of three types: data, summary, and category. Select one: True FalseF
  119. 119PivotTable rows are drawn from columns in the worksheet data. _________________________ Select one: True FalseF
  120. 120PivotTables automatically update when you change the underlying data for the PivotTable report. Select one: True FalseF
  121. 121The default chart type for a PivotChart is a 2-D Line chart. Select one: True FalseF
  122. 122To add data to a PivotTable, select field check boxes in the PivotTable Fields task pane. Select one: True FalseT
  123. 123Today, data are increasingly available from a wide variety of sources and gathered with much more ease. Select one: True FalseT
  124. 124Using a(n) trendline on certain Excel charts allows you to illustrate an underlying tendency of how one set of data is changing in relation to another set of data. _________________________ Select one: True FalseT
  125. 125When analyzing a chart that contains a trendline, always check the axes to be sure that the differences shown in the chart are not being visually overstated. _________________________ Select one: True FalseT
  126. 126When the data in a PivotTable report is changed, any PivotChart reports built upon that PivotTable report update to reflect those changes. Select one: True FalseT
  127. 127When you add a trendline to a chart, you can set the number of periods to forecast forward or backward in time. Select one: True FalseT
  128. 128When you create a PivotTable report, Excel creates and associates a PivotChart with that PivotTable report. Select one: True FalseF
  129. 129When you need to analyze the data presented in PivotTables and PivotCharts, use a trendline to select the data to display and summarize. Select one: True FalseF
  130. 130You can add data to a blank PivotTable by dragging fields from the ‘Choose fields to add to report' area to the ‘Drag fields between areas below' area. Select one: True FalseT
  131. 131You can change the summary function in a PivotTable report by selecting a different summary function in the Value Field Settings dialog box. Select one: True FalseT
  132. 132You can change the view of a PivotTable report depending on what you want to analyze. Select one: True FalseT
  133. 133You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane. Select one: True FalseT
  134. 134A cell containing a formula that references other cells is said to have ____. Select one: a. dependents b. calculations c. precedents d. referencesprecedents
  135. 135A cell whose value relies on another referenced cell is said to be a(n) ____ of that referenced cell. Select one: a. precedent b. partner c. example d. dependentdependent
  136. 136A(n) ____ Report shows the answer that Solver found, which constraints were in place, and which values in the worksheet Solver manipulated in order to solve the problem within those constraints. Select one: a. Solution b. Resolution c. Answer d. Calculationanswer
  137. 137An Answer Report shows original and final values of the target cell and changing cells plus ____. Select one: a. cell formatting b. constraints c. previous trial and error solutions d. all scenariosconstraints
  138. 138An Answer Report's ____ column indicates binding constraints. Select one: a. Constraints b. Cell Value c. Status d. Formulastatus
  139. 139For each model, it is helpful to define a ____ scenario that represents the starting assumptions. Select one: a. baseline b. topline c. bottomline d. sidelinebaseline
  140. 140Formula auditing tools include a tracer ____, which is drawn from a cell that appears in a formula in another cell or from a cell that contains a formula with cell references. Select one: a. arrow b. triangle c. link d. none of the abovearrow
  141. 141Formula ____ allows you to examine formulas to determine which cells are referenced by those formulas. Select one: a. calculating b. auditing c. formatting d. trendingauditing
  142. 142Identifying ____ highlights where changes will occur in the worksheet as a result of changing the value in the cell you are identifying as a referenced cell. Select one: a. precedents b. dependents c. examples d. relationshipdependents
  143. 143One of the tools that Excel provides to solve complex problems is ____, which allows you to specify up to 200 cells that can be adjusted to find a solution to a problem. Select one: a. Goal Seek b. Trendlines c. Solver d. Data Solutionssolver
  144. 144Solver allows you to set a constraint that includes a cell reference followed by a(n) ____. Select one: a. value b. operator c. format d. none of the aboveoperator
  145. 145The Goal Seek command is located on the ____ menu. Select one: a. What-If Analysis b. Problem Solving Tools c. Calculation Settings d. none of the abovewhat-if analysis
  146. 146The primary uses of the Scenario Manager include all of the following except ​ Select one: a. ​create different scenarios with multiple sets of changing cells. b. ​build summary worksheets that contain the different scenarios. c. ​view the results of each scenario on your worksheet. d. ​exclude cells that are input cells for your model.exclude cells that are input cells for your model
  147. 147The Scenario Manager command is located on the ____ menu. Select one: a. Data Tools b. Formula Auditing c. Scenarios d. What-If Analysiswhat-if analysis
  148. 148The Show Iteration Results check box is located in the ____ dialog box. Select one: a. Goal Seek solution b. Data Validation Rules c. Add Scenarios d. Solver Parameterssolver parameters
  149. 149The Trace Error button is located in the ____ dialog box. Select one: a. Error Checking b. Calculation Checking c. Formula Checking d. none of the aboveerror checking
  150. 150The ____ allows you to monitor the values and formulas in cells as you work on a worksheet. Select one: a. Show Window b. Data Window c. Watch Window d. Calculation Windowwatch window
  151. 151The ____ button allows you to move through a formula step by step. Select one: a. Check Formula b. Evaluate Formula c. Review Formula d. Verify Formulaevaluate formula
  152. 152The ____ error code indicates that a cell reference in a formula is not valid. Select one: a. #DIV/0! b. #NAME? c. #VALUE! d. #REF!#REF!
  153. 153The ____ feature is especially useful when working with very large worksheets. Select one: a. model b. summary c. outline d. auditingoutline
  154. 154The ____ Window button opens a separate window that displays values and formulas for specific cells that you choose to monitor. Select one: a. Formula b. Watch c. Error d. Monitoringwatch
  155. 155The ____ worksheet generated by the Scenario Manager actually is a worksheet in outline format. Select one: a. Calculation Summary b. Model Summary c. Scenario Summary d. Solution Summaryscenario summary
  156. 156To check for invalid data entered as the result of a formula or automated tools such as Goal Seek, use the ‘____' command. Select one: a. Bold Invalid Data b. Delete Invalid Data c. Circle Invalid Data d. Replace Invalid Datacircle invalid data
  157. 157When a cell contains a(n) ____ reference, it means that one of its defining values is itself. Select one: a. formatted b. circular c. error d. connectingcircular
  158. 158Which of the following commonly used Solver parameters sets the number of possible answer value combinations that Solver should try? Select one: a. Max Time b. Iterations c. Constraint Precision d. Use Automatic Scalingiterations
  159. 159Which of the following complex problem solving methods, features, or options allows you to provide Excel with all of the known rules of your problem as well as the goal you are seeking, and then attempts as many different solutions to the problem as possible? Select one: a. Trial and error method b. Solver feature c. Goal Seek feature d. Enable iterative calculations optionsolver feature
  160. 160Which of the following is not a primary use of the Scenario Manager? Select one: a. Find a scenario-style solution to a complex problem by changing a single variable b. Create different scenarios with multiple sets of changing cells c. Build summary worksheets that contain the different scenarios d. View the results of each scenario on a worksheefind a scenario-style solution to a complex problem by changing a single variable
  161. 161Which of the following is NOT a type of data validation criteria you can assign to a cell? Select one: a. any specified value b. whole numbers c. dates d. Bold style formattingbold style formatting
  162. 162Which of the following is NOT an issue that must be kept in mind when using Solver? Select one: a. The constraints may be constructed so that an answer that satisfies all of them cannot be found b. Multiple answers might solve the problem c. Some problems do not have solutions d. Constraint precision is incompatible with most forms of automatic scalingconstraint precision is incompatible with most forms of automatic scaling
  163. 163Which of the following is the path to the Data Validation button? Select one: a. (FORMULAS tab | Validation group) b. (DATA tab | Data Tools group) c. (DATA tab | Validation group) d. (FORMULAS tab | Data Tools group)data tab
    data tools group
  164. 164Which of the following is the path to the Error Checking button? Select one: a. (AUDITING tab | Formulas group) b. (FORMULAS tab | Error Checking group) c. (FORMULAS tab | Formula Auditing group) d. (ERROR CHECKING tab | Watch Cells group)formulas tab
    formula auditing group
  165. 165Which of the following is the path to the Solver button? Select one: a. (FORMULAS tab | Data Tools group) b. (DATA tab | Analyze group) c. (ANALYSIS tab | Data group) d. None of the abovedata tab
    analyze group
  166. 166Which of the following is the path to the Trace Precedents button? Select one: a. (FORMULAS tab | Formula Auditing group) b. (FORMULAS tab | Trace group) c. (HOME tab | Formulas group) d. (HOME tab | Auditing group)formulas tab
    formula auditing group
  167. 167Which of the following is the path to the Watch Window button? Select one: a. (FORMULAS tab | Formula Auditing group) b. (FORMULAS tab | Calculations group) c. (FORMULAS tab | Observations group) d. (FORMULAS tab | Watch group)formulas tab
    formula auditing group
  168. 168Which of the following is the path to the ‘Remove All Arrows' arrow? Select one: a. (FORMULAS tab | Reviewing group) b. (FORMULAS tab | Formula Auditing group) c. (FORMULAS tab | Arrows group) d. None of the aboveformulas tab
    formula auditing group
  169. 169Which of the following is the path to the ‘What-If Analysis' button? Select one: a. (DATA tab | Calculation Tools group) b. (DATA tab | Formula Tools group) c. (DATA tab | Forecast group) d. (DATA tab | Problem Solving Tools group)data tab
    forecast group
  170. 170____ are named combinations of values that are assigned to variables in a model. Select one: a. Constraints b. Tables c. Scenarios d. Data validation rulesscenarios
  171. 171A constraint that is not binding is one that is not a limiting factor in the solution that Goal Seek provides. Select one: True FalseT
  172. 172A Scenario Summary worksheet is a worksheet in outline format.​ Select one: True FalseT
  173. 173A Scenario Summary worksheet is not a useful decision-making tool.​ Select one: True FalseF
  174. 174A Solver constraint that is binding is one that limits the final solution in some way. Select one: True FalseT
  175. 175A(n) precedent is a limitation on the possible values that a cell can contain. _________________________ Select one: True FalseF
  176. 176After you display precedent arrows, you must remove them level by level. Select one: True FalseF
  177. 177Auditing the formulas in a worksheet can give you insight into how a worksheet is structured. Select one: True FalseT
  178. 178Each cell referenced in a formula is a dependent of the cell containing the formula. Select one: True FalseF
  179. 179Entries that are the result of calculations will not produce data validation errors. Select one: True FalseT
  180. 180Errors can be introduced into a worksheet in formulas. Select one: True FalseT
  181. 181Errors can be less obvious, introduced through formulas which, while technically correct, introduce unintended results to a worksheet. Select one: True FalseT
  182. 182Excel data validation rules apply when you enter data in a cell manually and when a cell's value is calculated by a formula. Select one: True FalseF
  183. 183Excel uses the Calculate Formulas button to move through a formula step by step. Select one: True FalseF
  184. 184Excel's data validation tool is a what-if analysis tool that allows you to record and save different sets of what-if assumptions used to forecast the outcome of a worksheet model. Select one: True FalseF
  185. 185Goal seeking allows you to manipulate multiple cells to find an optimal solution to a complex problem. Select one: True FalseF
  186. 186If you show a scenario and change values on the scenario worksheet, it is the same as changing the scenario. Select one: True FalseF
  187. 187PivotTables summarize large amounts of data, and can be rearranged and regrouped to show the data in various forms. Select one: True FalseT
  188. 188Solver creates a Summary Solution Report on the same worksheet as the data after it finds a solution. Select one: True FalseF
  189. 189The error code #DIV/0! indicates that there are no common cells in two ranges a formula identifies as having an intersection. Select one: True FalseF
  190. 190The goal for the Solver feature is to maximize the solution within the constraints set. Select one: True FalseT
  191. 191The only way to switch between scenarios is to use the Scenario Manager. Select one: True FalseF
  192. 192The Simplex LP solving method uses geometric progression to solve problems. Select one: True FalseF
  193. 193To ensure that values in specific cells contain only nonnegative whole numbers, Scenario Manager rules should be applied to those cells to restrict a user from entering invalid data. Select one: True FalseF
  194. 194When considering an approach to a complex problem in Excel, start with the least complex method of attempting to solve the problem. _________________________ Select one: True FalseT
  195. 195When trying to solve some problems, you can make a(n) educated guess if you are familiar with the data and the structure of the workbook. _________________________ Select one: True FalseT
  196. 196When using the Custom data validation type, you can use a formula that evaluates to either true or false. Select one: True FalseT
  197. 197You can attempt to solve a complex worksheet problem manually, also known as the trial and error method. Select one: True FalseT
  198. 198You can use scenario auditing to review the formulas in a worksheet. _________________________ Select one: True FalseF
  199. 199You should name ranges for all input variables before creating your first scenario. Select one: True FalseT

Information

Description
Flashcards on Excel 2016 ch 7, 8, 9, created by tom lou on 09/12/2019.
Created by
tom lou
Views
1
Rating

Feedback

What is it about?

What do you think of the new look?

How do you like it?