In schools, there are more than 1000 students in various standards and divisions.It is difficult to maintain their data manually in registers.
That is why the management of schools uses MS Excel to maintain data of students. In the excel mark sheet, we have to manipulate the marks of students in various ways to evaluate their performance and give the result. But we can also give the range for more than 255 numbers too as an argument for the function, to sum up. We can select continuous cells or specify the range with the colon manually. The syntax for the AVERAGE function is the same as the SUM function. Now we will use the ROUND function to round the values to the nearest integer. ![]() We will wrap up the AVERAGE function with the ROUND function to round the number, which will be returned by the AVERAGE function. This is called NESTED IF in excel, also as we will use the IF function to give an argument to the IF function itself. Formatting Marks In Excel How To Make MarkHere we discuss how to make mark sheets in excel format using different functions (Sum, Average, Round, If, and COUNTIF) with example and downloadable excel sheet. CFA And Chartered Financial Analyst Are Registered Trademarks Owned By CFA Institute. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |