Q&A Hero

Q: A(n) ____________________ reference contains both relative and absolute references.

Q: The amount of money being loaned is known as the ____. a. mortgage b. principal c. loan amount d. proposed principal

Q: Not all functions have arguments, and some functions have ____________________ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.

Q: In the figure above, nper stands for the ____. a. total number of payment periods b. total number of payments that have already been made c. number of payments per year d. number of interest payments per year

Q: A pie slice is a data marker that represents ____ from a data series. a. only one value b. at least one value c. no more than three values d. no more than five values

Q: In the figure above, pv stands for the ____. a. payments verified b. principal value of the loan c. present value of the loan d. primary interest rate of the loan

Q: To move one slice of a pie chart away from the pie creates a(n) ____. a. spontaneous pie chart b. perfect pie chart c. exploded pie chart d. exponential pie chart

Q: In the figure above, fv and type are ____. a. financial functions b. required arguments c. comparison operators d. optional arguments

Q: 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. a. Change Chart Type b. New Chart c. Alter Existing Chart d. Modify Chart

Q: The possible values for the type argument in the function above are. a. 0 or null b. 0 or 1 c. 0, 1, or 2 d. 0, 1, 2, or 3

Q: A chart that compares three set of values in a three-dimensional chart is _____. a. Stock b. Radar c. Surface d. Scatter

Q: Which of the following shows the correct order of steps for adding a data series to a chart? a. Select the chart, Click the Add button, Click the Select Data button, Select the range b. Select the chart, Click the Select Data button, Click the Add button, Select the range c. Select the range, Click the Select Data button, Click the Add button, Select the chart d. Select the range, Select the chart, Click the Select Data button, Click the Add button

Q: Edward Tufte was concerned with what he termed as chart ____, in which a proliferation of chart elementschosen because they look niceconfuse and distract the reader. a. espionage b. clutter c. confusion d. junk

Q: A chart sheet can contain ____. a. only one chart b. one or two charts c. one to four charts d. one to six charts

Q: You can choose Center, Inside End, Outside End, or Best Fit for the data label positions in the in the ____ pane. a. Format Data Labels b. Format Legend c. Format Chart Area d. Format Axis

Q: In the formula =INT(AVERAGE(A1:A100)), which would occur first? ____ a. The average of the values in the range A1:A100 is added to the integer. b. The average of the integer value is calculated. c. The average of the values in the range A1:A100 is calculated. d. The integer portion of the value is extracted.

Q: Some cell references are called ____________________ references because they are always interpreted in relation to the location of the cell containing the formula.

Q: When you nest functions, you should have ____. a. the equal sign b. the same number of left and right parentheses c. at least two functions d. the correct number of brackets

Q: ____________________ is a set of rules which specifies how a function should be written.

Q: The Insert Function button is in the ____ group. a. Calculation b. Function Library c. Sort & Filter d. Home

Q: The Insert Function dialog box has a(n) ____ option. a. search b. formatting c. find and replace d. expand/collapse

Q: The fill handle copies ____. a. content only b. formats only c. content and formats d. formats and cell references

Q: Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting. a. functions b. content c. cell references d. left-aligns

Q: Using AutoFill, what would be the extended series of the initial entry Jan? ___ a. uary b. Feb, Mar, Apr c. Kan, Lan, Man, Nan d. Jan1, Jan2, Jan3

Q: A logical function is a function that works with values that are either ____. a. right or wrong b. absolute or relative c. positive or negative d. true or false

Q: In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____. a. A is equal to B b. A does not equal B c. A1+B1 is equal to C1 d. A1>B1 is equal to C2

Q: ____ references 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. a. Absolute b. Relative c. Mixed d. Matched

Q: =IF(G22=x, SUM(H22:J22), ) with display ______ if G22 is not equal to x. a. a blank cell b. the result of the SUM c. dashes d. False

Q: ______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. a. Sum b. Average c. Lookup d. Find

Q: If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell. a. #VALUE b. #N/A c. #ERROR d. #NULL

Q: One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results. a. goal seek b. gunction c. search d. what-if analysis

Q: Case 3-1 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 2016. She need to keep track of her expenses and income for the year. 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

Q: Case 3-2 Susan is in charge of the inventory reports for her company. She will need to find specific inventory items as well as project increases in inventory costs. To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools. 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 ______. a. Data Validation b. Goal Seek c. Goal Set d. If Conditional

Q: In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= NO? _____ a. The formula returns the text RESTART. b. The formula returns the text DONE. c. The formula returns the text NO. d. The formula returns the text NO, RESTART.

Q: Which of the following is not a date function? ____ a. YEAR b. NOW c. AND d. TODAY

Q: The ____ function returns the maximum value in the range. a. TOP b. FIRST c. MAX d. MOST

Q: 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. a. cell b. relative c. absolute d. formula

Q: Absolute references are marked with a ____. a. < b. : c. $ d. !

Q: 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

Q: Use ____ references when you want different formulas to refer to the same cell. a. mixed b. relative c. absolute d. fixed

Q: A trial-and-error method lets you explore the impact that changing input values has on the calculated values in the workbook. _________________________

Q: Another name for the middle value is the ____ value. a. mode b. center c. median d. relative

Q: Goal Seek automates the trial-and-error process by allowing you to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. _________________________

Q: ____ arguments may provide more control over the returned value. a. Relative b. Required c. Optional d. Absolute

Q: The ____ category of Excel functions returns (true-false) values. a. Information b. Statistical c. Logical d. Math & Trig

Q: FUNCTION(argument1, argument2, ...) is ____. a. the syntax of writing optional arguments b. an example of a formula c. the general syntax of all functions d. the general syntax of all formulas

Q: Which of the following is a Statistical function? _____ a. INT b. RAND c. ROUND d. AVERAGE

Q: If an optional argument is not included, Excel assumes a(n) ____ value for it. a. default b. generic c. static d. absolute

Q: Which of the following is a Math & Trig function? ____ a. INT b. COUNT c. MIN d. AVERAGE

Q: Excel functions are organized into ____ categories. a. 8 b. 10 c. 11 d. 13

Q: =ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function. a. complex b. logical c. absolute d. nested

Q: Which of the following is not an Excel function category? ____ a. Math & Trig b. Algebra c. Statistical d. Text

Q: After you describe a function in the Search for a function box in the Insert Function dialog box, click ____. a. Go b. Select c. Insert d. Next

Q: Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references? a. SUM b. COUNT c. COUNTA d. AUTOSUM

Q: The numbers, text, or cell references used by the function to return a value are called ____. a. expressions b. arguments c. data d. values

Q: 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

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

Q: Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____ a. Location b. Information c. Reference d. Description

Q: To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

Q: An error value indicates that some part of a function is preventing Excel from returning a calculated value. ________________

Q: The region that is sent to the printer from the active sheet is known as the ____________________.

Q: When a formula includes a cell reference, Excel interprets that cell reference as being located relative to the position of the current cell. _________________

Q: A(n) ____________________ is text printed in the top margin of each page.

Q: The following mixed reference in the formula, $A5, has an absolute column reference and a relative row reference. _________________________

Q: When you specify a print area for a nonadjacent range, you are also inserting a(n) ____________________ page break.

Q: The Fill Formatting Only option, which is the default, copies both the content and the formatting. ______________

Q: Explain how to use conditional formatting effectively.

Q: The statement A1 >= B1 tests whether the value in cell A1 is lesser than or equal to the value in cell B1. _________________________

Q: A constant is a value in a formula that doesnt change. _______________ a. True b. False

Q: The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.

Q: Optional arguments are always placed first in the argument list. _______________ a. True b. False

Q: A lookup table organizes numbers or text into categories. _____________

Q: One challenge of nesting functions is to make sure that you include all of the parentheses. _______________ a. True b. False

Q: Functions are organized in the Function Library group on the FORMULAS tab. _______________ a. True b. False

Q: A mixed reference locks one part of the cell reference while the other part can change. _______________ a. True b. False

Q: An error value begins with a pound sign (#) followed by an error name that indicates the type of error. _______________ a. True b. False

Q: By default, AutoFill copies only the content not the formatting of the original range to the selected range. _______________ a. True b. False

Q: To display the current date and time, which is updated each time the workbook is reopened, use the TODAY function. _______________ a. True b. False

Q: The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. _______________ a. True b. False

Q: The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.