\begin{tabular}{|c|c|c|} \hline 2. & \begin{tabular}{l} a) Ensure your workbook has at least two worksheets with content (e.g. data, \\ formulas, functions, etc); chart / graph does not count ( 2 marks) \\ b) Name each tab (sheet) with an appropriate name ( 2 marks) \\ Note: You will have three worksheets when this assignment is done, two with the \\ data / content, and one sheet with only the chart / graph. \end{tabular} & 4 \\ \hline 3. & \begin{tabular}{l} Use the following formatting elements: \\ - A merged cell ( 2 marks) \\ - Cell formatting, specifically ( 2 marks for each; 4 marks total) \\ - Date \\ - Currency \\ - Two border styles ( 2 marks) \\ - Font formatting (e.q. appropriate size, alignment, etc) (up to 4 marks; 0 \\ for poor formatting to 4 for properly done) \\ - Worksheets are proofread and spelling error free ( 1 mark deduction for \\ each error) \end{tabular} & 14 \\ \hline 4. & \begin{tabular}{l} Formulas \\ Ensure the following with formulas are present in your spreadsheet to calculate \\ cell values ( 3 all or nothing marks each): \\ - A formula that uses addition, subtraction, multiplication and division (e.g, a \\ value times another value) \\ - A formula that includes an absolute cell reference \end{tabular} & 6 \\ \hline 5 & \begin{tabular}{l} Functions \\ Use the following functions in your spreadsheet ( 3 all or nothing marks each): \\ - SUM \\ - MVERAGE \\ - VAO \\ - Use one of the following: IF, COUNTIF, SUMIF, AVERAGEIF \\ BONUS: Use XLOOKUP for 6 marks instead of VLOOKUP with IFNA, and earn 2 \\ bonus marks (up to a total of 8 marks) \\ Create a 3D formula or function a a \end{tabular} & 18 \\ \hline 6 & Create a 3D formula or function across the two worksheets (2 marks) & 2 \\ \hline 7 & \begin{tabular}{l} Use at least two different rules for conditional formatting to format a set of cells in \\ your worksheet ( 2 marks for each rule; 4 marks total) \end{tabular} & 4 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline 2. & \begin{tabular}{l} a) Ensure your workbook has at least two worksheets with content (e.g. data, \\ formulas, functions, etc); chart / graph does not count ( 2 marks) \\ b) Name each tab (sheet) with an appropriate name ( 2 marks) \\ Note: You will have three worksheets when this assignment is done, two with the \\ data / content, and one sheet with only the chart / graph. \end{tabular} & 4 \\ \hline 3. & \begin{tabular}{l} Use the following formatting elements: \\ - A merged cell ( 2 marks) \\ - Cell formatting, specifically ( 2 marks for each; 4 marks total) \\ - Date \\ - Currency \\ - Two border styles ( 2 marks) \\ - Font formatting (e.q. appropriate size, alignment, etc) (up to 4 marks; 0 \\ for poor formatting to 4 for properly done) \\ - Worksheets are proofread and spelling error free ( 1 mark deduction for \\ each error) \end{tabular} & 14 \\ \hline 4. & \begin{tabular}{l} Formulas \\ Ensure the following with formulas are present in your spreadsheet to calculate \\ cell values ( 3 all or nothing marks each): \\ - A formula that uses addition, subtraction, multiplication and division (e.g, a \\ value times another value) \\ - A formula that includes an absolute cell reference \end{tabular} & 6 \\ \hline 5 & \begin{tabular}{l} Functions \\ Use the following functions in your spreadsheet ( 3 all or nothing marks each): \\ - SUM \\ - MVERAGE \\ - VAO \\ - Use one of the following: IF, COUNTIF, SUMIF, AVERAGEIF \\ BONUS: Use XLOOKUP for 6 marks instead of VLOOKUP with IFNA, and earn 2 \\ bonus marks (up to a total of 8 marks) \\ Create a 3D formula or function a a \end{tabular} & 18 \\ \hline 6 & Create a 3D formula or function across the two worksheets (2 marks) & 2 \\ \hline 7 & \begin{tabular}{l} Use at least two different rules for conditional formatting to format a set of cells in \\ your worksheet ( 2 marks for each rule; 4 marks total) \end{tabular} & 4 \\ \hline \end{tabular}