0
It is using cells in addition calculations instead of actual values. So if you wanted to add 5328 and 61134 on a spreadsheet you could do a straight calculation like this:
=5328 + 61134
That will work, but it is not very flexible, as if you wanted to add any other two numbers you would have to do a new formula and while you can see the total, you can't easily see the values used in the formula. The formula is also fixed, so it is no use for any other two value and so it cannot be copied. So what is done is to put the values into actual cells and use the cells in the formula.
So you could put the 5328 in cell A2 and the 61134 in B2 and then have the following formula:
=A2+B2
Now you will still get the same answer, but you can see the two figures on the spreadsheet. You can change the figures in the cells and the formula will add whatever values are in those cells. You can also copy the formula to use it for other values. Using this format is cell addition.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What is cell reference that contain numeric data?
a. Write down the cell reference of a cell the contains numeric data
A numeric value that originates in a excel worksheet cell is called a data?
A worksheet cell with a numeric value is called a data point.
When you type numeric data in a cell Excel automatically positions the entry in the cell?
Right-aligned
What are differences between data types numeric and non numeric?
Numeric data are data that can be quantify. i.e age, e.t.c While Non-numeric data are data that cannot be quantify but can be categorise. Such as colour, name e.t.c
When you enter numeric data in a cell Excel recognizes the values as numbers and what the values?
It formats the values.
What is the difference between numeric data and non-numeric data?
Numeric data are numbers (like age, cost, etc.), while non-numeric data are not numbers (like name, address, etc.).
Define numeric data?
Numeric data refers to any data that is represented as numerical values, such as integers, decimals, or fractions. This type of data is used for quantitative analysis and calculations in various fields such as mathematics, statistics, and science. Numeric data can be manipulated and processed mathematically to uncover patterns, trends, and relationships within the data.
What are the 2 types of data allowed in QBASIC?
the two types of data used in Qbasic is numeric data and alpha numeric data.
How would you describe a spreadsheet?
quantitative tool wherein data in cell locations are placed in rows and columns in matrix format. That makes data easy to structure. Rows and columns can be individually designed. Cell contents can be numeric data, alphanumeric data, or algorithms.
When does a cell contain the number symbol?
The pound (#) or number symbol will appear when the column is not wide enough for the numeric data it holds.
When a total number of characters of numeric data is greater than the column width of cell what is displayed?
The hash symbol is displayed, like this: ############
When the total number of characters of numeric data is greater than the column width of a cell what is displayed?
The hash symbol is displayed, like this: ############
