FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 10: Excel_Module_3

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 32

True/False

Review LaterAdd Note

Review Later

You can select nonadjacent ranges using the SHIFT key.

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

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

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.

Cell references in a formula are called ____.

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

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

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

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

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

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?​

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

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.

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.​__________

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

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

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

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

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