Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
Homework answers / question archive / IS 312 Excel assignment 1 (XA1): 12 points; each question is worth 3 points Q1: References - "Thought exercise" with formulas being copied
IS 312 Excel assignment 1 (XA1): 12 points; each question is worth 3 points
Q1: References - "Thought exercise" with formulas being copied. NO COMPUTER USE: pure "brain exercise"
Q2: Mixed reference - Discounted prices for DezinedT
Q3: Mixed reference - Gradebook for IS 312 SP 2019
Q4: PMT function - Ron's auto loan payment schedule
Please do NOT use spreadsheet but perform a "thought analysis" to determine the new formulas at the destination cells (marked "*").
The arrows and "*" indicate the DESTINATION of the copy: TYPE the new formula in the cell indicated with "*".
* PLEASE do NOT move the cell of the given formula: the problem is supposed to be solved based on the given formulas in given cells.
Need to provide concise explanation, in the format that are given in Week 2 class.
Students are assigned different questions according to his/her last name:
DezinedT is a small shop that designs and prints T shirts for customers. The folloinwg on the left are the LName in H-M:
original prices, and the right are the discounted prices with 10%, 15%, and 20% discounts, respectively. Current pricing Discounted options
Write the formulas to calculate the discounted prices. Service Price 10% 15% 20%
* NOTE: ONE formula ONLY, then copy the ONE formnula to all needed cells. Plain 9 8.1 7.65 7.2
That is: write ONE formula in D10/K12/O4/R15 (for respective last name), that can be copied to the Standard 11 9.9 9.35 8.8
whole area within the double-line borders, that can obtain the numbers as shown. Designed 15 13.5 12.75 12
LName in A-C: Rows 4-6:
Current pricing Discounted options Format to show "$"
Service Price 10% 15% 20% LName in D-G:
Plain 9 8.1 7.65 7.2 Current pricing Discounted options
Standard 11 9.9 9.35 8.8 Service Price 10% 15% 20%
Designed 15 13.5 12.75 12 Plain 9 8.1 7.65 7.2 LName N-Z:
Rows 8-10: Standard 11 9.9 9.35 8.8 Current pricing Discounted options
Format to show "$" Designed 15 13.5 12.75 12 Service Price 10% 15% 20%
Rows 12-14: Plain 9 8.1 7.65 7.2
Submission format: Format to show "$" Standard 11 9.9 9.35 8.8
1. Display formulas (<Ctrl>-<~>) Designed 15 13.5 12.75 12
2. Shrink the columns that do not contain yhour work (example: for LName N-Z, can shrink columns A-N) Rows 15-17:
3. Print the spreadsheet with formulas (I do not need spreadsheet with values - ONLY formulas). Format to show "$"
Already member? Sign In
