Exam 1: Getting Started With Excel

How many actions does the Undo button let you reverse?

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Luis wants to unhide and view all rows and columns in a worksheet. Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

To fit all worksheet content on one page, you can set page scaling in Backstage view.

What feature inserts a function that totals the cells above or to the left of the selected cell?

Which of the following appears in Page Layout view?

To enter data in a cell using examples already in your workbook, you can use the flash fill feature.

Which of the following statements is true about COUNT functions?

In the formula =SUM(A6:A9), which of the following best describes A6?

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.

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

Which of the following is true about pasting copied text? Select all the options that apply.

To save a workbook for the first time, you use the Save As dialog box.

Boris wants to remove a workbook window from his workplace. What series of clicks can he use to hide it?

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

Which of the following would you use to print only one page of a multipage worksheet?

Which of the following functions inserts the total of a range?

Which of the following inserts a function into a cell?

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

When you select a cell range, the cells must be adjacent to each other.