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

MS Excel

Share With

---

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 "$"