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.
1 answer:
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
Answer:
The program in C++ is as follows:
#include <iostream>
using namespace std;
int main(){
int qty;
float discount = 0;
cout<<"Quantity: ";
cin>>qty;
int cost = qty * 100;
{
; }
cout<<"Cost: "<<cost - discount;
return 0;
}
Explanation:
This declares the quantity as integer
int qty;
This declares and initializes discount to 0
float discount = 0;
This prompts the user for quantity
cout<<"Quantity: ";
This gets input for quantity
cin>>qty;
This calculates the cost
int cost = qty * 100;
If cost is above 1000, a discount of 10% is calculated
{
; }
This prints the cost
cout<<"Cost: "<<cost - discount;