write a snort note on following term (1) range of cells (2) auto Fill (3) arithmetic operators (4) SUM function
Answers
Answer:
1) When referring to a spreadsheet, the range or cell range is a group of cells within a row or column. For example, in the formula =sum(A1:A10), the cells in column A1 through A10 are the range of cells that are added together. This type of range is referred to as an adjacent range since all of the cells are together.
2) Autofill is a software function that automatically enters data in web forms and spreadsheets. It should not be confused with autocomplete or autocorrect, which perform separate functions. Autocomplete finishes words or phrases while typing, and autocorrect automatically fixes spelling mistakes.
3) Overview. The basic arithmetic operations are addition, subtraction, multiplication, and division.
4) The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.