Question

D.Write one word for the following.
1. The addresses of the cells containing values
2. Built-in formulas in Excel
3. Linking of text values

4.Combination of relative and absolute references
5.
This error occurs when the wrong type of operand is used​

Answer 1

Answer:

1.Cell addresses

A cell reference, or cell address, 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.

2.Excel provides a large number of built-in functions that can be used to perform specific calculations or to return information about your spreadsheet data. These functions are organised into categories (text, logical, math, etc.) to help you to locate the function you need from the Excel menu.

3.

4.

5.

Explanation: