Excel Answers

How do you insert a pie chart to represent temperature value in cell B10 to M10

How do you merge cell A1 to D1

Write the function to calculate the average of cell B10 to M18

Choose one device that you own and use - a laptop, tablet or smartphone.

Calculate the total costs of ownership (TCO) for the selected device including:

Purchasing costs of hardware

Purchasing costs or software subscription fee

Operating costs (hours spent on managing IT, e.g. upgrades, fixes, troubleshooting, searching for new software, learning with new programs, providing IT support to others)

Downtime costs (lost hours due to inoperable or inaccessible computer, internet connection, viruses, etc.)

When convering amount of time to money, consider average hourly gross wage 200 CZK (around 7 EUR).

Calculate overall TCO and annual TCO.

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the

Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set

the references to cells B5 and B6 as absolute references.

Grandpa John gives his kids Christmas gifts, but only if they are younger than 18.Write IF function to check who’s eligible for Christmas gifts this year. Return “Yes” if he/she is eligible, and “No” if he/she is not.

Students NamesInt1 MarksInt2 MarksInt3 MarksFinal ICAStatusScore of 100Mpho Tau5010090Neo Kou1001030Dee Maps203525Dkay Reed1004585Thabo Koloi506530Thato Khahloe10010090

Use the “IF” function to assign students a Status based on the following; Proceed (if final ICA is 50 or more), Supplement (if final ICA is between 30 and 49) or Retake (if final ICA is 29 or less).

The BMI (Body Mass Index) is calculated using height (measured in meters) and weight (measured in

Kg) of a person. A person with BMI of 25.0 or more is considered overweight, while the

healthy/normal range is 18.5 to 24.9 and a person with BMI less than 18.5 is considered underweight.

draw flowchart of this statement

What are the 3 type of output for the project

Describe the function of the following statements as used in vba

1. Sheets ("sheets"). Range (A1")=me .T1.value

2. Exit button