In cell B15, insert the RATE function to calculate the necessary monthly rate given the NPER, proposed monthly payment, and loan. Make sure the result is positive. 21 Finally, you want to convert the monthly rate to an APR. In cell B16, insert a formula to calculate the APR for the monthly rate in cell B15. 22 Insert a footer on all sheets with your name on the left side, the sheet name code in the center, and the file name code on the right side. 23 Save and close Exp 19_Excel_Ch07 CapAssessment_Shipping.xlsx. Exit Excel. Submit the
Q: In this task, you have to calculate the interquartile range (IQR) and the median values of CO2…
A: The solution to the given problem is given below: 1) Solution to TASK 1 * pandas library is for…
Q: draw flowchart to read names and ages of people terminated by 9999 and print the name of the oldest…
A: given: read names and ages of people terminated by 9999 and print the name of the oldest person…
Q: ● Prompt a user to input numerical values. If a wrong value is given, prompt the user again until a…
A: Answer : code is given at bottom 1.Taking user input through input box. when check button is pressed…
Q: B8, create a formula without using a function that multiplies the value in cell B7 by the value in…
A: Required: In cell B8, create a formula without using a function that multiplies the value in cell B7…
Q: Write the getTotalCase () function. The getTotalCase () function shall return the total number of…
A: Here I have defined the function named getTotalCase(). In this function, I have used a for loop to…
Q: In order to determine the length in concatenating the strings entered in cells A1 and B1, the…
A: According to the information given:- We have to choose the correct option to satisfy the statement.
Q: Next, you want to display the city names that correspond with the city airport codes. In cell F7,…
A: We have to display the city names that correspond with the city airport codes. In cell F7, insert…
Q: Below are sets of numbers. Decode the set of numbers using the letters in the alphabet that…
A: We need to decode the given set of numbers. We use the following conversion : 1 corresponds to…
Q: Which among the following show a valid use of the Color enumeration as a parameter to the setPixel…
A: In swift Language, enumerations can be introduced by using enum keyword.The values of the enum can…
Q: In cell B13, create a formula without a function using absolute references that subtracts the values…
A: In cell B13, create a formula without a function using absolute references that subtracts the values…
Q: The GTUC Company wants to produce a product orders report from its product orders file. Each record…
A: Pseudocode This is one of the approaches that could be used to represent a program's algorithm. This…
Q: Which of the following formulas properly produces the string "Income Statemen "Income "Statement…
A: The command is Strinh1&""&String2 In that case answer is 2nd option
Q: ?lf a column is defined as NUMBER(5,2), which of the following is true The column can store a total…
A: Given:
Q: In column J, you want to display Early Admission, Early Rejection, Admit, or Reject, respectively,…
A: Actually, given question regarding Excel.
Q: According to the last digit of your Student number, write the following Matlab scripts. Write a…
A: Code: brands=[1 2 1 3 2 2 1 3 3 2]price=[30000 20000 35000 20000 22000 31000 33000 24000 16000…
Q: Which of the following statement does not violate any rules of DFD?
A: Solution: The rules of DFD are as follows :- A source or sink(external agent) can't provide data to…
Q: Given the following definition of students, complete this expression to retrieve Emma's age.…
A: Given Entity is a list and by using index value we can access the each element in list Here, each…
Q: Which of the following values/results are of the datatype float? Select one -True -34 -‘Please…
A: Given: Which of the following values/results are of the datatype float? Select one -True -34…
Q: Format the range K2:K3 with Accounting Number Format with zero decimal places. Format cell K4 with…
A: Following needs to be performed for the given excel : Format cells K2 : K3 with Accounting Number…
Q: In cell A1 type in the heading Date then press Enter. In cell A2 type in the following: 20 Jan-20.…
A: We are given some operations to be performed in an excel worksheet. Below are the requirements :…
Q: Specify the local and Global variables used in the code below and express the reason
A: Before giving answer to above question we need to know that: Those variables which are defined…
Q: 5.1 Create plots of the following functions from x = 0 to 10. a. Y = e b. Y = sin(x) c. Y = ax² + bx…
A: a) b) c)
Q: Use the YYYY-MM-DD format to display the current date and to get the current datefrom the user. •…
A: Code: from datetime import date #Built-in modules in python3 to work with date and…
Q: Suppose you want to maintain the highest and lowest temperatures for every day of a year. What kind…
A: We will use a 2-D array of size double arr[365][2], at 0 index we will store min temp and at 1 index…
Q: You want to calculate the total monthly rental revenue if the rates increase by 5% for the occupied…
A: Here, i am calculating the total monthly rental revenue if the rates increased by for the occupied…
Q: Expressions For each expression in the left-hand column, indicate its value in the right-hand…
A: 1. Given expression: 1 + 2 * 3 - 4 * 5 * has highest precedence followed by +,- So, the given…
Q: Question No: 01 02123nt505 This is a subjective question, hence you have to write your answer in the…
A:
Q: The GTUC Company wants to produce a product orders report from its product orders file. Each record…
A: Pseudocode This is one of the approaches that could be used to represent a program's algorithm.…
Q: Q2: Draw a flowchart to read the temperatures for the month of July, then calculate and print the…
A: The Flow chart is as follows:
Q: 64. The following procedure is intended to return true if at least two of the three parameters are…
A: Answer: We have given one code and we need to understand which is the correct answer and which is…
Q: The GTUC Company wants to produce a product orders report from its product orders file. Each record…
A: Pseudo code: This is one of the approaches that could be used to represent a program's algorithm.…
Q: In cell B32, create a formula that multiplies the value of cell B31 (Charlie’s gross monthly…
A: In cell B32, create a formula that multiplies the value of cell B31 (Charlie’s gross monthly…
Q: In the input file (see image), grades are listed for the geography tests of group 2b. There have…
A: Given: In the input file (see image), grades are listed for the geography tests of group 2b. There…
Q: 4.6.2: Convert a height into inches. Write a second convertToInches() with two double parameters,…
A: logic:- use formula:- totalInches=numFeet*12.0+numInches return totalnches from function.
Q: String [] countyNames = {"Kings", "Albany", "New York", "Orange", "Bronx", "Queens", "Richmond"};…
A: Introduction: The above java program depicts the concept of the array of string type and the size of…
Q: Create code to check a course mark and give the equivalent letter grade as shown in the table below:…
A: Please find the answer below :
Q: in cell b13, create a formula using the vlookup function that looks up the value from cell a11 in…
A: The correct solution to this question is VLOOKUP(A11,A5:B7,2,0) . Explanation: The VLООKUР methоd…
Q: 1. Starting with the leftmost digit, double it and then double every other digit after it. However,…
A: code is given below
Q: Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF…
A: I am first showing the formula sheet of EXCEL then I will show the result table
Q: The ideal gas law relates the pressure P, volume V, and temperature T of an ideal gas: PV = nRT…
A: Matlab code: clc;clear all;close all;format short R=8.314;n=1;T=[100 200 300…
Q: Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the…
A: EXPLANATION: C9 = VLOOKUP(B9,$B$2:$C$6,2) is the formula for cell C9. From Cells C10 through C54,…
Q: Combine the first name, middle name, and last name and assign it as the 'fullname' of the hero. If…
A: Implementing given program in C++.
Q: Turn the following code into a procedure. Pass the input file and the amount of PM 10 to the…
A: As per the given question, we need to modify the given code such that the new code consists of…
Q: Using the integer entered by the user above, print out all the prime numbers between 2 and the…
A: import java.util.Scanner;public class Main { public static void main(String[] args) { Scanner sc =…
Q: Rotate all of the following characters by the given amount, to determine a new character. Do not put…
A: Here's the solution:
Q: In cell B6 in the Purchasing sheet, insert the payment function to calculate the monthly payment…
A: We have to calculate the monthly payment using cell references.
Q: You want to count the number of houses in one city. In cell C2, insert the COUNTIF function to count…
A: According to the information given. We have data of houses in the city. and we have to calculate the…
Q: Create a user-defined function that calculated the Reynolds number pVD μl Re= where p is the fluid…
A: The user defined function is given below along with VBA code and sample data
Q: bob employs a painting company that wants to use your services to help create an invoice generating…
A: Display "Please enter the working hours in week" Declare a variable workingHours Input the number of…
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 7 images
- The following table shows the rate of commission that will be paid to the salesman according to the total sales performance of the month:Total Sales Performance (RM) CommissionLess than 10000 No commission10000 – 20000 1% of the total sales20001 – 30000 2% of the total sales30001 – 40000 3% of the total salesMore than 40000 4% of the total sales Lastly, display the salesmanName, totalSalesPerformance,totalCommission and totalSalary.Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) Commission 1–5,999.99 10% of sales 6,000–29,999.99 $600 plus 13% of the sales over 6,000 30,000 and over $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total dueAn employee has only one job code, but a job code can be held by many employees. ERD
- XYZ pays 5% interest on shares exceeding Sh.100,000 and 3% on shares that do not meet the target. however no interest is paid on deposits in the members bank account. Calculate and display the shares on the screen for a member Calculate and display the deposits on the screen for a memberXYZ pays 5% interest on shares exceeding Sh.100,000 and 3% on shares that do not meet the target. however no interest is paid on deposits in the members bank account. calculate and display the shares, deposits, interest and total savings on the screen for a memberAlreej College Computer Application Student Name Student_ID Math En Ahmed Omar Huda 20f20 45 10 35 20f21 50 45 45 Muhmmed 20f22 20f23 20f24 20f25 46 20 50 Amira 50 35 50 Huda Ahemd 20 50 33 Noora Ali 33 45 46 Figure-1 1) Prepare and format your MS-Excel Document as shown above. 2) The total number of student marks for each Module during the semester needs to be calculated. Explain how you will do it. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations. 3) Explain how you will calculate the Average for each students. Your answer should include cell references to indicate the cells where the calculations will be done, the cells that will be required for the calculations, and the formula to be used. Use Microsoft Excel to test your explanations.
- in a shop ,there are 10 employee and 20 kinds of goods,goods id between 1-20 EMPLOYEE id first name last name gender 10001, 'Tom', 'Brown', 'F'10002, 'Elizabeth', 'Tremblay', 'F'10003, 'Gladys', 'Julie', 'F10004, 'John', 'Taylor', 'M10005, 'Amelia', 'Smith'10006, 'Logan', 'Katherine'10007, 'Leo', 'Brown'10007, 'Lem', 'Thompson'10009, 'Tom' 'Smith'10010, 'Emma', 'Campbell' ------------ and I want to add a name library in it ,like this how could i create a HTML file ,with will randomly create customers with these employee . there is a start button on the page . press "start "bottom ,and it will It will randomly match 10 items, customers, and goods, display goods id ,customername and gender ,employer name , id and gender . how to do such a page ?The expression =IF(A1 > 12, 3*A1, 6*A1) is used in a spreadsheet.Find the result if A1 is 2 Find the result if A1 is 13.The system to be developed for Williams and Son needs to produce the following slip for a customer once the sale has been concluded. Williams & Son VATnr: 0123456 Product Price Screwdriver R 100 Super glue R 20 Total: R120 Please note: For the purpose of this assignment, assume that a customerwill only purchase one unit of each item.
- Systems Analysis and Design Use any suitable tool, represent, using the proper symbols, the following action: A young inventors club has decided to implement a website to motivate its members. The website has the following data. Members are requested to fill the application forms. Member details are stored in member file. Accounts department gets the details from member file and decides the membership fees. And it sends the receipt to the member.Question 7 Each salesperson at IdzaaraAisya Inc. receives a commission based on the amount of his or her sales. The commission rates and additional payment amounts are shown below. Sales ($) 1-5,999.99 6,000–29,999.99 30,000 and over Commission 10% of sales $600 plus 13% of the sales over 6,000 $3,720 plus 14% of the sales over 30,000 Additional $500 if the salesperson has worked at the company for over 10 years and the sales amount is at least $10,000. $700 if the salesperson travels. Draw a flow chart. Calculate the commission, any additional amount, and the total due only when the sales amount is greater than 0; otherwise, display $0.00 as the commission, additional amount, and total due.TASK: Examples of the UNION operator, the use the DISTINCT operator. TOPIC : DATABASE