MCQs

6530 questions found

Practice Questions

Which function is used to concatenate (join) text strings in Excel?

A. SUM()
B. JOIN()
C. CONCATENATE()
D. TEXT()
nmdcat.online BS Nursing
Jun 6, 2026

What is the keyboard shortcut to move to the previous sheet in Excel?

A. Ctrl + PgDown
B. Ctrl + PgUp
C. Ctrl + Tab
D. Shift + Tab
nmdcat.online BS Nursing
Jun 6, 2026

What is the keyboard shortcut to move to the next sheet in Excel?

A. Ctrl + PgUp
B. Ctrl + PgDown
C. Ctrl + Tab
D. Shift + Tab
nmdcat.online BS Nursing
Jun 6, 2026

Which feature allows you to display only the rows that meet certain criteria in Excel?

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

What is the primary purpose of ‘Data Validation’ in Excel?

A. To color-code cells.
B. To restrict the type of data or values that users enter into a cell.
C. To automatically correct spelling errors.
D. To analyze large datasets.
nmdcat.online BS Nursing
Jun 6, 2026
nmdcat.online BS Nursing
Jun 6, 2026
nmdcat.online BS Nursing
Jun 6, 2026

What does ‘Wrap Text’ do in Excel?

A. It adjusts the column width to fit the text.
B. It allows text to extend beyond the cell boundary.
C. It wraps long text within a cell so that it appears on multiple lines.
D. It rotates the text within the cell.
nmdcat.online BS Nursing
Jun 6, 2026
nmdcat.online BS Nursing
Jun 6, 2026
nmdcat.online BS Nursing
Jun 6, 2026

Which chart type is best for showing trends over time in Excel?

A. Pie Chart
B. Bar Chart
C. Line Chart
D. Scatter Plot
nmdcat.online BS Nursing
Jun 6, 2026

What is the purpose of ‘Text to Columns’ in Excel?

A. To combine multiple text strings into one.
B. To split the contents of one cell into separate columns.
C. To change the font color of text.
D. To wrap text within a cell.
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to hide the selected rows in Excel?

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

What is the shortcut key to hide the selected columns in Excel?

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

Which Excel tool is used to remove duplicate values from a range of cells?

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

What is the shortcut key to insert a new worksheet in Excel?

A. Shift + F11
B. Ctrl + F11
C. Alt + F11
D. F11
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
Page 84 of 344
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6528 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →