Question

a. Explain the two different types of data present in Excel.
b. Define the following:
i. Cell reference
ii. Cell range
C. What are Operators? Name the different types of operators with examples.
d. What are Functions? Name the different types of functions.
e. How will you perform common calculations in a worksheet?​

Answer 1

Answer:

please make me Brainliest

Explanation:

1)A 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.

2)A cell range in an Excel file is a collection of selected cells. This range is usually symmetrical (square), but can exist of separate cells just the same. A cell range can be referred to in a formula as well.

3)Operators specify the type of calculation that you want to perform on elements in a formula—such as addition, subtraction, multiplication, or division.

4)A function in Excel is a preset formula, that helps perform mathematical, statistical and logical operations.

the different types of functions are:-

AutoSum;

IF function;

LOOKUP function;

VLOOKUP function;

HLOOKUP function;

MATCH function;

CHOOSE function;

DATE function;

5)How to do calculations in Excel

Type the equal symbol (=) in a cell. This tells Excel that you are entering a formula, not just numbers.

Type the equation you want to calculate. For example, to add up 5 and 7, you type =5+7.

Press the Enter key to complete your calculation. Done!