Excel

The___category of excel functions returns true or false values

Information

Which of the following is a Math&Trig function?

INT

Which of the following is a statistical function?

Average

=Round(Average(A1:A100),2) is an example of a(n)___function.

Logical

After you describe a functions in the search for a function box in the Insert Function dialog box, click___…

Next

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

Values

In the following formula: =IF(A1="YES", "Done", "Restart"), what happens if A1=No?

The formula returns the text NO

The ___ function returns the maximum value in the range.

Max

One of the great advantages ___ 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.

Cell

Absolute references are marked with a ___

$

When you copy a formula that contains an absolute reference to a new location, the reference____.

Is updated automatically

Use___reference when you want different formulas to refer to the same cell.

Relative

____arguments may provide more control over the returned value.

Absolute

FUNCTION(argument1, argument2,….)is _______.

The syntax of writing optional arguments

If an optional argument is not included, excel assumes a(n)____value for it.

default

Excel functions are organized into____catagoreies.

13

in "SUM(number1[, number2, number3,…]", number 1, number 2, and number 3 may be numbers or____.

Cell Reference

Which category of excel functions returns information about the format, location, or contents or worksheets cells?

Description

In the formula=INT(Average(A1:A100)), which would occur first?

The average of the values in the range A1:A100 is calculated.

Using the AutoFill Options button, the Fill Without Formatting option copies the___but not the formatting.

Functions

___reference are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.

Matched

=IF(G22="x", SUM(H22:J22),"") will display ___ if G22 is not equal to "x".

False

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

Lookup

If the Vlookup function connot find the lookup value, the ___error value is displayed in the cell.

#Value

One way to perform a ____is by changing one or more of the input values to see how they affect the calculated results.

What-if analysis

Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.

fixed reference

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?

F4

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

Exact

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.

#Value

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. True or False

True

A ________ contains the actual values that are plotted on the chart

Legend

Category values are usually located in the ____ of the data source

Either A or B

The ____ is the only one of the following charts to compare relative values from different categories to the whole.

Column

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

Move Chart

Placing a chart in a___displays only the chart and no worksheet cells.

Chart Sheet

Excel supports all of the following types of sparklines EXCEPT ____.

true/false sparkline for help making decisions

To resize an embedded chart,____.

Select the chart and drag the corner sizing handle of the selection box

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left.

Chart Elements

A pie slice is a data marker that represents ____ from a data series.

Only one value

To move one slice of a pie chart away from the pie creates a(n)____

Perfect pie chart

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab.

Change Chart Type

The range of values or _______, of an axis is based on the values in the data source.

Series

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab.

Design

___is the amount added to the principle of a loan by the lender.

Interest

The FV function stands for ___.

formulated value

the amount of money being loaned is know as the ____.

Loan amount

PMT(rate,nper,pv[,fv=0][,type=0]) the possible values for the type argument in the function above area.

0 or null

Since it’s important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya? _____

Pie

Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart.

Filter

Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____.

Exploded Pie Chart