Ms Excel Mcqs for ( NTS, PTS, KPPSC, FPSC,PPSC SPSC, OTS, ETEA) Set 10

181. “Qtr 1, Qtr 2, Qtr 3” is an example of a
a. Formula
b. Function
c. Series
d. Syntax

182. You can edit existing Excel data by pressing the
a. F1 key
b. F2 key
c. F3 key
d. F4 key

183. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is …. a.  G1-G10
b. B1.G10
c. B1;G10
d. B1:G10

184. A user wishes to remove a spreadsheet from a workbook.
Which is the correct sequence of events that will do this? 

a.  Go to File-Save As – Save As Type – Excel worksheet
b. Right click on the spreadsheet tab and select DELETE
c. Right click on the spreadsheet and select Insert – Entire Column
d. None of above

185. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula? 

a.  Goal Seek
b. Scenario Summary report
c. Forecasting
d. Trend line

186. what term describes a background that appears as a grainy, non smooth surface
a. gradient
b. pattern
c. solid
d. texture

187. Excel is a
a. Graphic program
b. None of these
c. Word processor
d. A spreadsheet

188. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called 

a.  HTML
b. Pivot Table Field List
c. Pivot Table List
d. Pivot Table Report

189. Which of the following is not a valid Zoom percentage in Excel? a. 10
b. 100
c. 300
d. 500

190. The spelling tool is placed on ______ toolbar
a. Standard
b. Formatting
c. Drawing
d. Reviewing

191. If you need a text to show vertically in a cell. How will you achieve this?
a. Choose Vertical on Text alignment in Format Cells dialog box
b. Choose 90 Degrees in Orientation of Format Cells dialog box
c. Choose Distributed from the Vertical drop down list of Format
Cells dialog box
d. Choose Center Across Selection from Horizontal combo box in Format Cells dialog box

192. Can you set 0.5 inch left indentation for a cell in Excel?
a. Excel does not have indentation feature
b. You can specify indentation only if you turn the rulers on
c. Indentation can be set from Format Cells dialog box
d. The indentation can be specified only when printing

193. You can automatically adjust the size of text in a cell if they do not fit in width by
a. Double clicking on the right border of column header
b. From Format choose Columns and then Autofit Selection
c. From Format Cells dialog box mark Shrink to fit check box
d. All of above

194. Formatting a cell in Currency, you can specify
a. Decimal Places
b. Currency Symbol
c. Both of above
d. None of above

195. Formatting a cell in Number format you can’t set
a. Decimal Places
b. Use 1000 separator
c. Negative numbers
d. Currency Symbol

196. What is entered by the function =today()
a. The date value for the day according to system clock
b. The time value according to system clock
c. Today’s date as Text format
d. All of above

197. Which function will you use to enter current time in a woksheet cell? 

a.   =today()
b. =now()
c. =time()
d. =currentTime()

198. Special category of Number tab in Format Cells dialog box can be used to apply formats like a.   Zip Code
b. Phone Number
c. Both of above
d. None of above

199. Merge cells option can be applied from
a. Format Cells dialog box Alignment Tab
b. Formatting toolbar
c. Both of above
d. None of above

200. Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from a.   from Fromat >> Cells
b. from Format >> Autoformat
c. from Table >> Autoformat
d. All of above 

Answers:

181 - c 
182 - b 
183 - d 
184 - b 
185 - d 
186 - a 
187 - d 
188 - d 
189 - d 
190 - a 
191 - b 
192 - c 
193 - c 
194 - c 
195 - d 
196 - a 
197 - b 
198 - c 
199 - a 
200 - b