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
pav-90 [236]
3 years ago
13

On the CallCenterReport worksheet, add formulas that will summarize the issues for the department entered in cell B3. In cell B6

, add an INDEX function that will use an INDIRECT function to retrieve the department issue list for the department listed in cell B3. Use an absolute reference to B3, and then use a relative cell reference to A6 as the row_num argument. Copy the formula down to cell B9.

Computers and Technology
1 answer:
grin007 [14]3 years ago
5 0

Answer:

In cell B6, formula =INDEX(INDIRECT($B$3),A6)

CallCenter Worksheet Details:

The image of the CallCenter Report worksheet for reference to the question asked is attached below.

Explanation:

Firtsly, an absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. To do this,we put a $ dollar sign ( =A$1,) before the row coordinate to lock only the row.

A relative reference in Excel is a cell address without the $ sign in the row and column coordinates example A1.

Having known what absolute and relative reference are, we wlil write the below formula in cell B6 that will later be copied to cell B9:

: =INDEX(INDIRECT($B$3),A6)

You might be interested in
Which statement does not describe the guidelines for the use of text in presentation programs?
olganol [36]
Choice a
have a great day

7 0
3 years ago
A slide show is another name for a PowerPoint presentation. <br> a. True<br> b. False
ruslelena [56]
It is true because a powepoint is a projecter

8 0
3 years ago
Read 2 more answers
What Intel socket recommends the use of a liquid cooling system?
Marizza181 [45]
The Intel socket that Intel recommends you use a liquid-cooling system on is the LGA2011.
5 0
3 years ago
(50 points) What animes should I watch?
Eddi Din [679]

Answer:

naruto,naruto shippuden and baruto

Explanation:

3 0
3 years ago
Read 2 more answers
Bobby is investigating how an authorized database user is gaining access to information outside his normal clearance level. Bobb
Sveta_85 [38]

Answer:

Aggregate Function .

Explanation:

The aggregate function returns the single value of the entire column of the database management system. The Aggregate Function is used in the SELECT statement and the GROUP BY clause.  

The sum(),avg(), etc are some examples of Aggregate Function in the database with the help of aggregate function bobby gains the access to information above the usual clearance point. and summarizes the data.

7 0
3 years ago
Other questions:
  • Check My Work _____ are made in response to situations that have occurred frequently enough to enable managers to develop decisi
    15·1 answer
  • Match each word to its correct meaning.
    7·1 answer
  • A ddr4 dimm with a pc rating of pc4-17000 is running at what speed?
    15·1 answer
  • A bluetooth device in ____ mode is part of the piconet but is in a low-power state.
    8·1 answer
  • Drag the correct type of update to its definition.
    13·1 answer
  • What have been three technological changes to photography in the past 200 years?
    10·1 answer
  • Defensive programming is sometimes referred to as _________.
    5·1 answer
  • Samuel was hired to create a program that asks the user questions and, based on the answers, recommend a book to read. What kind
    8·1 answer
  • Which type of evidence should victims collect to help officials catch cyber bullies?home addressesbirthdayssocial media username
    15·1 answer
  • The equals method of the Object class returns true only if the two objects being compared:_________
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!