1)

a) b) c)

d)

e)

f)

A set of contiguous data cells is called a (hint: two words) When creating a series based on one or more selected cells (called filling a series), you can select from 4 series types. Match the type to its definition. Linear Growth [Choose ] This option creates a series that produces the same results as dragging the fill handle. Excel calculates the series values by incrementing each cell in the series of dates, designated by the Date Unit you select, by Value Add Excel calculates the series values by multiplying each cell in the series by the step value. Excel calculates the series values by adding the value you enter in the Step Value box to each cell in the series. Calendar Pull Down Series Multiplier Date Auto Fill [ Choose] The feature looks for correlation between data that you enter in a column and the adjacent data. If it identifies a pattern of data entry based on the adjacent column, it fills the rest of the column to match the pattern. Excel provides three merge options. What are they? Merge & Center Merge Across Merge Cells O Merge Down O Merge Previously Selected Merge & Remove You can change the text alignment, text control, text direction, and text orientation settings on the tab of the dialog box. The [an] which is available from the Formula tab of the Ribbon, displays all named objects in the active workbook