When you move to the same row but to other columns? A. To perform a vertical lookup and return a value based on a specified criterion B. To perform a horizontal lookup and return a value based on a specified criterion C. To add up a range of cells D. To find the average of a range of cells Explanation: This describes the HLOOKUP function (horizontal lookup).
In Excel, from which tab can you write DOB like this YYYY/MM/DD? A. View Menu B. Format Menu C. Data Menu D. Insert Menu Explanation: Custom date formats (YYYY/MM/DD) are set in the Format Cells dialog under the Number tab.
If a formula references a cell that contains text instead of a numerical value, what error does Excel display? A. #NUM! B. #VALUE! C. #REF! D. #DIV/0! Explanation: #VALUE! An error appears when the formula expects numbers but receives text.
In Excel we added ____ before fraction for not to enter date. A. S B. & C. Space D. None of these Explanation: A leading space forces Excel to treat the entry as text/fraction.
Which is used for fractions, so data in MS-Excel doesn’t read it as a date? A. S B. @ C. / D. Space Explanation: Prefixing a fraction with a space prevents Excel from interpreting it as a date.
Which area in an Excel window allows entering values and formulas? A. Title bar B. Menu bar C. Formula bar D. Standard toolbar Explanation: The Formula Bar is the dedicated area for entering and editing content.
In MS Excel, which bar is used for formula and data writing? A. Menu bar B. Title bar C. Formula bar D. None of these Explanation: The Formula Bar is where you view and edit formulas and cell data.
To add Equation in the cell of the MS-Excel, we put ____ first. A. Addition sign B. Subtraction sign C. Equal sign D. Parenthesis sign Explanation: All formulas begin with the equal sign (=).
In Excel, the error message “#Value!” typically means: A. Invalid Input B. Calculation Error C. Data Corruption D. Low Memory Explanation: #VALUE! indicates a problem with the data type used in the formula.
In MS Excel, to create a formula, you can use ____. A. Cell references, although not both at the same time B. Cell references with values but not values C. Values but not cell references D. Both value and cell references Explanation: Formulas can combine cell references and literal values.