Question

anaya has prepared marksheet to her class.she realised that she has forgotten to enter marks of one subject.how can she create space in the marksheet to enter those marks?​

Answer 1

Answer:

by using insert row/ insert column option in computer

Answer 2

Answer:

• To create space in the marksheet:
• Place the cursor near to the cell were we want to create space.
• Right click and select insert row/column.

Explanation:

• From the All programmes select the start menu  and the open the Microsoft excel .
• The horizontal cells are rows and the vertical cells are column will be given.
• The Columns are denoted as C1, C2, C3,........ and the rows are denoted as R1, R2, R3............
• The data or values of the marks of each subject was entered in the sheet by selecting the rows and columns.
• To find the sum, average, difference for the data entered various formulae are used.

The functions used in excel sheet were given below:

(1)  SUM Function

               Comma method

                Colon method

(2)  AVERAGE function

(3)  ROUND Function

                Arguments explanation

(4) IF Function

(5)  COUNTIF

                   Arguments

• While writing the IF Function we must close the brackets
• If we are typing any text in the function it should be written within the double quotes (" ").
• If we have forgot to enter the marks of one subject we can create the space by selecting the cell near to which we have to create the space and then right click and select insert row/column.
• By this way we can create the space in the marksheet.

#SPJ3