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
Alex787 [66]
4 years ago
9

What is the first step to creating a PivotTable?

Computers and Technology
2 answers:
Mrrafil [7]4 years ago
5 0

Answer:    Click anywhere in the dataset.

   Go to Insert –> Tables –> Pivot Table.

   In the Create Pivot Table dialog box, the default options work fine in most of the cases. Here are a couple of things to check in it: ...

   Click OK.

Explanation:

lara31 [8.8K]4 years ago
4 0

Answer:

Click anywhere in the dataset

Go to Insert –> Tables –> Pivot Table.

In the Create Pivot Table dialog box, the default options work fine in most of the cases.

click ok

Explanation:

You might be interested in
1. I am a rectangle in a flowchart. What do I represent?
Strike441 [17]

Answer:

Down;

1.Parallelogram

3. Start

Across;

1. process

2.diamond

4. Flowchart

5. Arrow

Explanation:

3 0
3 years ago
A low concentration of market power has positive affects. A low concentration of market share has which of the following effects
lisov135 [29]
A or b i think hope it helps good luck and i hope it helps
6 0
4 years ago
Array, destination contains the number of 10 cities numbered 1 to 10 that the products were shipped to. Hence, 10 quantities of
Naddik [55]

Answer:

#include <stdlib.h>

#include <stdio.h>

void func1(int product[]){

int orders[6]={0};

for(int i=0;i<70;i++){

orders[product[i]]++;

}

printf("Total number of each type of products that were bought\n");

for(int i=1;i<=5;i++){

printf("Product %d = %d\n",i,orders[i]);

}

}

void func2(int product[],int quantity[],float price[]){

float total_cost=0;

for(int i=0;i<70;i++){

total_cost+= price[product[i]]* quantity[i];

}

printf("The total cost of all 70 orders = %.2f\n",total_cost);

}

void func3(int product[],int quantity[],int destination[],float price[]){

float total_cost=0;

for(int i=0;i<70;i++){

if(destination[i]==8){

total_cost+= price[product[i]]* quantity[i];

}

}

printf("The total cost of all products shipped to destination 8 = %.2f\n",total_cost);

}

void func4(int product[],int quantity[],float price[]){

int total_orders=0;

for(int i=0;i<70;i++){

if(price[product[i]]* quantity[i]>=50){

total_orders++;

}

}

printf("The total number of orders where each order is $50 or more = %d\n",total_orders);

}

void func5(int product[],int quantity[],int origination[],float price[]){

int total_orders=0;

for(int i=0;i<70;i++){

if(origination[i]==3 && price[product[i]]* quantity[i]>=50){

total_orders++;

}

}

printf("The total number of orders that originated from 3 where each order is $50 or more. = %d\n",total_orders);

}

void func6(int product[],int quantity[],int origination[],float price[]){

float total_cost=0;

for(int i=0;i<70;i++){

if(origination[i]==3 && price[product[i]] * quantity[i]>=50){

total_cost += price[product[i]] * quantity[i];

}

}

printf("The total number of orders that originated from 3 where each order is $50 or more. = %.2f\n",total_cost);

}

void func7(int origination[],int destination[]){

int total_orders=0;

for(int i=0;i<70;i++){

if(origination[i]==3 && destination[i]==8){

total_orders++;

}

}

printf("The total number of orders that originated from 3 and shipped to 8. = %d\n",total_orders);

}

void func8(int product[],int quantity[],int origination[],int destination[],float price[]){

float total_cost=0;

for(int i=0;i<70;i++){

if(origination[i]==3 && destination[i]==8){

total_cost += price[product[i]] * quantity[i];

}

}

printf("The total cost of orders that originated from 3 and shipped to 8. = %.2f\n",total_cost);

}

void func9(int destination[]){

int total_orders=0;

for(int i=0;i<70;i++){

if(destination[i]!=8){

total_orders++;

}

}

printf("The total number of orders that was shipped to all destinations except to 8. = %d\n",total_orders);

}

void func10(int product[],int quantity[],int destination[],float price[]){

float total_cost=0;

for(int i=0;i<70;i++){

if(destination[i]!=8){

total_cost += price[product[i]] * quantity[i];;

}

}

printf("The total cost of orders that was shipped to all destinations except to 8. = %.2f\n",total_cost);

}

int main(){

int product[70] = {4, 2, 4, 2, 4, 5, 5, 2, 2, 5, 5, 4, 3, 5, 4, 2, 5, 3, 1, 2, 2, 3, 3, 4, 5, 5, 4, 5, 3, 5, 5, 1, 4, 5, 1, 5, 3, 2, 4, 1, 2, 4, 5, 1, 5, 5, 5, 5, 5, 2, 5, 1, 4, 4, 4, 2, 3, 3, 3, 3, 4, 3, 5, 5, 3, 2, 3, 5, 3, 2};

int quantity[70] = {10, 9, 6, 4, 10, 4, 9, 6, 10, 7, 3, 4, 4, 9, 1, 8, 9, 1, 5, 8, 7, 2, 3, 4, 10, 5, 6, 2, 1, 7, 2, 8, 6, 9, 8, 8, 7, 7, 9, 10, 6, 7, 8, 2, 1, 7, 6, 3, 3, 1, 8, 4, 10, 7, 1, 10, 6, 9, 8, 2, 4, 6, 1, 8, 2, 6, 10, 2, 6, 2};

int origination[70] = {2, 7, 5, 5, 7, 2, 7, 2, 7, 7, 5, 2, 5, 5, 5, 2, 2, 7, 2, 7, 7, 2, 2, 2, 2, 5, 7, 5, 7, 7, 5, 5, 2, 2, 5, 7, 2, 5, 7, 2, 5, 7, 2, 5, 7, 2, 2, 7, 2, 7, 5, 2, 2, 2, 5, 7, 2, 5, 5, 5, 7, 7, 2, 5, 2, 7, 5, 2, 5, 7};

int destination[70] = {8, 7, 3, 10, 2, 6, 4, 5, 1, 3, 5, 9, 5, 8, 6, 4, 3, 7, 1, 2, 7, 2, 8, 2, 2, 1, 2, 6, 10, 2, 7, 7, 8, 6, 8, 8, 4, 8, 3, 10, 6, 9, 4, 9, 5, 1, 7, 3, 1, 7, 5, 5, 4, 9, 3, 10, 8, 1, 1, 1, 1, 8, 10, 3, 5, 2, 8, 7, 4, 10};

float price[6]={0,11.95,7.95,19.95,24.95,15.25};

func1(product);

func2(product,quantity,price);

func3(product,quantity,destination,price);

func4(product,quantity,price);

func5(product,quantity,origination,price);

func6(product,quantity,origination,price);

func7(origination,destination);

func8(product,quantity,origination,destination,price);

func9(destination);

func10(product,quantity,destination,price);

}

Explanation:

The program inputs order, products and cities products are shipped.

After a series of conditional requirements being met, will output the destination each product os going to and the number of products with its associated price.

3 0
4 years ago
Read 2 more answers
Java’s class Color has a constructor that takes three integers as parameters: the red, green, and blue components of the color
Tanzania [10]

Answer:

    public Balloon(){

          //Invokes the 2 argument constructor for balloon with relevant  

          //parameters

          this(10,new Color(135,206,250));

    }

Explanation:

class Balloon{

    //Private fields in the Balloon class

    private double radius = 0;

    private Color c = null;

    // Constructor with two arguments - radius and Color

    public Balloon(double radius,Color c){

         this.radius = radius;

         this.c = c;

    }

    // No argument constructor

    public Balloon(){

          //Invokes the 2 argument constructor for balloon with relevant  

          //parameters

          this(10,new Color(135,206,250));

    }

}

3 0
4 years ago
A disadvantage of creating a website with tables, without CSS is
ikadub [295]
I am just gonna yolo it... <span>each table has to be updated individually </span>
6 0
3 years ago
Read 2 more answers
Other questions:
  • For the MIPS assembly instructions below, what is the corresponding C statement? Assume that the variables f, g, h, i, and j are
    15·2 answers
  • What is the purpose of the overload keyword in the ip nat inside source list 1 pool nat_pool overload command?
    8·1 answer
  • Good afternoon guys !!!
    14·2 answers
  • You need to transmit PII via email and you want to maintain its confidentiality. Which of the following choices is the BEST solu
    8·1 answer
  • How have productivity programs improved the professional lives of people? (check all that apply)
    8·2 answers
  • Write the algorithm for finding the perimeter of a rectangle using English like form step by step
    10·1 answer
  • This the code from the last post I did
    8·1 answer
  • Write a program that gets a list of integers from a user. First, the user should be asked to enter the number of integers to be
    5·1 answer
  • When a browser is open on your computer, what browser tool is used to move the webpage to the previously viewed page on the brow
    8·1 answer
  • Differentiate between off the shelf software and bespoke software
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!