1. After selecting a cell in the source data range, what is the process to creat
ID: 3593687 • Letter: 1
Question
1. After selecting a cell in the source data range, what is the process to create a PivotTable report?
A. Click the Insert > PivotTable Ribbon icon and then define the structure by inserting fields into the desired report layout areas.
B. Click the Insert > Slicer Ribbon icon and then click the desired slicer buttons.
C. Click the Insert > Table Ribbon icon and then check the Total Row checkbox.
D. Click the Insert > SmartArt icon and then select the desired SmartArt graphic.
2. To change the math function applied to a value field, you can:
A. Right-click the value cell and select the desired function from the Show Values As shortcut menu item.
B. Right-click the value cell and select the desired function from the Summarize Values By shortcut menu item.
C. Select the desired PivotTable value cell and then type an equal sign (=) followed by the desired math function, for example, =SUM.
D. Similar to the SUBTOTAL function, you enter the desired function number into the function_num argument, for example, code 9 for SUM.
3. When we attempt to group a date field, the Grouping dialog box enables us to apply which of the following groups?
A. Months only.
B. Quarters only.
C. Years only.
D. Months, Quarters, and Years.
4. Three of the following are valid methods for filtering a PivotTable. Which one is not?
A. Insert a field into the Filters area to create a report filter.
B. Use the field filter control on any row or column field.
C. Create a slicer.
D. Use conditional formatting to highlight the desired values.
5. Which command launches Excel's web browser?
A. From Access.
B. From Web.
C. From Text.
D. From Other Sources.
6. How can you create a PivotChart?
A. Insert a PivotTable and then click the PivotChart Ribbon icon.
B. Insert a PivotTable and then click the Conditional Formatting Ribbon icon.
C. Insert a PivotTable and then click the Data Validation Ribbon icon.
D. Insert a PivotTable and then click the Sparkline Ribbon icon.
Explanation / Answer
Answer 1) Option A is correct.
To draw a pivot table, one needs to simple go to the insert than click on the pivot table button. A new dialogue box will appear infront of you. In that dialogue box, you can select the data range , than your worksheet location, and that the various fields like row, column etc. This is hoe your pivot table will be generated.
Answer 6) Option A is correct.
To create a pivot chart, simply click on the Insert than pivot chart than a dialogue box will appear from which you can choose use external sources and than choose connections. Your pivot chart will be created with this/
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.