1.6 & Chapter Summary

Question 1

Accounting Number Format

Answer 1

Add a dollar symbol, any necessary commas, and a decimal point followed by two digits even if none are typed; right-align the number in the cell.

Question 2

Percent Style

Answer 2

Multiply the cell value by 100 and display the result with a percent symbol; right-align the number in the cell.

Question 3

Comma Style

Answer 3

Add any necessary commas and a decimal point followed by two digits even if none are typed; right-align the number in the cell.

Question 4

Increase Decimal

Answer 4

Increase the number of digits displayed after the decimal in the selected cell.

Question 5

Decrease Decimal

Answer 5

Decrease the number of digits displayed after the decimal point in the selected cell.

Question 6

Workbook

Answer 6

A filed created in Excel. Consists of individual worksheets.

Question 7

Cell

Answer 7

The intersection of a column and a row. Defined by horizontal and vertical gridlines.

Question 8

Cell Name (Cell Reference)

Answer 8

displays in the Name box at the left side of the Formula bar. Includes the column letter and row number.

Question 9

If data entered in a cell consists of text (letters) and does not fit…

Answer 9

it overlaps the cell to the right.

Question 10

If data entered in a cell consists of numbers and does not fit…

Answer 10

the numbers change to number symbols (###)

Question 11

Save a workbook

Answer 11

Click the save button on Quick access or by clicking File tab and then clicking “Save as” option. Click “Browse” and navigate to desired folder, type the workbook name in the File name text box, and hit Enter.

Question 12

To replace data in a cell

Answer 12

click in the cell and type new data

Question 13

To edit data in a cell

Answer 13

double click in the cell and make necessary changes

Question 14

Print a workbook

Answer 14

You hit print….

Question 15

Close a workbook

Answer 15

You hit close or Ctrl+F4

Question 16

Close Excel

Answer 16

by Close button or Alt + F4

Question 17

AutoComplete

Answer 17

inserts a previous entry automatically if characters match a previous entry.

Question 18

AutoCorrect

Answer 18

simply corrects many typographical errors

Question 19

Autofill

Answer 19

fill handle adds the same or consecutive data into a range of cells (the best one)

Question 20

Open a workbook

Answer 20

click the File tab and then click “Open”. At the Open backstage area, click the “Browse” option. At the Open dialog box, double-click the workbook.

Question 21

AutoSum

Answer 21

button in Editing group on the Home tab to find the total or average of data in columns or rows

Question 22

To select all cells in a column

Answer 22

Click the column header

Question 23

To select all cells in a row

Answer 23

click the row header

Question 24

Select all cells in a worksheet

Answer 24

click the Select all button to the left of the column headers

Question 25

Change column width

Answer 25

dragging or double-clicking the column boundary line

Question 26

Merge and center adjacent cells

Answer 26

by selecting them and then clicking the Merge & Center button in the Alignment group on the Home tab.

Question 27

Format numbers in cells

Answer 27

with buttons in the Number group on the Home tab

Question 28

The Tell Me feature

Answer 28

provides info and guidance on how to complete actions. The “Tell Me” text box is located on the ribbon to the right of the View tab.

Question 29

Using the Tell Me feature

Answer 29

click a hyperlink in a button ScreenTip, or press F1 to display the Excel Help window. At this window, type a topic in the search text box and then press the Enter key.

Question 30

Help Button

Answer 30

some dialog boxes and the backstage area contain a Help button that, when clicked, displays the information specific to the dialog box or backstage area.