Microsoft Excel Worksheet
Budget: £750 – £1,500 GBP
Microsoft Excel Minimum Requirements:
Create an Excel workbook on your subject matter.
Use a worksheet with a minimum of ten columns and ten rows.
Use a minimum of ten column titles, Arial 10 pt, Bold, Fill color of your choice.
Use a minimum of ten row titles. Arial 10pt.
Use the min, max, and average functions.
Create formulas in at least four cells (formulas are DIFFERENT from the functions in the step above) (+, -, x, ÷).
Create a title for the worksheet merging and centering the text of a minimum of six cells.
Format title with Arial, 14 pt, bold, italics, the font color of your choice.
Apply borders to merged cells.
Rename the Sheet Tab.
You must include a picture on your first tab relevant to your topic.
Create 2 Graphs (Bar/Column, Pie Chart, or Combo) with the data. After created – move those to a new tab.
Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)
Save your Excel workbook as your last name_final Excel.
Item needs to be submitted as an excel workbook
Examples to receive more than a 3. Use of Pivot Tables, Pivot Chart, Slicer, Formulas, or Functions that pull data from multiple sheets, etc.
Create an Excel workbook on your subject matter.
Use a worksheet with a minimum of ten columns and ten rows.
Use a minimum of ten column titles, Arial 10 pt, Bold, Fill color of your choice.
Use a minimum of ten row titles. Arial 10pt.
Use the min, max, and average functions.
Create formulas in at least four cells (formulas are DIFFERENT from the functions in the step above) (+, -, x, ÷).
Create a title for the worksheet merging and centering the text of a minimum of six cells.
Format title with Arial, 14 pt, bold, italics, the font color of your choice.
Apply borders to merged cells.
Rename the Sheet Tab.
You must include a picture on your first tab relevant to your topic.
Create 2 Graphs (Bar/Column, Pie Chart, or Combo) with the data. After created – move those to a new tab.
Make sure your submission is visually appealing and has a similar theme (colors etc. as your other submissions)
Save your Excel workbook as your last name_final Excel.
Item needs to be submitted as an excel workbook
Examples to receive more than a 3. Use of Pivot Tables, Pivot Chart, Slicer, Formulas, or Functions that pull data from multiple sheets, etc.