All categories

4 years ago

1. Grouping Data in a Pivot Table can help you do what?

Computers and Technology

1 answer:

valentina_108 [34]4 years ago

4 0

Answer:

1.Grouping data in a PivotTable can help you show a subset of data to analyze. For example, you may want to group an unwieldy list of dates or times (date and time fields in the PivotTable) into quarters and months, like this image. Note: The time grouping feature is new in Excel 2016.

2.Select the rows or columns you wish to grouP

On the Data tab, in the Outline group, click the Group command.

In the Group dialog box, select Rows or Columns and click OK.

3.Select the rows or columns you wish to ungroup.

On the Data tab, in the Outline group, click the Ungroup command.

In the Group dialog box, select Rows or Columns and click OK.

1.Launch Microsoft Excel.

Browse to and open the workbook file containing the pivot table and source data for which you need filter data.

Select the worksheet containing the pivot tab and make it active by clicking the appropriate tab.

Determine the attribute by which you want to filter data in your pivot table.

The attribute should be one of the column labels from the source data that is populating your pivot table.

For example, assume your source data contains sales by product, month and region. You could choose any one of these attributes for your filter and have your pivot table display data for only certain products, certain months or certain regions. Changing the filter field would determine which values for that attribute are shown.

Force the Pivot Table Wizard or Field List to launch by clicking a cell inside the pivot table.

Drag and drop the column label field name you wish to apply as a filter to the "Report Filter" section of the pivot table field list.

This field name may already be in the "Column Labels" or "Row Labels" section.

It may be in the list of all field names as an unused field.

Set the filter to display one of the values for the field.

You can set the filter to display all values or only one. Click the arrow beside the filtered label and check the "Select Multiple Items" check box if you would like to select certain values for your filter.

Explanation:

PLZ MARK ME AS A BRAINLIST ;)

You might be interested in

To conserve its public IP addresses, a company can instead use ____ addresses for devices within its own network boundaries.

Thepotemich [5.8K]

Answer:

private ip addresses

Explanation:

A private ip address is assigned to each device on a network, allowing devices on the same network to communicate with each other without using any public ip addresses.

7 0

2 years ago

Based on this information, what is their gross income for six months? Roderick

alexira [117]

Multiply what he makes a month by six

8 0

3 years ago

. Briefly describe an SQL DML statement for changing existing data in a table.

bearhunter [10]

Answer:

The Update statement in the DML is used for changing existing data in a table.

Explanation:

Their are following Sql statement in the DML.

Insert

This SQL statement is used for inserting data into the table.

select

This SQL statement is used for retrieving data from database

update

This SQL statement is used for updating data in a table.

delete

This SQL statement is used for delete data from database .

The "UPDATE" SQL statement in DML is used for Modify the data in the existing table .

Following are the syntax of Update SQL query

Update tablename

set column1=value1,column2=value2............column N=valueN

Where condition;

Example :Suppose we have student table and (rollno,name,age and add) are the field for that table we have to change the address of rollno 105

Then we use update query like that

UPDATE STUDENT

SET add='kalam nagar'

where rollno=105;

8 0

3 years ago

Controller Area Network CAN B bus diagnostics is being discussed. Technician A says some modules do not set specific codes that

miss Akunina [59]

Answer:

Both Technician A and Technician B is correct.

Explanation:

CAN (Controller Area Network) is specially designed for the European cars and the automotive industry, but it has become the popular bus in the industrial automation and also in other applications.

CAN is the serial communication bus that is designed for flexible and robust performance in a harsh environment.

3 0

4 years ago

Write a function analyze_text that receives a string as input. Your function should count the number of alphabetic characters (a

laiz [17]

Answer:

def analyze_text(sentence):

count = 0

e_count = 0

for s in sentence:

s = s.lower()

if s.isalpha():

count += 1

if s == "e":

e_count += 1

return "The text contains " + str(count) + " alphabetic characters, of which " + str(e_count) + " (" + str(e_count*100/count) + "%) are ‘e’."

Explanation:

Create a function called analyze_text takes a string, sentence

Initialize the count and e_count variables as 0

Create a for loop that iterates through the sentence

Inside the loop, convert all letters to lowercase using lower() function. Check each character. If a character is a letter, increment the count by 1. If a character is "e", increment the e_count by 1.

Return the count and e_count in required format

5 0

3 years ago