Your page rank:

Total word count: 974
Pages: 4

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

The___category of excel functions returns true or false values


Which of the following is a Math&Trig function?


Which of the following is a statistical function?


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


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


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


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.


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.


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.


____arguments may provide more control over the returned value.


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

The syntax of writing optional arguments

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


Excel functions are organized into____catagoreies.


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?


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.


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


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


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


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


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?


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


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.


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


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


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.


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.


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.


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


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


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.


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

Exploded Pie Chart

Share This

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more


A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message