Excel Exam Part One

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

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

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

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

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.

False

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

(25+10)*50

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

Fill button in the Editing group and Fill Handle

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

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

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

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

True

Which of the following is true about moving cell contents?

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

When you underline cell content, you are using _____.

a font style

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

axis title

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

color

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

font

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

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

The _____ displays the cell reference of the active cell

name box

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

Argument

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

AutoFill Options button

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

Double-click the cell or click in the formula bar

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

False

To insert only the current date in cell B1, use the NOW function in cell B1

False

To find the largest value in a cell range, use the MIN function.

False

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

SUM

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

False

The default worksheet text is _____-point Calibri

11

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

= (equal), > (greater than), <> (not equal)

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

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)

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

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

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 indicates the column and row where a cell is located?

Cell reference

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

Change the color of the data series

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

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

Conditional formating

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

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.

False

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

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

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

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

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

Function

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

Highlight Cells Rules

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

Home tab, Mini toolbar, Format Cells dialog box

Which of the following is a type of logical function?

IF

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?

IFERROR

Which of the following Excel tools displays the syntax for a selected function?

Insert Function dialogue box

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

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

MEDIAN, AVERAGE

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

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

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

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 and Paste Options button

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

Pie chart

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 formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?

The formula =SUM(B6:B10)

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.

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.

True

A constant is a term in an equation whose value does not change

True

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

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

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

True

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

True

Currency is an example of a number format

True

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

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.

True

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

True

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 paste only a copied cell's formats, use the Paste Special command

True

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

True

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 add data markers to sparklines to indicate the high and low points in the chart.

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

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

data bars

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

ending values, low values, negative values, high values

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

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

print area

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.

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

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

zero