Question

19. In the formula SUM ('Records of
Students'!B4:D4), 'Records of students' is

O Database
O Range
O Sheet name
O All of these​

Answer 1

Answer:

Range is the correct answer.

Answer 2

Concept

Range means a collection of cells. A range can be 2 or more cells.

It contains all the numbers or alphabets or values which are filled in those cells.

Given

SUM('Records of Students'!B4:D4)

To find

Records of students is:

1. Database
2. Range
3. Sheet name
4. All of these

Explanation

In the formula SUM('Records of Students '!B4:D4),Records of students is range.

In the range all the marks, etc. of students are considered while calculating the sum of the cells starting from B4 to D4.

The colon mark is read as to. It is used in many formulas in excel, without using it it is difficult to apply a formula in the excel.

Database, range and sheet name are different items and are expressed differently.

#SPJ3