0
An input range could be the range of cells a function needs to be entered to do its task. Many functions use input ranges. If you wanted a sum of a range of cells and specified them in a range, that would be an input range. In the following example the cells from A2 to A20 are the input range:
=SUM(A2:A20)
Wiki User
∙ 10y ago
Wiki User
∙ 14y agoIt is the group of cells (range) you select that includes your data.
Add your answer:
Earn +20 pts
What are 3 requirements you need to identify when creating a spreadsheet?
Formatting of workplace documents. organisational guidelines on spreadsheet manipulation. Purpose and range of use of spreadsheet functions.
Used in place of a calculator to view range totals?
An electronic spreadsheet.
Is it true that a rectangular group of cells is called a range?
A rectangular group of cells in a spreadsheet can be called a range or a block.
What is a spreadsheet is often called?
It can be called a worksheet. There is a range of actual spreadsheet programs, so people often refer to them directly, like Excel or Quattro or Works or Open Office or Lotus 123, instead of using the term spreadsheet.
Is autocomplete fils in formulas and cell addresses across a range of cells?
No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.No. It finishes words you type in based on other values that may already be in the spreadsheet. Autofill can be used to fill in formulas and other values into a range of cells.
What is the software that has a range of builtin functions for statistical financial graphics?
The software is known as a spreadsheet.
What is the formula for selecting the lowest or highest value from a row of numbers in a spreadsheet?
There is no single formula. MIN(range) and MAX(range) are the Excel formulae
What rectangular space in a spreadsheet where data can be found?
A cell is the main answer, but you could also say a range.
What is range data?
Data Range is the values of the data from the minimum to the maximum that you are sampling.For plotting purposes(such as in EXCEL spreadsheet), it is the minimum and Maximum range of the values of X-Axis and Y-Axis.
Why are formulas used in Excel?
For doing a wide range of calculations and other data processing activities in a spreadsheet.
Adjacent cells in a row or column are called a?
In terms of a database, they would be a record. In a spreadsheet it would be a range.
How can you describe a set of data in a spreadsheet?
A set of data can be described to the spreadsheet as a range by specifying the beginning cell, in the upper left corner of the data, and the ending cell, in the lower right corner of the data.
