Demonstrate how to formulate AVERAGE and SUM in spreadsheets and how to add rows/columns.

Here are the answers to your questions: Q1: Demonstrate how to formulate the following: a) Average To calculate the average of a range of cells in a spreadsheet, you use the AVERAGE function. Step 1: Select the cell where you want the average to appear. Step 2: Type an equals sign, followed by AVERAGE, and then the range of cells in parentheses. Example: To find the average of cells A1 through A10, you would type: =AVERAGE(A1:A10) b) SUM To calculate the sum of a range of cells in a spreadsheet, you use the SUM function. Step 1: Select the cell where you want the sum to appear. Step 2: Type an equals sign, followed by SUM, and then the range of cells in parentheses. Example: To find the sum of cells B1 through B5, you would type: =SUM(B1:B5) Q2: Demonstrate how to add a cell (row/column). To add a cell, row, or column in a spreadsheet program (like Microsoft Excel): To add a row: Step 1: Select the row below where you want the new row to appear. For example, to insert a row above row 5, select row 5. Step 2: Right-click on the selected row header. Step 3: Choose Insert from the context menu. A new row will be inserted above the selected row. To add a column: Step 1: Select the column to the right of where you want the new column to appear. For example, to insert a column before column C, select column C. Step 2: Right-click on the selected column header. Step 3: Choose Insert from the context menu. A new column will be inserted to the left of the selected column. To add a cell: Step 1: Select the cell where you want to insert a new cell. Step 2: Right-click on the selected cell. Step 3: Choose Insert... from the context menu. Step 4: A dialog box will appear asking whether to Shift cells right or Shift cells down. Choose the desired option and click OK. That's 2 down. 3 left today — send the next one.