Answer Happy

answer 15 to 31
15. Changing cell values through scenarios affects not only the cells defined in the scenario but also any cells that reference the changing cells a. True b. False 16. If you create multiple scenarios for the same data, use the Scenario Manager to generate a scenario summary report summarizing and comparing the effects of the scenarios a. True b. False 17. One of the most powerful uses of Excel is to identify data trends and forecast future values a. True b. False 18. The forecast sheet feature creates a new worksheet with a data table and chart predicting future values based on the data you select a. True b. False 19. The forecast sheet feature relies on two data ranges: a set of dates in equal increments and a value for each of the dates a. True b. False 20. PivotTables do not contain any data themselves-they summarize data from another part of your workbook a. True b. False 21. Pivot Tables summarize data and calculate subtotals using functions like a. SUM b. AVERAGE c. Both a & b d. Neither a NOR b 22. Grouping adds another level of organization to your Pivot Table a. True b. False 23. Solver is a data analysis tool that evaluates multiple variables affecting a formula and produces optimal values for those variables within defined constraints to result in a value you specify a. True b. False 24. A slicer is a visual representation of a field and the values you can filter by. You can create multiple slicers and filter the Pivot Table by multiple values from each a. True b. False 25. A timeline allows you to filter data in a Pivot Table by segment(s) of time-days, months, quarters, or years a. True b. False 26. Timelines are similar to slicers except they are limited to Pivot Table fields formatted as dates a. True b. False 27. In Microsoft Access data are stored in multiple tables that connect to one another via related fields a. True b. False 28. Organizations often use a database to input and store data and then import those data into Excel to perform statistical and what-if analyses a. True b. False 29. Text files are common for passing data between organizations because they can be read by many different application programs a. True b. False 30. A text file that includes multiple data fields may separate the fields with a specific character (a delimiter] a. True b. False 31. Common delimiters are: a. Commas b. Tabs c. Spaces Upload Blocked ENG 01:29 AM