1. What is a range of cells?
2. Name the three types of cell references?
3. What do you mean by formula? Give example.
4. What do you mean by function?
5. Name the command used to format the cells according to a specified condition?
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.Relative Cell References.
Absolute Cell References.
Mixed Cell References.
4. A technical definition of a function is: a relation from a set of inputs to a set of possible outputs where each input is related to exactly one output. We can write the statement that f is a function from X to Y using the function notation f:X→Y.
5 . Answer: Conditional Formatting (CF) is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.
3. A formula is an expression telling the computer what mathematical operation to perform upon a specific value. ... 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.
Answer:
1. A cell range in an Excel file is a collection of selected cells. ... In a spreadsheet, a cell range is defined by the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range.
2. Relative Cell References.
Absolute Cell References.
Mixed Cell References
3. A formula is an expression telling the computer what mathematical operation to perform upon a specific value. ... 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.