61. A numeric value can be treated as a label value if it precedes with :
(a) Apostrophe ( ’ )
(b) Exclamation ( ! )
(c) Hash ( # )
(d) Tilde (~)
62. Which of the following statements is not true about linking Microsoft Excel data to Word document :
(a) it is not necessary for this setup for the source file be always available to provide data for the destination file
(b) when we edit the linked data, we actually open the source application and file and all editing is done in the source file
(c) in this process the Word document automatically gets updated when data in MS-Excel changes
(d) the destination file contains only a reference point to the source file
63. Selecting Portrait changes our page from :
(a) a wide to tall orientation
(b) a tall to wide orientation
(c) a normal font size to a condensed one
(d) a condensed font size to a normal one
64. The purpose of AutoSum is to :
(a) total and range that we select
(b) locate and total the rows and columns in a range nearest to the current cell
(c) add grand totals to a range containing other totals
(d) all of the above
65. An excel worksheet can have a maximum of ________ number of rows .
(a) 65535
(b) 256
(c) 1048576
(d) 65536
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