Hamna_Mustafa_Excel Assignment # 3 - Homework

.xlsx

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

Report
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