0
b gfggrtgrer235fr35r35
Armand Stiedemann
Add your answer:
Earn +20 pts
What is a calculation involving one or more cell references in a spreadsheet?
It can be called a formula.
In a Spreadsheet what are equations you build yourself using values and cell references?
formulas
What are horizontal references in a spreadsheet?
Horizontal references in a spreadsheet are cell references that point to cells in the same row as the reference cell. This allows you to easily pull data or perform calculations across a row. They are denoted by a combination of row number and a column letter (e.g., A1, B1).
When cell references are copied and adjusted for each new position what is each adjusted cell reference is called?
Relative reference
What is A6 and E9 called in a spreadsheet?
They are both cell references. A6 is the cell where column A meets row 6. E9 is where column E meets row 9.
Cell references refer to cells by their fixed position in the worksheet?
Cell references in a spreadsheet are used to identify and locate a specific cell within a worksheet. There are two types of cell references: relative references, which adjust when copied to other cells, and absolute references, which remain fixed. By using cell references, formulas can automatically update and calculate based on changes made to the cells they reference.
What do you do when you have to do a long school assignment?
1. Range- a group of cells 2. Grid lines- horizontal and vertical lines in a spreadsheet 3. Numeric label- a number that is used as text in a worksheet rather than being used as a value (a number used for calculation) 4. Row- horizontal references in a spreadsheet ; identified by a number 5. Formula- a mathematical operation 6. Selecting- highlighting items within a spreadsheet 7. Auto sum- a formula that automatically adds up a column of number 8. Fill handle- dot at bottom right of each cell; used to copy information from cell to cell 9. Auto format- a predesigned format that adds design elements to the spreadsheet 10. Graph- visual representation of data within a spreadsheet 11. Label- text used in a spreadsheet and usually creates titles 12. Value- number identified in spreadsheet that are used in calculations 13. Cell- intersection of a column and row 14. Cell address- name of boxes (cells) in spreadsheet 15. Active cell- cell your currently working in 16. Sheet- one page in a spreadsheet 17. Sheet tab- a tab that identifies a worksheet 18. Spreadsheet- program used to perform calculations and present data 19. Work book- many worksheets in a spreadsheet 20. Column- vertical references in a spreadsheet; identified by an alphabetic
When new rows are added to an existing worksheet what do cell references do?
Cell references will adjust to suit the new situation so that all formulas still work correctly. This is essential, as a spreadsheet could not work in a practical manner if you needed to continually adjust formulas when insert or removing rows or columns.
An absolute cell reference is?
In spreadsheet applications, a reference to a particular cell or group of cells that does not change, even if you change the shape or size of the spreadsheet, or copy the reference to another cell. For example, in Lotus 1-2-3 and other spreadsheet programs, the cell reference "$A$3" is an absolute cell reference that always points to the cell in the first column and third row. In contrast, the reference "A3" is a relative cell reference that initially points to the cell in the first column and third row, but may change if you copy the reference to another cell or change the shape and size of the spreadsheet in some other way. Absolute cell references are particularly useful for referencing constant values (i.e., values that never change).
Where can you enter data in a spreadsheet?
in a cell
Can you copy cells with an absolute reference?
A relative cell reference is one that will change to a different cell if you copy the formula. An absolute reference is one that will always use the same cell. For example, say you have a percentage in cell B1 that you want to add to all the cells from A3 down. In cell B3 you could use the formula '=A3*(1+$B$1)'. If you copy this formula to the cells below B3, the reference to A3 will change to be the cell immediately to the left, because it is a relative cell reference. By adding the $ symbol before the B and the 1, however, an absolute reference is created. It will always refer to cell B1.
What is one location on a spreadsheet?
One location on a spreadsheet is called a "cell".
