All categories

2 years ago

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

Computers and Technology

2 answers:

Reptile [31]2 years ago

8 0

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

Option: A

Procedure to create Pivot Table:

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]2 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.

Their are certain criteria for data to be placed in a Pivot Table

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.

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

You might be interested in

(1) Prompt the user to enter two words and a number, storing each into separate variables. Then, output those three values on a

Sergeu [11.5K]

Answer:

import java.util.Scanner;

public class num3 {

public static void main(String[] args) {

Scanner in = new Scanner(System.in);

System.out.println("Enter Favorite color");

String word1 = in.next();

System.out.println("Enter Pet's name");

String word2 = in.next();

System.out.println("Enter a number");

int num = in.nextInt();

//Point One

System.out.println("You entered: "+word1+" "+word2+

" "+num);

//Point Two

String passwordOne = word1+"_"+word2;

String passwordTwo = num+word1+num;

System.out.println("First password: "+passwordOne);

System.out.println("Second password: "+passwordTwo);

//Point Three

int len_passwrdOne = passwordOne.length();

int len_passwrdTwo = passwordTwo.length();

System.out.println("Number of characters in "+passwordOne+" :" +

" "+len_passwrdOne);

System.out.println("Number of characters in "+passwordTwo+" :" +

" "+len_passwrdTwo);

}

Explanation:

This question is solved using java programming language
The scanner class is used to receive the three variables (Two string and one integer)
Once the values have been received and stored in the respective variables (word1, word2 and num), Use different string concatenation to get the desired output as required by the question.
String concatenation in Java is acheived with the plus (+) operator.

3 0

2 years ago

A mom is planning a theme park trip for her husband, herself, and their three children. The family has a budget of $500. Adult t

dolphi86 [110]

Complete question :

Sue is planning a theme park trip for her husband, herself, and her three children. She has a budget of $500. Adult tickets cost $55 each, and child tickets cost $25 each. Which formula should go in cell B4?

Answer:

=E1B1+E2B2

Explanation:

Cost of adult ticket = $55

Child ticket = $25

Number of adult = 2

Number of children = 3

Assume :

Cost of adult ticket = $55 = E1

Child ticket = $25 = E2

Number of adult = 2 = B1

Number of children = 3 = B2

The formula that should go into cell B5 in other to calculate total amount :

Total should be :

($55*2) + ($25*3)

=E1B1+E2B2

6 0

2 years ago

A palindrome is a string that reads the same from left to right and from right to left. Design an algorithm to find the minimum

stepladder [879]

Answer:

Explanation:

The following code is written in Python. It is a recursive function that tests the first and last character of the word and keeps checking to see if each change would create the palindrome. Finally, printing out the minimum number needed to create the palindrome.

import sys

def numOfSwitches(word, start, end):

if (start > end):

return sys.maxsize

if (start == end):

return 0

if (start == end - 1):

if (word[start] == word[end]):

return 0

else:

return 1

if (word[start] == word[end]):

return numOfSwitches(word, start + 1, end - 1)

else:

return (min(numOfSwitches(word, start, end - 1),

numOfSwitches(word, start + 1, end)) + 1)

word = input("Enter a Word: ")

start = 0

end = len(word)-1

print("Number of switches required for palindrome: " + str(numOfSwitches(word, start, end)))

3 0

2 years ago

What was the history of technology since the 1980s to now and how is it used in classrooms?.?. PLEASE HELP

levacccp [35]

Answer:

Please check the explanation.

Explanation:

The US education department mentioned that in 1900 there were only 10% of students enrolled in the schools, however by the end of 1992, the percentage increased by 85% and it became 95%. In 1930 1 million students were enrolled in university. And by 2012, it became 21.6 million. The teachers began to follow a new type of teaching, and the academics began to follow a special method for communique, education as well as for helping the students understand the concepts.

Though, after the 1980s the personal computer came into being in schools and colleges. Since then numerous versions of PC have originated in the marketplace as well as mobiles tracked by Smartphones, and now nearly 100% of people in the US have smartphones. Virtual reality, augmented reality, AI, Machine learning. etc. has cemented the way for the virtual classrooms. Also, each subject is now up with fruits and not just-food. The consequence is such a delightful setup of the Virtual schoolrooms in the entire US, and all over the ecosphere. The projectors, VR devices, AI applications for education, online classroom facility, Electronic version of chalkboards, and in fact everything is no sophisticated, and it is making not only teaching easy but learning as well. And the result is, students are ending up with better results, and teachers seem to be happier and more relaxed. And that is making school management satisfied as well.

3 0

3 years ago

Why is OS important in every data processing system? Please Answer Fast!

Artist 52 [7]

Answer:

Functions of an operating system. An operating system provides three essential capabilities: It offers a UI through a CLI or GUI; it launches and manages the application execution; and it identifies and exposes system hardware resources to those applications -- typically, through a standardized API.

Explanation:

6 0

2 years ago