Excel Exam

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.

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

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

Which of the following is true about moving cell contents?

You can move cells using the drag-and-drop feature.

To format a range so that all values greater than $500 appear in red, which of the following can you use?

conditional formatting

You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.

hidden

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

hide

Which of the following lets you edit the contents of a cell?

Double-click the cell or click in the formula bar.

To move cell contents one space to the right, you can use the Increase Space button.

False

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

False

When you align a range, you combine the cells into one cell.

False

When you change cell contents to italics, you are changing the cell's alignment.

False

When you click a cell to insert a cell reference in a formula, you must type a(n) number to lock the cell reference in the formula.

False

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

False

When you enter a number, date, or time in a cell, it is left-aligned by default.

False

When you print in portrait orientation, the page is wider than it is tall.

False

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

False

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.

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

The Undo button on the Quick Access toolbar

Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats.

True

Currency is an example of a number format.

True

Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.

True

Flash Fill enters text based on patterns it finds in the data.

True

A _______ refers to a collection of characters with a similar, specific design.

font

Which of the following is a built-in formula that helps you perform complex calculations?

function

When you click the File tab and then click Print, which of the following elements appears in the preview of the worksheet printout?

worksheet data

The Percent style formats numbers as percentages with _____ decimal places by default.

zero

If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet.

hiding

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

holding the CTRL key while dragging the selected cells

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

(25+10)*50

To apply a cell style, you would use the Cell Styles command on the _____ tab.

Home

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

-Before you paste it, you only need to select cell C1. -After you paste it, the information is deleted from the original location.

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

-Home tab -Format Cells dialog box -Mini toolbar

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

-Left -Center

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

A button appears near the selected cells with options for pasting formulas and values.

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

AutoFit resizes the column to the widest cell entry.

Louis has entered a column of expense values. What feature can he use to insert the total expenses at the end of the column?

AutoSum button

How can you reverse your most recent action in Excel?

Click the Undo button.

To select a single worksheet cell so you can work with it, which of the following would you do?

Click the cell.

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.

Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?

Flash fill

To change the color of cell content, you use the ________ color list arrow.

Font

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

SUM

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

Page Break Preview

Which of the following tabs lets you set worksheet print options?

Page Layout

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

Page Layout view

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

True

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

True

To print a worksheet, you begin by going to Backstage view.

True

To enter a typed number into a cell, you can press Tab or Backspace.

False

To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider.

False

A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?

=COUNTA(B1:B20)

To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.

Color

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

-New command on the File tab -CTRL+N keys

To paste copied cell contents with values only, not including formatting, which of the following can you use? Select all the options that apply .

-Paste Special -Paste Options button

The default worksheet text is _____-point Calibri.

11

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

=COUNT(B1:B20)

To change the background color of a cell, you use the Background color button.

False

Which of the following can you use to insert a formula using a function? Select all the options that apply.

All the Above

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.

Which of the following keys do you press to copy cells while dragging them?

CTRL

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

Change the page orientation to landscape.

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

Clipboard

Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?

Create a custom cell style.

When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?

Excel changes the cell references in the copied formula to reflect the new location of the formula.

A good practice is to move the most important worksheets to the end of the workbook.

False

A predesigned combination of formats, such as font size and color, is called a cell default.

False

Changing a worksheet window to Normal view changes the contents of the worksheet.

False

Decreasing a cell's indent moves its contents to the right one space.

False

If you want to paste values and number formatting only, click the Paste Numbers button that appears below the pasted cell.

False

In formulas, calculations in square brackets are calculated first.

False

The Comma Style format adds a comma and a dollar sign to a cell value.

False

To copy a cell's formatting to another cell, which of the following can you use?

Format Painter

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

It follows the order of operations.

To combine multiple cells into one combined cell, which of the following do you use?

Merge and Center button

The _____ displays the cell reference of the active cell.

Name 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.

Preview

Scaling

What must you do before removing a page break?

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

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

True

When you use the Windows Start menu to start Excel, it opens in Backstage view.

True

You can edit cell contents in the formula bar or in the cell itself.

True

You can set a scaling option to resize a worksheet to fit within a single page.

True

You use conditional formatting to format a cell based on its value.

True

When you underline cell content, you are using _____.

a font style

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

argument

You can use the Find and Replace dialog box to find and replace _____.

cell formatting

Which of the following indicates the column and row where a cell is located?

cell reference

When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.

paste