complete step 11 correctly in order to receive points for completing the next steps.
Open the start file EX2016-ChallengeYourself-2-4. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify […]
Compute the monthly cost of insurance.
Open the start file EX2019-ChallengeYourself-3-3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify it. […]
analyze loan payments.
In this project, you will be working with a workbook used to analyze loan payments. Skills needed to complete this project: • Naming Worksheets • Applying Themes • Changing the Color of Sheet Tabs • Changing the Worksheet View • Adding Headers and Footers • Freezing and Unfreezing Rows and Columns • Moving and Copying […]
analyze shoe sales data and use what-if analysis to determine your commission potential and your sales goal.
In this project, you will analyze shoe sales data and use what-if analysis to determine your commission potential and your sales goal. Skills needed to complete this project: • Converting Data into Tables • Adding Total Rows to Tables • Removing Duplicate Rows from Tables • Filtering Data • Sorting Data • Inserting a Line […]
complete a series of budget worksheets, including a home loan analysis, rental comparison, and savings and retirement planning.
In this project, you will complete a series of budget worksheets, including a home loan analysis, rental comparison, and savings and retirement planning. The fair market rent information in the Final FY2017 Virginia FMR worksheet was copied from the U.S. Department of Housing and Urban Development Web site at http://www.huduser.org. Skills needed to complete this […]