excel

If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.

#N/A

Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ______ error value in the cell.

#N/A

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents.

1, 5, 2, 4, 3

A __ is the space between the page content and the edges of the page. A. Margin B. Border C. Frame D. Ruler

A. Margin

If an optional argument is not included, Excel assumes a(n) ____ value for it. A. default B. generic C. static D. absolute

A. default

In Excel, to merge cells A1,B1,C1,D1, and E1, _____ is the correct reference for the merged cell. a. A1!E1! b. A1 c. E1 d. A1-E1

A1

In the accompanying figure, the number 1 displays _____.

Alignment buttons

Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?A. F2 B. F4 C. F6 D. F1

B. F4

Ellen's spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box. A. Math & Trig button in the Formula group B. Math & Trig button in the Function Library group C. Financial button in the Formula group D. Financial button in the Function Library group

B. Math & Trig button in the Function Library group

Ellen opens Excel 2016 and enters her monthly income for one year beginning with January. To create a series of months, she can ____. A. Type = Jan-Dec in cell A1 and then press Enter. B. Type January in cell A1 and then drag the fill handle. C. Type =YEAR in cell A1 and then press Enter. D. Type =DATE(Jan, Dec) in cell A1 and then press Enter.

B. Type January in cell A1 and then drag the fill handle.

In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____. A. letters B. cell references C. symbols D. operators

B. cell references

In the accompanying figure, an example of a theme font is _____.

Calibri

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.A. Equal toB. BetweenC. Duplicate ValuesD. A Date Occurring

Duplicate Values

Susan needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .

FALSE

Which of the following is a Math & Trig function? ____

INT

The ____ function returns the maximum value in the range

MAX

Use ____ references when you want different formulas to refer to the same cell.

absolute

Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2013. She need to keep track of her expenses and income for the year.Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses form her monthly income. Since her monthly income is the same amount each month, she uses a(n) __________ to identify the cell containing the income value.

absolute reference

Which of the following is not an Excel function category? ___

algebra

The numbers, text, or cell references used by the function to return a value are called ____.

arguments

When you copy a formula that contains an absolute reference to a new location, the reference ____ ___ _____. a. is updated automatically b. does not change c. becomes bold d. has a dotted outline in its cell

b. does not change

Which of the following is not a comparison operator? a. = b. <= c. << d. <>

c. <<

The fill handle copies ____.

content and formats

In the accompanying figure, the _____ indicates the font is 11pt.

font size box

Referring to the figure above, which number refers difference between the scheduled andattended workouts

four

Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

goal seek

In the accompanying figure, the number 3 displays _____

indented texts

The ____ category of Excel functions returns (true-false) values

logical

__ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.

lookup

Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.

lookup function

Another name for the middle value is the ____ value.

median

when you don't want to associate a font with a particular design.

non-theme font

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

number

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

numbers

____ arguments may provide more control over the returned value. A. Relative B. Required C. Optional D. Absolute

optional

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

orientation

Setting the ______ to A1:L10 will print data in those cells. a. Page Format b. Print Area c. Page Break d. Print Preview

print area

One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.

relative

When you nest functions, you should have ____.

the same number of left and right parentheses

Fonts, colors, and cell styles are organized in _____ categories.

theme and non-theme

Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

type the data in A1 and Merge cells A1:E1

Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

use Format Painter

Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use ______.

what-if analysis