INFS4

.docx

School

University of Texas, Rio Grande Valley *

*We aren’t endorsed by this school

Course

3320

Subject

Electrical Engineering

Date

Feb 20, 2024

Type

docx

Pages

3

Uploaded by ColonelPencilShark7

Report
Question 1 1 out of 1 points A row label corresponds to a data series in a PivotTable report. Selected Answer: Fals e Question 2 1 out of 1 points A PivotTable is an interactive Excel report that summarizes large amounts of data, allowing you to more easily analyze it. Selected Answer: Tru e Question 3 1 out of 1 points Slicers are easy-to-use filtering components that enable you to quickly filter data in a PivotTable report. Selected Answer: Tru e Question 4 1 out of 1 points To best represent large amounts of data, it is often helpful to filter the PivotTable. Selected Answer: Tru e Question 5 1 out of 1 points When you import data from Microsoft Access to Excel, the resulting association between tables of data that share a common field is called a ________. Selected Answer: relationship Question 6 1 out of 1 points When a numeric field is added to a PivotTable, it is placed in the ________ area of the PivotTable field list. Selected Answer: VALUES Area Question 7 1 out of 1 points To limit the display of data to only specific information is called ________. Selected Answer: filter Question 8 1 out of 1 points
Which of the following is a button on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart? Selected Answer: Field button Question 9 1 out of 1 points A PivotTable report ________ large amounts of data so you can analyze related totals. Selected Answer: combines and compares Question 10 1 out of 1 points By default, when a non-numeric field is added to a PivotTable, it is placed in the ________ area. Selected Answer: ROWS Area Question 11 1 out of 1 points A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart. Selected Answer: field buttons Question 12 1 out of 1 points A slicer includes a ________ that indicates the category of the slicer items. Selected Answer: slicer header Question 13 1 out of 1 points Excel uses the column titles as the ________ for the categories of data. Selected Answer: field names Question 14 1 out of 1 points The default calculation in a PivotTable Report is to ________ the numeric data. Selected Answer: sum Question 15 1 out of 1 points The data for a PivotTable formatted in columns and rows is called ________.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help