Question: please answer in excel form or document Assignment 2 In this assignment, you need to practice using Excel focusing on one theme, for example a
Assignment 2 In this assignment, you need to practice using Excel focusing on one theme, for example a Loan Analysis your own budget, an invoice, a home budget, an inventory, a trip planning, diet tracking etc. You must include ALL the following features functions.cach with at least one example in your assignment 1. financial function. 2. Date & Time function 3. Statistical function 4. Look up & Reference function, 5. Logical function. 6. Conditional formatting 7. Use Data Validation (Data->Data Tools) 8. Formatting your whok sheet properly, including number format, Merge & Center. Fill coler er Fill effect, and border 9. Use Freeze Panes 10. Use at least two Form Controls (under developer tab) and configure your choice of controls properly 11. Use ActiveX controls Button & Scroll Bar for inputting data and put code for your Button & Scroll Bar so that it will work properly. (optional) 12. Protect your sheet (please leave password blank) so that user can only enter data into the cells for input. 13. User Userform for inputting data (optional bonus point) In addition to the above requirements, you can add as many features as you want, and all your design should be integrated and aesthetic. It will be great if you can practice Whut-if Analysis and other Data Analysis. (Not required in this assignment)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
