All categories

3 years ago

When a user inserts a PivotTable, where will it be inserted?

Computers and Technology

1 answer:

Alexeev081 [22]3 years ago

3 0

Answer:

depends on whether the Pivot Table is inserted into the current worksheet or a new worksheet and the current location of the cursor.

Explanation:

Pivot tables are short tables with few columns and rows out of the original set of rows and columns. And they are being governed by the report filter, and column labels can also be added, as well as rules can be applied to value, but for formulas, we need to create the formula field. However, it can be placed in the current worksheet or a new worksheet and the current location of the cursor.

You might be interested in

Write an SQL statement to display for every restaurant the name of the restaurant (where the name of the restaurant consists of

Rainbow [258]

Using the knowledge in computational language in SQL it is possible to write the code that display for every restaurant the name of the restaurant and for every category of menu item its description.

<h3>Writting the code:</h3>

INSERT INTO Dish Values(13, 'Spring Rolls', 'ap');

INSERT INTO Dish Values(15, 'Pad Thai', 'en');

INSERT INTO Dish Values(16, 'Pot Stickers', 'ap');

INSERT INTO Dish Values(22, 'Masaman Curry', 'en');

INSERT INTO Dish Values(10, 'Custard', 'ds');

INSERT INTO Dish Values(12, 'Garlic Bread', 'ap');

INSERT INTO Dish Values(44, 'Salad', 'ap');

INSERT INTO Dish Values(07, 'Cheese Pizza', 'en');

INSERT INTO Dish Values(19, 'Pepperoni Pizza', 'en');

INSERT INTO Dish Values(77, 'Veggie Supreme Pizza', 'en');

INSERT INTO MenuItem Values(0, 0, 13, 8.00);

INSERT INTO MenuItem Values(1, 0, 16, 9.00);

INSERT INTO MenuItem Values(2, 0, 44, 10.00);

INSERT INTO MenuItem Values(3, 0, 15, 19.00);

INSERT INTO MenuItem Values(4, 0, 22, 19.00);

INSERT INTO MenuItem Values(5, 3, 44, 6.25);

INSERT INTO MenuItem Values(6, 3, 12, 5.50);

INSERT INTO MenuItem Values(7, 3, 07, 12.50);

INSERT INTO MenuItem Values(8, 3, 19, 13.50);

INSERT INTO MenuItem Values(9, 5, 13, 6.00);

INSERT INTO MenuItem Values(10, 5, 15, 15.00);

INSERT INTO MenuItem Values(11, 5, 22, 14.00);

See more about SQL atbrainly.com/question/13068613

#SPJ1

4 0

1 year ago

________ to a base class may be assigned the address of a derived class object.

evablogger [386]

Fed jig. defect bhds. if. bugs. bffs. hex.

6 0

3 years ago

Read 2 more answers

Ashley Baker has been the webmaster for Berryhill Finance only ten days when she received an e-mail that threatened to shut down

Natasha_Volkova [10]

Answer:

cyber-extortion

Explanation:

Ashley Baker has been the webmaster for Berryhill Finance only ten days when she received an e-mail that threatened to shut down Berryhill's website unless Ashley wired payment to an overseas account. Ashley was concerned that Berryhill Finance would suffer huge losses if its website went down, so she wired money to the appropriate account. The author of the e-mail successfully committed cyber-extortion.

7 0

3 years ago

Which slide elements must Claire use to enhance her presentation?

Alja [10]

She needs to use animations to enhance her presentation

8 0

3 years ago

Type the correct answer in the box. Spell all words correctly. Joseph is a digital media developer and has years of work experie

Damm [24]

It is better to develop soft skills. Irrespective of profession, soft skill is a common skill which is required to be present in everyone to move along with others and continue the work successfully. A person who is good at technical need soft skill to work in collaboration with others, manage team, solve problems, etc.

So there are separate soft skill training provided for various roles and years of experience. So, I suggest to have soft skill training and do additionally MBA degree.

5 0

4 years ago