ITS 1000 SU Wk 3 Travel Expenses Formula Excel Spreadsheets Discussion For this discussion, you will need to address all of the questions below and be sure

ITS 1000 SU Wk 3 Travel Expenses Formula Excel Spreadsheets Discussion For this discussion, you will need to address all of the questions below and be sure to participate fully by responding to your classmates as well. Citations should be used to support your analysis and references should be included in APA format. Be sure to review the Discussion Question Guidelines before you begin!

Part 1 Hands-On Activities

Before you participate in the Discussion Area in Part 2, you need to complete hands-on activities in your TestOut Desktop Pro Plus courseware. The activities for this week are listed below and are accessible via their individual links.

• Please note, for each TestOut hands-on activity, you must click on the activity link from Brightspace, complete the activity in LabSim, and then click on Score Lab in LabSim for your score to be recorded in your Brightspace Grades for that activity. Failure to do so will result in a zero for that activity.
• You may attempt each activity multiple times, but you must start each attempt by clicking on that activity link from Brightspace. Your recorded score for that activity will be the highest score of all your attempts.
• All TestOut activities are combined for a total of 70 points weekly.

From your TestOut Desktop Pro Plus courseware, complete the following activities:

5.2.6 – Skills Lab: Create and Manage Workbooks
5.2.7 – Challenge Lab: Create and Manage Workbooks
5.3.5 – Skills Lab: Organize and Enter Data
5.3.6 – Challenge Lab: Organize and Enter Data
5.5.6 – Skills Lab: Format Cells
5.5.7 – Challenge Lab: Format Cells
5.6.6 – Skills Lab: Enter Simple Formulas
5.8.4 – Skills Lab: Display Data in Charts
5.8.5 – Challenge Lab: Display Data in Charts

• Please note, for each TestOut hands-on activity, you must click on the activity link from Brightspace, complete the activity in LabSim, and then click on Score Lab in LabSim for your score to be recorded in your Brightspace Grades for that activity. Failure to do so will result in a zero for that activity.
• You may attempt each activity multiple times, but you must start each attempt by clicking on that activity link from Brightspace. Your recorded score for that activity will be the highest score of all your attempts.
• All TestOut activities are combined for a total of 20 points weekly.

Part 2 Discussion

This week, you will be creating two Excel spreadsheets in one Excel workbook (file). Save the file as W4DQ_YourLastName (Excel will add the default of .xlsx to this name) and then Save often so you don’t lose any work! Name each worksheet descriptively.

Sheet 1 (which you will rename).

Create an itemized list of at least ten (10) items that you will need for your graduation party. Lay out your Excel spreadsheet following the example below. Make your columns as wide as you need to show all the information for that column by double clicking on the line between the columns or dragging the line between the columns. Cell B2 had the Wrap Text on the Home ribbon in the Alignment group turned on due to the length of the description. Only include numbers in the Cost per Unit, Quantity, and Cost columns so your calculations will work.

When you have entered your data, Sort your information by Item.
Share any questions about this or anything else in the Discussion Area.

Sheet 2 (which you will rename).

MS Excel is a great help with calculations which are completed using formulas. Remember, by typing an equal sign (=) into a cell, you are preparing Microsoft Excel to do a formula calculation. Refresh your memory on the use of formulas from this week’s assigned reading and the online lectures. For Sheet 2, think of a situation at home, work, or even a hobby or sport for which you could use a calculation and create a formula to solve a problem.

Open a spreadsheet in MS Excel and create your formula. Make sure you label components of your spreadsheet.
In the Discussion Area when you attach your file, describe the purpose of your formula and how it will help solve the problem it was designed to address. Share any challenges you had as well as tips for others.
Delete the unused worksheets by right clicking on them one at a time and choosing Delete.

By the due date assigned, make your initial post to the Discussion Area. By the end of the week, respond to at least two of your classmates.

In your discussion with your classmates, remember to respond substantively to two other students and to the instructor. For this assignment, you can respectfully share comments about layout, formatting, column widths, how to create any other formulas and what you might use them for, as well as other possible uses for Microsoft Excel. Include any helpful comments and let them know how you might benefit from the formulas they have created.