Ch. 3 Excel Vocab
goal seek
Create a spreadsheet in Excel that has your data. Click the cell you want to change. ... From the Data tab, select the What if Analysis... ... Select Goal seek.. ... In the Goal Seek dialog, enter the new "what if" amount in the To value text box. ... We also need to tell Excel which cell to change. ... Click OK.
data labels
Data labels make a chart easier to understand because they show details about a data series or its individual data points
auto-fill options
Drag the fill handle to fill data into adjacent cells. Select the cells that contain the data that you want to fill into adjacent cells
sparkline chart
Sparklines are graphs that fit in one cell and give you information about the data.
nested IF function
The IF function can be nested, when you have multiple conditions to meet. The FALSE value is being replaced by another If function to make a further test. For example, look at the formula below.
category names
To create a chart sheet that uses the default chart type, select the data you want to plot, and then press F11
paste options
To launch the Paste Special dialog box, execute the following steps. 1. Select cell B5, right click, and then click Copy (or press CTRL + c). 2.
drag and drop
To move some information in Excel using drag and drop, first select the cells you want to move
IF function
Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it's false.
sparkline
a very small line chart, typically drawn without axes or coordinates
relative cell reference
cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns.
chart filters
hide data on the grid, table filtering, filtering using table slicers, and filtering directly from the chart.
NOW function
it can be used to quickly add the current date - and time if desired - to a worksheet or it can be incorporated into a variety of date and time formulas as shown in the image above.
rotate text
rotates text 90 degrees counterclockwise
assumptions
values in cells that you can change to determine new values for formulas
what-if assumptions table
By using what-if analysis tools in Microsoft Excel, you can experiment with several different sets of values in one or more formulas to explore all the various results.
mixed reference
A mixed cell reference is either an absolute column and relative row or absolute row and relative column.
data series
A row or column of numbers that are plotted in a chart is called a data series. You can plot one or more data series in a chart. To create a column chart, execute the following steps.
absolute cell reference
An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both
split window
Select the cell where you want to split the worksheet. In our example, we'll select cell C7. ... Click the View tab on the Ribbon, then select the Split command. Clicking the Split command. The workbook will be split into different panes.
inserting and deleting rows and columns
Select the row above or the column to the right of where the insertion should occur. ... Choose Home→Cells and click the arrow to the right of the Insert button to open the drop-down list for the Insert button. From the menu, choose Insert Sheet Rows or Insert Sheet Columns.
freeze panes
Select the row below the row(s) you want to freeze. In our example, we want to freeze rows 1 and 2, so we'll select row 3. ... Click the View tab on the Ribbon. Select the Freeze Panes command, then choose Freeze Panes from the drop-down menu. ... The rows will be frozen in place, as indicated by the gray line.
format painter
Select the shape, text, picture, or worksheet cell with the formatting you want to copy. Click Home, and in the Clipboard group, click Format Painter