# Excel

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

### 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) ...

#### NCLEX 300-NEURO

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

#### NASM Flashcards

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

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price