The function is used to replace existing text with new text a. replace b. substitute c. substring d. string
Tab scrolling button a. allow you to view a different worksheet b. allow you to view a additional worksheet rows down c. allow you to view additional worksheet columns to the right d. allow you to view additional sheets tabs
The function extract data stored in a pivot table. a. getdata b. getpivotdata c. pivotdata value d. datavalue
In maximum, how many sheets can be set as default while creating new workbook? a. 254 b. 255 c. 256 d. No limit
The result of data processing is a. database b. information c. knowledge d. records
To remove a relation from an SQL database, we use the command. a. Delete b. Purge c. Remove d. Drop table
How can you link a table with another so that a field in current table will display values in drop down box form another table while entering data? a. Query wizard b. Look up wizard c. Form wizard d. Report wizard
A field can be called as in relation context. a. random file b. direct file c. attribute d. tuple
Every table in relational database contain a field or combination of field that can uniquely identify each records, it is called a. Foreign key b. Native key c. Composite key d. Primary key
The option is used to save PowerPoint Presentation in PDF with 4-slides per page a. slides b. handouts c. notes pages d. outlines view
Which view shows all slides in one screen? a. slide master b. slide sorter c. slide layout d. slide show
To insert a new slide in the current presentation, we can choose a. Ctrl + M b. Ctrl + N c. Ctrl + 0 d. Ctrl + F
A webpage displays a picture. What tag was used to display that picture? a. picture b. image c. img d. src
Using only HTML, we can create a. Dynamic web pages b. Static web pages c. Both A and B d. None of the above
What is the correct HTML for creating a hyperlink? a. <a href=”http://www.aicl.com“> aicl.com </a> b. <a url=”http://www.aicl.com“> aicl.com </a> c. <a>http://www.aicl.corn </a> d. <a name=”http://www.aicl.com”> aicl.com </a>
Which of the following have low failure rate? a. Mechanical devices b. Electronic devices c. Electro-mechanical devices d. None of the above
The main function of the ALU is to a. perform arithmetic and logical operation b. Store data and information for future use c. Control computer output, such as printing d. Monitor all computer activities
What is a light pen? a. A mechanical input device b. Optical input device c. Electronic input device d. Optical output device
Which of the following is suitable after you install new drivers a. Shut down b. Restart c. Sleep d. Hibernate
CD-ROM stands for a. Compactable Read Only Memory b. Compact Data Read Only Memory c. Compactable Disk Read Only Memory d. Compact Disk Read Only Memory
Which is a compiler? a. A compiler does a conversion line by line as the program is run b. A compiler converts the whole of a higher level program code into machine code in one step c. A compiler is a general purpose language providing very efficient execution d. None of the above
What is the most common tool used to restrict access to a computer system? a. User logins b. Passwords c. Computer keys d. Access-control software
As compared to the secondary memory, the primary memory of a computer is a. large b. cheap c. fast d. slow
Junk e-mail is also called a. spam b. spoof c. sniffer d. worm
Network congestion occurs a. in case if traffic overloading b. when a system terminates c. when connection two nodes terminates d. none of the above
What type of resources is most likely to be a shared common resource in a computer network? a. Printers b. Speakers c. Keyboards d. Floppy disk drives
MAN is a a. cost b. company c. network d. country
Communication channels is shared by all the machines on the network in a. broadcast network b. unicast network c. multicast network d. none of the above
In internet terminology IP means a. Internet Provider b. Internet Protocol c. Internet Procedure d. Internet Processor
A Microsoft Windows is a. Operating System b. Graphic Program c. Word Processing d. Database Program
When you turn on your computer, it will check on which of the following control filers)? a. command.com, io.sys b. command.com, date.com, dir.com c. command.com, io.sys, msdos.sys d. chkdsk.exe
The ….. Program compresses large files into a smaller files. a. WinShrink b. WinZip c. WinStyle d. None of the above
The main function of the command interpreter is a. to get and execute the next user-specified command b. to provide the interface between the API and application program c. to handle the files in operating system d. none of the above
Only filenames and extensions are to be displayed in wide format, which command you’ll use? a.Dir/w b. Dir a: c. Dir/s d. Dir/b
Which of the following is not valid version of MS Office? a. Office XP b. Office Vista c. Office 2007 d. None of the above
Background color or effects applied on a document is not visible in a. web layout view b. print layout view c. reading view d. print preview
What is gutter margin? a. Margin that is added to the left margin when printing b. Margin that is added to the right margin when printing c. Margin that is added to the biding side of page when printing d. Margin that is added to the outside of the page when printing
What is the shortcut key to Open dialog box? a. F12 b. Shift + F12 c. Alt+ F12 d. Ctrl + F12
Which of the following is not a type of page margin? a. Left b. Right c. Center d. Top
Which of the following statement is false? a. You can set different header and footer for last page of a section b. You can set different header footer for even and odd pages c. You can set different page number formats for different functions d. You can set different header footer for first page of a section
The space at the end of a page is called the a. footer b. margin c. bottom d. endnote
In which view Headers and Footers are visible? a. Normal View b. Page Layout View c. Print Layout View d. Draft View
Which of the following is not of the merge process? a. Sort the data source records b. Merge the two files to print or create a new document c. Edit a data source d. Format a main document
Which of the following is not a font style? a. Bold b. Italics c. Regular d. Superscript
The intersection of a column and a row on a worksheet is called a. Workbook b. Worksheet C. Cell d. address
Which function is used to calculate depreciation, rates of return, future values and loan payment amount? a. Logical b. Financial c. Statistical d. Math and Trigonometry
Which language is used to create macros in Excel? a. Visual Basic b. C c. Visual C++ d. Java
In Excel, which one denotes a range from 131 through ES? a. B1 — E5 b. B1:E5 c. B1 to E5 d. Bl$E5
Which tool is used to join some cells and place the content at the middle Opined cell? a. Wrap Text b. Center alignment c. Merge and Center d. Shrink to fit
In the formula, which symbol specifies the fixed columns or rows? a. $ b. * c. % d. &
