Review for Excel Chapter 1 True or False

Review for Excel Chapter 1

True or False The best way to make minor changes to existing data is to key new data and press the enter key

FALSE

True or False The primary advantage of the spreadsheet is to summarize text documents

FALSE

True or False A cell is the intersection of a row and a column

TRUE

True or False To select a group of cells, click each cell individually until all cells in the range have been selected

FALSE

True or False The active cell reference will appear in the tool bar

FALSE

True or False The GO TO command saves a file and exits Excel

FALSE

True or False Press F 2 to edit data in a cell

TRUE

True or False The Clear Command removes the contents of a cell

TRUE

True or False To change the cell to a decimal, select the Currency command from the Number Group.

FALSE

True or False Saving a spreadsheet file is very different from saving a Word Document

FALSE

Movement • To the Last Cell of Row that contains data

CTRL END

Movement • Up one Row

UP ARROW

Movement • To A 1

CTRL HOME

Movement • Down One Row

DOWN ARROW

Movement • Right one Column

RIGHT ARROW

Movement • Left one column

LEFT ARROW

Operations • Open an existing Spreadsheet file Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

Command from File Menu

Operations • Change the style of a cell to italics Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

Choose a button from the Home Ribbon

Operations • Move to a specific cell Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

F 5

Operations • Edit data in a cell Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

F 2

Operations • Save a spreadsheet Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

Chose a command from the File Menu

Operations • Clear data in a cell Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

Press the Delete Key or Choose a command in the Home Ribbon

Operations • Widen a spreadsheet column Choose a command in the Home Ribbon Press the Delete Key Choose a command from the File Menu Drag a double headed arrow Press F 5 Press F 2

Drag a Double Headed Arrow and Choose a command in the Home Ribbon