MCQs

6530 questions found

Practice Questions

Which Excel feature allows you to highlight cells based on their values (e.g., top 10%, values greater than)?

A. Data Validation
B. Conditional Formatting
C. Sort
D. Filter
nmdcat.online BS Nursing
Jun 6, 2026

What is the purpose of ‘Merge & Center’ in Excel?

A. To combine cells and align text to the left.
B. To combine cells and center the content in the new, larger cell.
C. To separate merged cells.
D. To apply a border to cells.
nmdcat.online BS Nursing
Jun 6, 2026

What is the keyboard shortcut to create a new workbook in Excel?

A. Ctrl + O
B. Ctrl + S
C. Ctrl + N
D. Ctrl + P
nmdcat.online BS Nursing
Jun 6, 2026

Which Excel function is used to convert text to lowercase?

A. UPPER()
B. LOWER()
C. PROPER()
D. SMALL()
nmdcat.online BS Nursing
Jun 6, 2026

Which Excel function is used to convert text to uppercase?

A. LOWER()
B. UPPER()
C. PROPER()
D. CAPS()
nmdcat.online BS Nursing
Jun 6, 2026

What does the COUNTA() function do in Excel?

A. Counts the number of empty cells.
B. Counts the number of cells that contain any type of data (non-empty).
C. Counts the number of cells that contain only text.
D. Counts the number of columns.
nmdcat.online BS Nursing
Jun 6, 2026

What does the COUNT() function do in Excel?

A. Counts the number of cells that contain numbers.
B. Counts the number of cells that are not empty.
C. Counts the number of cells that contain text.
D. Counts the number of rows.
nmdcat.online BS Nursing
Jun 6, 2026

Which Excel feature allows you to sort data based on multiple criteria?

A. Filter
B. Sort & Filter
C. Advanced Filter
D. Conditional Formatting
nmdcat.online BS Nursing
Jun 6, 2026

To select an entire column in Excel, which shortcut key is used?

A. Shift + Spacebar
B. Ctrl + Spacebar
C. Ctrl + C
D. Ctrl + V
nmdcat.online BS Nursing
Jun 6, 2026

To select an entire row in Excel, which shortcut key is used?

A. Ctrl + Spacebar
B. Shift + Spacebar
C. Ctrl + R
D. Shift + R
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to insert the current time in an Excel cell?

A. Ctrl + ;
B. Ctrl + :
C. Ctrl + D
D. Ctrl + T
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to insert the current date in an Excel cell?

A. Ctrl + ;
B. Ctrl + :
C. Ctrl + D
D. Ctrl + T
nmdcat.online BS Nursing
Jun 6, 2026

What is the correct way to start a formula in Excel?

A. (
B. +
C. #ERROR!
D. -
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel finds the smallest value in a range of cells?

A. MAX()
B. MIN()
C. AVERAGE()
D. SUM()
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel finds the largest value in a range of cells?

A. MIN()
B. MAX()
C. AVERAGE()
D. SUM()
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel is used to add up a range of numbers?

A. AVG()
B. COUNT()
C. SUM()
D. MAX()
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to open the ‘Format Cells’ dialog box in Excel?

A. Ctrl + F
B. Ctrl + 1
C. Ctrl + B
D. Ctrl + C
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to apply the Percentage format in Excel?

A. Ctrl + Shift + $
B. Ctrl + Shift + %
C. Ctrl + Shift + #
D. Ctrl + Shift + @
nmdcat.online BS Nursing
Jun 6, 2026
Page 85 of 344
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6528 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →