Home Tab

Total Questions: 12

1 - The thin black cross-shaped pointer in MS Excel is used to ----:

A ) Resize
B ) Move a group of cells
C ) Complete lists and fill patterns ✅
D ) Highlight duplicate cells

2 - In Excel from which tab can you write DOB like this YYY/MM/DD?

A ) Data Menu
B ) View menu
C ) Format menu ✅
D ) Insert menu

3 - To fill data in respect of a selected range you would typically use-----:

A ) Data entry
B ) Auto sum
C ) Copy-paste
D ) Autofill ✅

4 - You cannot link Excel worksheet data to a word document-

A ) Filter
B ) Active Cell highlighting ✅
C ) Data Validation
D ) Freeza Panes

5 - How to copy data from one Excel sheet to another Excel sheet?

A ) Paste special ✅
B ) Referencing
C ) Formulas
D ) None of these

6 - Borders can be applied to which of the following elements in a document---------:

A ) Images
B ) Hyperlinks
C ) Footnotes
D ) Cell, Table & paragraph ✅

7 - How do you automatically adjust the width of a column in Excel?

A ) Double click the column header
B ) Double click the left border of the column
C ) Double click the right border of the column ✅
D ) All of these

8 - Two cells are mixed with a ----:

A ) Combine cell
B ) Unify cell
C ) Merge cell ✅
D ) None of these

9 - Which of the following you can paste selectively using paste special command:

A ) Formats
B ) Validation
C ) Formulas
D ) All of these ✅

10 - Formatting a cell in currency you can specify:

A ) Currency Symbol
B ) Decimal Places
C ) Both A and B ✅
D ) None of these

12 - Which Excel feature is associated with a bold line appearing around a cell when selected?

A ) Filter
B ) Data validation
C ) Action cell highlighting ✅
D ) Freeze panes