Question

IV. Short Answer Questions:
1. What are the points to be taken care of while writing the format of a function in
MS Excel?
2. What is meant by cell reference?
3. Define Sheet Tab.
4. Explain the term “Range of Cells' in a spreadsheet.​

Answer 1

Answer:

ans1.

1. Each function must begin with an 'equal to' (=) sign.
2. Parenthesis is used to indicate the opening and closing of a function.
3. Arguments are written within the parenthesis.
4. Commas are used to separate the arguments

Explanation:

ansb.

A cell reference, is an alphanumeric value used to identify a specific cell in a spreadsheet. Each cell reference contains one or more letters followed by a number. The letter or letters identify the column and the number represents the row.

ansc.

In Microsoft Excel, a sheet, sheet tab, or worksheet tab is used to display the worksheet that a user is currently editing.

ansd.

A cell range in an Excel file is a collection of selected cells. ... In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range.

please mark me as brainliest

Answer 2

Answer:

2) Cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

3) In Microsoft Excel,a sheet, sheet tab,or worksheet tab is used to display the worksheet that a user is currently editing.

Hope it helps you