Question 1

Which of the following are methods you can use to insert the AVERAGE function in a formula? Select all the options that apply.
A) AutoSum arrow
B) Insert Function dialog box
C) Insert Formula dialog box
D) Typing and using Formula AutoComplete

Accepted Answer

A) AutoSum arrow: This is the quickest way to insert the AVERAGE formula as it allows you to select the cell range and inserts the AVERAGE function automatically.
B) Insert Function dialog box: This is a more detailed approach to inserting the AVERAGE function as it provides options to select the function, choose the cell range, and set additional parameters.
C) Insert Formula dialog box: This is not a valid option as it only allows you to create custom formulas, and not select pre-existing functions like AVERAGE.
D) Typing and using Formula AutoComplete: This is a quick way to insert the AVERAGE function as you just start typing "=AVERAGE(" and Formula AutoComplete will provide suggestions based on the cell range you select.

Question 2

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

Accepted Answer

When you want to save a new workbook for the first time, you need to use the Save As dialog box to give it a name and choose a location to save it in. After the first save, you can subsequently use the regular Save command to save changes made to the workbook.

Question 3

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?
A) Leave the workbook closed.
B) Open the workbook, change the first worksheet, and save it using the Save command.
C) Open the workbook, make changes, and then save it using the same name.
D) Open the workbook, make changes, and then save it using a different name.

Accepted Answer

By opening the workbook, making changes, and then saving it using a different name, you can preserve the original version of the workbook while also creating a new version with your changes. This way, you can always refer back to the original version if necessary.

Question 4

Which of the following would you use to print only one page of a multipage worksheet?
A) Page Layout tab
B) Formulas tab
C) Backstage view
D) Page Setup dialog box

Accepted Answer

Backstage view, accessible via the File tab in Microsoft Excel, allows users to manage files and data about files, such as printing options, including the ability to select specific pages for printing.

Question 5

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.
A) reverse
B) transpose
C) fill
D) merge

Accepted Answer

To convert column data into row data and row data into column data, we use the transpose feature.

Question 6

Which of the following lets you fill a cell with only specific elements of a copied cell?
A) relative cell reference
B) Auto Fill Options button
C) argument
D) mode indicator
E) SHEET

Accepted Answer

The Auto Fill Options button allows you to choose which specific elements of a copied cell you want to fill a selected cell with, such as only copying the formatting or only copying the values. The other options listed do not provide this functionality.

Question 7

Which of the following appears in Page Layout view?
A) Text box containing the header
B) Margins
C) Page number indicator
D) Blue dotted lines indicating page breaks

Accepted Answer

The answer of Which of the following appears in Page...

Question 8

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

Accepted Answer

- Sheet
 - sheet
 - SHEET

Question 9

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?
A) Gridlines View
B) Gridlines Print
C) Headings View
D) Headings Print

Accepted Answer

By unchecking Gridlines View, the gridlines will no longer be visible on the screen. Gridlines Print only affects whether the gridlines will be visible when the worksheet is printed. Headings View and Headings Print control the display and printing of column and row headings, not gridlines.

Question 10

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?
A) sheet tabs
B) arguments
C) scroll bars
D) operators

Accepted Answer

Scroll bars allow you to move around a worksheet that is too large to fit on the screen at once. Sheet tabs allow you to switch between different worksheets in the same workbook. Arguments and operators are used in formulas to perform calculations.

Question 11

Which worksheet view shows headers, footers, and rulers?
A) Normal view
B) Page Break Preview
C) Page Layout view
D) Formula view

Accepted Answer

The Page Layout view shows headers, footers, and rulers. Normal view only shows the worksheet without these elements, while Page Break Preview shows the worksheet in a different format to help with printing. Formula view displays formulas instead of the actual values in the worksheet.

Question 12

When you open a workbook, it contains one or more worksheets.

Accepted Answer

When you open a workbook in Microsoft Excel, it contains one or more worksheets by default.

Question 13

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

Accepted Answer

Worksheet gridlines appearing on the screen do not automatically appear on the printout; you must specifically set the option to print gridlines in the Page Layout settings in Excel.

Question 14

Which of the following is true about pasting copied text? Select all the options that apply.
A) You can only paste one cell of the copied text at a time.
B) You can use the Paste button in the Clipboard group to paste the copied text.
C) Copied text is deleted from the clipboard after you paste it once.
D) You can view the copied text on the Office Clipboard.

Accepted Answer

You can paste the entire copied text at once with the Paste button in the Clipboard group. Also, you can view the copied text on the Office Clipboard, which allows you to paste multiple cells at once. A is false because you can paste multiple cells. C is false because copied text remains on the clipboard until you replace it with new copied text.

Question 15

Where do you rename a workbook and adjust its save location?
A) Save As dialog box
B) Home tab
C) Name box
D) Active cell

Accepted Answer

To rename a workbook and adjust its save location, you need to use the "Save As" dialog box. This is where you can specify the new file name and the location where you want to save it. You cannot perform this task on the Home tab, Name box, or Active cell.

Quiz 7: Excel

Which of the following are methods you can use to insert the AVERAGE function in a formula? Select all the options that apply.

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

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

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

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow.

Which of the following lets you fill a cell with only specific elements of a copied cell?

Which of the following appears in Page Layout view?

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

Which worksheet view shows headers, footers, and rulers?

When you open a workbook, it contains one or more worksheets.

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

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

Where do you rename a workbook and adjust its save location?