If Any request contact us :techtanu17@gmail.com << Catch on Facebook << If any link broken, Plz tell. we try to fix them.

Monday 23 September 2013

MS-EXCEL OBJECTIVE QUESTIONS PART-3 FREE DOWNLOAD

GK Objective General Knowledge Computer Quiz Questions

GK  Objective General Knowledge Computer Quiz Questions

 Computer Knowledge Objective Type Questions

Computer GK Computer Awareness objective Questions for Exams

MS-Office objective questions free download.


MS-Excel, MS-Word,MS-PowerPoint  objective questions with answers/solutions.with are help full various teachers exam, and other exams.

121.    You can activate a cell by
a.   Pressing the Tab key
b.   Clicking the cell
c.   Pressing an arrow key
d.   All of above
ANS d

122.    Which of the following setup options can not be set in the page setup dialog box?
a.   Printer selection
b.   Vertical or horizontal placement
c.   Orientation
d.   Row and column titles
ANS a

123.    What term refers to a specific set of values saved with the workbook?
a.   Range
b.   Scenario
c.   Trend line
d.   What-if analysis
ANS b

124.    Got functions? No? You need the insert function dialog box. How do you get it?
e.   Right click a cell and then click insert
f.    Click the insert menu and then click function
g.   Type = in a cell
h.   All of the above
ANS b

125.    Which of the following describes how to select all the cells in a single column?
a.   Right click on column and select Pick from list
b.   Use data – text to columns menu item
c.   Left click on the gray column title button
d.   Pressing Ctrl + A on the keyboard
ANS c

126.    when you use the fill effects in the format data series dialog box, you can not
a.   rotate text on the chart
b.   select a fore ground color
c.   select a pattern
d.   select a background color
ANS a

127.    Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following?
a.   Rows and columns
b.   Headings
c.   Speed
d.   None
ANS c

128.    Which of the following is not a basic step in creating a worksheet?
a.   Save the workbook
b.   Modify the worksheet
c.   Enter text and data
d.   Copy the worksheet
ANS d

129.    What’s a quick way to extend these numbers to a longer sequence, for instance 1 through 20?
a.   Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows
b.   Select the range you want, include both cells, point to fill on the Edit menu, and then click down.
c.   Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special
d.   All of above
ANS a
130.    To insert three columns between columns D and E you would
a.   Select column D
b.   Select column E
c.   Select columns E, F and G
d.   Select columns D, E, and F.
ANS b



FOR MORE QUESTIONS CLICK BELOW LINK AND DOWNLOAD QUESTIONS WITH ANSWER. IT'S FREE

MS-EXCEL OBJECTIVE QUESTIONS PART-5 FREE DOWNLOAD

MS-EXCEL OBJECTIVE QUESTIONS PART-6 FREE DOWNLOAD

IF YOU HAVE ANY STOCK OF QUESTION, THEN PLEASE SEND ME FOR OTHER HELP FULL STUDENTS.

IF YOU FIND ANY ANSWER WRONG, COMMENT ME, SO THAT I RIGHT THAT ANS.
THANKS



0 comments:

Post a Comment