Which one of the following functions is not found in MS Excel? A. Max B. Min C. Mean D. Median Explanation: MEAN is not a built-in function (use AVERAGE instead).
A ____ is a dynamic mathematical calculation that displays a single value for a specific field. A. Format row B. Criteria row C. Aggregate function D. Format layout Explanation: Aggregate functions (SUM, AVERAGE, COUNT, etc.) calculate a single summary value.
In MS Excel, a data series is related to ____. A. Collection of Series data B. Collection of formulas C. Collection of metadata D. All of these Explanation: A data series is a collection of related data points plotted on a chart.
Formatting a cell in Currency, you can specify ____. A. Decimal Places B. Currency Symbol C. Both A & B D. None of these Explanation: Currency formatting lets you set both the symbol and the number of decimal places.
Two common wildcard characters that Excel accepts/recognizes are ____. A. *And? B. + and - C. / and \ D. > and < Explanation: Asterisk (*) and question mark (?) are the standard wildcards in Excel.
Which of the following can you paste selectively using the Paste Special Command? A. Formulas B. Validation C. Formats D. All of these Explanation: Paste Special allows the selective pasting of formulas, validation rules, formats, etc.
Two cells are mixed with a ____. A. Merge cell B. Combine cell C. Unify cell D. None of these Explanation: The Merge Cells command combines two or more cells into a single cell.
Border can be applied on____. A. Paragraph B. Text C. Cell D. All of these Explanation: Borders can be applied to paragraphs, text, and cells in MS Office applications.
What does the =Proper(TEXT) function do in MS Excel? A. First letter of each word is capitalized B. First letter of the sentence is capitalized C. All letters are capitalized D. None of the above Explanation: PROPER converts the first letter of each word in a text string to uppercase.
What is the shortcut key to quickly insert a new workbook in Excel? A. Shift+Enter B. Alt+Enter C. Control D. Shift + A Explanation: The document marks Alt+Enter, but the standard shortcut is Ctrl + N.