WorksheetsTAR-IIT
Total questions: 36
Worksheet time: 31mins
John has inserted a table in a Word document. Now, he wants to navigate in a row of the table by moving the cursor left and right in the cells. Which one of the following keys should John use to fulfill the requirement?
1 Tab and Shift + Tab
2 Down Arrow and Up Arrow
3 Ctrl and Tab
4 Backspace and Tab
Allen is creating a Word document for a seminar. He wants to display the topic name on top of each page of his document. Which one of the following options will enable him to accomplish the task?
1 Header and Footer
2 Page Setup
3 Print Options
4 Break
Which of the following tabs allows you to modify data source of the worksheet?
1 Data
2 Design
3 View
4 Layout
Which of the following elements can be used to send a message to a recipient such that the recipient's name is not visible to the other recipients of the same message?
1 BCC
2 CC
3 TO
4 SUBJECT
Which of the following keys begins the presentation in the Slide Show view?
1 F5
2 ESC
3 Ctrl+R
4 PageDown
Which of the following functions returns the value attained by dividing the sum of numbers by their count?
1 Average
2 SUM
3 Modulo
4 Divide
In Excel, text is ___________ aligned by default.
1 Left
2 Right
3 Justify
4 Center
Which of the following tabs allows you to modify type of chart of the worksheet?
1 Layout
2 Design
3 Insert
4 Format
Which of the following capitalizes only the first character of the selected sentence?
1 Sentence Case
2 Lower Case
3 All Case
4 Tittle Case
Which of the following key combinations can be used to send a message?
1 Ctrl+Enter
2 Ctrl+S
3 Ctrl+Alt+S
4 Ctrl+Space
You want to send a file using an instant message. Which one of the following groups will you use to accomplish the requirement?
1 Share
2 Protect
3 Compare
4 Publish
Which one of the following options in the mail merge wizard enables you to create an address list containing addresses of a group of users?
1 Directory
2 Letters
3 Envelopes
4 Labels
Which one of the following features of the Internet is used to gather different types of information from all over the Internet?
1 Search Engine
2 Chatting
3 Social Networking Sites
4 Games Sites
Which one of the following features of the Internet is used to share your interests, experiences, and stories with your friends and family who may be located in different geographical locations?
1 Social networking
2 Shopping
3 Chatting
4 Email
Which one of the following options is a real-time communication service on the Internet that offers an instant transfer of messages between people?
1 Chatting
2 Shopping
3 Entertainment
4 Games
Which one of the following mediums is not used to access the Internet?
1 External hard disk
2 Modem
3 Communication device
4 Telephone connection
You have connected an optical mouse to your computer. While working, you have discovered that the mouse is moving only in one direction. Identify the troubleshooting approach that you can use to rectify the same.
1 Its plastic lens needs to be cleaned with a damp cloth or cotton.
2 Remove and reinsert the batteries.
3 Reinstall the mouse driver.
4 Check if the touchpad is enabled.
Barry Allen wants to save a document. He wants the document to be available on the Internet. How can He perform this task?
1 should save the document in the .htm format.
2 should save the document in the .txt format.
3 should save the document in the .pdf format.
4 should save the document in the .xps format.
Peter parker wrote an email and sent it to his friend using Outlook. However, he found that his laptop is not connected to the Internet. Now, he wants to view the email again. Where should Peter parker look for the email that he sent to his friend?
1 Peter should look for email in the Drafts folder.
2 Peter should look for email in the Sent Items folder.
3 Peter should look for email in the Inbox folder.
4 Peter should look for email in the Outbox folder.
Alpine Alpha is a BPO organization that needs to enhance its operations. The network administrator of the company needs to establish a network between 100000 computers.
1 Mesh
2 Star
3 Bus
4 Ring
Advent Corporation is a newly established event management company based in Scotland. It is spread across five floors of a building. what do you thing which one is right according network bellow
1 LAN
2 MAN
3 PAN
4 WAN
Dr Banner needs to display the current date in an Excel worksheet. What should he do to ensure the same?
1 Dr Banner should use the TODAY function.
2 Dr Banner should use the DAY function.
3 Dr Banner should use the TI
4 Dr Banner should use the DATEVALUE function.
You have three workbooks, which contain the budget figures of the past three years. You want to quickly go to the budget of the preceding year or the next year from a particular year's workbook. What will you do to ensure the same?
1 Use hyperlinks.
2 Use sparklines.
3 Use filters.
4 Use charts.
Thor has created a PowerPoint presentation on British media. Now, he wants to save the presentation to get opened in a slide show view, next time. What should Harry do to save the presentation?
1 Use the .pptx file format.
2 Use the .ppt file format.
3 Use the .pps file format.
4 Use the .xps file format.
Bruce wanyne have a collection of songs in your pen drive. He need to transfer these songs to your computer. For this, you need to connect the pen drive to your computer.
1 Connect the pen drive to the USB port and connect a speaker to the audio port. To view the high definition video, connect the device to the HD
2 Connect the pen drive to the ethernet port and connect a speaker to the audio port. To view the high definition video, connect the device to the HDD connector.
3 Connect the pen drive to the HDD connector and connect a speaker to the HD
4 Connect the pen drive to the memory slots and connect the speaker to the HD
Alfred are playing a game on a computer by using the mouse and keyboard. To play the game, He need to move the cursor up and down. Identify the keys that allow Alfred to do so.
1 Arrow keys allow to move the cursor up and down. The execution of the current game can be stopped by pressing the Esc key.
2 Arrow keys allow to move the cursor up and down. The execution of the current game can be stopped by pressing the Delete key.
3 Backspace key allows to move the cursor up and down. The execution of the current game can be stopped by pressing the Ctrl key.
4 Backspace key allows to move the cursor up and down. The execution of the current game can be stopped by pressing the Shift key.
Vision want to create a network in which the nodes should be connected through a point-to-point connection as well as there should be no endpoints. Identify the topology that he can use for the same.
1 Ring
2 Bus
3 Star
4 Tree
Adam has an Internet connection. While browsing a Web page, he finds a video on Troubleshooting a PC. However, he is unable to play the movie using the Web browser. What could be the possible reason for the preceding problem?
1 The Plug-ins and Add-ons to play video not installed
2 A huge amount of temporary files
3 A long browsing history
4 The IP of the proxy server not correctly set
Jack is creating a PowerPoint presentation. He wants to view small versions of all the slides in the presentation. Which one of the following views allows him to do so?
1 Slide Sorter View
2 Notes Page View
3 Normal View
4 Reading View
You have created a PowerPoint presentation on smartphones using some text and images. You need to capitalize only the first letter in some text on the slides in the presentation. Which one of the following options will you use to accomplish the task?
1 Sentence case
2 Lower case
3 Upper case
4 Capitalize Each Word
When you select or insert an object within a PowerPoint presentation, one or more contextual tabs appear on Ribbon. Which one of the following options is not a type of contextual tab?
1 Animations
2 Format
3 Layout
4 Design
Convert this IP to Bits 192.168.109.203 :
Convert this IP to Bits
243.77.152.201 :
Convert this IP to Bits
133.19.111.233 :
Convert this IP to Bits
4BF9:7A6C:0:0 :
Convert this IP to Bits
3D8E:0:24AF:0
