1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Ira Lisetskai [31]
3 years ago
10

Before you create a pivot table, it is important to __.

Computers and Technology
2 answers:
Reptile [31]3 years ago
8 0

Before you create a pivot table, it is important to <em><u>Create a database</u></em>.

Option: A

<u>Procedure to create Pivot Table: </u>

1. Select the cells and table in the sheet containing the data you want to use.

2. Go to the Insert tab and click the PivotTable command.

3. In the dialog box ‘Create PivotTable’ will appear. Choose your settings, then click OK. In our example, we will use Sheet1 as our source data and insert the PivotTable on a new worksheet.

4. The Field List and blank PivotTable will appear on a new worksheet.

5. Once you create a PivotTable, you have to decide which fields to add. Each field has a simple column header from the source data. In the PivotTable Field List, check the box for each field you want to add.  

6. The selected fields will be added to one of the four areas below the Field List. In our example, the Salesman field has been added to the Rows area, while the Order Amount has been added to the Values area. Alternatively, you can click, hold, and drag a field to the desired area.

7. The PivotTable values will calculate and summarize the selected fields. In our example, the PivotTable shows the amount sold by each salesman.

scoundrel [369]3 years ago
7 0

Before you create a pivot table, it is important to(A) Create a database

Explanation:

A pivot table is used as a data summarization tool for processing data

The Pivot tables are used to summarize, sort, reorganize, group, count, total or average data that is stored in a database system

The Pivot Table allows  users to convert  columns into rows and rows into columns.

<u>Their are certain criteria for  data to be placed in a  Pivot Table</u>

  • The First criteria is : Each column must have a title. Blanks/ empty cells as column headings are not permitted.
  • The title of each column should be unique .Redundant data is not allowed.
  • Each column should have only one criteria or value.

<u>As we know that pivot table is a data summarizing tool it is very important to create data that need to be summarized.If their is no data what will a pivot table summarize .Thus we can say that Before you create a pivot table, it is important to(A) Create a database</u>

You might be interested in
What are several different types of software, which sit in the middle of and provide connectivity between two or more software a
brilliants [131]

Answer:

The answer to the given question is the option "a".

Explanation:

In this question, the answer is "middleware" software because this software works between the operating system and the applications that provide connectivity to two or more software applications. for example database, application server, etc and other choices that are not correct can be described as:

  • In option b, The integration middle wear represents the software of the system. It does not coordinate between operating and application software.
  • In option c, It is used to manage the data and the information for the process.
  • In option d, It includes the hardware, software and the networks. In this hardware and software link for use software.

That's why the answer to this question is the option "a".

6 0
3 years ago
Why do I keep losing my crown thingies (brainliest answers) and I lost 2 ranks in the last month? HOW? WHY? I'm starting to get
Natali [406]

there is a lag with the website mines did the same

7 0
3 years ago
Read 2 more answers
According to the video, what tasks do Carpenters commonly perform? Select four options. supervising Plumbers, Electricians, and
TiliK225 [7]

Answer:

Cutting, shaping, and fastening wood.

Installing rafters, joists, windows, and subflooring.

Setting hardwood floors.

Building kitchen cabinets.

7 0
3 years ago
Read 2 more answers
A copyright gives the exclusive legal right to the original author or creator to print, publish, perform, record, or produce mat
KatRina [158]

Answer:                

True.                                

Explain: TRUE                                                  

4 0
3 years ago
Read 2 more answers
How might the design be changed so that additional copies of print statements would not be needed?
bogdanovich [222]

A design be altered so that additional copies of print statements would not be needed by changing the format spring.

<h3>What is the aim of a print statement?</h3>

The PRINT statement is known to be often sent data so that it is taken to the display terminal or to another kind of print unit.

Note that A design be altered so that additional copies of print statements would not be needed by changing the format spring.

Learn more about design from

brainly.com/question/1020696

#SPJ1

5 0
1 year ago
Other questions:
  • Frank has created a résumé and separated the sections using headings. How can he set the headings apart from normal text?
    13·1 answer
  • If you press the tab key when you're in in the last cell of a table,
    10·1 answer
  • How does technology improve productivity at home? (Select all that apply.)
    5·1 answer
  • Will the Python code below print something? And will it terminate?
    9·1 answer
  • Which of the following might cause a shift from PPF1 to PPF2? I. A new source of high quality denim fabric. II. A new lighter me
    12·1 answer
  • 1. Se requiere implementar un conversor unipolar que tendrá una tensión analógica variable entre 0 y 2 V pico. Deberá tener una
    10·1 answer
  • What is cyber ethics​
    10·2 answers
  • Sonora wants to extend the cells to be added in her formula. What is the quickest way to add more cells?
    13·2 answers
  • What is a closed system?​
    7·1 answer
  • 1. Name the three kinds of Eraser in Photoshop. <br>​
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!