Exam 1: Getting Started With Excel

You have cut the range A1:A5,and want to paste it to C1:C5.Which of the following statements is true?

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

To open a workbook after you start Excel,you can use the Open Other Workbooks command on the Navigation bar.

After you delete a worksheet column,_____.

To show formulas instead of values,click on the Formulas tab in the ribbon,then in the Formula Auditing group,click on the Show Formulas option.

To move a worksheet,you can drag its sheet tab to the left or right.

In the formula =A8*$A$1,which of the following describes A8?

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin.What view are you in?

When you cut or copy a cell,it is cut or copied to which of the following?

How many actions does the Undo button let you reverse?

To print more than one copy of your worksheet,which tab would you go to?

When you insert a worksheet row,a row is inserted above the cell pointer and the sheet contents move downward.

Which of the following is true when you delete a cell?

To print worksheet contents across the length of a page,you can use portrait orientation.

If you specify that you want worksheet gridlines to appear on the screen,they will automatically appear on the printout as well.

Your worksheet is too wide to fit on one portrait page.What is the best way to fix this problem?

To see a preview of how a pasted value will look,which of the following would you use?

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

If you discover an error immediately after you have confirmed a cell entry,what of the following would you use next?

To customize the status bar,right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.