📂

Computer skills

200 questions found

Practice Questions

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

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

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

Which Excel feature allows you to sort data based on multiple criteria?

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

What does the COUNT() function do in Excel?

A. Counts the number of cells that contain numbers.
B. Counts the number of cells that are not empty.
C. Counts the number of cells that contain text.
D. Counts the number of rows.
nmdcat.online BS Nursing
Jun 6, 2026

What does the COUNTA() function do in Excel?

A. Counts the number of empty cells.
B. Counts the number of cells that contain any type of data (non-empty).
C. Counts the number of cells that contain only text.
D. Counts the number of columns.
nmdcat.online BS Nursing
Jun 6, 2026

Which Excel function is used to convert text to uppercase?

A. LOWER()
B. UPPER()
C. PROPER()
D. CAPS()
nmdcat.online BS Nursing
Jun 6, 2026

Which Excel function is used to convert text to lowercase?

A. UPPER()
B. LOWER()
C. PROPER()
D. SMALL()
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to apply the Percentage format in Excel?

A. Ctrl + Shift + $
B. Ctrl + Shift + %
C. Ctrl + Shift + #
D. Ctrl + Shift + @
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to open the ‘Format Cells’ dialog box in Excel?

A. Ctrl + F
B. Ctrl + 1
C. Ctrl + B
D. Ctrl + C
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel is used to add up a range of numbers?

A. AVG()
B. COUNT()
C. SUM()
D. MAX()
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel finds the largest value in a range of cells?

A. MIN()
B. MAX()
C. AVERAGE()
D. SUM()
nmdcat.online BS Nursing
Jun 6, 2026

Which function in Excel finds the smallest value in a range of cells?

A. MAX()
B. MIN()
C. AVERAGE()
D. SUM()
nmdcat.online BS Nursing
Jun 6, 2026

What is the correct way to start a formula in Excel?

A. (
B. +
C. #ERROR!
D. -
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to insert the current date in an Excel cell?

A. Ctrl + ;
B. Ctrl + :
C. Ctrl + D
D. Ctrl + T
nmdcat.online BS Nursing
Jun 6, 2026

What is the shortcut key to insert the current time in an Excel cell?

A. Ctrl + ;
B. Ctrl + :
C. Ctrl + D
D. Ctrl + T
nmdcat.online BS Nursing
Jun 6, 2026

To select an entire row in Excel, which shortcut key is used?

A. Ctrl + Spacebar
B. Shift + Spacebar
C. Ctrl + R
D. Shift + R
nmdcat.online BS Nursing
Jun 6, 2026
Page 6 of 11
Jump to:

🏆 Top Contributors

  • N

    nmdcat.online

    6361 MCQs

  • N

    NMDCAT.ONLINE

    1 MCQ

  • G

    GULABsb

    1 MCQ

Categories

View all →