Write a program that allows a user to enter any number of student quiz scores, as integers, until the user enters 99. If the score entered is less than 0 or more than 10, display Score must be between 10 and 0 and do not use the score. After all the scores have been entered, display the number of valid scores entered, the highest score, the lowest score, and the arithmetic average Please enter your scores---->2Please enter your scores------>3Please enter your scores------>5Please enter your scores------>-1Score must be between 10 and .Please enter your scores------>45Score must be between 10 and o.Please enter your scores------>7Please enter your scores------>99You entered 4 valid scoresThe highest seores is : 7The lowest scores is : 2The sum is i17

Write a program that allows a user to enter any number of student quiz scores, as integers, until the user enters 99. If the score entered is less than 0 or more than 10, display Score must be between 10 and 0 and do not use the score. After all the scores have been entered, display the number of valid scores entered, the highest score, the lowest score, and the arithmetic average

Write a program that allows a user to enter any number of student quiz scores, as integers, until the user enters 99. If the score entered is less than 0 or more than 10, display Score must be between 10 and 0 and do not use the score. After all the scores have been entered, display the number of valid scores entered, the highest score, the lowest score, and the arithmetic average

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter11: User Interfaces, Visual Basic For Applications (vba), And Collaboration Features

Section: Chapter Questions

Problem 11AYK

See similar textbooks

Similar questions

Sumif, Countif Functions Kindly following the instructions below and enter the appropriate formula in cell. Name Electronics SELLING PRICE Results Patricia King Laptop $ 6,665.00 Sum all Electronics that equals "Monitor" and enter in D8. Patricia King Monitor $ 5,000.00 Charles Monaghan Printer $ 7,300.00 Fred Jones Projector $ 6,500.00 In cell D11 count all electronics for Patricia King. John Paul Headset $ 5,248.00 Charlie Brown Laptop $ 6,000.00 Pink Panter Monitor $ 4,400.00 $ 4,400.00 ITEM CAR MODEL SELLING PRICE Results Retro Style Billet Grille Chevy $ 319.00 In cell D17 Sum all Car Models that equals "Dodge". Hood Vent Dodge $ 55.00 Rear Spoiler…
Sumif, Countif Functions Kindly following the instructions below and enter the appropriate formula in cell. Name Electronics SELLING PRICE Results Patricia King Laptop $ 6,665.00 Sum all Electronics that equals "Monitor" and enter in D8. Patricia King Monitor $ 5,000.00 Charles Monaghan Printer $ 7,300.00 Fred Jones Projector $ 6,500.00 In cell D11 count all electronics for Patricia King. John Paul Headset $ 5,248.00 Charlie Brown Laptop $ 6,000.00 Pink Panter Monitor $ 4,400.00 $ 4,400.00 ITEM CAR MODEL SELLING PRICE Results Retro Style Billet Grille Chevy $ 319.00 In cell D17 Sum all Car Models that equals "Dodge". Hood Vent Dodge $ 55.00 Rear Spoiler Mustang $ 220.00…
(d) Using the IF function, write a formula in J6 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J7:J14. Screen shot attached thanks
The -------------- statement is used to execute one action when a condition is true and another when that condition is false.
(g) Using the IF function, write a formula in J38 to display "Yes" if the activity is critical and display "No" if the activity is not critical. Copy the formula to cells J39:J44. Screenshot attached below thanks
Correct answer only. Code and output screenshot. Nastia has 2 positive integers An and B. She characterizes that: The integer is acceptable in case it is detachable by A⋅B; In any case, the integer is almost acceptable, in case it is detachable by A. For instance, if A=6 and B=4, the integers 24 and 72 are acceptable, the integers 6, 660 and 12 are almost acceptable, the integers 16, 7 are neither acceptable nor almost great. Discover 3 unique positive integers x, y, and z to such an extent that precisely one of them is acceptable and the other 2 are almost acceptable, and x+y=z. Input The main line contains a solitary integer t (1≤t≤10000) — the number of experiments. The primary line of each experiment contains two integers An and B (1≤A≤106, 1≤B≤106) — numbers that Nastia has. Output For each experiment print: "Indeed" and 3 distinct positive integers x, y, and z (1≤x,y,z≤1018) to such an extent that precisely one of them is acceptable and the other 2…
How to write this code without this #include <iomanip> #include <iostream>#include <iomanip> using namespace std; int main() { const double BROKERAGE_FEE = 0.015; double buyingPrice, sellingPrice, netAmount, originalInvestment, totalFees; int sharesSold; cout << "Enter the purchase price of each share: "; cin >> buyingPrice; cout << "Enter the selling price of each share: "; cin >> sellingPrice; cout << "Enter the number of shares sold: "; cin >> sharesSold; originalInvestment = sharesSold * buyingPrice; totalFees = (sharesSold * sellingPrice) * BROKERAGE_FEE; netAmount = (sharesSold * sellingPrice) - totalFees; cout << fixed << showpoint << setprecision(2) << endl; cout << "Total amount invested: $" << originalInvestment << endl; cout << "Total amount received from selling: $" << netAmount << endl; cout…
-s is optional and means that the mortgage will be a 15 year mortgage instead of the standard 30 year mortgage you would use as a default. -r is required and the argument is the yearly interest rate for the loan. The interest rate should be between 3% and 10% inclusive. -d is optional and the argument is the downpayment that will be made on the loan. It cannot be larger than the price of the home. You will print out the resulting payment amount as follows. Use rounding to keep money to two decimals and percentages to three decimals. "The payment on a loan of $###,###.## with an interest rate of #.###% for a term of ## years will be $##,###.##" There should be no other output at all to the screen. 1. 0.004166667 2. 1.004166667 3. 360 4. 0.2238265956 5. 0.7762 6. 0.00536822 7. 536.82 Add PMI since there is no down payment: 1. 1% * 100000 = 1000 2. 1000 / 12 = 83.33 3. 536.82 + 83.33 = 620.15
-s is optional and means that the mortgage will be a 15 year mortgage instead of the standard 30 year mortgage you would use as a default. -r is required and the argument is the yearly interest rate for the loan. The interest rate should be between 3% and 10% inclusive. -d is optional and the argument is the downpayment that will be made on the loan. It cannot be larger than the price of the home. You will print out the resulting payment amount as follows. Use rounding to keep money to two decimals and percentages to three decimals. "The payment on a loan of $###,###.## with an interest rate of #.###% for a term of ## years will be $##,###.##" There should be no other output at all to the screen.
Given code is provided down below. Please do not change the existing code. The instructions are in the image. Please explain and show each step and a screenshot of the input and output. Thank you. main.cpp #include "Triangle.h"#include "Square.h"#include <iostream> using namespace std; int main() { //Do not modify return 0;} ------------------------------------------- Square.cpp #include "Square.h"#include <iostream>using namespace std; Square::Square(){ base = 0; height = 0;} Square::Square(int b, int h) : base(b), height(h) { } void Square::setBase(int b){ base = b;} void Square::setHeight(int h){ height = h;} void Square::calculateArea(){ // calculate Area correctly depending on shape type} int Square::getBase() const{ return base;} int Square::getHeight() const{ return height;} double Square::getArea() const{ return area;}// Overloaded << operator // Overloaded >> operator ------------------------------------------- Square.h #ifndef…
(Financials: currency exchange) Write a program that prompts the user to enter the exchange rate from currency in U.S. dollars to Rupees PKR. Prompt the user to enter 0 to convert from U.S. dollars to Rupees PKR and 1 to convert from Rupees PKR and U.S. dollars. Prompt the user to enter the amount in U.S. dollars or Rupees PKR to convert it to Rupees PKR or U.S. dollars, respectively. Use c++ program.
Please draw the correct flowchart for this game ? # Function to display question and answer def new_game(): guesses = [] Right_guesses = 0 question_num = 1 num = 1 for key in questions: print("\n------------------------- \n") print("Question " + str(num) + "\n" ) num += 1 print(key) for i in options[question_num-1]: print(i) guess = input("\nAnswer (A, B, C, or D): ") guess = guess.upper() guesses.append(guess) Right_guesses += check_answer(questions.get(key), guess) question_num += 1 display_score(Right_guesses, guesses) # ------------------------- # Function to check answer def check_answer(answer, guess): if answer == guess: print("\nYour Answer Correct!") return 1 else: print("\nYour Answer Wrong!") return 0 # ------------------------- # Function to display score def display_score(Right_guesses, guesses):…