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