Excel Chapter 3

Question 1

By default, a column is inserted in this direction from the column containing the active cell.

Answer 1

left

Question 2

To delete a row, select the row and then click the Delete button in this group in the Home tab.

Answer 2

Cells

Question 3

With the options at this button’s drop-down list, you can clear the contents of the cell or selected cells.

Answer 3

Clear

Question 4

Use this button to insert color in the active cell or selected cells.

Answer 4

Fill Color

Question 5

Select data in a cell and this displays in a dimmed fashion above the selected text.

Answer 5

Mini Toolbar

Question 6

By default, numbers are aligned at this side of a cell.

Answer 6

Right

Question 7

Click this button in the Alignment group in the Home tab to rotate data in a cell.

Answer 7

Orientation

Question 8

The Themes button is located in this tab.

Answer 8

Page Layout

Question 9

If you type a number with a dollar sign, such as $50.25, Excel automatically applies this formatting to the number.

Answer 9

Currency

Question 10

If you type a number with a percent sign, such as 25%, Excel automatically applies this formatting to the number.

Answer 10

Percent

Question 11

Align and indent data in cells using buttons in the Alignment group in the Home tab or with options at this dialog box with the Alignment tab selected.

Answer 11

Format Cells

Question 12

You can repeat the last action performed with the command Ctrl + Y or by pressing this function key.

Answer 12

F4

Question 13

The Format Painter button is located in this group in the Home tab.

Answer 13

Clipboard

Question 14

To hide a column, select the column, click this button in the Cells group in the Home tab, point to Hide & Unhide, and then click Hide Columns.

Answer 14

Format