Create a footer with the sheet name code in the center

Assignment Help Basic Computer Science
Reference no: EM13847947

I need help with excel here is the problems I got wrong I-5 Insert a nested lookup function in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 5.000 A nested lookup function was not inserted in cell E2 that will look up the rental price in column D using the apartment number referenced in cell B2. 0.000/5.000 I-7 Perform an advanced filter based on the criteria range. Filter the existing database in place. 10.000 An advanced filter based on the criteria range was not performed. 0.000/10.000 I-8 In cell C7, enter a DCOUNTA function to calculate the number of apartments to remodel. 3.000 A database function was not entered to calculate the number of apartments to remodel in cell C7. 0.000/3.000 I-9 In cell C8, enter a database function to calculate the total lost rent for the month. 2.000 A database function was not entered to calculate the value of lost rent in cell C8. 0.000/2.000 I-10 Enter a database function to calculate the year of the oldest remodel in cell C9. 2.000

A database function was not entered to calculate the year of the oldest remodel in cell C9. 0.000/2.000 I-13 Insert a formula in cell E3 to calculate the total number of periods. 2.000 In the cell [E3] on Sheet (Loan), the 'Formula' was not set to 'B4*B5'. 0.000/2.000 I-16 In cell E6, insert a function to calculate the total interest paid on the loan. Ensure that the function returns a positive value. 2.000 A function in cell E6 was not inserted to calculate the total interest paid on the loan. 0.000/2.000 I-17 Complete the loan amortization table for the first five payments only.

In cell A11, enter 1. In cell B11, create a relative reference to cell B7 and in cell C11, create a relative reference to cell E2. Use the DATE function to complete the Payment Date column and financial functions for the Interest Paid and Principal Payment columns. In cell F11, enter =C11-E11. In cell C12, create a relative reference to cell F11. Note: Be sure to only complete the table through row 15. 18.000 Row [11] that starts with "1" was not detected in the submission. Engine reported the failure as ‘The loan amortization table was not completed for the first five payments only.' 0.000/5.400 Row [15] that starts with "5" was not detected in the submission. Engine reported the failure as ‘The loan amortization table was not completed for the first five payments only.' 0.000/1.800 Row [11] that starts with "1" was not detected in the submission.

Engine reported the failure as ‘Financial functions were not used for the Interest Paid columns.' 0.000/3.600 Row [11] that starts with "1" was not detected in the submission. Engine reported the failure as ‘Financial functions were not used for the Principal Payment columns.' 0.000/3.600 Row [12] that starts with "2" was not detected in the submission. Engine reported the failure as ‘A date function was not used for the Payment Date column.' 0.000/3.600 I-18 Create a footer with the sheet name code in the center, and the file name code on the right side of each worksheet. 6.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Summary worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission.

Engine reported the failure as ‘A footer with the file name code on the right side of Summary worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Database worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the file name code on the right side of Database worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the sheet name code in the center, on the right side of Loan worksheet was not created.' 0.000/1.000 Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as ‘A footer with the file name code on the right side of Loan worksheet was not created.'

Reference no: EM13847947

Questions Cloud

Implement a modified version of the card game war : Implement a modified version of the card game WAR
Calculate your grades based on the number of points you get : Create a program that calculates your grades based on the number of points you accumulate over the entire semester
Project risk requirement : The management of risk is proving to be one of the most difficult tasks for the project management profession. How can risk be managed effectively and who should be responsible for this task?
How do law and ethics intertwine : How do law and ethics intertwine? Describe and distinguish among valid, void, voidable, and unenforceable contracts
Create a footer with the sheet name code in the center : Create a footer with the sheet name code in the center
What marketing strategy does mattel use globally : Give two examples from the case that the global market is important to Mattel's growth and describe briefly. What marketing strategy does Mattel use globally? Describe by giving an example from the case.
Analyze the facts and apply it to the law : Discuss whether the action taken is illegal under Title VII. Analyze the facts and apply it to the law. What recommendations would you make to the employer to avoid this type of discrimination claim in the future
Which country is expected to have a commanding lead : Which country is expected to have a commanding lead in the size of its economy by 2020? The United States India China Japan.
What is an object? : What is an object?

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Write a program to estimate the minimum of the function

Write a program to estimate the minimum of the function using the steepest descent method. Use the starting point [10 , 1]

  Calculate the total wages for an employee

Design and create a program to calculate the total wages for an employee. An employee is paid $10 per hour for the first 40 hours. The employee is paid $15 per hour for every hour greater than 40 hours and up to 50 hours.

  Determining most effective it projects

Not sure what will suit their requirements in achieving better organization between branches by updating their information systems. What will you suggest they do to find out most effective IT projects?

  What are some ways increase our chances of success

IT Projects are notoriously difficult to complete successfully and they are expensive to start with. Most failures can be attributed to issues not directly tied to technology issues, but rather issues of organizational behavior.What are some ways in ..

  Programming tasks use any high-level programming

Programming Tasks Use any high-level programming language you wish for the following programming exercises. Do not call built-in library functions that accomplish these tasks automatically. (Examples are sprintf and sscanf from the Standard C librar..

  Problem regarding the computer forensics investigation

Describe, in detail, at least 5 different cases or situations that could lead to the need for a computer forensics investigation. For each case or situation, do the following:

  Examine how application pools will help to reduce costs

Analyze how using Terminal Services will help meet many of the criteria for providing applications for the remote offices. Propose how to deploy, configure, and secure terminal service features in order to meet the requirements specified in the scen..

  Write a program called generateprimes

Write a program called generatePrimes.py that prompts the user for a number n and outputs all the primes less than or equal to n. You must use the algorithm described above.

  Write a program that reads a number x from the user

Please use MIPS and MARS ida Write a program that reads a number x from the user, and prints the first x letters of the alphabet (in lower case). You do not need to check whether the number is positive.

  Describing online services provided by selected companies

Identify and briefly describe the online services provided by the selected companies (e.g. online catalogue search, online information search.

  Write guide for the organization

Write a 2-3 page report recommending style manual and/or technical/legal writing guide for the organization to use and describe the reasons for your recommendations.

  Explain which learning experiences facilitated

For this Discussion, reflect on all the material covered in this module. Share with your colleagues your thoughts on what you feel you learned and achieved over these eight weeks.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd