Microsoft Excel – 2 – 3

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

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

ANSWER

EXPLANATION

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

EXPLANATION

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

EXPLANATION

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

EXPLANATION

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

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

ANSWER

EXPLANATION

1 2 3 4 5 6 7 8 9 10
Be a Part of The New & Next

MCQs fb  MCQs G+

Share the Knowledge

Shares
Copy Protected by Chetan's WP-Copyprotect.