AVERAGE and Financial ratios completed

Excel Formula Question - Multiple Choice  1. Which of the following is an example of a properly constructed Excel formula that adds cell B1 to B2 and then multiplies the result by B3. a) =B1+B2*B3 b) =(B1+B2)*B3 c) =(B1+B2*B3) d) =B1+(B2*B3) Explain Please.

An ISBN-10 (International Standard Book Number) consists of 10 digits: The last digit, is a checksum, which is calculated from the other nine digits using the following formula:   (d1 x 1 + d2 x 2 + d3 x 3 + d4 x 4 + d5 x 5 + d6 x 6 + d7 x 7 + d8 x 8 + d9 x 9) % 11) If the checksum is 10, the last digit is denoted as X, according to the ISBN convention. Write a program that prompts the user to enter the first 9 digits as a string and displays the 10-digit ISBN (including leading zeros). Your program should read the input as a string.

Please right solution only please fast u will like it

C# Language You are tasked with writing a program to process students’ end of semester marks. For each student you must enter into your program the student’s id number (an integer), followed by their mark (an integer out of 100) in 4 courses. A student number of 0 indicates the end of the data. A student moves on to the next semester if the average of their 4 courses is at least 60 (greater than or equal to 60).   Write a program to read the data and print, for each student: The student number, the marks obtained in each course, final mark of the student (average of all the marks), their final grade (A,B,C,D or F) and whether or not they move on to the next semester.   In addition, after all data entry is completed, print The number of students who move on to the next semester and the number who do not. The student with the highest final mark (ignore the possibility of a tie).   Grades are calculated as follows: A = 70 and over,   B = 60 (inclusive) -70,   C = 50(inclusive)-60 D =…

Use the appropriate arithmetic assignment operator to abbreviate the following assignment statement: intNum = intNum – 5.

When can we use several operators?

Please write the pseudocode for admission in the form of the pseudocode in 1.

Bob a builder has come to you to build a program for his construction business. He needs to determine the square footage of a room in order to buy material and calculate costs.Bob charges $425 per square metre.the program is going to ask the user to enter the name of a room . It will then ask you for the width and length of a room (in metres) to be built.the program will calculate the room area and use this information to generate an approximate cost. Your program will display the room , the total area and the approximate cost to the screen

WEEK7 Costway provide a loan scheme to their staffs. The duration payment (year of installment) is 2 years. The maximum loan is RM10,000. The program that can help the Account Department to calculate the monthly installment. The program should be able to receive inputs from the staff: name, year of installment and the amount of loan in RM. Based on these inputs, the program should therefore be able to calculate the monthly installment. Display the staff's name, year of installment, the amount of loan and the installment. The table for the interest calculation is provided as follows: Year of Amount of Loan installment <2 years (RM) <5,000 5,000 - 10,000 <5,000 5.000 10,000 Interest (%) 2.0 2.5 22 years 1.5 2.0 The formulas for the monthly installment calculation are as follows: Total of Interest = Percent of Interest x Amount of Loan Total Loan with Interest = Amount of Loan + Total of Interest Monthly Installment = Total Loan with Interest/(Year of Installment x 12) %3D

Flow Chart Ask the user his/her birthdate. Compute for the age. Display "you are still a minor" if age < 18 "you are an adult" if age => 18 "you are a senior citizen" if age => 60

Compute the income tax due on taxable income entered by the user, given the data as shown in the following table. Be sure to include error checking to make sure the user does not enter a negative number. Assume all entries are integer values. Taxable Income Tax Due From To $0 $49,999 $0 + 5% of amount over $0 $50,000 $99,999 $2,500 +7% of amount over $50,000 $100,000 $6,000 + 9% of amount over $100,000 (Provide the following: Pseudocode; Flowchart) Dago 2 of 5

# Question 4def costume_rating(costume_color, bling_value):    """    Returns a function that calculates the number of candies to return based on    the costume color, bling value, and phrase length.     Args:        costume_color (str): The color of your costume. Must be one of 'blue',        'red', 'green', 'yellow', 'purple', or 'orange'.        bling_value (int): Represents how shiny your costume is. Must be a        positive integer.     Returns:        A function that takes in one parameter:            phrase (str): The phrase said by the trick-or-treater.     >>> costume_rater = costume_rating('blue', 5)    >>> costume_rater('19 Character Phrase')    85    >>> costume_rater('e')    0    >>> costume_rater('seven c')    1     >>> costume_rater = costume_rating('orange', 8)    >>> costume_rater('hello i want candy')    14     >>> costume_rater = costume_rating('yellow', 5)    >>> costume_rater('please give me…