MCQs

1144 questions found

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

What is the use of a horizontal Scroll Bar in MS Excel?

A. to view the data from left to the right ✓

B. to view the data in Excel from up and down

C. to view the data from right to the left

D. None of these

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

MS Excel is based on: _____________?

A. UNIX

B. DOS

C. WINDOWS ✓

D. OS/2

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

Which shortcut key is used to create chart in MS Excel?

A. F10

B. F12

C. F11 ✓

D. None

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

How do you display current date and time in MS Excel ?

A. Date()

B. Year()

C. Now() ✓

D. Time()

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

Which shortcut key is used to print a document?

A. Ctrl+M

B. Ctrl+N

C. Ctrl+P ✓

D. None of these

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

Letters in Excel denote: ______________?

A. Columns ✓

B. rows

C. numbers

D. reference

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

Another name for a pre programmed formula in excel is ___________?

A. Cell

B. Graph

C. Function ✓

D. Range

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

How are data organized in a spreadsheet ?

A. Lines and spaces

B. Layers and planes

C. Rows and columns ✓

D. Height and width

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

In Excel, which is used to perform what if analysis?

A. Goal seek

B. Solver

C. Scenario Manager

D. All of above ✓

Read More Details about this Mcq:

nmdcat.online Computer

May 22, 2026

1 ... 58 59 60 61

Page 60 of 61

Jump to:

MCQs

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?

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?

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

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

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

Which shortcut key is for auto sum ?

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

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

________________________ is not a valid data type in excel?

Ctrl +U is used for ____________________?

What is the use of a horizontal Scroll Bar in MS Excel?

MS Excel is based on: _____________?

Which shortcut key is used to create chart in MS Excel?

How do you display current date and time in MS Excel ?

Which shortcut key is used to print a document?

Letters in Excel denote: ______________?

Another name for a pre programmed formula in excel is ___________?

How are data organized in a spreadsheet ?

In Excel, which is used to perform what if analysis?

🏆 Top Contributors

Categories