The nested function is ____. A. Function outside a function B. Function within a function C. Function nearest a function D. None of these Explanation: A nested function uses one function as an argument inside another.
MOD() function is used in MS Excel to get ____. A. Dividend B. Remainder C. Quotient D. None of these Explanation: MOD returns the remainder (modulus) of a division.
What formula is used to calculate monthly mortgage payments in Excel? A. PMT B. GMT C. PST D. None of these Explanation: PMT is a financial function that calculates the periodic payment amount.
Which function displays row data into a column or column data into a row? A. Hyperlink B. Index C. Transpose D. Rows Explanation: TRANSPOSE switches rows and columns.
Which of the following is not a function in Microsoft Excel? A. SUM B. MAX C. MIN D. AVG Explanation: AVG is not valid; the correct function is AVERAGE.
Which of the following functions in Microsoft Excel counts the number of cells with numerical data in the argument? A. COUNT B. AVERAGE C. SUM D. MAX Explanation: COUNT tallies only numeric cells.
Which function in Excel returns the remainder of a division? A. Divide B. MOD C. ACOT D. None of these Explanation: MOD returns the remainder after division.
In MS Excel, which function automatically totals a column or row of values? A. Total B. ADD C. SUM D. AVG Explanation: SUM is the dedicated function for totaling values.
The ____ function in Excel returns the highest value in a set of data that you specify. A. MAX B. AVG C. LRG D. None of these Explanation: MAX returns the largest value in a range.
Which command is used to add data in Excel? A. ADD B. COUNT C. SUM D. None of these Explanation: The SUM function is the standard command to add numerical data.