nmdcat.online

Practice Questions

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

A. TRIM ✓
B. SUBSTITUTE
C. CLEAN
D. REPT
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

A. =LARGE(A:A, 2)
B. =LARGE(UNIQUE(A:A), 2)
C. =INDEX(SORT(UNIQUE(A:A), , -1), 2) ✓
D. =SMALL(UNIQUE(A:A), 2)
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

Which of the following is last column in MS Excel-2016?

A. XFD ✓
B. ZZZ
C. ZXF
D. ZAZ
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

Which shortkey is suitable for reach at the last Row of MS Excel?

A. Ctrl + Space
B. Shift + Ctrl +Enter
C. Ctrl + Down Arrow ✓
D. Ctrl + =
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

In MS Word, “Justify” works to make text straight in both sides but How Justify works in MS Excel?

A. Text in Columns
B. Text in Rows ✓
C. Text in selection
D. None
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

Which shortcut key is for auto sum ?

A. Alt + = ✓
B. Ctrl + Shift
C. Alt + F1
D. Ctrl + =
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

The default page size for word documents is also used in offices_____________________?

A. A4 ✓
B. Legal
C. Letter
D. None
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

In MS Word, the shortcut for paste command is _________________________?

A. Ctrl+V ✓
B. Ctrl+X
C. Alt+X
D. Shift+Alt+X
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

________________________ is not a valid data type in excel?

A. Number
B. Label
C. Character ✓
D. none
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026

Ctrl +U is used for ____________________?

A. underline ✓
B. italic
C. bold
D. none
Read More Details about this Mcq:
nmdcat.online Computer
May 22, 2026
1 ... 633 634 635 636 637
Page 635 of 637
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6361 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →