2024 – Open this Excel workbook titled Fundraiser Receipt and save the worksheet as FirstInital LastName School expenses xlsx Add a column to
Spreadsheet Applications – 2024
- Open this Excel workbook titled “Fundraiser Receipt” and save the worksheet as “FirstInital_LastName_School expenses.xlsx.”
- Add a column to the right of the “Last Name” column and name as “Full Name.” Use the Concatenate function to join First Name and Last Name together split by a space.
- Click here for more information on how to use the concatenate function.
- Sort Columns C (C2:C21), using A-Z formatting.
- Using the Conditional Formatting, determine which students have provided over $50 for the fundraiser in Funds Received Column and also in 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.
- Click on any cell in (A1:E22), and apply a design to your data: In the Styles group, select Format as Table and use a dark formatting option.
- At Total row (E22 and F22), provide a Sum for the Funds Raised and Funds Pending.
- Add the Title “College Fundraiser Project” by inserting blank lines. Change the font size of the title 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.
2024 – Open this Excel workbook titled Fundraiser Receipt and save the worksheet as FirstInital LastName School expenses xlsx Add a column to.
Need assignment writing services that are 100% risk-free. Our writers are capable of providing the best assignment help to students in globally at best rates.