Access over 20 million homework & study documents

2022 Xa1

Content type
User Generated
Subject
Excel
School
ashford university
Type
Homework
Rating
Showing Page:
1/12

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/12

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/12

Sign up to view the full document!

lock_open Sign Up
Showing Page:
4/12

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 12 pages?
Access Now
Unformatted Attachment Preview
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 follow the "Submission format" given on each spreadsheet. "brain exercise" 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. Resize columns so your columns are wide enough to contain formulas, w Students are assigned different questions according to his/her last name: columns narrwed down. LName in A-C: =B1+C4*E$3/$D4 (Given above) * LName in D-G: =C2+D3*B$4/$C3 (Given above) * Copied to: cell with "*" (type formula there) LName in H-M: * =C4+B3*D$2/$E5 (Given above) Copied to: cell with "*" (type formula there) * =C4+B3*D$2/$E5 Copied to: cell with "*" (type formula there) LName in N-Z: * =B5+C6*E$4/$D3 (Given above) * * Copied to: cell with "*" (type formula there) wide enough to contain formulas, while unused *" (type formul ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4