📂

Computer skills

200 questions found

Practice Questions

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 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

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

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
nmdcat.online BS Nursing
Jun 6, 2026

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

A. Ctrl + + (plus)
B. Ctrl + - (minus)
C. Ctrl + Shift + + (plus)
D. Ctrl + Shift + - (minus)
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to delete a row or column in Excel?

A. Ctrl + + (plus)
B. Ctrl + - (minus)
C. Ctrl + Shift + + (plus)
D. Ctrl + Shift + - (minus)
nmdcat.online BS Nursing
Jun 6, 2026

Which of these is NOT a common error message in Excel?

A. #DIV/0!
B. #NAME?
C. #VALUE!
D. #SUCCESS!
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

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

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

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
Page 5 of 11
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6361 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →