Practice Questions

What is a “PivotTable” used for in Excel?

A. To create simple calculations.
B. To summarize and analyze large datasets. ✓
C. To draw complex shapes.
D. To check for spelling errors.
nmdcat.online BS Nursing
Jun 6, 2026

Which tab in Excel would you use to apply a password to protect your workbook?

A. Home
B. Insert
C. Review
D. File (then Info) ✓
nmdcat.online BS Nursing
Jun 6, 2026

To quickly navigate to the last used cell in an Excel worksheet, what is the shortcut key?

A. Ctrl + Home
B. Ctrl + End ✓
C. End, Home
D. Shift + End
nmdcat.online BS Nursing
Jun 6, 2026

What is the keyboard shortcut for ‘AutoSum’ in Excel?

A. Alt + = ✓
B. Ctrl + =
C. Shift + =
D. F2
nmdcat.online BS Nursing
Jun 6, 2026

What does VLOOKUP() do in Excel?

A. Looks for a value in the leftmost column of a table, and returns a value in the same row from a column you specify. ✓
B. Looks for a value in the top row of a table, and returns a value in the same column from a row you specify.
C. Adds values vertically.
D. Validates data entry.
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

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

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
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
Page 631 of 1127
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    11260 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →