E. Answer the following questions.
1.
Name the types of operators used in MS-Excel.
2. Which function is used to find the largest amongst given numbers?
3. What is the use of Auto Sum button?
4.
What are Formulas?
5.
Define Functions.
Answers
Answer:
1.Excel uses four different types of operators: arithmetic, comparison, text, and reference.
2.For finding largest number, the function large() is called with arguments num1, num2, and num3. The large() function has three parameters a, b, and c. The parameters will store the values of arguments.
3 If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.
4.A formula is an equation that makes calculations based on the data in your spreadsheet. Formulas are entered into a cell in your worksheet. They must begin with an equal sign, followed by the addresses of the cells that will be calculated upon, with an appropriate operand placed in between.
5.an activity that is natural to or the purpose of a person or thing.