([Link]
com/) Login
([Link]
/login
/?url=https
%3A%2F
%[Link].c
fundamentals%2Fprac
mcq-question-
on-ms-
excel%2F
%3Fsection%3D2%26
Home ([Link] Aptitude ([Link]
English ([Link]
Reasoning ([Link]
DI ([Link]
GK ([Link]
Current Affairs ([Link] Interview ([Link] Computer
Programming Engineering More Ask Question ([Link]
Microsoft Excel mcq questions With Answer | MS Excel || Computer Fundamental
Home ([Link] / Computer Fundamentals ([Link] / MS Excel
Section 1 ([Link]
Section 2 ([Link]
Section 3 ([Link]
41. How do you delete a column?
A. Select the column heading you want to delete and select the Delete Row button on the standard toolbar
B. Select the column heading you want to delete and select Insert Delete from the menu
C. Select the row heading you want to delete and select Edit>Delete from the menu
D. Right click the column heading you want to delete and select delete from the shortcut menu
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option D
Solution:
Right click the column heading you want to delete and select delete from the shortcut menu in Excel 2003.
From 2007 and Higher version Home > Delete > Delete Sheet Columns.
42. How can you find specific information in a list?
A. Select Tools > Finder from the menu
B. Click the Find button on the standard toolbar
C. Select Insert > Find from the menu
D. Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option D
Solution:
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
43. When integrating word and excel, word is usually the
A. Server
B. Destination
C. Client
D. Both b and c
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option D
Solution:
When integrating ms-word and excel, word is usually the Destination and Client .
44. When a label is too long to fit within a worksheet cell, you typically must
A. Shorten the label
B. Increase the column width
C. Decrease the column width
D. Adjust the row height
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option B
Solution:
When a label is too long to fit within a worksheet cell, we must increase the column width.
45. The name box
A. Shows the location of the previously active cell
B. Appears to the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
Answer & Solution Discuss in Board ([Link] Save for Later
Answer & Solution
Answer: Option B
Solution:
Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the
worksheet. You can also use the name box to quickly create a named range.