Answer the following questions:
(a) What is formula? Explain about the different types of categorisation of formula used in spreadsheet.
(b) What is AUTOSUM?
(C)What is sorting? Explain the different steps of sorting data in a worksheet.
Answers
Answer:
Explanation:
a] A formula is an expression telling the computer what mathematical operation to perform upon a specific value. When referring to computer software, formulas are most often used in spreadsheet programs, such as Microsoft Excel. Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet.
In the picture below is an example of a Microsoft Excel formula =SUM(A$1:A$3), which adds the total of cells A1, A2, and A3. In this formula, SUM is the function of the formula.
Formula in Microsoft Excel
b]When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. ... Here's an example. To add the January numbers in this Entertainment budget, select cell B7, the cell immediately below the column of numbers.
c]Here are the steps to sort data in a spreadsheet:
- Highlight the rows and/or columns you want sorted.
- Navigate to "Data" along the top and select "Sort."
- If sorting by column, select the column you want to order your sheet by.
- If sorting by row, click "Options" and select "Sort left to right."
a answer photo is given below
please help me my marking my answer as brainliest
Answer:
don't know the answers sorry