excel

Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?

$A$5

Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use?

-ROUND(AVERAGE(C3:C50),0)

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)

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)

The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed?

=IF(B2>=60, "pass", "Fail")

Cell A5 contains the number 24.7835. In another cell, Ariane wants to enter the number from cell A5 but rounded to two decimal places. Which of these formulas can she use to do so?

=ROUND(A5,2)

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.

Which of the following functions would you use to calculate the arithmetic mean of a price list?

AVERAGE

In the formula =B6*$B$2, which of the following describes $B$2?

Absolute cell reference

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

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.

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.

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

When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change?

Click the AutoFill Options button and then click Fill Without Formatting.

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.

While working in Page Layout view, how can you enter your name so it appears in the lower-right corner of the printout?

Click the footer section on the right and type your name.

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

Clipboard

What is the correct formula to insert the date January 12, 1998 into a cell?

DATE(1998,1,12)

Ian needs to extract the day of the month from the date entered as a serial number in cell A1. Which formula can he use to do this?

DAY(A1)

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.

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.

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

Excel updates their cell references to reflect the new layout.

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

False

AutoComplete can extend any data pattern involving dates, times, numbers, and text.

False

You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell?

Fill handle

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 copy a cell's formatting to another cell, which of the following can you use?

Format Painter

A _____ is a named operation that replaces the action of an arithmetic expression.

Function

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

Hidden

Myra does not want a worksheet of sensitive data to be available to other users, but she does want to use its data in formulas in other worksheets. What can she do?

Hide the worksheet.

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Highlight Cells Rules

Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use?

IF

Which of the following is a type of logical function?

IF

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

It follows the order of operations.

In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours?

MAX

To have Excel enter the lowest price from a range of prices, which of the following would you use?

MIN function

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

Merge and Center button

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.

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

Which worksheet view shows headers, footers, and rulers?

Page Layout view

You can edit a worksheet footer in _____.

Page Layout view

Eleanor wants to repeat the first row of the worksheet on each printed page of a four-page worksheet. Which of the following options should she use in the Page Setup dialog box?

Print titles

After inserting a new worksheet, what should you do to identify the purpose of the worksheet?

Rename the worksheet.

If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command .

Replace

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

SUM

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

Save As dialog box

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

Scaling

Which of the following dialog boxes do you use to remove a data series from a chart?

Select Data Source dialog box

What must you do before removing a page break?

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

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 constant is a term in an equation whose value does not change

True

Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns.

True

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

True

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

True

Arlo wants to use Goal Seek to answer a what-if question in a worksheet. Which button should he click on the Data tab to access the Goal Seek command?

What-if Analysis

When you underline cell content, you are using _____.

a font style

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

argument

Which of the following inserts a function into a cell?

autosum button

A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis.

axis title

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

b. font

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

cell reference

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

color

You need to add another product to your inventory worksheet, which shows product names in row A. Which of the following should you add?

column

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

conditional formatting

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

ctrl

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

false

To preserve an exact cell address in a copied formula, you can use a relative cell reference.

false

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

false

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

false

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

font

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

function

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

hide

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 apply a cell style, you would use the Cell Styles command on the _____ tab

home

he _____ displays the cell reference of the active cell.

name box

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

To which of the following chart types can you not add axis titles?

pie chart

If you want to print only part of a worksheet, you can set a _____.

print area

Which of the following chart types show how two numeric data series are related to each other?

scatter charts

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

scroll bars

To rename a worksheet, you change the text on the _____

sheet tab

Which of the following type of data can you wrap within a cell?

text

After you delete a worksheet column, _____.

the columns to its right shift left

A _____ chart displays each category of data in a rectangle and smaller rectangles within them for subcategories.

treemap

To rotate cell contents, you use the Orientation button in the Alignment group on the Home tab.

true

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

true

When you are using a workbook and want to open another one, you can display Backstage view and then click Open

true

To redisplay a hidden worksheet, you _____ the worksheet.

unhide

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 decimal places