Homework 7a_IF_IF AND_IF OR and Conditionin formatting

Question 1 of 12

5.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 2 of 12

5.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 3 of 12

5.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 4 of 12

5.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 5 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 6 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 7 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 8 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 9 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 10 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 11 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Question 12 of 12

10.0 Points

Accepted characters: numbers, decimal point markers (period or comma), sign indicators (-), spaces (e.g., as thousands separator, 5 000), "E" or "e" (used in scientific notation). NOTE: For scientific notation, a period MUST be used as the decimal point marker.

Complex numbers should be in the form (a + bi) where "a" and "b" need to have explicitly stated values.

For example: {1+1i} is valid whereas {1+i} is not. {0+9i} is valid whereas {9i} is not.

Homework 7 One you are done with this HW, you need to do 2 things: 1. Go to Sakai "Test&Quizzes" Section and fill in your anwser. Your answer will be automatically graded by Sakai. 2. Go to Sakail "Assignments" Section and upload your Excel file, which contain your work. The Assignment name is Homework 7a_IF_IF AND_IF OR and Condt Formatting Deadline is posted on Sakai Calendar In "Net Income Data" sheet, we have Net income numbers for 25 company (company ID 1 to 25) over the 14 quarters Question 1 Identify the largest net income number For that cell, calculate: "Company ID"*100 + quarter What is the value you get? (Use Conditional Formatting for this questio For example, if the largest net income belongs to "company ID": 3 and in quarter 5 the number for your answer should be: 3*100 + 5 =305 Question 2 Identify the 3 smallest net income numbers. What is the sum these 3 numbers? (Use Conditional Formatting for this questio Question 3 How many cells have net income more than 5000? Question 4 How many cells have net income less than or equal to 4600? Question 5 If net income in a given cell (firm/quarter) is less than 2000 OR more than 6000, give grade 1 for that cell if not, give grade 3 Find the total of the grade for all cells. Question 6 If net income in a given cell (firm/quarter) is more than 3000 AND less than 5000, give grade 1 for that cell. If not, give grade 5 Find the total of the grade for all cell. Question 7 Analyze the 1st quarter only. Create a new column call "level1". In this colum: If net income of a company is less than 3000, then give value 2 If net income of a company is more than or equal to 3000, then give value 3 What is the total of the "level1" column? Question 8 Analyze the 1st quarter only. Find the average net income for that quarter. Create a new column call "level2". In this colum: If net income of a company is less than the above average, then give value 2 If net income of a company is more than or equal to the above average, then give value 3 What is the total of the "level2" column? Question 9 If net income in a given cell (firm/quarter) is more than 2000 and less than 4000, give grade 1 for that cell. If not, give grade 5 Sum the grade up and report the sum. Question 10 If net income in a given cell (firm/quarter) is less than 2500 OR more than 4500, give grade 1 for that cell if not, give grade 3 Sum the grade up and report the sum. Question 11 For each company, calculate the quarterly average for Net Income. (so each company has 01 number of average, right) For a give company/quarter (cell), if net income is greater than the above average, give value 3 if not, give value 1. So you now you have a big table with value 1 or 3. Now sum these number up and what is the value of that sum Question 12 For each quarter calculate the average for Net Income across these companies (so each quarter has 01 number of average, right) For a give company/quarter (cell), if net income is greater than the above average, give value 3 if not, give value 1. So you now you have a big table with value 1 or 3. Now sum these number up and what is the value of that sum matting for this question. Watch the video on this topic posted in this week announcement) matting for this question. Watch the video on this topic posted in this week announcement) rade 1 for that cell grade 1 for that cell. grade 1 for that cell. rade 1 for that cell at is the value of that sum? at is the value of that sum? Company ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 1 5330 7972 8545 4578 7302 1897 9673 5087 5231 932 9339 2578 7733 5129 3302 8186 1289 8992 114 2900 2484 8956 5620 2006 6763 2 6352 5941 6667 466 2727 1004 3027 3357 2129 8292 1636 668 62 7523 2895 1823 7197 1298 7637 1997 7699 8731 2361 333 8713 3 6340 2861 2121 4142 3103 2010 8230 4366 8041 6741 4046 2880 6281 531 3723 9237 9180 1372 9595 7434 8177 4600 9121 2785 7986 4 3399 3290 2339 8350 7626 5347 5254 8394 3736 4472 8853 1070 6440 8214 4878 6659 6347 2314 5612 3348 7154 190 4453 3094 5532 5 6566 1019 4770 7439 1587 7317 2387 1112 84 8125 6472 5176 4685 7844 8164 5545 1669 9826 9926 909 8270 3601 5495 3338 3823 6 7376 7399 7296 6085 152 7296 2204 5339 7751 8098 3421 2053 5765 1324 7557 2644 8184 9583 9296 593 9399 2678 8411 4394 7845 7 6882 6442 3215 8381 1703 4274 3757 7816 7037 1376 8477 5537 6021 1874 622 6701 7139 4291 8708 5041 5589 9160 6226 963 1235 8 1842 8003 7919 5872 7555 9668 2198 40 757 4459 421 7207 6489 5539 8190 627 3079 4432 3297 8253 4150 9896 1594 144 3588 9 7362 5092 2176 2703 7933 933 4277 2661 4196 609 5982 9743 9301 2852 8919 4053 7598 9447 8470 7435 1434 6589 2460 8169 7295 10 8205 4634 9129 6974 2909 464 3363 2344 6542 4390 7183 5352 7345 1405 104 5154 264 7985 3881 8234 559 6981 7285 3601 7026 11 6222 7569 1321 702 6907 5940 1421 4169 2284 3383 937 6070 7595 1357 9372 1397 1063 1622 2893 4179 1802 8874 8325 7283 6889 12 7695 2538 695 5846 6706 1800 6232 9030 8692 7026 6464 3025 8682 8172 2238 9701 8523 9888 5397 168 5397 6861 1706 8759 838 13 1681 2619 7945 7176 3230 7241 7141 3342 2194 3724 9546 559 4337 3777 7434 6229 390 8798 9705 1196 9389 3812 8111 9617 5453 14 2283 7932 1673 9179 5961 3500 1058 6448 9069 1077 120 7095 6967 9676 7909 6093 1332 1696 3073 4171 337 2602 9610 4907 4245