In your formulas, you can include references to cells, ranges of cells, and whole columns or rows of data—including cells in other tables and on other sheets. Numbers uses the values in the referenced cells to calculate the result of the formula. For example, if you include “A1” in a formula, it refers to the value in cell A1 (the cell in Column A and Row 1). Show
Note: If your table uses categories and you add a new row within a range of reference cells, the formula results won’t include the new row unless you change the cell reference. The examples below show the use of cell references in formulas.
The formula below refers to a column by its header name, “Number of Guests,” and cell B2 in a table on another sheet. A-B-C-D-E-F-G-H-I-J-K-L-M-N-O-P-Q-R-S-T-U-V-W-X-Y-Z The first step of learning about spreadsheets is understanding the terminology you will encounter as you work through this lesson. The glossary below lists terms that are specific to spreadsheet applications. Terminology that we learned when we looked at wordprocessing (such as copy, paste, clipboard, etc.) also apply to spreadsheet applications.
When moving data from one cell to another in order to maintain the formulas of the original cell you must?When moving or copying data from one cell to another, in order to maintain the formulas of the original cell you must _____. simply complete the action. Excel maintains the formulas for you.
Which of the following Excel features recognizes a pattern in the data of a worksheet?Excel Flash Fill is a special tool that analyzes the information you are entering and automatically fills data when it identifies a pattern. The Flash Fill feature was introduced in Excel 2013 and is available in all later versions of Excel 2016, Excel 2019, Excel 2021, and Excel for Microsoft 365.
Which action should she take to copy a formula into an adjacent cell?Simply do the following: Select the cell with the formula and the adjacent cells you want to fill. Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Is a value that originates in a worksheet cell and that is represented in a chart by a data marker?Data point
A value that originates in a worksheet cell and that is represented in a chart by a data marker.
|