96. The Edit menu has an option Clear in it. Its sub menu has the following options :
(a) All, Formats, Contents and Notes
(b) Only All and Formats
(c) It is without a sub menu
(d) All, Formats and Contents
97. A worksheet is made of columns and rows, wherein :
(a) columns run horizontally and rows run vertically
(b) columns run vertically and rows run horizontally
(c) the run is dependent on the application being used
(d) Both (b) and (c)
98. By which menu we can make database of our worksheet data :
(a) Form
(b) Filter
(c) Database
(d) Data
99. To remove the grid lines the option is available under :
(a) Tools>Options
(b) Views>Options
(c) Format
(d) Tools>Wizard
100. How many types of drawing objects are available in drawing toolbar :
(a) 4
(b) 5
(c) 10
(d) 12
Related Posts
Microsoft Excel » Exercise - 1 1. For opening and closing of the file in Excel, you can use which bar ? (a) Formatting (b) Standard (c) Title (d) Formatting or Title 2. Which of the following is the latest version of Excel : (a) Excel 2002 (b) Excel XP (c) Excel 2013 (d) Excel ME 3. In Excel the intersection of a column and a row is called : (a) Cell (b) Grid (c) Table (d) Box 4. Anything that is typed in a worksheet appears : (a) in the formula bar only (b) in the active cell only (c) in both active cell and formula bar (d) in the formula bar first and when we press ENTER it appears in active cell 5. Crtl + C is equivalent to : (a) Copy (b) Cut (c) Paste (d) Delete 6. Roman Symbol for last column in an Excel sheet is represented by : (a) XFA (b) XFB (c) XFC (d) XFD 7. Which shortcut command is used to reach the next worksheet : (a) Page down (b) Ctrl + Page down (c) Ctrl + -> (d) Tab 8. Named the shortcut key to fill the value of just above cell : (a) Ctrl + D (b) Ctrl…- Microsoft Excel » Exercise - 257. In which Menu will you get the validation command : (a) Insert (b) Data (c) Tools (d) Format
- Microsoft Excel » Exercise - 270. Which command is used to copy the formula not the value from one data to another : (a) Paste (b) Paste special (c) Ctrl + V (d) Hyperlink
- Microsoft Excel » Exercise - 123. Which command is used to copy the formula not the value from one data to another : (a) Paste (b) Paste special (c) Ctrl + V (d) Hyperlink
- Microsoft Excel » Exercise - 141. Which menu kept the Goal seek command : (a) Data (b) Tools (c) Insert (d) Format