Formatting Worksheets
1. You can set Page Border in Excel from
A.  From Border tab in Format Cells dialog box B.  From Border tool in Formatting toolbar C.  From Line Style tool in Drawing toolbar D.  You can not set page border in Excel
2. Which of the following is invalid statement?
A.  Sheet tabs can be colored B.  Some picture can be applied as a background of a sheet C.  You can set the column width automatically fit the amount of text D.  The width of a row and be specified manually or fit automatically
3. You can auto fit the width of column by
A.  Double clicking on the column name on column header B.  Double click on the cell pointer in worksheet C.  Double clicking on column right border on column header D.  Double clicking on the column left border of column header
4. By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
A.  Right click on Sheet Tab of third sheet and choose Delete from the context menu B.  Click on Sheet 3 and from Edit menu choose Delete C.  Both of above D.  None of above
5. Which of the following action removes a sheet from workbook?
A.  Select the sheet, then choose Edit > Delete Sheet B.  Select the sheet then choose Format > Sheet > Hide C.  Both of above D.  None of above
6. Which menu option can be used to split windows into two?
A.  Review > Window B.  View > Window > Split C.  Window > Split D.  View > Split
7. Which setting you must modify to print a worksheet using letterhead?
A.  Paper B.  Margin C.  Layout D.  Orientation
8. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
A.  Unfreeze panes command on the window menu B.  Freeze panes command on the window menu C.  Hold titles command on the edit menu D.  Split command on the window menu
9. Which of the following is not a worksheet design criterion?
A.  Efficiency B.  Aditibility C.  Description D.  Clarity
10. A typical worksheet has ________ number of columns.
A.  128 B.  256 C.  1024 D.  16384