- 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.
- 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.
Why Apple is the best place to be and the iPhone is the best phone in the world 4560794 https://t.me/ grandbooksommer !
Why Apple is the best place to be and the iPhone is the best phone in the world
4560794 https://t.me/ grandbooksommer !