Answer the following

In cell B3, insert a nested MATCH function within an INDEX function that will look up the rental price in column D using the apa

____ [38]

Solution :

Step 1:

Open the excel exploring_e07_grader_h1_Apartment.xlsx and save it as exploring_e07_grader_h1_Apartment_LastFirst.

Step 2:

At cell G8 in the Summary worksheet, insert the date function to the number of Years since remodel:

Compute the difference between the years 1/1/2018 value in the cell H2 and the Last remodel date present in cell F8 which returns the number of days.

Then, divide the resultant by 365 days to get the answer in the form of years.

The formula to compute the number of years since remodel at cell G8 is,

=($H$2 - F8)/365.25

Copy the function used in the cell G8 to the cells G9:G57.

Step 3:

At cell H8 in the Summary worksheet, insert the function to compute the pet deposit.

Condition to check is whether the number of rooms that is at Cell C8 is greater than or equal to 2 and it is remodel less than 10 years ago.

If the condition is true, then pet deposit cost is $275 present at cell H4.

Otherwise the pet deposit cost is $200 present at cell H5.

So, the formula to apply at cell H8 is,

=IF(AND(C8>=2, G8<$H$3), $H$4, $H$5)

Step 4:

At cell I8 in the Summary worksheet, insert the function to display Need to Remodel:

Condition to check is whether the apartment is unoccupied depending on the cell E8(“Yes” or “No”) and last remodeled that is cell G8 is greater than 10 years (cell H3).

If the condition is true, then display as “No Change”.

Otherwise display as “Need to Remodel”.

So, the formula to apply at Cell I8 is,

=IF(_AND(_E8="No", G8>$H$3), "Need to Remodel", "No Change")

Step 5:

Copy the functions used in the cells H8:I8 to the cell range H9:I57.

Step 6:

At cell B3, to display the rental price:

By using Index function look up for the rental price present in Column D and check for the match of cell B2 with respective the Column Range A8:A57.

Syntax for INDEX function is:

=INDEX(Array, Row number, Column number)

Syntax for MATCH function is:

=MATCH(Loop up, Loop up array, Match type)

So, the function to be inserted at cell B3 is,

=INDEX($D$8:$D$57, MATCH(B2, $A$8:$A$57,0))

3 0

3 years ago

Define a class named ComparableSquare that extends Square (defined above) and implements Comparable. Implement the compareTo met

Alexxx [7]

Answer:

/*********************************************************************************

* (The ComparableCircle class) Define a class named ComparableCircle that *

* extends Circle and implements Comparable. Draw the UML diagram and implement *

* the compareTo method to compare the circles on the basis of area. Write a test *

* class to find the larger of two instances of ComparableCircle objects. *

*********************************************************************************/

public class Exercise_13_06 {

/** Main method */

public static void main(String[] args) {

// Create two instances of ComparableCircle objects

ComparableCircle comparableCircle1 = new ComparableCircle(12.5);

ComparableCircle comparableCircle2 = new ComparableCircle(18.3);

// Display comparableCircles

System.out.println("\nComparableCircle1:");

System.out.println(comparableCircle1);

System.out.println("\nComparableCircle2:");

System.out.println(comparableCircle2);

// Find and display the larger of the two ComparableCircle objects

System.out.println((comparableCircle1.compareTo(comparableCircle2) == 1

? "\nComparableCircle1 " : "\nComparableCircle2 ") +

"is the larger of the two Circles");

}

3 0

3 years ago

Hat is the purpose of the domain name?

Andreyy89

B because it is true it is a government website because the “ gov “ stands for government.

~ Destiny

3 0

3 years ago

Read 2 more answers

Which statement below is true about how the functions of the digestive and circulatory system are connected.

telo118 [61]

Answer:

The digestive system breaks down the food into molecules that can be used by the cells. The circulatory system moves the molecules from the villi to all cells in the body.

8 0

3 years ago

What permissions should you assign a group if you want the group to have the ability to read, add, delete, execute, and modify f

ratelena [41]

Answer:

Modify is the correct answer to the following question.

Explanation:

If any person or user wants to read, delete, modify and execute the files then they have required the Modify permission. In other words, Modify permission provides the user to modify and delete the following files but they unable to delete subfolders because of the following permission.

If they want then they have to change the permission by click right button from the mouse on the file or the folders which they want to change and then click on the properties from there they can change the permission.

7 0

4 years ago