Check to see if the average is in the range 80 to 89 (not including 80 or 89). if (average 80) (average 89): C. Check to see if the grade is invalid – grades below 0 are considered invalid, as are grades above 100. if (grade 0) (grade 100

Check to see if the average is in the range 80 to 89 (not including 80 or 89). if (average 80) (average 89): C. Check to see if the grade is invalid – grades below 0 are considered invalid, as are grades above 100. if (grade 0) (grade 100

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter3: Working With Large Worksheets, Charting, And What-if Analysis

Section: Chapter Questions

Problem 2.1EYK

See similar textbooks

Related questions

Q: Aerospace engineers sometimes compute the trajectories of projectiles such as rockets. A related…

Q: As you surely know, due to some astronomical reasons, years may be leap common. The former are 366…

A: Now consider the rules and frame the code statments Year not divisible by 4 is a common year .…

Q: You can find out how many seconds have elapsed since Jan 1, 1970 using the time() function.…

Q: write a program to input 3 integers and determine which of them is biggest:- Using if(. ) &&(. )

A: We are using only the if conditions here according to the question. The program is written in C…

Q: 30. If originally x=4, what is the value of x after the evaluation of the expression: x+=x+3

A: The value after evaluation will be 11. #include <iostream> using namespace std; int main(){…

Q: Correct the following code so that it prints the correct message. if (score <= 60)cout <<…

A: "if-else" statement: “if-else” statement is known as selection control structure. The syntax for…

Q: Q2/ Write a program that reads a code and temperature. If the code is 1, convert from centigrade to…

A: C programming: C programming is a procedural programming language that was developed by Dennis…

Q: If a = 4; and b = 3;, then after the statement a = b; the value of b is still 3. Select one: O True…

A: Here initially a=4 b=3 And. a=b; will store value of b in variable a. Hence it will only change the…

Q: If F1(A, B, C, D) = Sum(0, 1, 3, 8, 9, 14, 15) and d=Sum(4, 5, 11, 12, 13), the F1 =

Q: int x=1O; int y-3; if(x>y II y!=3) x=x+y; if(y%2==1} --y; else X=x-y; Cout<- x<<" "<<y;

A: Draw a dry run to get the correct answer

Q: program that calculates the final score and the average score

A: As programming language is not mentioned. So used Python Programming language to complete the task.…

Q: Given four positive integers a, b, c, and d, compute the sum of those among them that are odd.…

A: PROGRAM: //Defining class OddSum public class OddSum { //Defining main() function public static…

Q: / Write a program (using IF statement) to display the name of day by giving the day number as the…

A: The required Matlab program has been provided, by using if-else statements, in the next step.

Q: Wind Chill = 35.74 + 0.6215T - V^0.16 (35.75- 0.4275T) Compute the wind chill for a temperature of…

Q: Complete the pay computation to give the employee 1.5 times the hourly rate for hours worked above…

A: Python code: hours = 45 rate = 10 overtimeRate = 1.5 grossPay = 0 if hours < 40: grossPay =…

Q: 28. If originally x=4, what is the value of x after the evaluation of the expression: x+=4

A: Given, x = 4. The value of x after the evaluation of the expression: x+=4 is 8.

Q: You have 100 kids of ages between one and ten years old. Sum the number of: 5 years old kids 10…

A: MATLAB CODE first=0; // variable second=0; third=0;fourth=0;for i=…

Q: Suppose that x, y, and z are int variables and x = 13, y = 45, and z = 20. Determine whether the…

A: a. !(x - y <= 10) Decoding the above line is as follows, ==> !(13-45<=10) ==> !(-32…

Q: Evaluate the following expressions if x is 10.5, y is 7.2, m is 5, and n is 2. x / (double)m = x /…

A: Expression evaluation:In expression (1), “double()” is used to convert integer value of “m” to…

Q: Select the answer that indicates the truth and falsehood of each of th three statements below:

A: Lets see the solution in the next steps

Q: (b) Determine the smallest positive integer so that when divided by 3, 5 and 7, the reminder is 1,…

A: Smallest number: 34 Explanation: LCM of 3,5 and 7: 3x5x7 = 105 Because the LCM of 3, 5, and 7 equals…

Q: If x, and y are positive numbers both are less than one, then maximum value of floor(x + y) ?is 1 2…

A: Ans: If x and y are positive numbers both are less than one , then maximum value of floor(x + y) is:…

Q: 6- Write a program to read three numbers A,B,C then find whether A,B,C can form the sides of a…

A: Note: As no programming language is mentioned, therefore answering the given question in python.…

Q: To test whether x is between 10 and 100, which of the following expressions are correct? a. 100 >…

A: Answer: Boolean expression: An expression that produces a boolean value, that is true or false, when…

Q: trace the following code and give the output. for (int cc= 5; cc <= 6; cc++) cout << "ABC";…

A: Tracing the code: A variable “cc” is initialized to 5. A “for” loop iterates till “cc <= 6”. In…

Q: Correct the following code so that it prints the correct message. (3) if (score <= 60) cout <<…

A: As per our honor code, we are answering the first question. Please post the remaining as separate…

Q: a- if(x>0){ if(y>0) S.O.P("A");} b- if(x>0 || y>0) 5) x and y are two integers. Which of the…

A: GIVEN : x and y are two integers, which of the following is not equivalent to other ? a)…

Q: Evaluate the following: a - True b - False C - True print(a and b) print(c and b or a) print (b or c…

A: Given: Python Evaluation

Q: Let x, y, and z be True statements, and a, b, and c be False statements. If (b V ~ y) → (n → a) =…

A: In given question 1, we are given some true and false statements and asked for the value of n. In…

Q: 2. Evaluate the following expressions for m = 6, n=2 b= 0, c = 0, d = 0, and e = 0 (i) a+=4+ ++m*n:…

A: After evaluation: (i) m=7 n=2 a=18 b=0 c=0 d=0 e=0 (ii) m=5 n=2 a=0 b=0 c=0 d=0 e=0…

Q: The snippet that has to be used to check if “a” is not equal to “null” is _________ i) if(a!=null)…

A: The not-equal operator !== compares o to null and evaluates to either true or false.

Q: Determine the truth value of the statement given that p is true, q is false, and r is false. 1.…

A: Given: Given that p is true, q is false, and r is false.

Q: Convert the following code into descriptive code, and verify using White Box Testing. a = 2 b = 10 c…

A: Answer :

Q: answer will be upvoted else downvoted. number is called 2050-number if it is 2050, 20500, ...,…

A: Here have to determine about the 2050-number problem statement.

Q: Evaluate the following expressions if x = 10.5 y = 7.2 m = 5 n = 2 1) x / (double)m 2) x / m 3)…

A: (I) x/(double)m; It first convert m into double and then process x/m which comes to be 2.1 (ii) x/m;…

Q: Q1: Write a program that input four grades for six students and output a. The grades summation for…

A: #include<iostream.h>#include<conio.h> #include<dos.h> void main ( ) {…

Q: Given: If A AND B, then C. Given: The if-then statement's reverse is also correct. If A is True, B…

A: Given: A∧B →C & C→A∧B So, (A∧B)↔C , If A is True, B is True then C is also True…

Q: Q1: What is wrong in the following code? if (score >= 60.0) cout « "Grade is D"; else if (score >=…

A: The code given is : if (score >= 60.0)cout « "Grade is D";else if (score >= 70.0)cout <«…

Q: Take in one number and check if it is even or odd. Then, print out the number and tell me if it is…

A: Answer: Provide the program in c++ Code: #include <iostream>using namespace std; int main() {…

Q: If a = 2, b = 4, and c = 6, is the following expression true or false? (b > a) || (b > c)…

A: Given: Condition true or not.

Q: The following equations estimate the calories burned when exercising (source): Women: Calories (…

A: Required:

Q: 6- Write a program to read three numbers A,B,C then find whether A,B,C can form the sides of a…

A: Required: write a program to check if a triangle is valid or not and if valid then check if it is…

Q: The value Q from the following is? BR(Y)-a*y**2+b*y+c a=5.0, b=6.0,c-2.0 Ix=4 Q=BR(flo at(Ix))

A: Answer : Q = 106.0

Q: Find the following expression, which is given in the prefix notation. - / * 6 + * 4 y 7 3 x and…

A: The infix notation to given prefix is (((6*((4*B)+7))/3)-A)

Q: Correct the following code so that it prints the correct message.if (score <= 60)cout <<…

A: CORRECTED CODE: #include <iostream> // include header file for input output…

Q: Given: If A AND B, then C. Given: The if-then statement's reverse is also correct.

A: Solution is given below :

Q: Aerospace engineers sometimes compute the trajectories of projectiles such as rockets. A related…

A: newton.m function [ root ] = newton( f, df, x0, epsilon, max_iter )%function, derivative,initial…

Question

B. Check to see if the average is in the range 80 to 89 (not including 80 or 89).

if (average 80) (average 89):

C. Check to see if the grade is invalid – grades below 0 are considered invalid, as are grades above 100.

if (grade 0) (grade 100):

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

You can answer E, F, and G only
The options are even or odd.
In Saudi Arabia, the Kudai Parking Area is a parking lot that is next to the Ajyad Police Station and close to the Power Plant. Kudai is a well-known parking space near Masjid al-Haram. After parking there, you can take a taxi to Masjid al-Haram for 10-15 Riyals for a 10-minute drive. The parking is usually heavily occupied, and the following formula is used to compute the parking lot uțilization: Percentage of Parking Lot Utilized - Number of lots occupied + Total number of lots Write a program that calculates the occupancy rate for each zone of a massive parking lot like Kudai. The program should start by asking for the number of zones in the parking lot. A loop should then iterate once for each zone. During each iteration, the loop should ask the user for the number of lots in the zone and the number of them that are occupied. After all the iterations, the program should display the number of lots the parking has, the number of them that are occupied, the number that is vacant, and…
Given four positive integers a, b, c, and d, compute the sum of those among them that are odd. Because you have not yet learned how to make decisions, use the fact that for a positive integer n, the expression n % 2 is either 0 or 1. (not allowed to use an if statement or conditonal)
Scenario As you surely know, due to some astronomical reasons, years may be leap or common. The former are 366 days long, while the latter are 365 days long. Since the introduction of the Gregorian calendar (in 1582), the following rule is used to determine the kind of year: if the year number isn't divisible by four, it's a common year, otherwise, if the year number isn't divisible by 100, it's a leap year. otherwise, if the year number isn't divisible by 400, it's a common year. otherwise, it's a leap year. none of the above year int(input("enter the year")) if (year%4 1-0) and (year%400 -0) or (year % 1000): print (year is common year") else: print(year, is leap year") year= int(input ("enter the year")) if (years !-0) or (year480 1-0) and (year % 1001-0): print(year is common year") else: print(year, "is leap year") D year= int(input("enter the year"))
Question 4 Rewrite the following statement without using variables. Then, give an exam- ple that shows the statement is true. There exist two real numbers a and b such that ab > a + b. Question 5 Rewrite the following statement without using variables. Then, give an exam- ple that shows the statement is false. For any positive integer n, n³ > n².
B.Question The BITI Students Club is offering a new travelling package or membership. People can choose either one of three packages : a) business, b) family or single package. Each packages have different prices for monthly subscription. A business package is RM40, a family package is RM20 and single package is RM30. People can choose any package and duration-in-month for subscription. The program will calculate and display the total of payment. The program can be repeated as long as the option to exit is not selected. Any invalid input will result in an error message to retry. C) Sample Output BITI Caravan Travelling Club Membership 1. BUSINESS (RM40) 2. FAMILY 3. SINGLE 4. Quit the Program (RM20) (RM30) Enter your choice: 1 For how many months do you like to caravan with us ? 5 The total charges are RM200.e0 BITI Caravan Travelling Club Membership 1. BUSINESS (RM40) 2. FAMILY 3. SINGLE 4. Quit the Program (RM20) (RM30) Enter your choice:
Given four positive integers a, b, c, and d, compute the sum of those among them that are odd. Because you have not yet learned how to make decisions, use the fact that for a positive integer n, the expression n % 2 is either 0 or 1. (not allowed to use an if statement)
Compute the average and print the standard deviation of four scores. The standard deviation is defined to be the square root of the average of four scores where a is the average of the four values (Si – a)2 where a is the average of the four scores of s1, s2, s3, and s4.
Question: 1A perfect number is an integer that is the sum of its positive proper divisors (all divisors except itself). For example, 6 is a perfect number. The divisors of 6 except itself are 1,2 and 3. The sum of the proper divisors of 6 is 6. Thus 6 is a perfect number. You have to take integers as input and continue taking input until the word “STOP” is given as input. After taking the inputs you have to classify the integers as Perfect and Imperfect and store it in a dictionary(Please see the output for better understanding).[Note: You CANNOT use any built in functions EXCEPT input(),range(),print()]Sample Input :61082528100496530STOPSample Output:(No need to follow the output format. Just print the resultant dictionary.){Perfect: [6,28,496],Imperfect: [10,8,25,100,530]}
d) Find the value of Z' at X = 0 and Y = 1 Given : Z = X.Y' + Y.X'
Q3/ The electric field at a point situated at a distance d from straight charged conductor is (a) Proportional to r (b) Inversely proportional to r (c) Inversely proportional to f (d) None of the above