How to write the formulas of these exercises in ms excel?? C-13 C-78 D-66 B-82 B-92 B-47
Fantastic news! We've Found the answer you've been seeking!
Question:
How to write the formulas of these exercises in ms excel??
Transcribed Image Text:
C-13 C-78 D-66 B-82 B-92 B-47 B-48 D-35 B-52 C-88 B-38 C-31 C-79 D-44 B-43 B-53 B-41 C-42 B-75 C-36 D-74 B-86 B-17 B-14 B-39 C-51 B-27 D-12 C-77 C-73 D-34 D-18 C-87 B-91 B-37 C-24 Identifier Cylinder capacity 1249 cm3 1195 cm3 1599 cm3 2 995 cm3 1298 cm3 1 195 cm3 2995 cm3 2 995 cm3 2 490 cm3 980 cm3 1 298 cm3 1599 cm3 1995 cm3 1795 cm3 2 995 cm3 1298 cm3 1249 cm3 1599 cm3 2995 cm3 980 cm3 2 490 cm3 1249 cm3 1195 cm3 2 995 cm3 1 795 cm3 1995 cm3 980 cm3 1795 cm3 2 490 cm3 2995 cm3 1795 cm3 1795 cm3 1195 cm3 2 490 cm3 1599 cm3 1195 cm3 Year of manufacture Mileage 45 234 km 34 308 km 116 953 km Condition 2011 2011 2008 2012 8515 km novel 2008 238 450 km to be replaced 2009 192 795 km 2011 56 145 km 2006 268 943 km 2011 52 722 km 2006 278 123 km to be replaced 9 936 km novel 2012 2009 163 553 km 2009 170 791 km 2010 57 623 km to be replaced 2009 134 985 km 2006 218 072 km 2012 9998 km novel 2008 175 273 km 2006 199 817 km 50 047 km 2011 2008 209 712 km - 2011 55 163 km 46 645 km 2011 2010 83 178 km 2010 131 748 km 2009 189 761 km 2012 18 309 km 2011 47 711 km 2012 8 683 km novel 87971 km 2010 2006 163 940 km 2012 14 717 km 2006 359 114 km to be replaced 2010 77 590 km 2010 130 724 km 2006 139 813 km 5. In cell B46 display the consumption of the vehicle whose identifier is in cell A46! The connection between the cylinder capacity and the consumption can be found in auxiliary table 01:P5 which contains lower limits. However, if the given identifier cannot be found in the main table, show message "WRONG IDENTIFIER"! (3 points) 6. Set italic font style and lightgreen background color for whole rows in which the cylinder capacity is below 2000 cm3 and the year of manufacture is greater than 2009! Format by using your own formula! (3 points) 7. In cell A48 show the identifier of the oldest vehicle! However, if there are more vehicles with the lowest year of manufacture, display "MORE"! (4 points) 8. In cell A50 determine the maximum year of manufacture of the vehicles that meet ANY of the following conditions: (1) the cylinder capacity is between 1000 and 2000 (including the limits), (2) the mileage is higher than the average. If there is no proper vehicle, show "NONE" instead! (5 points) 9. In cell A57 calculate the average mileage of vehicles that meet BOTH of the following conditions: (1) the year of manufacture was before 2008 or after 2010 (excluding these two dates) (2) the cylinder capacity is NOT higher than the average cylinder capacity of the vehicles manufactured in 2011. (5 points) C-13 C-78 D-66 B-82 B-92 B-47 B-48 D-35 B-52 C-88 B-38 C-31 C-79 D-44 B-43 B-53 B-41 C-42 B-75 C-36 D-74 B-86 B-17 B-14 B-39 C-51 B-27 D-12 C-77 C-73 D-34 D-18 C-87 B-91 B-37 C-24 Identifier Cylinder capacity 1249 cm3 1195 cm3 1599 cm3 2 995 cm3 1298 cm3 1 195 cm3 2995 cm3 2 995 cm3 2 490 cm3 980 cm3 1 298 cm3 1599 cm3 1995 cm3 1795 cm3 2 995 cm3 1298 cm3 1249 cm3 1599 cm3 2995 cm3 980 cm3 2 490 cm3 1249 cm3 1195 cm3 2 995 cm3 1 795 cm3 1995 cm3 980 cm3 1795 cm3 2 490 cm3 2995 cm3 1795 cm3 1795 cm3 1195 cm3 2 490 cm3 1599 cm3 1195 cm3 Year of manufacture Mileage 45 234 km 34 308 km 116 953 km Condition 2011 2011 2008 2012 8515 km novel 2008 238 450 km to be replaced 2009 192 795 km 2011 56 145 km 2006 268 943 km 2011 52 722 km 2006 278 123 km to be replaced 9 936 km novel 2012 2009 163 553 km 2009 170 791 km 2010 57 623 km to be replaced 2009 134 985 km 2006 218 072 km 2012 9998 km novel 2008 175 273 km 2006 199 817 km 50 047 km 2011 2008 209 712 km - 2011 55 163 km 46 645 km 2011 2010 83 178 km 2010 131 748 km 2009 189 761 km 2012 18 309 km 2011 47 711 km 2012 8 683 km novel 87971 km 2010 2006 163 940 km 2012 14 717 km 2006 359 114 km to be replaced 2010 77 590 km 2010 130 724 km 2006 139 813 km 5. In cell B46 display the consumption of the vehicle whose identifier is in cell A46! The connection between the cylinder capacity and the consumption can be found in auxiliary table 01:P5 which contains lower limits. However, if the given identifier cannot be found in the main table, show message "WRONG IDENTIFIER"! (3 points) 6. Set italic font style and lightgreen background color for whole rows in which the cylinder capacity is below 2000 cm3 and the year of manufacture is greater than 2009! Format by using your own formula! (3 points) 7. In cell A48 show the identifier of the oldest vehicle! However, if there are more vehicles with the lowest year of manufacture, display "MORE"! (4 points) 8. In cell A50 determine the maximum year of manufacture of the vehicles that meet ANY of the following conditions: (1) the cylinder capacity is between 1000 and 2000 (including the limits), (2) the mileage is higher than the average. If there is no proper vehicle, show "NONE" instead! (5 points) 9. In cell A57 calculate the average mileage of vehicles that meet BOTH of the following conditions: (1) the year of manufacture was before 2008 or after 2010 (excluding these two dates) (2) the cylinder capacity is NOT higher than the average cylinder capacity of the vehicles manufactured in 2011. (5 points)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these operating system questions
-
Write the formulas of the following compounds. a. Nitrogen tribromide b. Xenon tetroxide c. Oxygen difluoride d. Dichlorine pentoxide
-
Write the formulas of the following compounds. a. Chlorine trifluoride b. Nitrogen dioxide c. Dinitrogen tetrafluoride d. Phosphorus pentafluoride
-
Write the formulas of the conjugate bases of the following acids: (a) HNO2, (b) H2SO4, (c) H2S, (d) HCN, (e) HCOOH (formic acid).
-
A new out-of-state client, Robert Ball, has asked you to prepare a Form 709 for a large gift he made in 2013. When you request copies of any prior gift tax returns he may have filed, he responds,...
-
What can an employer do to avoid liability for retaliation?
-
Design a typical mentanance schedule for pumping equipment inna water supply station
-
It seems that leaders and effective followers may be more alike than leaders and managers. Is that so?
-
The Sweet Tooth Candy Company knows it will need 10 tons of sugar six months from now to implement its production plans. Jean Dobson, Sweet Tooths purchasing manager, has essentially two options for...
-
You get paid 1 0 0 $ every 5 months in perpetuiy and get paid 2 0 0 $ every 7 months in perpetuits. Your discount rate is 6 percent EAR. What is the PV of this investment
-
Sadie Cuono started her own consulting firm, Cuono Consulting, on May 1, 2020. The trial balance at May 31 is as follows. In addition to those accounts listed on the trial balance, the chart of...
-
If the graph of f(z) - (z-2) +1 is transformed into the graph of g(z) =f(z-4) +3, then the coordinates of the vertex on the graph of yg(a) will be D (2. 4) D(2. 4) O(6, 4) O (6, 4)
-
Take a postcard-sized envelope, or a half-sheet of A4 paper, and create an elevator pitch (EP) for your group project. Share your pitch with a project team member to gain feedback and then refine the...
-
Reflect back on a recent project you have been involved in which necessitated contractual negotiations. How did the negotiations consider the four essential elements of a contract?
-
Look up the forest taxes implemented across the country, and consider the advantages and problematic points of each.
-
Interview someone who works in a field you are interested in pursuing. (a) How did they get started in the field? (b) How important is project management in the field? In their current job? (c) What...
-
Interview someone who has worked as a project manager or project management professional. Find out. (a) How did they get started in the field? (b) How has their career progressed? (c) What advice...
-
You are supposed to receive $3,600 five years from now.At an interest rate of 9%, what is that $3,600 worth today?
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
A common misconception is that the following chemical reaction occurs when water is boiled: 2H2O(l) 2H2(g) + O2(g) instead of H2O(l) H2O(g) a. What evidence do you have that the second reaction is...
-
List three natural sources of sulfur or sulfur compounds.
-
Calculate the pressure of water vapor at 120.0oC if 1.000 mol of water vapor occupies 32.50 L. Use the van der Waals equation (see Table 5.7 for data). Compare with the result from the ideal gas law.
-
Comparative Data Comparative stockholders' equity sections from two successive years of balance sheets from Kirkwood, Inc., are as follows: No dividends were declared or paid during 2018. Required...
-
The stockholders' equity LOS, 6,8 accounts of Cooper Corporation at January 1 follow: During the year, the following transactions occurred: Jan. 5 Issued 20,000 shares of common stock for \(\$ 15\)...
-
The stockholders' equity of Ranger Corporation at January 1 appears below: During the year, the following transactions occurred: May 12 Declared a 15 percent stock dividend; market value of the...
Study smarter with the SolutionInn App