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
Vhat is output by the code below?<br><br> PLEASE HELP!! TIME LIMIT!!
marysya [2.9K]

Answer:

My best guess about this is C

Explanation:

6 0
3 years ago
Suppose you are provided with 2 strings to your program. Your task is to join the strings together so you get a single string wi
Mariulka [41]

Answer:

public class TestImport{

   public static void main(String[] args) {

       String string1 = args[1];

       String string2 = args[2];

       System.out.println(string1 +" " +string2);

   }

}

Explanation:

The solution here is to use string concatenation as has been used in this statement System.out.println(string1 +" " +string2);

When this code is run from the command line and passed atleast three command line arguments for index 0,1,2 respectively, the print statment will return the second string (that is index1) and the third argument(that is index2) with a space in-between the two string.

6 0
2 years ago
Call your function from Example 1 three times with different kinds of arguments: a value, a variable, and an expression. Identif
Blizzard [7]

Answer:

Example 1:

def function(num):  

   print(num*2)

Example 2:

function(5)

num = 2

function(num)

function(3-1)

Explanation:

Given:

See attachment for complete question

To start with Example (1)

def function(num):  

   print(num*2)

<em>Note that; the above code segment which doubles the parameter, num could have been any other code</em>

<em />

<em>In Example (1), the parameter is num</em>

For example (2):

We can call the function using:

#1. A value:

function(5)

<em>In #1, the argument is 5; a value</em>

#2. A Variable

num = 2

function(num)

<em>In #2, the argument is num; a variable</em>

#3. An Expression

function(3-1)

<em>In #3, the argument is 3-1; an expression</em>

8 0
3 years ago
The responsibilities of the IT department and the needs of the user departments may cause conflicts over A. the color of the use
monitta

I'd say B: the amount and type of security placed on an application.

This is a common problem that exists between IT and other user departments. The IT department is well known for closing up certain sites and applications needed by other departments all in the name of security. As a result, it might slow down operations within different department and may cause inefficiency.

4 0
3 years ago
Ergonomics is defined as
Scrat [10]

Answer:

B. The design and arrangement of items for efficiency and safety.  

Explanation:

6 0
3 years ago
Other questions:
  • Reading is the process of transferring data, instructions, and information from memory to a storage medium.
    15·1 answer
  • ANSWER ME PLS
    9·1 answer
  • When studying an information system, illustrations of actual documents should be collected using a process called _____.
    12·1 answer
  • Which of the following choices is not a viewing option?
    10·1 answer
  • Can anyone find any words in here?
    14·2 answers
  • In Microsoft Word, when you highlight existing text you want to replace, you're in
    7·1 answer
  • Give two advantages of representing integers in pure binary.
    5·1 answer
  • Where are parameters such boot order, processor voltage, motherboard raid, hardware virtualization support, and overclocking con
    7·1 answer
  • HELP PLEASE 100 POINTS
    8·2 answers
  • Which SCSI standard allows for the technique known as “hot swapping”? Ultra SCSI Original SCSI Serial SCSI Fast-Wide SCSI
    5·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!