Excel Revision #01

How do you select an entire row?

• View>Select>Row from the menu

• Click the Row heading

• Hold down the CTRL key as you click

  anywhere in the row

• Hold down the SHIFT key as you click

  anywhere in the row.

To delete a column,

• Right click on the column heading then

  select Delete from the menu.

• Click on a column name and then press the

  DELETE key

• Select the cells which you want to delete,

  and then press the delete key on the

  keyboard

• Select the cells which you want to delete,

  and then press <Ctrl+Spacebar>

To select multiple cells, which keys are

held down while clicking the mouse?

• ALT or SHIFT

• ALT or CTRL

• SHIFT or CTRL

• ALT and SHIFT or CTRL

Which key is used to modify data in a

selected cell?

• F1

• F2

• F3

• F4

To select all cells in a worksheet press,

• <Ctrl+X>

• <Alt+V>

• <Ctrl+B>

• <Ctrl+A>

Which keystrokes must be used to copy

selected cells?

• <Ctrl+X> and <Ctrl+V>

• <Ctrl+C> and <Ctrl+V>

• <Shift+V> and <Ctrl+C>

• <Ctrl+Z> and <Ctrl+V>

What kind of program is Microsoft Excel

• Word processing

• Spreadsheet

• Database

• Graphics

Which of the following displays the cell

name

• Formula bar

• Status bar

• Ribbon

• Name box

What file extension will normally be used

for a file created by Microsoft Excel

• ppt

• xlsb

• xlsx

• exe

Which icon is used to change border

style

• 4

• 5

• 6

• 8