11th class Computer Unit 9 MCQs
76. If the custom format is 0000 then 12 will be displayed as:
a. 12
b. 0012
c. 000012
d. 00012
77. If the custom format is #,### then 1500 will be displayed as:
a. 120.0
b. 1,500
c. 120.0
d. 12.0
78. If the custom format is ###.00 then 1.2 will be displayed as:
a. 120.0
b. 1.20
c. 120.0
d. 12.0
79. The first part of number format describes:
a. Zero values
b. Positive number
c. Text values
d. Negative number
80. The second part of number format describes:
a. Zero values
b. Positive number
c. Text values
d. Negative number
81. The third part of number format describes:
a. Zero values
b. Positive number
c. Text values
d. Negative number
82. The fourth part of number format describes:
a. Zero values
b. Positive number
c. Text values
d. Negative number
83. The command used to merge a number of selected cells into one cell is called:
a. Merge &Center
b. Merge
c. One unit
d. Split
84. Which tab of format Cells dialog box is used to rotate the text?
a. Border tab
b. Number tab
c. Font tab
d. Alignment
85. The wrap text feature is available under what menu?
a. Format
b. Edit
c. Tools
d. Insert
86. Which is the faster way to change horizontal alignment in a document on?
a. Align Right
b. Align Left
c. Center
d. All
87. In text orientation feature, the direction of text can be changed to:
a. 90 degrees
b. 10 degrees
c. 45 degrees
d. All
88. The position of data in a cell is called:
a. Placement
b. Direction
c. Position
d. Alignment
89. By default, the numbers in the cell are aligned to:
a. Downwards
b. Left
c. Upwards
d. Right
90. By default, text in the cell is aligned to:
a. Downwards
b. Left
c. Upwards
d. Right
91. Which capability of spreadsheet can be used to show data graphically?
a. Functions
b. Formatting
c. Charts
d. Formulas
92. Which of the following is not an element of a chart?
a. Chart area
b. Plot area
c. Series
d. Fill handler
93. The vertical axis in charts is called:
a. X-axis
b. Z –axis
c. Slot
d. Y –axis
94. When the chart is created as a separate sheet, it is stored in:
a. Current workbook
b. Current worksheet
c. Separate workbook
d. A or c
95. Which Excel tool consists of the steps to create a chart?
a. Chart Tool
b. Graph master
c. Graph
d. Chart wizard
96. Which of the following is modified to add a title to chart and change title’s format?
a. Label options
b. Data series
c. Subtype
d. Series labels
97. Which of the following is not a type of chart?
a. Line
b. Column
c. Figure
d. Pie
98. Graphic representation of data is named:
a. Chart
b. Graphics
c. Figure
d. Picture
99. Page setup dialog box can be accessed through which menu?
a. View
b. File
c. Window
d. Edit
100. Page orientation is changed through which dialog box?
a. Page setup
b. Paper
c. Setup
d. Print
click here to go directly on chapter no.10