(T, F) In Excel, the Goal seek feature is accessed through the What-if function
ID: 3838064 • Letter: #
Question
(T, F) In Excel, the Goal seek feature is accessed through the What-if function option. (T, F) The Function, "=FV(RATE, NPER, PMT') is an example of statistical function in Excel. (T, F) The Function, '=NPV (RATE, RANGE)' calculates the net present value of an investment. (T, F)(We are using the '=PM(RATE, NPER, PV)' Function to calculate the monthly payment of an automobile. In this Function the RATE (a yearly rate) must always be multiplied by 12. (T, F) The following is a valid Excel Function. '=IF(AND(B4 > 600, c4 > 3.3), "ACEPTED", "REJECTED")" (T, F) The following is a valid Excel Function. ""=IF(AND(B8 > 600, NOT(C8 > 3.3), "ACCEPTED", "REJECTED")" (T, F) One way to draw a chart in Excel is to select the data and then press the F12 function key. (T, F) In Excel, a table can be sorted only based on one primary key and up to two secondary keys. (T, F) The Sort menu in Excel is always reached through the Edit menu. (T, F) The "CRITERION RANGE" in Excel must have a heading identical to the heading of the main table. (T, F) The "CRITERION RANGE" in Excel could be inside the table itself (within the data). (T, F) The "DCOUNT" Function is one example of the database statistical functions in Excel. (T, F) All Excel Database functions must be preceded with the letter "D". (T, F) The Table function in Excel is reached thorough the Edit menu. (T, F) In Excel, "=A1^2" is the equivalent of "= squareroot (A1)". (T, F) The HLOOKUP and VLOOKUP are two examples of Excel lookup functions. (T, F) The HLOOKUP is used for horizontal searches. (T, F) In the FREQUENCY Function, you need to specify the Data-Array and Bins-Array before calculating the frequency of each data set. (T, F) In "FREQUENCY (data _array, bins_ array)", three keys must be pressed simultaneously in order to finalize the results. These keys include CTRL, SHIFT, and DELETE. (T, F) In the Function "=DCOUNT (database, field, criteria)", the order of the arguments are correct. (T, F) The formula "=A1+A2+A3" is the equivalent of the Function "=SUM(A1:A4)". (T, F) The "=SLN(cost, salvagevalue, life)" Function is used in order to calculate the sum-of-years' digits depreciation of an asset for a specified period. (T, F) The "SYD(cost, salvage, life, per)" is a valid Function in Excel.Explanation / Answer
59. T ,GOAL SEEk feature comes under what if analysis
60. F , =FV is a financial function
61. T ,=NPV calculate net present value of an investment
62.their is no formula =PM in excel . correct is =PMT . IN PMT value for yearly is 12. T (considering formula =PMT)
63. T, Valid IF formula
64. F, Invalid formaula NOT is not valid.
65. F, Shortcut key is F11.
66. F, No limit on secondary key.
67.F, Its present in DATA menu .
68. T, It shold be identical
69.F,it cant be apply on data
70. T, DCOUNT is a Database Function.
71.T, All data base function start with D.
72.F, Its in DATA menu
73.F, both are differnt function.
74.T, both are lookup table example
75.T, Hllookup is used for horizontal seach
76.T ,FREQUENCY( data, intervals ) formula, data specified before.
77. F, These keys are not the shortcut for frequency.
78.T, Mention formula is correct.
79.F, Filter is in DATA tab.
80.T, Both are equivalent.
81.T, It is used to find depreciation .
82.F, =SYD is valid but SYD is invalid.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.