📂

BS Nursing

5385 questions found

Practice Questions

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

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 absolute cell referencing (e.g., $A$1) in Excel?

A. It changes when a formula is copied to another cell.
B. It remains constant when a formula is copied to another cell.
C. It refers to a cell on another worksheet.
D. It refers to a cell in a different workbook.
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

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

A. (
B. +
C. #ERROR!
D. -
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 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

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

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

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

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

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

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

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

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

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

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

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

What is the function of the ‘Strikethrough’ font effect?

A. To draw a line through the middle of the selected text.
B. To make text bold.
C. To highlight text.
D. To make text subscript.
nmdcat.online BS Nursing
Jun 6, 2026
Page 85 of 284
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    11060 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →