Which one is not a function in MS Excel:...? Mcqs

✅ Correct Answer: AVG

✅ Correct Answer: If function

✅ Correct Answer: Wrap text

✅ Correct Answer: Paragraph formatting (Line Space and Paragraph Space)

✅ Correct Answer: Max

✅ Correct Answer: TRIM

✅ Correct Answer: SQRT

✅ Correct Answer: transpose

✅ Correct Answer: =SUM()

✅ Correct Answer: Count

✅ Correct Answer: COUNT

✅ Correct Answer: Performing logical comparisons

✅ Correct Answer: You can Find and Replace within the sheet or workbook

✅ Correct Answer: Open Document

✅ Correct Answer: To perform a logical test and return a value based on the result

✅ Correct Answer: =PRODUCT()

✅ Correct Answer: Searches for a value in the column

✅ Correct Answer: COUNT

✅ Correct Answer: Nested function

✅ Correct Answer: MAX

✅ Correct Answer: F7

✅ Correct Answer: Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button

✅ Correct Answer: Delete cells

✅ Correct Answer: Table

✅ Correct Answer: Today ()

✅ Correct Answer: Control + space bar

✅ Correct Answer: Oracle

✅ Correct Answer: Macros

✅ Correct Answer: Cell Tip

✅ Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

✅ Correct Answer: Performing logical comparisons

✅ Correct Answer: Formula

✅ Correct Answer: Count

✅ Correct Answer: organized data

✅ Correct Answer: Ctrl+5

✅ Correct Answer: New Document

✅ Correct Answer: To find a value in a table based on a matching value in the first column

✅ Correct Answer: 32767

✅ Correct Answer: To perform operations arithmetic and logic

✅ Correct Answer: None of these

✅ Correct Answer: Open Print Dialog box

✅ Correct Answer: Freezing pane

✅ Correct Answer: nested

✅ Correct Answer: Cache

✅ Correct Answer: SUMIF

✅ Correct Answer: All above mentioned

✅ Correct Answer: Macros

✅ Correct Answer: AVERAGE

✅ Correct Answer: Ctrl+0

✅ Correct Answer: Ampersand

✅ Correct Answer: To add up a range of cells

✅ Correct Answer: None of these

✅ Correct Answer: Complete lists and fill patterns

✅ Correct Answer: It makes tho selected text bold

✅ Correct Answer: Searches for a value in a column and returns a value in the same row

✅ Correct Answer: MAX

✅ Correct Answer: To add up a range of cells