Exam 10: Excel_Module_3

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

Cell references in a formula are called ____.

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -You can replace a formula with its function so it remains constant.​__________

A(n) ____________________ cell reference instructs a paste operation to keep the same cell reference as it copies a formula from one cell to another.

You can press the CTRL+ACCENT MARK(`) keys to display the formulas in a worksheet. _________________________

The Linked Pictures option in the Paste Options gallery copies an image of the source area as a picture so that a change to the cells in the source area updates the picture in the destination area.

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -Which of the following patterns extends the fill series to 525, 475, 425?​

Following the insertion of a row, the Insert Options button lets you select from which of the following options?

Panes created using the vertical split bar scroll together horizontally. ________________________

Which of the following is an extension of the fill pattern Sunday, Tuesday?

You can select nonadjacent ranges using the SHIFT key.

Charts can either be embedded in a worksheet or placed in a separate ____.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

The ____________________ option on the Auto Fill Options menu fills the destination area with a series that uses the format of the source area.

You can press the ____ keys to open the Format Cells dialog box.

Case 3-1 ​ George runs a mid-size accounting practice and recently upgraded to Excel 2016. He expects sales to grow in the next few months during tax season. After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office. He will start with the Reception area, which has the most visibility. -You use the _____ sheet in the Format Cells dialog box to position data in a cell by centering it, for example.​

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.

When you magnify a worksheet, Excel enlarges the view of the characters on the screen and displays more rows and columns.

You know Excel is in Copy mode when a small plus sign appears next to the block arrow mouse pointer during a(n) ____________________ operation.