Microsoft Excel Final

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

False

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

False

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

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

true

the percent style formats numbers as a percentages with ___ decimal places

zero

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

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 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 use the windows start menu to start excel, it opens backstage view

False

the comma style format adds a comma and a dollar sign to a cell value

False

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

False

to change the color of cell content, you use ____ color list arrow

font

Which of the following lets you apply bold formatting to a selected cell

format cells dialog box, mini toolbar, home tab

to copy a cells formatting to another cell, what do you use

format printer

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

function

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

To print a worksheet, you begin by going to the backstage view

true

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

true

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

true

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

you use conditional formatting to format a cell based on its value

true

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

AutoFit resizes the column to the widest cell entry

What feature can be used to insert the total expenses at the end of a column

AutoSum Button

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

False

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

Page Break View

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 move a worksheet, you can drag its sheet tab to the left or right.

True

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

double click the the cell or click in the formula bar

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

False

The default worksheet text is _____-point Calibri.

11

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

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)

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

Clipboard

Changing a worksheet window to normal view changes the contents of the worksheet

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

to apply a cell style, you would use the cell styles command on the ____ tab

Home

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

To paste copied cell contents with values only, not including format, what can you use?

Paste options button, paste special

Which of the following functions inserts the total of a range

SUM

Which of the following is true about moving cell contents

You can move cell contents using a drag and drop feature

When you underline cell content, you are using _____.

a font style

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

argument

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

cell reference

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

color

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

it follows the order of operations

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

paste

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

paste the same format multiple times

Which of the following is true about deleting a worksheet row

to delete a row, you can select the row, and then click the delete button in the cells group