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

Authored by Carly Kehn

Computers

12th Grade

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

177 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

argument

function

labels

active cells

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Page Layout

Page Break Preview

Normal

Reading

MULTIPLE SELECT QUESTION

30 sec • 1 pt

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.

Click the Undo button on the Quick Access toolbar.

Click the Cancel button on the Formula bar.

Press CTRL+Z.

Press CTRL+Y.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

ALT

SHIFT

TAB

CTRL

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

=25+10*50

=25+10x50

=50x25+10

=50*(25+10)

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Preview

Home

Page Layout

View

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Zoom percentage

Scaling

Print selection

Gridlines

Access all questions and much more by creating a free account

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

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

54 questions

Analyzing Line Graphs & Tables

Quiz

•

4th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Computers

18 questions

[AP CSP] JavaScript Programming Lesson 2025-2026

Lesson

•

9th - 12th Grade

57 questions

[AP CSP] Unit 5 Review: Internet & Cybersecurity

Quiz

•

9th - 12th Grade

Microsoft Excel Quiz - Modules 1-7

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?

Access all questions and much more by creating a free account

Popular Resources on Wayground

Discover more resources for Computers