File Tab

Total Questions: 8

1 - In MS Excel Readymade templates are available under ------ tab ?

A ) Insert
B ) Design
C ) File ✅
D ) None of these

2 - How does MS Excel Autosum a file by default?

A ) Every 10 minutes ✅
B ) Every 20 minutes
C ) Every 30 minutes
D ) Every 40 minutes

3 - When applying conditional formatting you can check the conditions against:

A ) Cell value
B ) Formula Cell
C ) Both A and B ✅
D ) None of these

5 - In MS Excel 2016, 'conditional formatting' option is available in menu.

A ) Page layout
B ) Formulas
C ) Home ✅
D ) Insert

6 - How to duplicate values in a cell range in MS Excel 2016?

A ) Select the range of cells in the worksheet ✅
B ) Click the conditional formatting button in the styles group of theme
C ) Both A and B
D ) None of these

7 - How can view a cell comment?

A ) Click the edit comment commands on the insert menu
B ) Click the comment command on the view menu
C ) Position the mouse pointer over the cell ✅
D ) Click the display comment on the window menu

8 - How to fit long texts in a single cell with multiple lines?

A ) Start typing in the cell and press the inter key to start another line
B ) Use the wrap text option in the format _>alignment menu ✅
C ) Use the shrink to fit option in the format _>cells _>alignment menu
D ) All of these