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
asambeis [7]
3 years ago
11

Edra wants to consolidate the data from each of the regions. Switch to the Consolidated Sales worksheet, then update the workshe

et as follows:
a. In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet.
b. Copy the formula from cell A6 to the range A7:A9 without copying the formatting.
c. In cell B6, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B6 in the Idaho:Washington worksheets.
d. Copy the formula from cell B6 to the range B7:39 without copying the formatting.
e. Then copy the formulas and the formatting from the range B6:39 to the range C6:E9.
Computers and Technology
1 answer:
VashaNatasha [74]3 years ago
7 0

Answer:

a. In cell A6, enter a formula without using a function that references cell A6 in the Washington worksheet.

b. Copy the formula from cell A6 to the range A7:A9 without copying the formatting.

Explanation:

Microsoft Excel is a spreadsheet application used for data analysis and statistical calculation. The worksheet is made of columns and rows like a table and labeled alphabetically and numerically respectively. Several worksheets can be referenced in an excel workbook

To consolidate data in excel, reference a cell from another worksheet in the formula of the current worksheet and copy the formula from the cell to a given range of cells, without copying the formatting of the cell.

You might be interested in
What type of power flaw involves a fluctuation in voltage levels caused by other devices on the network or by EMI?
HACTEHA [7]

Answer:

noise is the correct answer for the above question.

Explanation:

  • The noise is a term which is a barrier in the network of communication. It forces the signals to make a delay in data transfer. It is caused by any device or mechanism.
  • For example, if any data is transferring, but some device makes fluctuation in wire, then the communication voltage is disturbed.
  • The above question asked about the term which born with the help of some devices and it caused the fluctuation in the voltage. So the term is known as noise.
4 0
4 years ago
TLS is not generally compatible with SSL because:__________. 1. SSL is proprietary while TLS is open 2. SSL can interact with it
kodGreya [7K]

Answer:

2. SSL can interact with its earlier versions which is a vulnerability

Explanation:

TLS (Transport Layer Security) and SSL (Secure Sockets Layer) are both used for providing data authentication and encryption between networking devices  (such as servers, PCs and applications) operating over a network. The iterations of SSL were versions 1.0, 2.0 and 3.0. But then, all these iterations had security issues and so TLS 1.0 was released to improve on those security flaws. And seeing that SSL can interact with its earlier versions which are all vulnerable, downgrading TLS to SSL for compatibility sake will abuse the essence of TLS in the first place.

6 0
3 years ago
ASAP PLEASE
notka56 [123]
1st blank:task
2nd blank:transparency
6 0
3 years ago
Read 2 more answers
The picture that graphically represents the items you use in windows is called a/an
oee [108]
<span>The picture that graphically represents the items you use in windows is called a/an icon.</span>
7 0
4 years ago
What is best android apps​
natima [27]

Answer:

brainly

Explanation:

cuz yeah its the best app ever tbh

8 0
3 years ago
Read 2 more answers
Other questions:
  • Which of the case studies that you read (Walmart, Target or 5 Big Data Industries) caught your attention and why? Before reading
    11·1 answer
  • Which career professional and creates large data base and makes the data base with other systems
    13·1 answer
  • Identifying your learning preferences Helps You To
    12·1 answer
  • Write a program that asks the user for the name of a text file. the program should display the last 10 lines of the file on the
    13·1 answer
  • (EASY 15 POINTS) What are two indications in a browser that a secure connection is being used?
    6·1 answer
  • Some languages are traditional programming languages for developing applications; others, such as markup and scripting languages
    12·1 answer
  • There are n coins, each showing either heads or tails. We would like all the coins to show the same face. What is the minimum nu
    6·1 answer
  • In Online Data Extraction data is extracteddirectly from the ------ system itself.o Hosto Destinationo Sourceo Terminal
    15·1 answer
  • How to share pictures on brainy ​
    8·1 answer
  • Please help with my Python code - Functions
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!