Question

Develop a marksheet in excel using different formula

Answer 1

Things to Remember about Marksheet in Excel

• Make sure to close the brackets for the IF function.

• While specifying any text in the function, please use double quotes (” “) as we have used while writing “Passed,” “Failed,” “ER,” etc.

1 – Comma Method

In this method, we use commas for specifying and separating the arguments. We have specified or selected various cells with commas.

2 – Colon Method (Shift Method)

In this method, we have used the ‘Shift’ key after selecting the first cell (E3) and then used the Right Arrow key to select cells until I3. We can select continuous cells or specify the range with the colon manually.

After entering the formula for the first student, we can copy down the formula using Ctrl+D as a shortcut key after selecting the range with the first cell at the top so that this formula can be copied down.