Excel

How do you insert a new 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

How do you select an entire column?

• Select Edit > Select > Column from the menu
• Click the column heading letter
• Hold down the shift key as you click anywhere in the column.
• Hold down the Ctrl key as you click anywhere in the column

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

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

How can you find specific information in a list?

• Select Tools > Finder from the menu
• Click the Find button on the standard toolbar
• Select Insert > Find from the menu
• Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

Which button can you click to add up a series of numbers?

• The autosum button
• The Formula button
• The quicktotal button
• The total button

To copy formatting from one area in a worksheet and apply it to another area you would use:

• The Edit>Copy Format and Edit>Paste Format commands form the menu.
• The Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu.
• There is no way to copy and apply formatting in Excel � You have to do it manually
• The Format Painter button on the standard toolbar

If the cell contains hashtags (#), what do you need to do?

• Expand the column
• Expand the row
• Change the formula

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

You can edit a cell by...

• Clicking the formula button
• Double clicking the cell
• Selecting Edit>Edit Cell from the menu
• None of above