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

The IF function can use which of the following comparison operators? Select all the options that apply.

> (greater than) Correct! = (equal), (not equal)

When you underline cell content, you are using _____.

a font style

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

absolute cell reference

Which of the following lets you extend any data pattern involving dates, times, numbers, or text?

autofill options button

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

average

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

axis title

What can you do to make data series easier to distinguish from one another?

change the color of the data series

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

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

color

To insert only the current date in cell B1, use the NOW function in cell B1. t/f

false

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

false

To retrieve a return value from a vertical lookup table, you use the VTABLE function.

false

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

false

You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables.

false

You should move a chart to a chart sheet when you want the source data to appear with the chart. t/f

false

the comma style format adds a comma and a dollar sign to a cell value, t/f

false

Which of the following options can you set when you create or edit a data bar conditional formatting rule? Select all the options that apply.

fill color of the data bars, value used for the longest data bar, how to display negative values

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

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

font

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

format painter

You can add data marks to sparklines to highlight which of the following values? Select all the options that apply.

high values negative values ending values low values

Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells?

highlight cells rules

When you underline cell content, you are using _____.

home

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

home tab, mini tool bar, format cells dialog box

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 Excel tools displays the syntax for a selected function?

insert function dialog box

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? MIN

max

Which of the following are functions you can use to calculate measures of central tendency? Select all the options that apply.

median, average

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

merge and center

What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)?

number of the column containing the return value

Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which Label Position option should she select for the data labels?

outside end

Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents. t/f

true

Column sparklines show a general trend without a legend, title, or gridlines. t/f

true

The Percent style formats numbers as percentages with _____ decimal places by default. one, three, zero, two

zero

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?

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

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")

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.

Which Excel features can you use to extend a formula into a range with AutoFill? Select all the options that apply.

Fill handle, Fill button in the Editing group

Which of the following is a type of logical function?

IF

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

MIN function

To format a range so that all values greater than $500 appear in red, which of the following can you use? cell formatting, cell styles, conditional formatting, quick access toolbar

conditional formatting

Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell?

data bar

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

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

false

A(n) trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart. t/f

false

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

false

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

false

You can edit a worksheet footer in _____.

page layout view

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

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

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

You can create conditional cell formats using either the Home tab or the _____.

quick analysis tool

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

replace

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

scatter

Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option?

sum

If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them.

themes

Which of the following elements can you add to a chart to display a line representing the general direction in a data series?

trendline

A combination chart combines two chart types and can plot data on primary and secondary axes. t/f

true

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. t/f

true

Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK. t/f

true

To change a chart title, you click the chart title, type the new title, and then press ENTER. t/f

true

To format the cell value 44.54 as 44.540, you can use the Increase Decimal button, t/f

true

To paste only a copied cell's formats, use the Paste Special command.

true

You can add data markers to sparklines to indicate the high and low points in the chart. t/f

true

You use conditional formatting to format a cell based on its value, t/f

true

a theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats, t/f

true

currency is an example of a number format, t/f

true