Excel Answers

Can you do me a competitors analysis fir a company in saudi arabia?

Comparing Televisions: You are shopping for a new television and want to compare the prices of three televisions. Research new televisions. Create a worksheet that compares the type, size, and the price for each television, as well as the costs to add an extended warranty. Use the concepts and techniques presented in this module to calculate the average price of a television and average cost of an extended warranty and to format the worksheet.

I would just like step to step answers to these questions.

6 Use a nested MATCH function within the INDEX function in cell C40 to identify the date for the lowest temperature. Ungroup the worksheets.
8.000

11 Enter a nested IF function in cell C6 to determine which city had the highest temperature. Based on the result returned in B6, enter the city name as OKC or Tulsa or Lawton in C6. Remember to enclose city names in double quotation marks in the function. Use Help if needed to help you understand a nested IF statement. Copy the formula down the High-City column. 6.000
12 Enter a nested IF function in cell E6 to determine which city had the lowest temperature. Based on the result returned in D6, enter the city name as OKC or Tulsa or Lawton in E6. Copy the function down the Low-City column.

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.

The function returns a positive value and set the references to cells B5 and B6 as absolute references?

How do I find the monthly payment for this question:

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.

Interest rate is 4.5%
Number of payments is 12
cost of altamonte facilities is $16,450.95

Hi, I'm in a business program and I take Excel classes i'm almost done and I need help with my CIS 114 Excel project. I did all the research for data i need but i need help with putting the data on excel putting it in a chart format as a table putting it in a pivot table