Practice Questions

What is a cell in Excel?

A. A row
B. A column
C. A unit of data
D. A unit of formatting
nmdcat.online Computer
May 22, 2026
nmdcat.online Computer
May 22, 2026

Which of following is not an element of computer spreadsheet interface?

A. Pencil work
B. Active cell
C. Menu bar
D. Workbook
nmdcat.online Computer
May 22, 2026

in MS-Excel__________ short cut key is used for hiding rows.

A. Ctrl+H
B. Ctrl+7
C. Ctrl+9
D. None of the above
nmdcat.online Computer
May 22, 2026

Title bar in MS-Excel displays name of the __________ ?

A. Worksheet
B. Workbook
C. Formula
D. Location
nmdcat.online Computer
May 22, 2026

What is the intersection of a column and row called in Excel?

A. A cell
B. A range
C. A column header
D. A row header
nmdcat.online Computer
May 22, 2026

What is the function of the SUM function in Excel?

A. To add up a range of cells
B. To find the average of a range of cells
C. To count the number of cells in a range
D. To find the maximum value in a range of cells
nmdcat.online Computer
May 22, 2026

What is the function of the IF function in Excel?

A. To perform a logical test and return a value based on the result
B. To add up a range of cells
C. To find the average of a range of cells
D. To count the number of cells in a range
nmdcat.online Computer
May 22, 2026

What is the function of the VLOOKUP function in Excel?

A. To perform a vertical lookup and return a value based on a specified criteria
B. To perform a horizontal lookup and return a value based on a specified criteria
C. To add up a range of cells
D. To find the average of a range of cells
nmdcat.online Computer
May 22, 2026

To insert chart in MS Excel, which shortcut key used?

A. Alt+F1
B. F2
C. F3
D. F4
nmdcat.online Computer
May 22, 2026
Page 648 of 652
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6509 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →