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

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

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