You have the following grading scale: Letter Grade A B C D F Marks ...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You have the following grading scale: Letter Grade A B C D F Marks ο ο ο ο >90 80-90 70-80 60-70 <60 The user inputs marks in a cell named 'grade'. How will you write a nested 'IF' function to determine the corresponding letter grade? =IF (grade>90,"A",IF(grade<60,"F",IF(grade<70,"D",IF(grade<80,"C","D")))) =IF(grade>90,"A",IF(grade>=80,"B",IF(grade>=70,"C",IF(grade>=60,"D","F")))) O=IF(grade>90,A,IF(grade<80,C,IF(grade<70,D,IF(grade<60,D,B)))) =IF(grade>90,A,IF(grade<60, F,IF(grade<70,D,IF(grade >80,C,D)))) You have the following grading scale: Letter Grade A B C D F Marks ο ο ο ο >90 80-90 70-80 60-70 <60 The user inputs marks in a cell named 'grade'. How will you write a nested 'IF' function to determine the corresponding letter grade? =IF (grade>90,"A",IF(grade<60,"F",IF(grade<70,"D",IF(grade<80,"C","D")))) =IF(grade>90,"A",IF(grade>=80,"B",IF(grade>=70,"C",IF(grade>=60,"D","F")))) O=IF(grade>90,A,IF(grade<80,C,IF(grade<70,D,IF(grade<60,D,B)))) =IF(grade>90,A,IF(grade<60, F,IF(grade<70,D,IF(grade >80,C,D))))
Expert Answer:
Answer rating: 100% (QA)
IF function to determine the corresponding letter grade based on a given mark Here are the four options provided in the image along with an explanation of each Option 1 Excel IFgrade90AIFgrade 60FIFgr... View the full answer
Related Book For
Starting Out With Java From Control Structures Through Data Structures
ISBN: 9780133957051
6th Edition
Authors: Tony Gaddis
Posted Date:
Students also viewed these programming questions
-
A given crystal structure (such as NaCl) can be represented as consisting of planes of atoms, as shown below. A beam of x-rays can be reflected off the crystal, where the some of the beam penetrates...
-
Briefly describe ASCII and Unicode and draw attention to any relationship between them. [3 marks] (b) Briefly explain what a Reader is in the context of reading characters from data. [3 marks] A...
-
A companys retained earnings on December 31, 2018 was $2,190,000 and its shareholders equity was $8,760,000. During 2019 the company reported the following: Net income $225,000 A sale of treasury...
-
At December 31, 2014, Cascade Company had a net deferred tax liability of $450,000. An explanation of the items that compose this balance is as follows. In analyzing the temporary differences, you...
-
Water at 25C flows at 5 ft/s through a straight, cylindrical tube cast from benzoic acid, of 2-in. inside diameter. If the tube is 10 ft long, and fully developed, turbulent flow is assumed, estimate...
-
As a battery is used to charge a capacitor, does the overall charge inside the battery get smaller, get greater, or stay the same?
-
Product costing systems and product profitability Potter Corporation has gained considerable market share in recent years for its specialty, lowvolume, complex line of products, but the gain has been...
-
19.A radioactive -emission. A detector records n -particles in 2s and by next 2s (accumulatively) it records 1.1 n -particle. Number of -particles recorded by detector after a long time, is (1) 11n...
-
Use the superposition principle to find io and vo in the circuit Fig. 4.79? Figure 4.79 For Prob. 4.11. 10 10 20 6 A 40 4 +30 V 10
-
A table of values for a linear functions are shown. x f(x) -1 -8 36 6 0 96 Select the bubbles that match the key features of the graph to its table. X-intercepts: x-intercept y-intercept rate of...
-
The local small appliance store has microwave ovens for sale at a price of \($149.95.\) The price tag notes that the manufacturers suggested retail price is \($160.\) This type of pricing is referred...
-
Why should a customer be concerned about transit inventory cost if they pay for the inventory only when the merchandise arrives at their premises?
-
Why do we say that transport is a derived demand?
-
Discuss whether a specific advertising campaign that promotes social equality by showing non-traditional families would turn you away from a product or make you consider using a product.
-
You just learned about new product development, branding, and pricing.Consider how this content relates to other areas of business. What information would you need to plan for how branding and...
-
a) Write the constraints (position variables) and closure loop equation(s) b) Write velocity equations c) Write acceleration equations d) For 02=135, @ =24 rad/s (cw) and az-8 rad/s? (cw), perform a...
-
Several months have passed and the Managing Partner approved and properly filed the Complaint and properly submitted the Request for Production of Documents that you drafted. In fact, it has been 75...
-
This is the part of a problem that is solved with recursion. a. Base case b. Iterative case c. Unknown case d. Recursion case
-
Create a JavaFX application where the user enters the wholesale cost of an item and its markup percentage into TextFields. (For example, if an items wholesale cost is $5 and its markup percentage is...
-
How do you make a text field read-only? In code, how do you store text in a text field?
-
Describe a scenario to fit the energy bars shown in Figure 7. 22. What happens during the interaction? Data from Figure 7. 22 AE, AE LLEF AK AU K U E E K U E, E
-
Which of the following deformations are reversible and which are irreversible: (a) the deformation of a tennis ball against a racquet, \((b)\) the deformation of a car fender during a traffic...
-
Translate the kinetic energy graph in Figure 7. 2 into three sets of energy bars: before the collision, during the collision, and after the collision. In each set, include a bar for \(K_{1}\), a bar...
Study smarter with the SolutionInn App