Answer:
if(revenue.cents - expenses.cents < 0){
profit.dollars = revenue.dollars - expenses.dollars - 1;
profit.cents = 1 - revenue.cents - expenses.cents;
}
else{
profit.dollars = revenue.dollars - expenses.dollars;
profit.cents = revenue.cents - expenses.cents;
}
Explanation:
We know that profit is given as: revenue - expenses from the question.
From the given expression above;
if(revenue.cents - expenses.cents < 0)
then profit.dollar will be revenue.dollars - expenses.dollars - 1; the 1 is to be carry over to the cent part. And the profit.cent will be 1 - revenue.cents - expenses.cents;
else the profit.dollars and the profit.cent is computed directly without needing to carry over:
profit.dollars = revenue.dollars - expenses.dollars;
profit.cents = revenue.cents - expenses.cents;
Well it all depends how you plan on making it as you would need to know Web Development or you could just copy paste code from YT
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)
Answer:
place your cursor or highlight the text where you wish to insert a bulleted list. Under the [Home] tab in the “Paragraph” section, click the [Bullets] drop-down menu. Choose a bullet style or select "Bullets and Numbering” to create a customized bullet style.
