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
tensa zangetsu [6.8K]
3 years ago
5

What are the steps for consolidating data from multiple worksheets? 1. Select the range of data on the first worksheet you wish

to consolidate. 2. Go to the Data tab on the ribbon and select Data Tools. 3. Then, select and the dialog box will appear. 4. Choose the in the drop-down. Then, select the first group of data and press Enter. 5. To add from more worksheets, select from the View tab. 6. To include more references, click .
Computers and Technology
2 answers:
likoan [24]3 years ago
7 0

Answer:

2. Go to the Data tab on the ribbon and select Data Tools.

3. Then, select and the dialog box will appear.

4. Choose the in the drop-down. Then, select the first group of data and press Enter.

1. Select the range of data on the first worksheet you wish to consolidate.

5. To add from more worksheets, select from the View tab.

Explanation:

Consolidation in Microsoft Excel is used to gather information from several worksheets. To consolidate data in a new worksheet, select the new worksheet and click on the upper left side where the data should be.

Click on Data > Consolidate, then a dialog box would appear. From the dialog box click on the function to consolidate with, then click on the reference area and select the first data range by clicking on the first worksheet and drag the data range to the box and click Add.

To add more data range, click on the reference area and do the same as the first data.

Gelneren [198K]3 years ago
6 0

Answer:

consolidate, function, switch windows, add

Explanation:

I just took the test on

You might be interested in
After you log in to PowerPoint Online, what is the first thing you need to do to start creating a presentation?
ivann1987 [24]

Answer:

click create new presentation -_- i use power poin all the time

Explanation:

im not dum

4 0
3 years ago
Read 2 more answers
Survey data are collected by using all of these methods EXCEPT
castortr0y [4]

Answer:

Survey data are collected by using all of these methods except Field Research.

Explanation:

In field research data has been gathered from different experiments, qualitative analysis and observations of any event.

On the other hand, survey data can be collected from Following:

<u>structured interview</u><u>:</u>

where data can be gathered by interviews and analyzed it on quantitative basis.

<u>Face to face questionnaires:</u>

Data has been collected by asking questions directly from users in the form of interview.

<u>self-administered questionnaires</u>

In this research, questionnaire has been designed to asked question related to some topic without conducting interview.

8 0
3 years ago
A document format is
anyanavicka [17]

Answer:

A document file format is a text or binary file format for storing documents on a storage media, especially for use by computers. There currently exist a multitude of incompatible document file formats.

Explanation:

8 0
3 years ago
Read 2 more answers
A thick black line around the outside edge of a page is a _____.
Montano1993 [528]
B. Border. It borders the outer page.
7 0
3 years ago
Read 2 more answers
All changes
Vsevolod [243]

You should get up and move every 30 minutes

Hope  this helps

-scav

7 0
3 years ago
Other questions:
  • You've formatted the first paragraph of a document. What button can you use to apply the formatting from the first paragraph to
    9·2 answers
  • The array s of ints contain integers each of which is between 1 and 1000 (inclusive). write code that stores in the variable ord
    9·1 answer
  • a corporation needs an operating system that allows the various teams in its office to network &amp; collaborate on projects. wh
    11·2 answers
  • The three tasks within data harmonization, namely: data consolidation, data cleansing, and data formatting use techniques called
    8·1 answer
  • Higher-speed Ethernet technologies use an electronic device known as a Hub rather than a switch True/False
    15·1 answer
  • Java supports ________; collections of related methods that typically enable you to tell objects what to do, but not how to do i
    12·1 answer
  • A ____ is a statement specifying the condition(s) that must be true before the function is called.
    6·1 answer
  • How do you create a formula in excel​
    10·1 answer
  • Identify two real-world examples of problems whose solutions do scale well
    13·1 answer
  • In this paper https://arxiv.org/pdf/2008.10150.pdf, I'm having a hard time understanding how the assignment in the picture is de
    10·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!