spread sheets
Weekly tasks or assignments (Individual or Group Projects) will be due by Monday and late submissions will be assigned a late penalty in accordance with the late penalty policy found in the syllabus. NOTE: All submission posting times are based on midnight Central Time.
Be sure to download the companion resources using the link provided in the reading assignments.
- You will determine the funds received and use the text to column feature (concatenate, apply conditional formatting, sort and filter data).
- You will determine your analysis and use sorting and filtering data, conditional formatting, as well as subtotals.
- Open this Excel workbook titled “Fundraiser Receipt” and save the worksheet as “FirstInital_LastName_School expenses.xlsx.”
- Add two columns to the right of the full name and rewrite the name as “Last Name, First.” Use the Concatenate function to join two or more text strings together.
- Click here for more information on how to use the concatenate function.
- Sort Columns C (A2:E22), using A–Z formatting.
- Using the Conditional Formatting, determine which students have provided over $50 for the fundraiser in both Funds Received and Funds Pending Column.
- The conditional formatting function allows you to apply different formatting options to data that meets certain conditions.
- Click here for more information on how to use the conditional formatting function.
- Highlight the entire data set (A1:E22), and apply a design to your data: In the Styles group, select Format as Table and use a dark formatting option.
- Apply the Total row from the Design tab, providing a Sum for the Funds Raised and Funds Pending.
- Add a Title column by inserting blank lines, change the font size of your data to 22, fill color with white background, darker 35%.
- Change the orientation to landscape.
- Name the worksheet “Fundraiser_Receipt_Solution.”
- Save the workbook. Close the workbook and then exit Excel. Submit your Excel spreadsheet.
References
Microsoft. (n.d.). Concatenate function. Retrieved from http://office.microsoft.com/en-us/starter-help/concatenate-function-HP010342288.aspx?CTT=3
Microsoft. (n.d.). Quick start: Apply conditional formatting. Retrieved from http://office.microsoft.com/en-us/excel-help/quick-start-apply-conditional-formatting-HA010370614.aspx
Please submit your assignment.
http://office.microsoft.com/en-us/starter-help/concatenate-function-HP010342288.aspx
https://support.office.com/en-US/Article/Quick-start-Apply-conditional-formatting-6b6f7c2a-5d62-45a1-8f67-584a76776d67?ui=en-US&rs=en-US&ad=US
Leave a Reply
Want to join the discussion?Feel free to contribute!