Answ
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?
Answers
Answer:
c 66txt76tt7x7d7tx66fuyx6xt6r6
Answer:
a. You enter three types of data in cells: labels, values, and formulas.
Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
Values (numbers) are generally raw numbers or dates.
b
i.) 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.
ii.) 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. ... Eventually separate cells can be added to this selection, then the range is called an irregular cell range.
C.) Let us discuss in detail the function of each type of operator.
Arithmetic Operators. It includes basic arithmetic operations like addition, subtraction, multiplication, division, modulus operations, increment, and decrement. ...
Relational Operators. ...
Logical Operators. ...
Assignment Operators. ...
Bitwise Operators.
D.) The various types of functions are as follows:
Many to one function.
One to one function.
Onto function.
One and onto function.
Constant function.
Identity function.
Quadratic function.
Polynomial function.
E.) Creating a Formula for a Single Worksheet
Select the cell where the results should be displayed.
To begin the function, press [=].
Click the first cell to be included. OR. ...
Type the first operator. ...
Click the next cell to be included. ...
Repeat steps 4–5 as necessary to complete the formula.
When finished, press [Enter].