All categories

3 years ago

In the Microsoft Excel spreadsheet how many choices are possible when using a single IF statement

Computers and Technology

1 answer:

cricket20 [7]3 years ago

8 0

Answer:

An if statement can have only two choices. However the choices can be extended by using multiple if else statements within the first if statement.

Explanation:

Best Regards: Your Friendly Study Co-Pilot

You might be interested in

PLS HURRY!!! Look at the image below!

max2010maxim [7]

Answer:

Ctrl+c

Explanation:

6 0

2 years ago

Read 2 more answers

Ask the user to input their grade percentage (e.g. the use will enter 98 if they had an overall grade of 98% in their course) fo

Airida [17]

Answer:

In Python

def getpointValue(subject):

if subject >= 75: point = 4; grade = 'A'

elif subject >= 60: point = 3; grade ='B'

elif point >= 50: point = 2; grade = 'C'

elif point >= 40: point = 1; grade = 'D'

else: point = 0; grade = 'F'

return point,grade

subjects= ["Accounting","Marketing","Economics","MIS"]

acct = int(input(subjects[0]+": "))

mkt = int(input(subjects[1]+": "))

eco = int(input(subjects[2]+": "))

mis = int(input(subjects[3]+": "))

acctgrade = getpointValue(acct)

print(subjects[0]+" Grade: "+str(acctgrade[1]))

mktgrade = getpointValue(mkt)

print(subjects[1]+" Grade: "+str(mktgrade[1]))

ecograde = getpointValue(eco)

print(subjects[2]+" Grade: "+str(ecograde[1]))

misgrade = getpointValue(mis)

print(subjects[3]+" Grade: "+str(misgrade[1]))

totalpoint = (acctgrade[0] + mktgrade[0] + ecograde[0] + misgrade[0]) * 3

gpa = totalpoint/12

print("GPA: "+str(gpa))

Explanation:

The solution I provided uses a function to return the letter grade and the point of each subject

I've added the explanation as an attachment where I used comment to explain difficult lines

Download txt

6 0

2 years ago

A milk carton can hold 3.78 liters of milk. Each morning, a dairy farm ships cartons of milk to a local grocery store. The cost

makvit [3.9K]

Answer:

milk_produced = float(input("Enter the total amount of milk produced in the morning: "))

liter_cost = float(input("Enter the cost of producing one liter of milk: "))

carton_profit = float(input("Enter the profit on each carton of milk: "))

carton_needed = round(milk_produced / 3.78)

cost = milk_produced * liter_cost

profit = carton_profit * carton_needed

print("The number of milk cartons needed to hold milk is " + str(carton_needed))

print("The cost of producing milk is " + str(cost))

print("The profit for producing milk is " + str(profit))

Explanation:

*The code is in Python.

Ask the user to enter milk_produced, liter_cost and carton_profit

Calculate the number of milk cartons needed, divide the milk_produced by the capacity (3.78) of a cartoon and round the result

Calculate the cost, multiply the milk_produced by liter_cost

Calculate the profit, multiply the carton_profit by carton_needed

Print the results

3 0

2 years ago

Suppose you wanted to run a web server or ftp server from your home. what type of ip address would you want?

Greeley [361]

You would need to have a static ip address.

3 0

2 years ago

Define a class named person that contains two instance variables of type string that stores the first name and last name of a pe

Katarina [22]

Answer:

Answered below

Explanation:

//Program is written using Java programming language.

Class Person {

private string firstName;

private string lastName;

void set firstName(string a){

firstName = a;

}

string getFirstName(){

return firstName;

}

void setLastname( string b){

lastName = b;

}

string getLastName( ){

return lastName;

}

void displayDetails( ) {

System.out.print(firstName);

System.out.print (lastName);

}

//Test program

Class Main{

public static void main(String args [] ){

Person person = new Person( )

person.setFirstName("Karen")

System.out.print(person.getFirstName)

person.displayDetails()

}

5 0

2 years ago

In the Microsoft Excel spreadsheet how many choices are possible when using a single IF statement​

In the Microsoft Excel spreadsheet how many choices are possible when using a single IF statement