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 626 of 1122
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    11210 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →