Introduction to excel 2010

You can activate a cell by

• Pressing the Tab key

• Clicking the cell

• Pressing an arrow key

• All of the above

How do you insert a row?

• Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

• Select the row heading where you want to insert the new row and select Edit >Row from the menu

• Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

• All of the above

Which of the following is not a basic step in creating a worksheet?

• Save workbook

• Modifiy the worksheet

• Enter text and data

• Copy the worksheet

To create a formula, you first:

• Select the cell you want to place the formula into

• Type the equals sign (=) to tell Excel that you’re about to enter a formula

• Enter the formula using any input values and the appropriate mathematical operators that make up your formula

• Choose the new command from the file menu

How do you delete a column?

• Select the column heading you want to delete and select the Delete Row button on the standard toolbar

• Select the column heading you want to delete and select Insert Delete from the menu

• Select the row heading you want to delete and select Edit>Delete from the menu

• Right click the column heading you want to delete and select delete from the shortcut menu

When a label is too long to fit within a worksheet cell, you typically must

• Shorten the label

• Increase the column width

• Decrease the column width

• Adjust the row height

Each excel file is called a workbook because

• It can contain text and data

• It can be modified

• It can contain many sheets including worksheets and chart sheets

• You have to work hard to create it

Which of the following methods can not be used to edit the contents of a cell?

• Press the Alt key

• Clicking the formula bar

• Pressing the F2 key

• Double clicking the cell

You can edit a cell by

• Clicking the formula button

• Double clicking the cell to edit it in-place

• Selecting Edit>Edit Cell from the menu

• None of above

To save a workbook, you:

• Click the save button on the standard toolbar from the menu

• Press Ctrl+F5

• Click Save on the Windows Start button

• Select Edit>Save