PTS Sindh Police IT Department Old Papers, Information Technology MCQs, MS Word, Power Point and Computer Science MCQs for PPSC, AJKPSC, PPSC, FPSC ,KPSC, BPSC ,NTS, OTS and PTS This material is helpful for PTS, NTS , OTS, PPSC , FPSC , KPSC, BPSC , in sindh

Whom we are looking for

Experience Requirements

PTS Sindh Police IT Department Old Papers, Information Technology MCQs, MS Word, Power Point and Computer Science MCQs for PPSC, AJKPSC, PPSC, FPSC ,KPSC, BPSC ,NTS, OTS and PTS
This material is helpful for PTS, NTS , OTS, PPSC , FPSC , KPSC, BPSC , SPSC and AJKPSC Computer Science , Information Technology and Steno tests.
INTRODUCTION TO COMPUTER
Who is known as father of Computer?
(3) Charles Babbage (b) Alan Turing (c) Bill Gates (d) rirn Berners-Lee
Internet mostly uses for purpose of (a) Entertainment (b) Business (c) E mail (d) Chat
3 What type of devices are CDs or DVDs? (a) Output (b) Input (c) Electric (d) Storage
4 Who created Pretty Good Privacy (PGP)? ..0) Paul Zimmerman (b) Ken Thompson (c) Bill Gates (d) Tim Berners
5. What kind of computer memory is both static and nonvolatile? '(a) OM (b) RAM (c) RAN (d) NAM
6. What type of device is a digital camera? (a) Output (b) Input (c) Electric (d) Mechanic
10.
Which of the following is command? (a) Ping (c) 6111 Trn
What is a URL? ia)' The address of a page on the World Wide Web (b) The title of a web site (c) The bile memory Card (d} None of the above W*h of the following is not an Internet bfawserl (a) Netscepe (c) WAN
not a network
(b) Netcfg (d) BMW

What is a cookie? I) Internet information file (b) Hedcer file (c) Customary File (d) Norte of the above
(b) AOL (d) None of these
11. There is a process in which an item or file is moved into an application or environment which is different than that native to it What is it called? (a) Download (b) Transfer (C) Import (d) Protocol 12. The kernel provides low-level services_ Which of the following is included in Kernel's services? (a) Hardware-software interaction. (b) Memory management (c) Both of them (d) None of them 13. What is used in a computer to protect a networked server from damage by those who log in to it (a) Antivirus (b) Firewall (c) Gateway (d) Flow Control 14 What is called a graphical representation of a directory or subdirectory? (a) Directory (b) Folder (c) Partition (d) Extension 15 -BAT" extension refers usually to what kind of file? (a) System file (b) Backup file (c) Main File (d) Auto File
16 What was the first ARPANET message? (a) "Hello World' (b) "La" (c) Sir (d) Done
17 A Cathode Ray Tube is found in what? (a) Monitor (b) CPU (c) Mouse (d) Keyboard
18. Which of the following is not an image file? (a) PEG (b) TMP (c) TIM (d) BING 19. Which one is not an output device? (a) Keyboard (b) Modem (c) CPU (d) Mouse
20 Which is the fastest type of computer memory? (a) Cache (c) Micro
(b) Flash (d) ROM
21 What is the name of the professor who coined the name virus for self replicating programs? (a) Tim Berners-Lee (b) Ken Thompson (c) Alan Turing (d) Fred Cohen 22. The capacity of computer bus depends upon (a) Capacity of CPU (4 Capacity of the microprocessor (0) The number of data lines it contains (d) The system software 23 The interface between user and computer is (a) Programming (b) Hardware (c) Memory (d) Processing What type of device is a computer mouse/ (a) Output (b) Input (c) Board (d) Division 25 Which of the following is the section of a hard drive? (a) Partition (c) Board 26. Where is the headquarters of Microsoft located (a) Redmond, Washington lb) Santa Clara, California (c) New York USA (d) Paris France 27 *BAK" extension refers of file (e) Backup file (C) Board file 28- One MB is equal to (a) 1024 Bytes (b) 1224 KB whicb one works29 devise (a) Winner (c} Board 30. windows is" user.dat wircreg 0431 t .4,1 SyS e • •LIC" 10)8. it_ tiser,dat and

(b) Room (d) Division



as
usually to what kind (h) Audio file (d) Division file (b) 1 024 KB (b) 1324 KB an output and input (b) Modem (d) Division consists of which
(G) Beth a
two
31
(d) None of the above
lIrnl Guide
Why was the first Intel Celeron promsor not as popular as exper;tedl (a) No level
2 the (b) Caused Excess heat (c) Both a & d (d) None of the above
32. A computer tower is NOT (a) A CPU A peripheral (c) Both a & b (b1 (d) None of these
33. What does BIOS stand for? (a) Binary iip and otp system (b) Biological Internet (c) Botha&b (d) None of the above
34. FORTRAN, a computer programming language is mainly used for what purpose? (a) Business applications (b) Scientific Research (c) Word Processing (d) None of these
35 Compact discs, (according to the original Ca specifications) hold how many minutes of music? (a) 74 RIMS (b) 60 mins (C) Both a & b to) None of these
36 Which one is an email address (a). effi _ iqbat@hotmail.com (b) httpidiviariet,comiindantm (e) httpAlmi.corrifindexttrn (d) None of the above
37 Vi tick hard disk will be able to store more (3) 240tg information? (c) Both a & b (b) 24MB
38. (d) None of these filesWhich file extensions indicate only graortics (a) REG and IXT (b) BNIP and GtF (o) BO a b In the vivid of computers, what is bus width') FA None of these (a) The number of pinS in a computer per (c) Bow a b CPU soultaneoosiy nt to
3 (t4 /The numbeg of bits that can oe se (d) None of the above What does the term IRO statitt for?
(a) Interrupt Request
(b) Interrupt Request Due (e) Both a & b (d) None of the above
41 What type of device is a 3 1/2 inch floppy drive? (a) Storage (c) Both a & b (d) None of these
(b) Software
42. Which Windows program manage folders and files? li) Windows Explorer (b) Windows Accessories (c) Both a & t (d) Norte of the above
43. A Computer Virus cannot be contracted by '(a) Computer Scanner (b) Floppy diskette (c) Both a & b (d) None of the above
44. A computer port is used to '(a) Communicate with other computer peripherals (b) Download files from the web (c) Both a & b (d) None of the above
45, yVhat type of device is a computer keyboard" (a) input (b) Output (c) Both a & b (d) None of these
46. Which computer is the fastest? (a) Pentium 600Mliz (b) Pill 500MHz (c) Both a & b (d) None of these
47• In order for your computer to play music you need (a) „Nothing more than the internal speaker (b) A sound card and speakers (c) Both a & b (t1) None of the above What Islatericy? (WIN number of clock cycles needed to read a particular bit of Information (b) The .gap between a processor lc) Both a 4 b (d) None of the above
4t3 Which was the first company in the world to facture computers for commercial use? Remington Rand
do you

use to
48,
251
lc) Hewlett-Packard IBMwlett-Packard (d) Apple Computers 50 Which of the following computers was the first louse the concept of stored programs/ (a) Mark I (b) EN lAC (c) EDSAC (d) UNIVAC•I
51 What is referred by 'path"' (a) Specifies the location of a software (b) Specifies the location of a hardware (c) Specifies lire location of a web (d) Specifies the location of a file 52 Which of the following is a PC video file extension" (a) MVE (to) AVI (c) Both a & b (d) None of these
53. Which kind of computer memory is the first to activate when you turn on your computer? (al BIOS (b) RAM (C) ROM (d) UPS
54. What is a memory cache" The amount of memory your computer has on hand for any particular task (n) A temporary memory storage device that keeps certain data available for quick reference (c) Both a & b (d) None of the above
(a)
55. When your computer speed begins to drop, which element of memory is likely overtaxed? '(a) RAM (b) ROM (c) BIOS (d) LAN
56, Which of the following is not an operating system? (a) Windows (c) BIOS \

57, What type of device is a (b)m (a) Input co PuOleutpr Output monitor? (c) ROM In order le access the W(clo)Irld8WIOidS b Wide BIOS You 7)6 Aii Internet connection an Internet (b) A Modern an 1,- Serves Provider and browser software (C) Both a & band a ,tiowser (d) None of the above
(b) OSD (0 LAN
58.
43l
59. The sampling rate, (how many samples per second ate stored) for a CD is. .? In) 44.1 kHz (b) 48.4 kHz (c) Both a & b (d) None of these 60 Software is a (a) Set of instructions (h) Collection of programs (c) Set of information (d) Joining of programs 61 What is degauss? (a) Creating magnetic media (11),' Erasing magnetic media (c) Both a & (d) None of the above 62 Which of the following file extensions is not an audio file format? (a) COM (b) AIF (c) RAM (d) CPU The resolution of a printer is measured in (a) Dots per inch (b) inches (c) Both a 8 b (d) None of these 64 'TMP" extension refers usually to what kind of file? (a) Temporary file (b) Audio file (c) Both a & b (d) None of these
65. The Intel Pentium hugiflaw was an issue with the (a) FPU (b) Cache (c) RAM (d) CPU 66 Typically, hard disk drives employ what technology as a storage mechanism/ (a) Magnetic (b) Light (c) Both a & b (d) None of these 67 What type of device is a computer printer? (a) Input (0/ Output (c) Both a 8 b (d) None of these Which Indian co-founder of Hatmail in 1996 and then sold the company to Microsoft? (a) Sabeer Bhatia (b) Alan Turing (C) Ada Byron Lovelace(d) Bill Gates 69. Who is the owner of the Microsoft Computer Company? (a) Charles Babbage (b) Alan Turing (c). Bill Gales (Id) Inn Berners-Lee



70 USB is the. acronym for lay Universal Serial Bus (b) Urgent Serial Bus (C) Universal Serial Service (d) Universal service Bus 71. Which is the oldest sears engine oi *ft founded in 1993)? (a) Google (c).,, 4:web
(d) MSti 72. British scientist Tim Berrires-iLee, was Tit founder of/ (a) Googie Company (C) 'World Wide Web 73. Who is considered programmer? (a) Ada Lovelace (c) Tim Bernerslee
(b) Yahoo Mai (d) Hotrod to be the ftv
(b) Alan Turing (I.1) Brlf Gates
74 When was the first e-mail sent/ (a) 1963 (b) 1*9 (C) 1971 (d) 1974 75. Where is the BIOS stored') (a) On the hard drive (b) On a diskette (C) On a USB drive (d) On a flash memory chip 76. Who was one of the original founders Intel Corporation? (a) Bill Gates (b) Jerry Yang (0' Gordon E, Moore (d) Sergey 77 Which of the following is not a s-JcIal network site? (a) Amazon (b) MYSfam (c) Orkut (d) Twitter 78. Vt/ho created the first mouse in 19631 (a) Douglas Eriglebart (0) BiliGates (c) John Mauchly (0) Robert rar.e. 79. How many bits is a byte? ,,-- (a) 4 (0 8 (c) 12 (d) 16 80. Computers calculate numbers in what mode? (a).._Decirrial (b) ectal Id) Binary (a) None 01 OM What is the White Book? (a) Specifications for 00•R. MAW Discs (b) Specifications for Oigrtal Audio CD
81.
Ihni Guam
(C) Specifications for Computer Data CD (d) -Specifications for VCD and Photo CD 82. Which country's people Wised more internees? (a) America (b) Japan (c) India Id) China Name of the great Muslim scientist who was considered as one of the founders of computer (a) R.t Khawarizmi (b) Zakerya (c) Abu Sina Id) Pascal 84. Who found the term "cyberspace") (a) Thomas Watson (b) Bill Gates (C) Steven Spielberg id) Wiliam Gibson 85, What is the meaning of Fetch? (a) To retrieve data or instructions from storage (b) A programming language that influenced LISP (c) Specifications for Computer Data CD (d) Specifications for VCD and Photo CD 86 Who sent the first e•mail? (erRay Tomlinson in 1971 (b) Alan Turing in 1971 (c) Bill Gates in 1971 (d) Tim Berners-Lee in 1971 87. UNIX.was developed by tai Bell laboratories (b) John Mauchly (c) Google Company (0) Robert Noyce Who is the founding father of Yahoo? (a) Larry Page and Sergey Brin (b) _Sabaer Shelia and Jack Smith 'Ic) Jerry Yang and David Filo (d) None of these Who 'is the founding father of Hotrriad? (a) Larry Page and Sergey Brin tb Sabeer Bhatia and Jack Smith (c) Jerry Yang and David Filo (d) None of these which is the worlds largest web-based email sprvice with 369 million members? la) Windows bve Hotrnail (b) Gmall
83.
88
90



(c) Yahoo( Mail (d) None of these 91 Goole is an American multinational corporation which provides Internet-related products and services, including Internet search, cloud computing„ software and advertising technologies. Who is the founding fattier of Coop? 'VI Larry Page and Sergey Brin (b) Sabeer Bhatia and Jack Smith (c) Jerry Yang and David Filo (d) None of these 92. A method of transferring information (often text message) from one computer to anotner over a network is catled: (a) Electronic Mail (E-Mail) (b) FAX (c) Downloading (d) Data transfer 93 What is called is the coding or scrambling of information in a hie So that it can only be decoded and read by someone who has the correct ,.ecoding key? (a) Encryption (b) Java applet (c) Firewall (d) Encoding
94 What is called the high-capacity optical disc that looks like a CD. but can store much information then CD? (a) Digital Versatile Disc (DVD) (b) Super Density disc (SD) (c) Digital Video Disc (DVD) Id) All of these 95. Who or what is Lara Croft? (a) The first Apple computer that featured a mouse (b) The first female CEO of AOL (c) A programming language influenced LISP (d) The main character in the Tomb Raider g 96. In Which year was ASCII formed (a) (c) ;996833 97. (a) 1022546 r4tteesS I Picture » Clip Art (a) It inserts a clipart picture into document (b) It lets you choose apart to insert into document (c) It opens Clip Art taskbar (d) Noce of above 32. Which option is not available in Insert Table Autofit behavior (a) Fixed Column Width (b) AuloFit to ContentS (c) Autofit to Window (d) Autofitto Column 33. To autofit the width of column (a) Double dick the right border of column (b) Double click the tell border of column (c) Double click the column header (d) All of above 34 From which menu you can insert Header and ((law)) teFormatInsert r Insert neun ((bd )) VTools Iew ivikieenhul 35 enter footer text? After typing header text, ho can elck on Switch bet,„ an-i-j-tyypoeu quickly the .ext (a) Press PageDown key for 'rooter n Heder Foote'.
then type the text (c) Both of above (d) None of above
3' When inserting Page number in looter it appeared 1 but you wish to show a How can you do that/ (a) From format menu choose bullets and Numbering and configure necessary setting (b) From Insert menu choose Page Number and specify necessary setting (c) Click on Page Number Format tool and specify required setting (d) All of above 37 Which of the following statement is false/ (a) You can set different header looter for even and odd pages (b) You can set different page number formats for different sections (c) You can set different header rooter for first page of a section (d) You can set different header and footer for last page of a section 38. Where can you change align ment? (a) Formatting toolbar (b) Paragraph dialog box (c) Page Setup dialog box (d) Standard toolbar 39 To get to the 'Symbol' dialog box, click on the menu arid choose 'Symbol' (a) insert (b) Format (c) Tools (d) Table 40. Which of the following 'symbol sets .would be most likely to contain a mathern.atical symbol such as a degree sign. greater than or equal to, or a Greek letter") (a) Wingdings (b) Wingdings 3 (d)' Symbol (c) Welxiings 41 Pressing Fa key for three times selects (a) A word (b) A sentence (c) A paragraph (d) Entire document 42, What happens if you press Ctrl + Shift + F8? (a) It activates extended selection (t) it activates the rectangular selection
the vertical
nGuield (c) it selects the paragreob on insertion tine is. (d) None of above 43. How can you disable extended seteelsee triode? (a) Press F8 again to disable (b) Press Del to disable (o) Press Esc to disable (d) Press Enter to disable 44 What does EXT indicator on status bar of MS %/iced indicate/ (a) It indicates whether the external text is pasted on document or not (b) II indicates whether extended add-ons are installed on LIS Word or not (c) It indicates whether Extended Selection mode is turned on or off (d) None of above 45. What is the maximum number of hnes you can set for a drop cap? (a) 3 (b) 10 (e) 15 (d) 20 46, What is the default number of lines to drop for drop cap? (a) 3 (b) 10 (c) 15 (d) 20 47. What is the shortcut key you can press to create a copyright symbol*? (c) Ctft C (d) C (b) Alt + C 111 + Shift + C (a) Ait+Cet+C 46. How many columns can you insert in a word document in maximum/ tbl 45 (a) 35 (d) 65 (c) 55 49. What is the smallest and largest font size available in Font Size tool on formarog toolbar? 50 (b) 8 and 64 ((ac)) 812anandd7272 Whfor and yis the maximum font slize: can ply (a) 163 (d) None 01 aeove aboye (c) 1,6038 character? (d) NcPne 51, When assigning a shortcut keY to
5712( to select a: Y r xe you should alweys trY combination that is`
BO Guido
la) unassigned (b) Located on the ten-key pad section of your keyboard (c.) Assigned to another task (1) Front the same font family as the symbol. 62- Suppose you wanted to create an AutoCorrect entry that would type the words We regret lo inform you that your submission has been declined' Of the following choices, which would be the best name you could assign to this entry? (a) _Regret (b) Subdual (c) We regret to inform you that your submission has been declined (d) 11 53. If you want to convert a symbol or several tines of text into an Auto Correct entry, you should, (ay Insert the symbol or type the text in a Word document firs! Then, select the text or symbol and go to the AutoCorrect dialog box. (b) Click the Toots menu and choose AutoCorrect Options. Then, Glick the Insert menu and choose Symbol (or clx:k the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect (c) AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or rnulfiple lines of text into an AutoCorrect entry (d) Insert the symbol or type the text in a Word doormen! first. Then, select the text or symbol and Glick the Edit menu followed by Paste Special Select New AutoCorrect Entry and then click OK. AutoCorrect was originally designed to replace words as you type (a) Short, repetitive (b)llyincorrect (c Misspelled (d) None of the above 65. Mich of the Vowing is the second step in creating a macro? (a) Stan recording

54.
3O
(b) Using your mouse or keyboard. perform the task you want to automate (c) Assign a keyboard shortcut to the macro (d) Give the macro a name 56. If you will be displaying or printing your document on another computer. you'll want to make sure and select the option under the 'Save' tab (a) Eirrbed Fonts (b) Embed True Type Fonts (c) Save True Type Fonts (d) Save Fonts 57, In Word. the mailing list is known as the (a) Data sheet (b) Source (c) Data source (d) Sheet 58. Which of the following is not one of the three 'Mail Merge Helper steps/ (a) Merge the two files (b) Create the main document (c) Set the mailing list parameters (d) Create the data source 59 Vlithich of the following button will allow you to add. delete, or change records in your Data Source? (a) 'Data Source' button (b) 'Edit' button (c) 'Edit Data Source' button (d) Data editing' button


60 ft is possible to beforepe- rf orm,ng a merge. (a) Create (0 Sort
a data source
(b) Modify (d) all of the above
61 What is the default font size of a new Word document based on Normal template? (a) 10 pt (b) 12 pt (c) 14 pt (d) None of above document? 62. What is the default font used in MS 'Nord
63
(a) Times New Roman b) Arial c) Algerian d) Preell
Which tab in Font dialog box apply font effects contains options to a (a) Font lab (b) Character Spacing
Se4
to) toPiOffort4Il tilt glontU?d Toolbar t34 II you need to double underline a word, how will you do trial? (n) Go to Format menu and then Font option. Open Underline Style and choose Double Underline (0) From Format menu choose Font option arld then from Font tab open Underline Stykl and sitter:1 Double Underline sit the text then choose Formal ROI and on Font lab on Underline s%ie and choose Double Underline iig) CIO double underline tool on formatting Mbar DropCap means (a) Atl Caps (b) Small Caps (C) Title case (d) None of above
What Is the short cut key to open Font dialog box? (a) Ctrl F (c) Ctrl D (dl) Ctn. + Shift + V Now can you access the font size tool on formatting loather? (a) Ctrt S (b) Clri + Shift + S (c). Cul + P (d) Ctrl + Shitt P 68 How can you make the selected character superscripted? (a) Ctrl (b) Ctrl + shift -+ (c) Alt + CIO + (d) None of above 69. What does Cid + = key effecf? (a) Superscript (bf Subscript (C) All Caps (d) Shadow 70, What happens if you mark on Hidden check box of Font dialog box after you select some leg? The text is deleted from document and you need to bring from Recycle in if required again. (b) The text is hidden and you need to bring II by removing the check box if needed again (c) The text is deleted and cannot be returned back (d) The text Is hidden and cannot be returned back
(b) Alt + Ctrl + F
(a)
limi Guide
71 Now can you increase the font size Of selected text by one point every time? (a) By pressing Ctri (b) By pressing Ctrt + (c) By pressing Ctrl + ) (d) By pressing CIA 72. iNhich of the following line spacing is invalid, (b1 Double la) Single (d) %Ante (c),-Triple 73. How can you apply exactly the same formatting you did lo another text? (a) Copy the text and paste in new location Then type the new text again. (b) Copy the text and click on Paste Speoal tool on new place (c) Select the text then click on Format Painter and select the new text (4) All of above 74. What should you do if you require pasting the same format in many places? (a) Click the Format painter and go on pasting in many places holding All Key Double click the format painter then go on pasting in many places Click the format painter then go on pasting to many places holding CV! Key (d) All of above 75 On which toolbar can you find Format Painter tools Standard toolbar (b) Formatting toolbar (c) Drawing Toolbar (d) Picture Toolbar 76. Which indent marker controls all the Imes except first line? (a) First Line indent Marker (b) Left Indent Marker (c) Hanging Indent Marker (d) Right Indent Marker 77 How can you remove tab stop markers from ruler? (a) Double click the tab marker and choo&e, Clear All (b) Drag the tab stop 'marker out of the ruler (t) Right click the tab stop marker and choose remove (d) All of above
(c)
tirtli Guide
8 which operation you will perform ii you need to move a block of text? (a) copy and Paste 03) Cut and Paste (c) Paste and Delete (d) Paste and Cut 79, What is the extension of Word files? (a) FJL (b) DOT (cr.D-0C (d) TXT 80, Which of the following option is not available in insert Picture? (a) Chart (c) Clip Art
(b) Word Art .(d) Graph
St To insert a drop cap in one of the paragraph you should access (a) Insert litlenu -(b) Format (c) Tools (d) None of above 82. How many different positions can you set for drop cap? (a) 1 (b) 2 (0) 4 (d) 6 83 What is the maximum number pf lines you can set for lines to drop box-? (a) 3. (b) (er 10 (d) 15 84. Which of the following can NOT be used to create parallel style COitairt? (a) Format Tabs (b) Table Insert Table (c) Insert Tembox ICFormat Columns 85. Which of the following is used to create newspaper style columns? (a) Format Tabs (b) Table Insert Table (c) Insert Textbox (d) Format Columns
86 Columns dialog box can be opened from (a) Formal menu Columns submenu (b) Double click on column space in ruler (C) Press Alt + C + C t1) All of above 87, You can jump to the next column by (a) Cricking with your mouse on the next column (6) Press An + Down-arrow
305
-(6) Both of above (d) one of Above 88 How can you break the current column and Maria new column immediately? -0 Press Ctrl + Shift 4- Enter (b) Press Alt + Enter (6) Press CIO + Enter (d) Press Alt + Shift + Enter 89 What is the smallest width of a column? (a) 0' lb) 415' (c) (d) 15' 90. if the number of columns is selected 1 and the line between check box is marked, where is the line drawn? (a) in the left margin (b) in the right margin (c) both in lett and right margin (CC None of Above 91. The other Col# are inactive when you've select 3 columns. How will you activate those boxes? (a) double click on spacing box (b) double click on inactive Cof# (c) Remove mark from Line between checkbox (d) Remove mark from Equal Column Width check box 92 How much space in minimum must be provided between columns? (a) 0' (c) 1' as IVIcoso((ftdb)) "1°1.-55: 93 1v1Flacpaint, etc give Vie co mpwwu toerrdS. task es are called/ the user intscucactiesi which provide tools to What these El lo acconiplish a BegBatsners umns chalog (b) APPliCatiOn 9 4 (a)ne ruler double I click on the(d1) MS-DOSar p,eft mar - area of bOx quickly
(b) double vlick th ruler e space between area on (c) double chick the (d) 'VI of 1111 above In ruler 95. Which of
available Tthe following Com °6S' nlenU? Mand not
306
ilrni Guido
(a) Auto text (b) Autocorrect (c) Auto summarize (d) Macro 96 To move the cursor page to page of document (a) ClIrl+PoDn (b) Ctrt+PgUp (c) Both of the above (d) None of the above 97 Text boundary can be displayed or hidden from (a) Auto text option from Insert menu (b) Options from Tools menu (C) Customize from Tools menu (d) All of above 98. Which of the following are word processing softwareo (a) WordPerfect (b) Easy Word (c) MS Word (d) All of above 99. MS Office provides help in many ways, which of these is one of them? (a) What is this? (b) Office Assistant (c) Help menu (d) All of the above 100. You wished to justify text over the height of paper, which option will you choose (a) Page Setup from File menu (b) Paragraph from Format menu (c) From formatting toolbar (d) Font from Format menu Which of the following is not of the merge process'? (a) Sort the data source records (b) Format a main document (c) Edit a data source (d) Merge the two files to print or create a new document 102 There can be many ways to insert page number in a document. Which of the following lets you insert page number (a) Page number from Insert menu (b) Page Setup from file menu (c) Footnote from Insert menu

(d) Both a & C 103 Which is not a data source component? (a) mail merge toolbar (b) header row (c) data fields (d) data records 104. Which of the following is not the part of standard office suite? (a) Word Processor (b) Database (c) Image Editor (d) File manager 105. Where can you find the Draw Table tool button? (a) Standard toolbar (b) Formatting toolbar (c) Drawing toolbar (d) Tables and Formatting toolbar 106. Which of the following option in File pull down menu is used to close a MS Word documenP (a) Quit (b) Close (c) Exit (d) New 107 You need to jump to the next column breaking current column right at the cursor position. Now can you break column? (a) Pressing Ctri+Enter (b) Pressing Alti+Shift*Enter (o) Break command from Insert menu (d) Both b and c 108. Superscript, subscript, outline, emboss, engrave are known as (a) font styles (b) font effects (c) word art (d) text effects 109. Shimmer, Sparkle text, Blinking Background etc. are known as (a) font styles (b) font effects (c) ward art Id) text effects 110. The feature of Word that automatically adjusts the amount of space between certain combination of characters so that an entire word looks more evenly spaced. What is that feature called? (a) Spacing (c) Kerning


(b) Scaling (d) Positioning
rim; Guide
111.
moti of the following is not .available it Spaongl (a) Normal (by Loosely (c) Condensed (d) Exparripd 112. Which of the following position is not available for fonts on MS Word? d (a) Normal (b) Raise (c) Lowered (d) Centered 113 Whet is the maximum scale percentage available in Scale drop down. box'? (a) 500 (t) 200 (c) 100 (d) 90 114 Reid, italic, Regular are known as (a) font styles (b) font effects (c) ward art (d) text effects 115. You can refresh the Page by (a) Press Shift + F7 (b) Press Ctrl + F7 (c) Press Alt+ F7 (d) Press F5 116. You can Open a New Browser Window by Press (a) Shift + F7 (b) Ctrf +N (C) Alt+ F7 (d) F7 117. You can Refresh Current Window by Press fa) Ctrl+R (b) Ctrl+W (c) ClIrl+H (d) CIO LID 118 You can Close the Active Window by Press (a) Ctrl+R (b) MOW (d) Ctri+H (d) LiO 119, You can Opens the History Window by Press (a) Cfri+R (b) Ctrl+W it) Ctrl+H (d) Ctrl+ LIO 120 You can Opens the Locate or Open Dialog Wirioow by Press (a) Ctrt+R Cul+H
on I
121
(b) Ctri+W (d) Ctr1+ Lia
Uppercase on Change Case dialog box and All Caps on Fonts dialog box both converts selected text into Capital Letters. What's the difference between the two (a) Both are same They are only two different ways of capitalize text. It is faster to convert from Change Case than from Font dialog box (c) Change Case makes conversion
307
permanent but AJI Caps on Font can always be reverted (d) All Caps on Font dialog box makes the change permanent where Change Case can be always reverted 122. If you need to hide some paragraphs, how can you do A? (a) From Paragraph dialog box (b)' From Font dialog box (c) From Options Dialog box (d) None of above 123, Which of the following is the latest version of MS Word? (a) Word 2000 (b) Word 2007 (c) Word 2010 (d) Word 2011 124. Changing the appearance of a document is called (a) Proofing (b) Editing (c)- Formatting (d) All of above 125. In a document what is the maximum number of columns that can be inserted in MS Word Table? (a) 36 (b) 15 lc) 63 (d) 65 126. You can detect spelling and grammar errors bar (a) Press Shift + F7 (b) Press Ctrl + F7 (c) Press Alt+ F7 (d) Press F7 127. You can paste the text by Press (a) Ctrl+A (b) Ctrl+C (c) Ctri+X ((d) CCtri+V 128. You can Undo Command in word Microsoft by Press(a) Crl+A (b) Clrl+Z 129. (co can CIn cu fl+ (d) Ctrl+V. X1 the selected Text by Press You (a) Ctri+A (b) Ctrl+C (C) Cirl+x (d) Cl.r1+V 130. you
(t'YC'acaro)))essca!trtritir++4!" (d) Cirl+V the selected Text by Press 131. D u can Select (Entire (d) ct+ v :+ccurrent) by (c) Ctri+x (b) cid+c
2
MICROSOFT POWERPOINT
Which file format can be added lo a PowerPoint show? (a) •09 (b) .giv (c) way (If( All of these In Microsoft PowerPoint two kind of sound effects files that can be added to the presentation are (away files and mid files (b) way files and .gif files (c) .way files and jog files (d) .jpg files and ,gif files 3. Material consisting of text and numbers is best presented as (CA table slide (b) A bullet slide (c) A title slide (d) All of the above 4, What is a motion path? (a) A type of animation entrance effect (b) method of advancing slides A method of moving items on a .slide (d) All of the above i. Mal is a slide-title master pair? (a) The title area and text area of a specific slide (b) a slide master and title master merged into a single Ode ticrA slide master and title master for a specific design template (d) All of above 6. Which of the following should you use if you want all the slide in the presentation to have the same "look"? (a) the slide layout option (b) add a slide option (e) tline view 7a Presentation design template Ine context of animations, what is a trigger? (a)action - on button that advances to the next e An item on the slide that performs an actieh when clicked (c) The name at 8 "id} All of above. a motion path You have a r, anti wanl send snow you created leacher cnd using emall to another rnes can add the show to your email "Iff as a (an)
(c) Reply Attachment (d) Forward (a) Inclusion 9. In order to edit a chart, you can . (a) Triple click the chart object (b) lick and drag the chart object Double click the chart object (d) Click the chart object 10. to exit the PowerPoint (a) click the application minimize button (b) lick the document close button ( double click the applications control menu icon (d) double click the document control menu icon 11 To preview a motion path effect using the custom animation task pane, you should click the play button (b) click the show effect button (c) double dick the motion path (d) all of above 12. You can create a new presentation by completing all of the following except (a) Clicking the new button on the standard toolbar (b) Cli king file, new licking file open (d) Pressing ctrl N 13. You can embed a MS-Organization Chart in a slide by (a) Clicking tbe object command on the edit ltb.)---menuClicking the object command on the edit menu (c) Clicking the insert new double button the standard toolbar then new click e toolbar formatting organization, chart button on the form ar (d) Clicking 14. slide resentatioYnPelrik , What do you presthe IMS-Or button on the standard toolb ganizatio Chart To select one h
after another
during a ( Tab s? (c) CEO + h (b) CM + K 15 Special effects used to introduce slides In a are are called (d) All of above (a) present animations (b) custom animations cts transitidnQ
..1111.1
16 What is the term used when you press and hold the left mouse key and more the mouse around the slide? (a) Highlighting (terthagging (c) Selecting (d) Moving 17 Which of the following toolbars provide diffe nt options in various master views? Common tasks toolbar (b) Drawing toolbar (c) Formatting toolbar (d) Standard toolbar 18. How can you create a uniform appearance by adding a background image to all slides? (a) Create a template (be---Sait the slide master (c) Use the autocorrect wizard (d) All of the above 19 Which option on the custom animation task pane allows you to apply a preset or custom mot ath? a Add effect (b) Emphasis (c) Animate now (d) Alt of the above 20 What is the term used when a clip art image changes the direction of faces? (a) Group (b) Flip (or-Rotate (d) All of the above The slide that is used to introduce a topic and set the tone for the presentation is called the (a) table slide (b) graph slide (c) bullet slide Kr title slide 22 Which of the following features should you use when typing, in the notes text box? (a) Slide show (b)lesert (c) Slide maser (d)- Zoom 23. Which option allows you to select line, curve, freeform or scribble tools? (a) nsert motion path (b) Create effect Draw custom path (d) All of the above 24. Which of the following should be used when you want to add a slide to an existing presentation? (a) File, add a new slide (}Insert, New slide (d) File, New (c) File Open 25. The size of the organization chart object (a) is determined by the presentation design and cannot tie changed (Ie) is determined by the presentation design but can be changed in PowerPoint (c) I& ependent on the amount of text Wit e organization chart b and C which of the fallowing is the default page 28, setup orientation of slide in Power

(c) Portrait (a) Vertical Li\taonneescolapebole 27 Want a PowerPoint photo alb to 21ntinuouslye album side show -(1) Use random slide transitions (b) Launch an online broadcast (c) Loop continuously (d) All of the above 28. What is defined by the handout mestere (a) fide formatting Layout of audience handout notes (c) Handout content formatting for Microsoft word export. (d) All of above 29. Which of the following toot enables you to add text to a slide without using the standard pia holders? a) Text tool box (b) Line loot (c) Drawing tool (d) Auto shapes tool 30. In notes master view, how do you modify the font size of text for all hle4 notes of a presentation? (a) Modify the slide design (b) lllodify the notes master layout Modify the text within the Op placeholder (d) All of the above 31. Want your logo in the same poSition on every slide, automatically? Insert it on the (a)_etiandout master (b) Notes maser (cr Slide master (d) All of the above Which of the following views is the best vies to use when setting transition effects for all slid in a presentation? ( Slide sorter view (b) Slide view (c) Notes pages view (d) Outline view 33. Objetict—s on the slide that hold text are died (sj- Placehoefers (b) Object holders (C) Auto layouts 34. Which of the following provides Textvide ti ame°16efanss of printing out feature notes with a rninatet. slide on a printed page? (a) Slide with animation (b)Outiline verr (crKudience handout (d) Notes page 35 Which command brings you to the first in your presentation? (a)elext slide button (b) Page up (er Cut + Home (d) Ctrl +End 36. In normal view, how can you quickiy chaff to handout master view? (aaj w (a) the outline tab and select handout m
Halt Guide
32.
.16) Press the shift key and click the handout
Irrirti Gil (de master view button
311
tc) On the view menu, click slide sorter, and dick handouts (d) Alt of above 37 you quickly reinstate a looter placeholder in master view, 0) Create a new slide master Re-apply the footer poetic:Met (c) Re.apply the slide layout (d) All of the above Which of the following can you use to add times to the slides in a presentation'? (a) Slide show menu Or—Rehearse timings button (c) Slide transition button (d) All of the above To select all of the boxes of an organization enart (a) Clicking and edit and select all (b) Right click the chart background and then click select al (c) Press and hold the SHIFT key and click each x, (drAll of above 40. You can show the shortcut menu during the sWe show by (a) Clicking the shortcut button on the !NM ng toolbar ) Right clicking the current slide to) ClidOg an loon on the current slide (d) a and b 41. Auto apart is a feature that (a) Automatically places c.‘-lipart in your presentation tb) Scans your presentation for incorrect sPelkng 'in your words on each slide (c) Scans your presentation for incorrect spelling in Word Arts objects (Alt of above 42, To edit the text within the boxes of an r11:2!rzi? chart you fect the box and text, then make u?anies the box, then make the changes le "'elm the text, them make the wa 41 0) a and b bo lh WO of the following more than g a OW you to select t si,de in a presentation? rbil) Click each slide each slide The k each slide licSt each stile44 lt'-` ic at displays the slides on a
3g.
deleted
presentation as miniature representations of the tides is called -( slide sorter view (b) slide show (c) notes page view (d) outline view 45, The PowerPoint view that displays only text (idle and bullets) is (a) Slide sorter view (b),Slide avow [Cl Notes page view (d)- Outline view 46, in Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an) (b slide transition (c) custom animation (d) preset (a) animation Y animation 47 'Which of the following presentation elements can you modify using the slide master? (a) Slide comments (4)---"Vide transitions (c) Speaker note foot and color (d) All of above 48. Which of the following provides a printed copy of your presentation? (a) Q,111Ae (b) Speaker notes (orAudience handotit (d) All of the above 49.. Slide show options available to the presenter include all of the following except () Transitions command Oa) Speaker notes commend (c) Meeting reminder command (d) Navigation commands 50. Presentation designs regulate the formatting and layout for the slide and are commonly called (a) Design plates (15-6emptateS (c) Placeholders (d) Blueprints 51 Which of the following bypasses the print dialog box when printing individual slides or an entire presentation, (a) File, print„ preview (tyrThe print button (c) File, print 52. To add a header or footer ) to Ctrl+Phandout. you can use (a) Title master (b) Slide master (c4-1-tanolout master 0 (d) All of above sides in a slide show view v once the ) ) Esc key 54 Arn (a) EMPhasis effects thell:1);:aberl' SclibtU? (c) The mouse butt spacebar al are [Ines curve, fr e or Ester on (d) The E er ke (173 Types of custom (C) Predefined e motion paths (d) All of the ritrane and exit r, e above e reots
animations e applied to
312 55. Comments on a presentation can record who wrote them and when they were added. What's the automatic way in PowerPoint 20021 (a)e online collaboration (b) Use comments (c) Use the notes page (d) AU of the above 56. When using PowerPoint. to play a PowerPoint show for previewing the show, select (a) View, slide sorter (b) View, slide (orView, slide show (d) View outline 57 In Microsoft PowerPoint in order to see all the slid on one screen use ( view, slide sorter (b) view, slide (c) view, master (d) view, slide show 58. What's the best place to find animated images for your PowerPoint 2002 preseniatione (a) licrosoft online (tl Word apart (c) PowerPoint tools and ins (e) All of the above 59 You can create a new presentation by completing all at the following except: (a) Clicking the new button on the standard toolbar (b ticking ale, new (t Clicking file open (d) Pressing Ctrl + N 60. Which of the following option.s in the printer dialog box would you select to prit slides 5 in a presentation? ) Slides (b) Custom shows (C) Current slide (d) All Which of the following toolbars provides Jiff ei nt options in various master views? Common tasks toolbar (b) Drawing toolbar (c) Formatting toolbar (d) Standard toolbar 62. You n tell when an object is active because The object is highlighted (b) Eight small sizing handles appear surrounding the text (a) A box frame appears surrounding the text (d) b and c which of the knowing is not an option when 63, priming handouts? (a) slides per Pee Five slides per Page
UUlftto
(c) Three slides per page (d) Two slides per page fiat The selected design template can be apoel (a) To current slide only (b) To all the slides (c) Tk nil the new presentation you create of above 65 In which menu can you lind features ijko Slide Design, Slide Layout eteek (o) Insert Menu or Format mess (c) Tools Menu (d) Slide S. Menu 66 Which menu provides you options hkc Animation Scheme, custom Animation, Shee Transition.'" (a) lesert Menu (b) Format Menu (oKSlide Show Menu (d) Tools Menu 67 how many steps are there between Sim and Finis in AuloConlent Wizard? (a .3 (b) 4 (c) 5 (d) 6 68 Which of the following is not a part of Slide Design') (a) Design Template (b) Color Scheme (c) Animation Scheme (dlide Layout 69. What is the best way to create another copy of a slide? (a) Click the slide then press Ctrl+A and in new slide From insert Menu choose Duplicate Slide (C) Redo everything on a new slide that you had done on previous slide (d) None of above 70. From which menu you can access Picture, Test Box, Chart etc') Ala (b) Edit Insert (d) View 71. Which of the following font effect is 001 available in PowerPoint Font dialog box? (a) Underline (b) Shadow (c) Emboss (re)' trikethrough 72. Any and every command can be found on the (a) Drawing toolbar (b) Formatting toolbar (c) Standard toolbar (drivtenu bar 73. The slide that is used to introduce a topic and set the tone for the presentation is called the (a) Table slide (b)§rapti slide (C) Bullet slide (dr Title slide 74. Which of the following features should you use when typing in the notes text box? (a) Slide shows (b) twat (e) Slide master isirloorn


an



(a)
fkriGuicfe 313 Vi?lel of the following should e used when yOU want to add a slide to an existing presentation? (a) Fee, add a new sliderrlsere new
elide (c) File, open (d) File, new 14 wnjee of the following is the default page setup orientation for notes pages, outlines and handouts? (a) Vertical (b) Landscape POtfail (d) None of above rt midi of the following is the default page setup orientation for slides i owerPoint? (a) Vertical ) Landscape Portrait (d) None of above 76 How can you get your photo album slide show 10 play continuously? (a) Use random slide transition (b) Launch an online broadcast (el-loop continuously (d) Ae of above 79. Mat are symbols used to identify items in a list? (a) Iris (b) Markers Bullets (d) Graphics SO. What lets you to create new presentation by selecting ready-made font color and graphics effects? (a) Presentation Template (b) Master Slide Design Template (d) Animation Scheme 13•1 Which command will you use in PowerPoint if you need to chance the color of different ottects without changing conte3Q (a) Design Template (eirColor Scheme (c) Font Color (d) Object Color `+h at P a PowerPoint feature will you use to aPatY motion effects to different obiects of a side, (a) Slide Transition (b) lide Design ft) Animation Objects Animation 83 Scheme Mat will feature you use to apply motionof;i eve n between a slide exits and another ,a) Stele Transition (b) Slide Design (0) Pornation Objects (d) Animation Scheme WhIch of the fallowing provides a means of mg out features notes with a miniature IAa Printed page? (a) Slides with animaeon IN Outline st- w lc) Nolte page
PA
OP'
Audience handout Which command brings you to the first slide in your presentation? (a) Next slide button (la) Page up (eratrl + home (d) Cid + end 86 Obees on the slide that hold text are called ka.r Placeholders (b) °b led, holders (c) Auto layout (d) Text holders 87 Good de-sign determines (a) Credibility (b) Readability (c) First impression (0)---AlTot above 1113 The view that displays the slides of a wesenta bon as miniature representations of the slides is called (a) Slide show ffirilide sorter view
(c) Notes page view 89. The power point view (title and bullets) (a) Slide show
(d) Outline view that displays only text.
(b) Slide sorter
view (c) Notes page view (tn Outline view 90. Which of the following provides a printed . copy of your presentation? (a) Clines (b) Speaker notes p Audience handouts (d) All of above 91 Presentation designs regulate the formatting and layout for the slide and are commonly called (a) Design templates (tr templates (c) Placeholders (d) Blueprints 92. Line spacing refers to The space between the lines of text (b) The height of the line (c) The length of the iine (d) a and c Which of the following bypasses the print dialog box when printing individual slides or an entire presentation? (a) File, Print Preview (t') The print button (c) File, print 95. HOW do you add degree(C(Sdtjr116:10f CHtrtaer;sclp:ar rency 10 The handout master contains plaeeholdere for all of the following except (a) Slide number (c) Footer Shapeso usrt: dcshows a s (a) Use 40 style 4 bwus:i toolbar airbrooug,h,?sno o on the drawtng that the side (b) Use the Set Use Tr ah sPa re er nt C ctm button°n icture toolbar ForrnatAuh- Trahsarene slid hrux. er in the
Ilirommom
314
(d) NI of above 96. Material consisting of text and numbers is be peasentectas ( A table slide (b) A bullet slide (c) A title slide (d) All of above 97, Which command select all object at one time when selecting multiple objects to be delet ( Edit, Select All (b) All + a (c) Ctrl + a (d) Shift + Enter 98 You can edit an embedded organization chart object by (a) Clicking the edit object (b) Double cticking the organization chart object (c) Right clicking the chart object, then clickiwdit MS-Organization Chart object (dB and c 99. What is the name of the form used to input chart values' i(41 Dalasheet (b) MicTosoft Excel (c) fvticrosoft graph (d) Auto form 100. Which of the following you must fast complete in order to delete an object? (a) utle click the image ( Select the image (c) Resize the image (d) Move the image to a new location 101. What is the term used to described the separation of a dip all object into different parts so that it becomes a PowerPoint object? (a) Embedding
1. d
11. a
(b) Regrouping
21. d 3t. c 41. d 51. b 61. a
2. a
12. c
22. d
32 a
71. d
81 b
42. a
52. c 62 a
72. d
82. d'
91. b
92, a
101 c
102. b
3. 4. c 14. a 23. c 24. b 33, a T 34, c
a
13. b
43. c 44. a
53 a ten)

Mini Guide ( Ungrouping (d) Grouping 102. The auto shapes tool provides you with (a) F ney text to place on your slide ( Commonly found shapes (c) Any shape you want to add on a slide (d) Clip art that is related t0 your 103. Wprehsicehntoaftiothne fottowing should e used when you want to add a slide to an existing presentatien (a) File, add a new slide ((Insert, new slide (c) File, open (d) File, new 104. An organization has a president. vice president, managers and supervisors. On what level of an organaabon chart are the vice presidents (a) Fourth level (b) Third level Second level (d) First level 105. Which of the following includes Special effects that can be applied to drawing objects? (a) Gradient fills (b) otating (c) Line color and style or-4 of above 106. What is the term used when a dip art image changes the direction it faces*? (a) Group (b) F (c) Rotate ( a and b 107. What is the term used when you press and hold the left mouse key and move the mouse around the slide?
(a) Highlighting (c) Selecting
0rangging 10,a
Fd 5. e 6. 7. b 8. b 9. c 10. c 15. d 16. b 17, a 18. b 19. a 20 c 25. d 26. b 27. a 28. b 29. a 311 c_ 35, c 36 b 37. b 38. b 39. d 40. b 45, d 5571b 46. b 47. b 48. c 49. a 50, b 56. a 57 a 58. b 59. c 60. a M. b 66. c 67 a 68. d 69. b 70 c 75. b 75 c 77. b 65. c 86 a 67 d 78, c 88. 79. c80. c 95, c b 89. d 911 c 96. a 106.d 97. a 107,d 98. d 99. a TO. b 105 d
MICROSOFT EXCEL (MS EXCEL) (c) Bar charts, line graphs and pie charts (d) Bar charts and tine graphs only 11. What is the short cut key to replace a data with another in sheet? (a) Ctrl + R (b) Ctrl + Shift + R Nee(c) .Ctrl + Fi is notCtrl + \ 12. Which of the following a s no valid Zoom percentage. in Excel'? (c) 300 (b) 100 (d) 500 \e,e (a) 10 (a) Standard (b) Formatting toolbar Ne 13.‘ The spelling tool is placed on (c) Drawing (d) Reviewing verted into columns 14. When a row of data is to be con (a) Copy the cells in row, select the same number of cells in row and paste (b) Copy the cells in column then choose Edit Paste Special, then click Transpose and OK (c) Copy the cells then go to Format Cells then on Alignment tab dick Transpose es check box and click OK \e(d) Select the cells then place the cell pointer on new cell and choose Edit Paste Special, mark Transpose check box and click OK 15. Ctrl * D shortcut key in Excel will (a) Open the font dialog box (b) Apply double underline for the active cell (c) Fill down in the selection (d) None of above 16. MS Excel provides the default value for step in Fill Series dialog (a) 0 (a) Right align the conte (b) 1 (c) 5 (0) 10 17. The short cut key CtrlR used in Excel to
1, What term describes a background that ee. appears a a grainy, non smooth surface? (a) Gradient (b) Pattern (.0. Solid (d) Texture 2 Excel is a (a) Graphic program (b) Word , processor Ne(c) A spreadsheet (d) None of these. 3 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 Nee (d) Pivot Table Report 4. What function displays row data in a column or column data in a row? (a) Flyperlink (b) Index s\e(c) Transpose (d) Rows 5. When you insert an Excel file into a Word document, the data are 1, (a) Hypertinked Ne(b) Placed in a word table (c) Linked (d) Embedded Except for the function, a formula with a logtal function shows the word 'TRUE" or 'FALSE.` as a result 'a) IF (b) AND (c) OR (d) NOT 7. Macros are 'run* or executed from the ... . menu, \.(a) kneel (b) Format (C) Tails (d) Data t You ° open the consolidate dialog box by choosing Consolidate from the ,„.. menu. (a) Insert (b) Format (c) Tools 1\e(d) Data 61? excel file is called a workbook because (a) It can centain text and data \\,(b) It Can he modified (c) It can contain many sheets including vfoksneets and mart sheets le (d) You have to work hard to create ii Vlf*„ types of charts can excel produce? tat Line graphs and pre charts only (111) Orly line graphs

(b) Remove the cell
nt of cell
cells contents of selected \ (c) Fill the seiec right him with active ?soil -- is to the
(d) None of above 1a, Which tn:ronli y.ouo Place the contem use Pin some cells tutshnetmiddle of joinedScealnl?d Merge _ F rMal Cells dialog box dick on Cellsells check box
316
(b) From Format Cells diatog box select the Centered alignment (c) From Formal Cells dialog box choose "vN. Merge and Center check box (d) Click on Merge and Center tool on formatting toolbar
19 Tab scroll buttons are place on Excel screen e.,.., (a) towards the bottom right corner Ne (b) towards the bottom left corner (c) towards the top right corner (d) towards the top left corner 20. The Name box on to the left of formula bar '(a) showS the name of workbook currently working on (b) shows the name of worksheet currently ,., working on Nv(c) shows the name of cell of range currently working on (d) None of above 21.. The default font size in Excel worksheet is No(a) 10 points (b) 12 points (c)
14 points (d) None of above 22., The default font used in Excel is Ne(a) Anal (b) Algerial (c) Times New Roman (cl) Preeti 23. Which of the following is not an option in the \ spelling dialog box? v(a) Edit (b) Ignore (c) Ignore all (d) Change 24. You can quickly change the appearance of your work by choosing Auto Formal from the .... Menu . \ (a) Edit (b) View pN,e(c) Format (d) Tools 25. To protect a worksheet, you can choose Protection and the Protect Sheet from the .„... menu N (a) Edit 'Lei (b) Format \a/ (c) Tools % (d) Data 26, You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu (a) Edit \ (b) Insert (d) T3ools (c) Format 27 If you press ,..., the cell accepts your typing \(a) Enter as its contents !,a (b) Ctrl 4 Enter Ne (c) TAB (d) Insert 28. What symbol is used before a number to make it a label? I (a) '(quole) (b) = (equal) (c) I (underscore) (d) ' (apostrophe)
ffrni Guide
2a, Which symbol must all formula begin vrie.'er' Ne (a) = (b) (c) ( (d) 30. Which of the following formulas is not ,eilierel Correctly' (a) =10450 (b) =8781 (c) 437+14 Ne(d) 10450 31, A typical worksheet has Number of columns (a) 128
(b) 256 (c) 512 Ai\iid (d) 1024 32. How many characters can be typed in a single cell in Excel? (a) 255
(b) 1024 \te( (c) 32,000 d) 65.535 33. A worksheet can have a maximum of Number of rows (a) 256 (d) 55a1605! 53sr 4zczs, 34 (c) 32,000 Which of the following is not an example of a6 value (a) 350 (b) May 10, 2001 (c)
57% (d) Sena! Number 50771
35. The chart wizard term data series refers to (a) A chart legend (b) A collection of chart data markers (c) A set of values you plot in a chart (d) A data label
36. The Chart wizard term data categories refers to \\„(a) A chart plot area (b) A horizontal axis (c) The organization of individual values with a chart's data series (d) The data range that supply chart data
37. A worksheet range is a (a) A command used for data modeling (b) A range of values such as from 23 to \234 (c) A group of cells (d) A group of worksheets
38. Getting data from a cell located in a differe sheet is called (a) Accessing \e4b) Referencing (d) Functioning
39. Tab scrolling button (c) Updating (a) Allow you to view a different worksheet (b) Allow you to view additional works rows down \\,(c) Allow you to view additional workshtet columns to the right (d) Allow you to view additional sheets tabs
ono GO* Fach excel file is a workbook that contains differeni sheets Which of the following cannot be a sheet in workbook? (a) work sheet (b) chart sheet (c) module sheet \f(d) data sheet 4i, mich of the following is not the correct method of editing the cell content/ (a) Press the AJt key (b) Press the F2 key (c) Click the formua bar (d) Double click the cell
42. you can merge the main document with data source in Excel. In mail merge operation, word is usually ( (a) server b) source ,(o) client (d) none 43 HOW can you update the values of formula cells if Auto Catculate mode of Excel is disabled? (a) F8 (b) F9 (c) Fl (d) F11
44 Where can you change automatic or manual calculation mode in Excel, \ (a) Double CAL indicator on status bar `v(b) Go to Tools » Options Calculation and mark the corresponding radio button ft) Both of above (d) None of above
45. 1-fow can you show or hide the gridlines in Excel Worksheet? (a) Go to Tools Options View tab and mark or remove the check box named Gridlirre (b) Click Gridline tool on Forms toolbar \e(c) Both of above (d) None of above
46. What happens when you press Clrl + X after selecting some cells in Excel? (a) The cefl content of selected cells V(is.aPear from cell and stored in clipboard b) The cells selected are marked for cutting (0) The selected cells are deleted and the cells* shifted left (1) The selected cells are deleted and cells are shifted up Mich of the following option is not available
48 (c). Oivide in Paste 3Peclal di log box? ) ikcsd (d) SORT (b) Subtract Yiluth eocommand will you choose to oonveconverta iton al data into row, ta! pave Cut anti (b, Edit ).• Paste Special Transpose
317
(c) Both 01 above (d) None of above
49 Wilich of the cell pointer indicates you that \ you can make selection? (a) Doctor's symbol (Big Plus) (b) small thin plus icon (c) Mouse Pointer with anchor at the lip (d) None of above
50. Which of the cell pointer indicates that you can fill series') \ (a) Doctor's symbol (Big Plus) \?(0) small thin plus icon (C) Mouse Pointer with anchor at the tip (d) None of above
51 Which of the cell pointer indicate that you can move the content to other cell? (a) Doctors symbol (Big Plus) (b) nall thin plus icon ( Mouse Pointer with anchor at the tip (d) None of above
52 You can auto fit the width of column by (a) Double clicking on the column name on column header (b) Double click on the cell pointer in worksheet (c)—
15-nuble clicking on column right border on column header (d) Double clicking on the column left border of column header
53 The command Edit Fill Across Worksheet is active only when (a) ne sheet is selected ( When many sheets are selected (c) When no sheet is selected (d) None of above
54 Which of the following you can paste selectively using Paste Special command? (a) Validation Paste Special allows some FA0p°fierorilrfaaatitb°so (c) Formulas nvewhile you paste to new cell Which of the operation is valid'? 0 °Wing ta) Square
55
56• (a) Deletes the content (c) Goal Seek (bo:a cell Edit Delete command( (tb) DDeelfee: sFeo.rrno- mment Of eil (c) letes the conattesnotfocfelsel 1 57 must e To remove ieefee cells ectecl cells (c) Ecii. ›) ear )› Cent (a) Einudi.tilv:e:_tchD__elelec Delete command ,. you t Clear A ii ents
roentage Divide
(d) Data .» Delete 58 The Delete key of keyboard is assigned to which command in Excel, (er Edit » Clear e Contents (b) Edit » Clear All (c) Edit Delete (d) All of above 59. If you need to remove only the lorrnatting done in a range (numbers and formula typed the4e should not be removed), you must From Edit menu choose Clear and then Formats (b) From Edit menu choose Delete (c) Click on Remove Formatting tool on Standard Toolbar (d) Double click the Format Painter and then press Esc key in keyboard
60 By default Excel provides 3 worksheets. You need only two 01 them. how will you delete the third one? C5) Right dick on Sheet Tab of third sheet and choose Delete from the context menu (b) Click on Sheet 3 and from Edit menu choose Delete (c) Both of above (d) None of above 61. Formatting a cell in Currency, you can specify (a) rrency Symbol (b) Decimal Places ( Both of above (d) None of above
02. Formatting a cell in Number format you can't set (a) Decimal Places (b) Use 1000 separator (c) Negative numbers (d( Currency Symbol 63. Wh is entered by the function =today() ( 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
64. Special category of Number tab in Format Cells dialog box can be used to apply formats like (a) ip Code (b) Phone Number ( Both of above (d) None of above
65 Merge cells option can be applied from (g.r. Format Cells dialog box Alignment Tab (b) Formatting toolbar (c) Both of above (d) None of above 66. Which of the following format you can decide



10 apply or not in AutoFormat dialog bee) (c) Font format (a) Number format (ober) _Atom of above ve tver eiereei 07 How can you remove borders applied ,n cells? (a) Choose None on Border tab of Format cells (b) Open the list on Border OW in Formatting toolbar then choose first tool (no bord ( Both of above (d) None of above 68 Where can you set the shedding color for a range of cells in Excel' (a) Choose required color form Patterns tab of Format Cells dialog box (b) Choose required color on Fill Color tool in Formatting toolbar (c) Choose required color on Fill Coe tee in wing toolbar e) Ail of above 69. You can set Page Border in Excel from (a) From Border tab in Formal Cells dialog box (b) From Border tool in Formatting toolbar (c) From Line Style tool in Drawing toolbar You cannot set page border in Excel
70. You can check the conditions against when applying condieonal formatting (a) Il value (b) Formula (cKNef th of above (d) None of above 71. Which of the following is invalid regarding the Protection in Excel? (aProtect Workbook (b) Protect Sheet Protect Workspace (d) All of above
72. Which of the following options is not availab to remove arrows of Formula Auditing? (a) Remove all precedent arrows (b) Remove all dependent arrows (c) Remove all arrows (dr-Remove all arrows for this cell
73. To apply Goal Seek command your cell pointer must be in (a) The Changing cell whose value you need to find eVenterTedhe Result Cell where formula is (c) The cell where your targeted value is entered (0) None of above
74 Which of the following is not What IF analysis tool in Excel? (a) Goat Seek (b) Scenarios
(d) Data .» Delete
58 The Delete key of keyboard is assigned to which command in Excel, (er Edit » Clear e Contents (b) Edit » Clear All (c) Edit Delete (d) All of above
59. If you need to remove only the lorrnatting done in a range (numbers and formula typed the4e should not be removed), you must From Edit menu choose Clear and then Formats (b) From Edit menu choose Delete (c) Click on Remove Formatting tool on Standard Toolbar (d) Double click the Format Painter and then press Esc key in keyboard
60 By default Excel provides 3 worksheets. You need only two 01 them. how will you delete the third one?
C5) Right dick on Sheet Tab of third sheet and choose Delete from the context menu (b) Click on Sheet 3 and from Edit menu choose Delete (c) Both of above (d) None of above
61. Formatting a cell in Currency, you can specify (a) rrency Symbol (b) Decimal Places ( Both of above (d) None of above
02. Formatting a cell in Number format you can't set (a) Decimal Places (b) Use 1000 separator (c) Negative numbers (d( Currency Symbol
63. Wh is entered by the function =today() ( 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
64. Special category of Number tab in Format Cells dialog box can be used to apply formats like (a) ip Code (b) Phone Number ( Both of above (d) None of above
65 Merge cells option can be applied from (g.r. Format Cells dialog box Alignment Tab (b) Formatting toolbar (c) Both of above (d) None of above
66. Which of the following format you can decide



10 apply or not in AutoFormat dialog bee) (c) Font format (a) Number format (ober) _Atom of above ve tver eiereei
07 How can you remove borders applied ,n cells? (a) Choose None on Border tab of Format cells (b) Open the list on Border OW in Formatting toolbar then choose first tool (no bord ( Both of above (d) None of above
68 Where can you set the shedding color for a range of cells in Excel' (a) Choose required color form Patterns tab of Format Cells dialog box (b) Choose required color on Fill Color tool in Formatting toolbar (c) Choose required color on Fill Coe tee in wing toolbar e) Ail of above
69. You can set Page Border in Excel from (a) From Border tab in Formal Cells dialog box (b) From Border tool in Formatting toolbar (c) From Line Style tool in Drawing toolbar You cannot set page border in Excel 70. You can check the conditions against when applying condieonal formatting (a) Il value (b) Formula (cKNef th of above (d) None of above 71. Which of the following is invalid regarding the Protection in Excel? (aProtect Workbook (b) Protect Sheet Protect Workspace (d) All of above
72. Which of the following options is not availab to remove arrows of Formula Auditing? (a) Remove all precedent arrows (b) Remove all dependent arrows (c) Remove all arrows (dr-Remove all arrows for this cell
73. To apply Goal Seek command your cell pointer must be in (a) The Changing cell whose value you need to find eVenterTedhe Result Cell where formula is (c) The cell where your targeted value is entered (0) None of above
74 Which of the following is not What IF analysis tool in Excel? (a) Goat Seek (b) Scenarios