00:01
Hello students, to perform the following task, initially open the microsoft excel and create a new workbook and rename the file using the last name and add the final project to the name.
00:18
Name as the final project.
00:26
The next step we perform is to click on the first worksheet in the workbook.
00:32
So enter at least 5 element titles in the first row using the times roman 12pt font, bold and font color other than black.
00:45
Enter at least of the 5 elements, 5 columns titles in the first row.
01:02
Now after using the times roman and the 12pt font, as the size of the font and with respect to the bold, the next step we follow is to enter at least 7 row titles in the first column.
01:38
Now enter the formula in at least 4 cells using the different formula for each.
01:58
For example, we can use for the sum, if, count, etc.
02:19
Now use the min, max, average functions on the separate sheet of the cells to calculate the average values respectively.
02:40
Later merge and center the text in the minimum of 5 cells.
03:05
Now format the title using the font of your choice and 14 as the 14pt size, bold, italic, and the font color other than black.
03:15
Now right click on the sheet tab at the bottom and rename and change the sheet tag name at your last name.
03:26
Now right click on the sheet tab again and tap to the color.
03:32
Choose the color to apply the sheet...