Question: 1) what is default statistic is used for non -numeric data in the values area of the pivot table? 2)what default statistic is used for

1) what is default statistic is used for non -numeric data in the values area of the pivot table?

2)what default statistic is used for numeric data in the values area of the pivot table?

3)by default, how does a pivot table arrange the categories in a row or column area?

4)what happens when you place a date field in a row or column area?

5)what are two ways of filtering a pivot table?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

Instructions Start Excel. Download and open the file named Exp19_Excel_Ch05_ML1_RealEstate.xlsx. Grader has automatically added your last name to the beginning of the filename. Before subtotaling the...

Q:

please answer all questions with the given excel sheet and show work please Arial 10 ' ' = = Date ID Paste Conditional Form 9. Format us Table Cell Styles LU BI INI $ % ) a89 H2 Xfx 4/1/2021 A B D E...

Q:

D 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 A Month Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15...

Q:

BA 1605: Midterm Recap (Due: Feb. 27, 2015) Name _____________________________ 50 Student ID _____________________________ Section 01B 10:00~11:20 am Section 02B 01:00~02:20 pm [Questions 4 ~ 7] The...

Q:

Create charts to better understand data sets. For cross-sectional data, use a scatter chart. For time series data, use a line chart. Linear y = a + bx Logarithmic y = ln(x) Polynomial (2nd order) y =...

Q:

Data analytics is the process of examining data sets in order to draw conclusions about the information they contain Data analytics is widely used in business to enable organizations to make better...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Year Quarter Location CarClass Revenue NumCars 2018 Q1 Airport Economy 1011191 5650 2018 Q1 Downtown Economy 943509 5965 2017 Q4 Airport Economy 926382 5122 2016 Q3 Downtown Economy 777155 5280 2017...

Q:

Suppose you had to identify the color of ink for a series of printed words, but the printed word appeared in a color of ink that did not match the name of the color. For example, if you were shown...

Q:

On January 1, 2013, Appliance Outlets had the following balances in its stockholders equity accounts: Common Stock ($10 par), $800,000; Paid-In Capital in Excess of Par, $625,000; and Retained...

Q:

BE9.11 (LO 3) Cheng SE traded a used truck for a new truck. The used truck cost $30,000 and has accumulated depreciation of $27,000. The new truck is worth $37,000. Cheng also made a cash payment of...

Q:

REVIEW THE INFORMATION ABOUT LEAPFROG HOSPITAL SAFETY GRADES. CHOOSE TWO HOSPITALS TO COMPARE A VERY EFFECTIVE ONE AND ONE WHICH IS NOT EFFECTIVE. WHAT SEPARATES THE TWO? HOW CAN THE A HOSPITAL USE...

Q:

7. How can the models we use have a detrimental effect on others?

Q:

2. In this chapter, the reader should reflect on the following concepts: Systemic structuring, the displaced error, the communicable part of knowl-edge, tacit knowledge, hidden knowledge, analogy,...

Q:

2. List five points that are crucial to pay attention to if you want to positively influence someone from a foreign culture.