Hamna_Mustafa_Excel Assignment # 3 - Homework
.xlsx
keyboard_arrow_up
School
University of Massachusetts, Amherst *
*We aren’t endorsed by this school
Course
350
Subject
Computer Science
Date
Apr 3, 2024
Type
xlsx
Pages
18
Uploaded by AmbassadorPantherPerson1089
Chapter 3: Formulas an
Tasks
1
2
3
4
5
6
Insert an IF formula in column I that meets the following conditions: -
If there is no added ch
-
Otherwise, I1 should d
7
Insert an IF formula in column J that meets the following conditions: -
If the total amount in -
Otherwise, J1 should d
8
9
10
11
12
- It must be accepted (in
- It must have no extra 13
- The price of the board
- The quantity of the bo
14
15
16
Below is an image of what your worksheet should look like.
Instructions: Complete the below steps. Once you are done, kindly upload this Excel W
Fill all column F (range F6:F43
) with a formula that multiplies each board game's price
by
Use a SUMPRODUCT function to calculate the Total in cell
O6
. It is the sum of the produ
In cell G6
, calculate the commission per item. Your formula multiplies the Total Amount
cell referencing - you will only be marked correct if you use absolute referencing).
Auto Fill the values in column G
(range G6:G43
).
Column H sums up values from columns G
and F. Use a SUM function to fill in the range
Insert the date of February 3rd, 2023
in cell R3
using the DATE function.
Insert today's date using the TODAY function in cell R4
.
In cell B45
, use a function to count the number of entries in the range B6:B43
of your wo
In cell C45
, use a function to count the number of times there was an added charge in th
Insert an AND function
in the range O9:O11
to decide whether it is a good decision to bu
Enter an OR
function in the P9:P11
to decide if you need to contact the supplier if one o
In the range Q9:Q11
enter a ROUND
function that rounds the Added Commission (colum
Fill column K
with an IFERROR
Function. You are summing up numbers in columns C and
Fill column L
with a formula that multiplies the Tax (cell O3
) by the Total in column F. Us
Having Problems with ExPrep? ExPrep monitors all file submissions. If you submit someone else’s work, the software flags it as a possible integrity violatio
grade of zero. “Borrowing a friend’s computer” and accidently submitting your friend’s project instead of your own is not result in a zero for the project. For this reason, if you use a shared computer, it is advisable to learn how to save your work
Take a screenshot and email: contact@excelpreparation.com
nd Functions - HomeWork
harge, I1 should display the message "No".
display the message "Added Charge".
column H is greater than $750, J1 should display the message "Reject".
display the message "Accept".
nformation found in column J)
charge (information found in column I)
d game is less than $20 (information found in column E).
oard game is greater than 50 (information found in column D).
Workbook to ExPrep by using the side menu. You have 2 trials for this assignment.
y the quantity
. uct of each board game's price and quantity.
t
in column F by the Commission Amount in cell
O4
. (Hint: Use e H6:H43.
orksheet.
he range C6:C43
of your worksheet.
uy the board game or not. The conditions to be met are:
of the below conditions are met:
mn H) for the three videos to the nearest 1 decimal place.
d H. However, if an Error occurs, your formula is going to simply return the value "Error".
se absolute references.
Points
5
5
5
5
5
10
10
5
5
5
5
10
10
5
5
5
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
A company pays a 3% annual bonus to employees who have been with the company more than 5 years; other employees receive a 1% bonus. Which control structure would an algorithm use to calculate every employee’s bonus?
a. selection
b. repetition
c. both selection and repetition
arrow_forward
The condition to press the buttons in front of two competitors after reading the question in a quiz. They can answer questions with. When the button is pressed, the competitor who pressed first the light is on (when the digital is 1, the lamp lights up). 10 seconds to answer the question there is. If the question is not answered after the time is over, the lamp in front of the competitor turns off and the second The contestant can answer the question by turning on the lamp in front of him by pressing the button. As a result of pressing the button in front of the competition, the game of all competitors can be rotated. (When the buttons are pressed, the digital zero signal goes to the microcontroller.) Write the necessary software for the relevant competition with Arduino.
arrow_forward
An ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for
checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o
must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10-
digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not.
Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176
Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN.
Note: When the check digit turns out…
arrow_forward
The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees.
Group of answer choices
True
False
arrow_forward
Q2/
A teacher decided to sign students' papers with letters according to their
degrees out of 100 if the degree >90 he gives “A", and if the degree >80
he gives “B", and if the degree <80 he gives pass .
design decision table for the above system.
arrow_forward
Problem 2
Concert Tickets
8 points
There are three tickets for a concert. The VIP tickets cost $120, premium tickets cost $80, and
regular tickets cost $40. Prompt the user how many tickets of each category he would like. Then
print an invoice with overview of the order and total price. Include a sales tax of 9.25%.
How many tic kets would you like to order?
VIP Tickets ($120): 0
Premium Tickets ($80) : 4
Regular Tickets ($40): 2
Invoice:
$120 x 0= $ 0.00
$ 80 X 4 = $320.00
$ 40 x 2 = $ 80.00
9.25% $ 37.00
VIP:
Premium:
Regular:
Sales Tax:
Total Price:
$437.00
arrow_forward
Purpose: One of the most commonly made decisions is based on comparing the means of multiple conditions. Significance tests for comparing means are critical in the decision making process. In this assignment, you will practice how to use t tests and ANOVA tests to compare the means of multiple conditions under one independent variable in different experiment design (between-group and within-group)
Tasks: Please write an R script that performs the following operations in the order
listed. At the beginning of each task, write a comment marking the task number.
Name the file as: lab6-<your last name>.R
ANOVA tests
8. Import the 'iris.csv' dataset. Browse and understand the data in each column 9. Compute descriptive statistics and create boxplot for sepal length and
species.
10. Select the appropriate test to determine whether there is significant difference in sepal length between the three species. Follow the steps of ANOVA analysis. Make sure you check whether the assumptions are…
arrow_forward
Solve the following using multiple selections structure. Draw a flowchart only.
A certain store is having a sale and the discount rate is based from the product code (it could be 1, 2, 3 or 4). If the code is 1, the discount rate is 10%; else if the code is 2, the discount rate is 7%; else if the code is 3, the discount rate is 5%; else if the code is 4, the discount rate is 3%. Draw the flowchart that represents the logic of the program which accepts the product code, unit price and quantity of the product purchased by a customer. The program should compute and display the discount and the discounted price and the amount payable by the customer.
arrow_forward
_____ Order repeats the finite number of steps over and over till the condition is not meet
arrow_forward
The most important rule when assigning
wherein the assignment operation always
takes place from right to left, and never the
other way.
Answer:
arrow_forward
Business Scenario:
"Tasty Burgers", a very fast-growing burger outlet in Melbourne has approached your company
(Software Inc) to help their business by providing the required IT solutions.
Tasty Burgers - Manager Jim has given the following brief about their current business practices
and their expectations:
The burger outlet started in 2010 has seen very steady growth over the past decade. Their main item
and the most popular among the locals are the burgers, the outlet also serves hot chips and cold
drinks. Currently, the restaurant uses a POS (Point of Sales) system to take orders.
Hugely attracted by the self-ordering kiosks at other popular fast-food restaurants, the management
of Tasty Burgers wanted to implement a similar system at their outlet.
During an earlier meeting with your manager (Tom), Jim has been briefed about the challenges in
implementing a full-fledged self-ordering kiosk as a single project. Therefore, it has been decided to
break the project into 4 stages (A, B,…
arrow_forward
Overdue tasks are highlighted in
Select an answer:
green
yellow
orange
red
arrow_forward
Assignment-5
Create flow chart and algorithm for following problem:
Check whether the inputted number is
a. Positive
b. Negative
C. zero
arrow_forward
Scheduling Goals: Select all of the following statements that are true.
The response time is the time required for a particular process to complete, from
submission time to completion.
The time that elapses in an interactive program from the issuance of a command
to the beginning of a response to that command is called the response time.
Throughput is the number of processes completed per time unit.
The waiting time is included in the turnaround time.
The concept of virtual (run)time in the Completely Fair Scheduler is used to
ensure fairness in the allocation of processor capacity.
In interactive systems, short response times are unimportant.
arrow_forward
By default, the first item to be shown in the drop-down list is
Pick a college :
Choose a college
Richfield
PC Training
Select one:
a. college
O b. Choose a college
O c. PC Training
O d. Richfield
arrow_forward
GreenLawn a local lawn care company has different pricing policies for its customers. GreenLawn sends out monthly invoices and will give discounts if payments are made within 5 days. The discounting policy is as follow: If the amount of the monthly bill is greater than $300, subtract 4 percent from the invoice; if the amount is between $300 and $100, subtract a 2-percent discount; if the amount is less than $100, do not apply any discount. All bills made via the web automatically receive an extra 3-percent discount. Develop a decision for GreenLawn discounting decisions. Decision Table submission: Include the initial table with all rules, and the most simplified table. Use different colors in the columns to easily show how columns are collapsed/simplified.
please do not provideo solution in image format thank you!
arrow_forward
There are two options for ending tasks and preventing deadlocks:
arrow_forward
Design pattern is a solution to repeatedly occurring problem in various context
Select one:
O True
False
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Related Questions
- A company pays a 3% annual bonus to employees who have been with the company more than 5 years; other employees receive a 1% bonus. Which control structure would an algorithm use to calculate every employee’s bonus? a. selection b. repetition c. both selection and repetitionarrow_forwardThe condition to press the buttons in front of two competitors after reading the question in a quiz. They can answer questions with. When the button is pressed, the competitor who pressed first the light is on (when the digital is 1, the lamp lights up). 10 seconds to answer the question there is. If the question is not answered after the time is over, the lamp in front of the competitor turns off and the second The contestant can answer the question by turning on the lamp in front of him by pressing the button. As a result of pressing the button in front of the competition, the game of all competitors can be rotated. (When the buttons are pressed, the digital zero signal goes to the microcontroller.) Write the necessary software for the relevant competition with Arduino.arrow_forwardAn ISBN (International Standard Book Number) is a 10 digit number that is used to identify a book. The first nine digits of the ISBN number are used to represent the Title, Publisher and Group of the book and the last digit is used for checking whether ISBN is correct or not. To uniquely identify a book a 10-digit ISBN number is used. The rightmost digit is checksum digit. This digit is determined from the other 9 digits using condition that 10d, + 9dz + 8dg + + d4o must be a multiple of 11 (where d, denotes the i" digit from the right). The checksum digit d; can be any value from 0 to 10: the ISBN convention is to use the value X to denote 10. Write a C program using pointers that receives a 10- digit ISBN, and computes the checksum, and reports whether the ISBN number is correct or not. Example: 007462542X = 10°0 + 9*0 + 8*7 + 74 + 6*6 + 5*2 + 4*5 + 3"4 + 2*2 + 110 = 176 Since 176 leaves no remainder when divided by 11, hence it is a valid ISBN. Note: When the check digit turns out…arrow_forward
- The Excel function =sin(A1) will calculate the sine of the value in cell A1. The value in cell A1 must be in degrees. Group of answer choices True Falsearrow_forwardQ2/ A teacher decided to sign students' papers with letters according to their degrees out of 100 if the degree >90 he gives “A", and if the degree >80 he gives “B", and if the degree <80 he gives pass . design decision table for the above system.arrow_forwardProblem 2 Concert Tickets 8 points There are three tickets for a concert. The VIP tickets cost $120, premium tickets cost $80, and regular tickets cost $40. Prompt the user how many tickets of each category he would like. Then print an invoice with overview of the order and total price. Include a sales tax of 9.25%. How many tic kets would you like to order? VIP Tickets ($120): 0 Premium Tickets ($80) : 4 Regular Tickets ($40): 2 Invoice: $120 x 0= $ 0.00 $ 80 X 4 = $320.00 $ 40 x 2 = $ 80.00 9.25% $ 37.00 VIP: Premium: Regular: Sales Tax: Total Price: $437.00arrow_forward
- Purpose: One of the most commonly made decisions is based on comparing the means of multiple conditions. Significance tests for comparing means are critical in the decision making process. In this assignment, you will practice how to use t tests and ANOVA tests to compare the means of multiple conditions under one independent variable in different experiment design (between-group and within-group) Tasks: Please write an R script that performs the following operations in the order listed. At the beginning of each task, write a comment marking the task number. Name the file as: lab6-<your last name>.R ANOVA tests 8. Import the 'iris.csv' dataset. Browse and understand the data in each column 9. Compute descriptive statistics and create boxplot for sepal length and species. 10. Select the appropriate test to determine whether there is significant difference in sepal length between the three species. Follow the steps of ANOVA analysis. Make sure you check whether the assumptions are…arrow_forwardSolve the following using multiple selections structure. Draw a flowchart only. A certain store is having a sale and the discount rate is based from the product code (it could be 1, 2, 3 or 4). If the code is 1, the discount rate is 10%; else if the code is 2, the discount rate is 7%; else if the code is 3, the discount rate is 5%; else if the code is 4, the discount rate is 3%. Draw the flowchart that represents the logic of the program which accepts the product code, unit price and quantity of the product purchased by a customer. The program should compute and display the discount and the discounted price and the amount payable by the customer.arrow_forward_____ Order repeats the finite number of steps over and over till the condition is not meetarrow_forward
- The most important rule when assigning wherein the assignment operation always takes place from right to left, and never the other way. Answer:arrow_forwardBusiness Scenario: "Tasty Burgers", a very fast-growing burger outlet in Melbourne has approached your company (Software Inc) to help their business by providing the required IT solutions. Tasty Burgers - Manager Jim has given the following brief about their current business practices and their expectations: The burger outlet started in 2010 has seen very steady growth over the past decade. Their main item and the most popular among the locals are the burgers, the outlet also serves hot chips and cold drinks. Currently, the restaurant uses a POS (Point of Sales) system to take orders. Hugely attracted by the self-ordering kiosks at other popular fast-food restaurants, the management of Tasty Burgers wanted to implement a similar system at their outlet. During an earlier meeting with your manager (Tom), Jim has been briefed about the challenges in implementing a full-fledged self-ordering kiosk as a single project. Therefore, it has been decided to break the project into 4 stages (A, B,…arrow_forwardOverdue tasks are highlighted in Select an answer: green yellow orange redarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE LProgramming Logic & Design ComprehensiveComputer ScienceISBN:9781337669405Author:FARRELLPublisher:CengageNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
- C++ for Engineers and ScientistsComputer ScienceISBN:9781133187844Author:Bronson, Gary J.Publisher:Course Technology PtrProgramming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning