Practice Questions

Which function is used to concatenate (join) text strings in Excel?

A. SUM()

B. JOIN()

C. CONCATENATE() ✓

D. TEXT()

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com 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

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com 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

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

Which feature allows you to display only the rows that meet certain criteria in Excel?

A. Sort

B. Filter ✓

C. Conditional Formatting

D. Subtotal

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

What is the shortcut key to toggle between relative, absolute, and mixed references in a formula?

A. F2

B. F3

C. F4 ✓

D. F5

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

What is the primary purpose of ‘Data Validation’ in Excel?

A. To color-code cells.

B. To restrict the type of data or values that users enter into a cell. ✓

C. To automatically correct spelling errors.

D. To analyze large datasets.

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

Which function in Excel checks if a condition is met, and returns one value if true and another if false?

A. SUMIF()

B. COUNTIF()

C. IF() ✓

D. VLOOKUP()

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

What is the shortcut key to create a chart from selected data in Excel?

A. F7

B. F8

C. F11 ✓

D. F12

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

Which feature helps you enter a series of data (e.g., numbers, dates, days of the week) into adjacent cells automatically?

A. AutoSum

B. AutoFilter

C. AutoFill ✓

D. AutoCorrect

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com 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.

Read More Details about this Mcq:

mintcream-chough-797767.hostingersite.com BS Nursing

Jun 6, 2026

1 ... 140 141 142 143 144 ... 637

Page 142 of 637

Jump to:

Practice Questions

Which function is used to concatenate (join) text strings in Excel?

What is the keyboard shortcut to move to the previous sheet in Excel?

What is the keyboard shortcut to move to the next sheet in Excel?

Which feature allows you to display only the rows that meet certain criteria in Excel?

What is the shortcut key to toggle between relative, absolute, and mixed references in a formula?

What is the primary purpose of ‘Data Validation’ in Excel?

Which function in Excel checks if a condition is met, and returns one value if true and another if false?

What is the shortcut key to create a chart from selected data in Excel?

Which feature helps you enter a series of data (e.g., numbers, dates, days of the week) into adjacent cells automatically?

What does ‘Wrap Text’ do in Excel?

🏆 Top Contributors

Categories