Q&A Hero

Q: The ____ identifies which data markers are associated with each data series. a. x-axis b. y-axis c. chart area d. legend

Q: The ____________________ is the middle value from a sample.

Q: ____ is the amount added to the prinicpal of a loan by the lender. a. Rate b. Simple c. Interest d. Maximum

Q: TODAY is an example of a(n) ____________________ function.

Q: The FV function stands for ____. a. function value b. future value c. financial value d. formulated value

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: 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 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: Another name for the middle value is the ____ value. a. mode b. center c. median d. relative

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

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

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: 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: The ____ category of Excel functions returns (true-false) values. a. Information b. Statistical c. Logical d. Math & Trig

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 Statistical function? _____ a. INT b. RAND c. ROUND d. AVERAGE

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

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

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

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

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: 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: 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: 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: 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: Which of the following is not a comparison operator? ____ a. = b. <= c. << d. <>

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

Q: Lookup tables can be constructed for exact match or approximate match lookups. _______________ a. True b. False

Q: One of the benefits of conditional ____________________ is that it helps you analyze data by highlighting significant trends in data.

Q: An argument can be any type of value including text, numbers, cell references, or even other formulas or functions. _______________

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: Case 2-1 Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges. a. selective b. nonadjacent c. consecutive d. specific

Q: Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting. a. Quick Tool Bar b. Quick Analysis Tool c. Quick Formatting Bar d. Conditional Analysis Tool

Q: A(n) ____________________ is a collection of formatting that specifies the fonts, colors, and graphical effects used throughout the workbook.

Q: Ten ____________________ colorsdark red, red, orange, yellow, light green, green, light blue, blue, dark blue, and purpleare always available regardless of the workbooks theme.

Q: Use the ____________________ button in the Alignment group on the Home tab to increase the size of the indention used in a cell.