Excel, EXAM 3

Name Box

The ____ displays the cell reference of an active cell.

11

The default worksheet text is _____ -point Calbri.

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

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

A font syle

When you underline cell content, you are using _____.

Change the color of the data series.

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

=MONTH(DATE(2016,7,0))

Which formula can you use to extract the month number from the date entered in cell F5 as July 8, 2016?

=DATE(1998,1,12)

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

Insert Function Dialog Box

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

Increase the font size

Which of the following can you do to make a chart title stand out on a chart?

Scatter

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

Highlight Cells Rules

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

Select Data Source dialog box

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

Trendline

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

(25+10)*50

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

AVERAGE

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

AutoSum button

Which of the following inserts a function into a cell?

IF

Which of the following is a type of logical function?

=ROUND(A5,2)

Cell A 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?

Function

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

Font

A ____ refers to a collection of characters with similar, specific changes.

Treemap

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

Waterfall

A _____ chart tracks the addition and subtraction of values within a sum.

=COUNTA(B1:B20)

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

Sunburst

A(n) _____ chart organizes hierarchies of data in a series of concentric rings and is appropriate for showing groups within categories of information.

Axis title

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

Rename the worksheet

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

What-IF Analysis

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

Line sparklines

Annemarie lists 12 months of product sales data in the range A3:M7. The products are listed in the range A3:A7 and the monthly sales data in the range B3:M7. She wants to display a simple chart at the end of each row in column N to track the monthly sales for each product. What can she insert in the range N3:N7?

Outside End

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?

Hiding

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.

#N/A error value

If the VLOOKUP function cannot find a match in the lookup table, what does it return?

Data bars

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

Replace

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

Print area

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

It follows the order of operations.

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

MAX

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.

Absolute cell reference

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

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

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?

Sum

Kathy wants to add the numbers entered in a range of selected cells. Which tab will she click on the menu that appears after clicking on totals in the Quick Analysis option?

Zero

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

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

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 a cell C2 to check whether the student passed or failed?

Home

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

Edit the conditional formatting rule

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?

Font

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

Merge and Center button

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

Format Painter

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

Highlight Cells Rules

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

Conditional formatting

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

MIN Function

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

Color

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

Ctrl

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

Pie Chart

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

Scale of the sparkline axis

What can you change to coordinate sparklines with other charts and graphic objects on a worksheet?

Number of the column containing the return value.

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

Data Bar

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

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

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

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

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

You can add a border to the left, top, right, or bottom edge of a cell or range.

Which of the following is true about adding cell borders?

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

Which of the following is true about moving cell contents?

AutoFill Options button

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

Waterfall

Which type of chart would show increases in the value of a stock find in green, decreases in gray, and the initial and final values in red?

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

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

Quick Analysis Tool

You can create conditional cell formats using either the home tab or the ______.

Page Layout View

You can edit a worksheet footer in ______.

Cell formatting

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

Paste the same format multiple times.

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

Fill handle

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

Column

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

Hidden

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

If it needs an absolute cell reference.

You've copied a cell containing formula to the rows below it, and the results in the copied cells are all zeros. To find the problem, what should you check for in your original formula?

$A$5

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?