Microsoft Excel – Exercise – 2

61. A numeric value can be treated as a label value if it precedes with :

(a) Apostrophe ( ’ )
(b) Exclamation ( ! )
(c) Hash ( # )
(d) Tilde (~)

Answer
Answer : (a)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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

Answer
Answer : (a)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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

Answer
Answer : (a)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

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

Answer
Answer : (d)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

65. An excel worksheet can have a maximum of ________ number of rows .

(a) 65535
(b) 256
(c) 1048576
(d) 65536

Answer
Answer : (c)
Explanation
Explanation : No answer description available for this question. Let us discuss.
Discuss
Discuss : Write your answer. Click here.

Related Posts

  • Microsoft Excel - Exercise - 1Microsoft 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…
    Tags: excel, cell, data, worksheet, file, ctrl, general, computer
  • Microsoft Excel - 57Microsoft Excel » Exercise - 257. In which Menu will you get the validation command : (a) Insert (b) Data (c) Tools (d) Format
    Tags: excel, menu, command, insert, data, tools, general, computer
  • Microsoft Excel - 70Microsoft 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
    Tags: excel, command, formula, data, ctrl, general, computer
  • Microsoft Excel - 23Microsoft 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
    Tags: excel, command, formula, data, ctrl, general, computer
  • Microsoft Excel - 41Microsoft Excel » Exercise - 141. Which menu kept the Goal seek command : (a) Data (b) Tools (c) Insert (d) Format
    Tags: excel, menu, command, data, tools, insert, general, computer