All categories

3 years ago

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

Computers and Technology

1 answer:

valentina_108 [34]3 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

Explain your understanding of distributed object system.

Paraphin [41]

Answer:

In the distributing computing, distributed object system is the process in which the distributed object are get distributed in different address space. The distributed object system is the enhancement of the client server model.

Distributed object are basically refers to the software module which are designed in such a way, so that they work together in the network.

And it is distributed physically within the network area and the methods is executed on the basis of remote host in the distributed system.

7 0

3 years ago

Which is an example of an binary number?

Liula [17]

The second one
01111
This is because a computer uses binary and only understands two digits which consit of 1 and 0

8 0

3 years ago

Read 2 more answers

What methods could you use to set up printing in an organization?

shutvik [7]

The used to set up printing in an organisation are as follows;

Connecting directly to the printer
setting up a print server
using a cloud service to set up printers.

<h3>Method for printing in organisation.</h3>

There are different method for setting up printing in an organisation.

They include the following;

Connecting directly to the printer : directly connecting a printer; From small to large organizations, you have lots of ways to set up a printer.
setting up a print server
using a cloud service to set up printers. There are numerous cloud service that could render this service like goggle.

learn more on printing here: brainly.com/question/14668983

#SPJ11

3 0

2 years ago

Given a floating-point formal with a k-bit exponent and an n-bit (fraction, write formulas for the exponent E, significant M, th

ANEK [815]

Answer:

A) Describe the number 7.0 bit

The exponential value ( E ) = 2

while the significand value ( M ) = 1.112 ≈ 7/4

fractional value ( F ) = 0.112

And, numeric value of the quantity ( V ) = 7

The exponent bits will be represented as : 100----01.

while The fraction bits will be represented as : 1100---0.

<u>B) The largest odd integer that can be represented exactly </u>

The integer will have its exponential value ( E ) = n

hence the significand value ( M )

= 1.11------12 = 2 - 2-n

also the fractional value ( F ) =

0.11------12 = 1 – 2-n

Also, Value, V = 2n+1 – 1

The exponent bits will be represented as follows: n + 2k-1 – 1.

while The bit representation for the fraction will be as follows: 11---11.

<u>C) The reciprocal of the smallest positive normalized value </u>

The numerical value of the equity ( V ) = 22k-1-2

The exponential value ( E ) = 2k-1 – 2

While the significand value ( M ) = 1

also the fractional value ( F ) = 0

Hence The bit representation of the exponent will be represented as : 11---------101.

while The bit representation of the fraction will be represented as : 00-----00.

Explanation:

E = integer value of exponent

M = significand value

F = fractional value

V = numeric value of quantity

A) Describe the number 7.0 bit

The exponential value ( E ) = 2

while the significand value ( M ) = 1.112 ≈ 7/4

fractional value ( F ) = 0.112

And, numeric value of the quantity ( V ) = 7

The exponent bits will be represented as : 100----01.

while The fraction bits will be represented as : 1100---0.

<u>B) The largest odd integer that can be represented exactly </u>

The integer will have its exponential value ( E ) = n

hence the significand value ( M )

= 1.11------12 = 2 - 2-n

also the fractional value ( F ) =

0.11------12 = 1 – 2-n

Also, Value, V = 2n+1 – 1

The exponent bits will be represented as follows: n + 2k-1 – 1.

while The bit representation for the fraction will be as follows: 11---11.

<u>C) The reciprocal of the smallest positive normalized value </u>

The numerical value of the equity ( V ) = 22k-1-2

The exponential value ( E ) = 2k-1 – 2

While the significand value ( M ) = 1

also the fractional value ( F ) = 0

Hence The bit representation of the exponent will be represented as : 11---------101.

while The bit representation of the fraction will be represented as : 00-----00.

8 0

3 years ago

Maisy is an aspiring video game programmer. She has some unique ideas for new video games, but first, she needs to get some comp

xenn [34]

Answer:

She does not need a computer all she needs are a good laptop that could handle a game engine and a graphic drawing tablet to make the terrain and characters.

Explanation:

It also depends on what kind of game you want to create

6 0

3 years ago