When you double-click the right border of a column heading, which of the following occurs?

AutoFit resizes the column to accommodate the widest cell entry.

Excel hides the column to the left of the double-clicked border.

AutoFit resizes the column to the default width of 8.43 characters.

Excel adds a column to the right of the double-clicked border.

Which of the following is true about adding cell borders?

You can add a border to the left, top, right, or bottom edge of a cell or range.

You cannot apply borders to all worksheet cells.

A cell border underlines the cell text, not the entire cell.

Borders are always single or double black lines.

Which of the following statements is true about COUNT functions?

The COUNT function returns the number of cells in a range that contain numeric data.

The COUNT function returns the number of calls in a range that are not blank.

The COUNT function returns the number of calls in a range that contain any data at all.

Using the COUNT function is useful for computing the average of a cell range.

In a complex formula, how does Excel determine which calculation to perform first?

It follows the order of operations.

It calculates the leftmost formulas first.

It calculates operations outside parentheses first.

Min has selected a cell range and then pasted the most recently copied formula into the range by using the Paste button in the Clipboard group. Which of the following applies to this situation?

A button appeared below the selected cells, providing options for pasting formulas and values.

They must adjust the cell references in the pasted formulas in the selected range.

The Auto Fill Options button appeared, providing options for pasting in the selected range.

They can preview the pasted formulas by pointing to each cell in the selected range.

Which of the following is not a way to move cell contents?

Press and hold CTRL while dragging selected cells to a new location.

Click the Cut button, right-click the selection, then click the Paste button.

Press CTRL+X, right-click the selection, then press CTRL+V.

Drag-and-drop selected cells to a new location.

Bohdan wants to cut the range A1:A5 and paste it to C1:C5. Which of the following statements is true? Select all the options that apply.

Before he pastes it, he only needs to select cell C1.

After he pastes it, the information is deleted from the original location.

Before he pastes it, he needs to select C1:C5.

After he pastes it, the information is deleted from the Clipboard.

Which of the following is not true about setting column width?

You can change the width of only one column at a time.

Column widths are expressed as the number of characters a column can contain.

The default column width is 8.43 standard-sized characters.

You can use the Format button in the Cells group to set an exact column width.

Which of the following is true about deleting a worksheet row?

Deleting a row removes both the data and the selected cells from the worksheet.

After you delete a row, the rows below it shift down one row.

Deleting a row and clearing a row have the same results.

Deleting a row removes the data but preserves the worksheet structure.

When you insert a column in a worksheet, what happens to formulas you already entered?

Excel updates the cell references in their fomulas to reflect the moved cell locations

Excel displays an error in the moved cells that contain formulas.

You need to manually update the cell references in the formulas of the moved cells.

Excel does not change the formulas in the moved cells.

After you delete a worksheet column, Excel removes the data from its cells and _____.

the cells to its right shift left to fill the vacated space

the cells below it shift up to fill the vacated space

preserves the worksheet structure

the cells to its left shift right to fill the vacated space

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 after opening the workbook?

Save it using a different name, and then make changes.

Copy the cells below the last line of data, and then make changes.

Change the first worksheet, and save it using the same name.

Save it using the same name, and then make changes.

Which of the following is true about deleting a worksheet? Select all the options that apply.

You can right-click a sheet tab and then click Delete on the shortcut menu.

Deleting a worksheet deletes any text and data it contains.

You can click the Delete button in the Worksheet group on the Insert tab.

You cannot delete a worksheet from a workbook.

To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?

Edit the conditional formatting rule.

Delete the conditional formatting rule.

Format the range in the Font dialog box.

Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin?

On the Margins tab of the Page Setup dialog box, change the number in the Left box.

On the Page Layout tab, set the Width and Height to Automatic and the Scale to 100%.

On the Page tab of the Page Setup dialog box, change the Orientation setting.

On the Margins tab of the Page Setup dialog box, click the Preset button.

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines

Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines

Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines

Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines

What must you do before removing a page break?

Select a cell below or to the right of the page break

Click the heading of the column containing the page break

Click the heading of the row containing the page break

You double-click the Format Painter button when you want to _____.

paste the same format multiple times

copy a cell's data to another cell

paste conditional formatting only

Microsoft Excel Quiz - Modules 1-7

Quiz

•

Computers

•

12th Grade

•

Practice Problem

•

Hard

Carly Kehn

FREE Resource

Print selection

Gridlines

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Popular Resources on Wayground

10 questions

Forest Self-Management

Lesson

•

1st - 5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

30 questions

Thanksgiving Trivia

Quiz

•

9th - 12th Grade

30 questions

Thanksgiving Trivia

Quiz

•

6th Grade

11 questions

Would You Rather - Thanksgiving

Lesson

•

KG - 12th Grade

48 questions

The Eagle Way

Quiz

•

6th Grade

10 questions

Identifying equations

Quiz

•

KG - University

10 questions

Thanksgiving

Lesson

•

5th - 7th Grade

Discover more resources for Computers

30 questions

Thanksgiving Trivia

Quiz

•

9th - 12th Grade

11 questions

Would You Rather - Thanksgiving

Lesson

•

KG - 12th Grade

10 questions

Identifying equations

Quiz

•

KG - University

18 questions

Thanksgiving Trivia

Quiz

•

4th - 12th Grade

20 questions

Thanksgiving

Quiz

•

KG - 12th Grade

28 questions

Ser vs estar

Quiz

•

9th - 12th Grade

10 questions

hands washing

Quiz

•

5th - 12th Grade

53 questions

US History Domain 1 Review CP 2025 (Tech Enhanced)

Quiz

•

9th - 12th Grade

Microsoft Excel Quiz - Modules 1-7

177 questions

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

Which of the following views shows how a worksheet will appear when printed?

If you discover an error immediately after you have confirmed a cell entry, which of the following could you do to reverse the error? Select all the options that apply.

Which of the following keys do you press to copy selected cells while you drag and drop the selected cells to their new location?

Which of the following formulas adds 25 and 10, and then multiplies the result by 50?

Which of the following tabs in the ribbon provides immediate access to worksheet print options such as changing orientation and scaling to fit?

Which of the following options can you set to make sure the active worksheet will print on one page?

Which of the following is the temporary storage area that holds selections you copy or cut?

To create a new, blank workbook, which of the following can you use? Select all the options that apply.

When you double-click the right border of a column heading, which of the following occurs?

Create a free account and access millions of resources

Popular Resources on Wayground

Discover more resources for Computers