Q21. Long text can be broken down into many line within a cell. You can do this through
a) Justify
b) Wrap Text
c) Conditional Formatting
d) None of the above
Answer – [B]
Q22. How do you rearrange the data in ascending or descending order?
a) Data, Sort
b) Data, Form
c) Data, Table
d) None of the above
Answer – [A]
Q23. Worksheet is also called an array of ………….
a) Column
b) Cells
c) Box
d) Formula
Answer – [B]
Q24. What command is used to close the window of Excel?
a) Alt + F4
b) Ctrl + W
c) Ctrl + R
d) Ctrl + C
Answer – [A]
Q25. Which tab is used to include Pivot table, Charts, Hyperlinks to a spreadsheet?
a) Insert Tab
b) Page Layout Tab
c) Data Tab
d) Review Tab
Answer – [A]
Q26. Which tab in Excel is used when Importing, Querying, Outlining and Subtotaling the data placed into worksheet’s data list?
a) Formula Tab
b) Data Tab
c) Review Tab
d) Insert Tab
Answer – [B]
Q27. Which tab is used for Proofing, Protecting, and marking Up a spreadsheet?
a) Formula Tab
b) Data Tab
c) Review Tab
d) View Tab
Answer – [C]
Q28. Which tab in MS-Office is best for organizing data and making list?
a) Access
b) Excel
c) Power Point
d) Word
Answer – [B]
Q29. Which tab is used to change the display of worksheet area and the data it contains?
a) Page Layout Tab
b) Data Tab
c) Review Tab
d) View Tab
Answer – [D]
Q30. What is the shortcut key to hide entire column?
a) Ctrl + H
b) Ctrl + 0
c) Ctrl + –
d) None of the above
Answer – [B]