O Level IT Tools Paper July 2022 | Set 1

To display both the current date and time, you should use:

This function will return the current date and time, and it updates automatically when the sheet recalculates.

Correct Answer: C) Now( )

The correct answer is:

(C) Both (A) & (B)

In presentations, you can insert sound clips and movie clips to enhance the content. Both are commonly used to make presentations more engaging.

Correct Answer: C) Both (A) & (B)

The correct answer is:

(A) Unified Payment Interface

UPI stands for Unified Payment Interface, which is a real-time payment system developed by the National Payments Corporation of India (NPCI).

Correct Answer: A) Unified Payment Interface

The correct answer is:

(D) Visual effect in slide show

A slide transition refers to the visual effect that occurs when moving from one slide to the next in a slideshow presentation, such as a fade, wipe, or push effect.

Correct Answer: D) Visual effect in slide show

The correct answer is:

(B) Portrait

The default page orientation in LibreOffice is Portrait, where the height of the page is greater than the width.

Correct Answer: B) Portrait

The correct answer is:

(C) Electronic mail

E-mail stands for Electronic mail, which is a method of exchanging digital messages over the internet.

Correct Answer: C) Electronic mail

The correct answer is:

(B) Formula

Any expression that begins with an equals '=' is treated as a formula in spreadsheet applications like Excel. The formula is used to perform calculations or manipulate data.

Correct Answer: B) Formula

The correct answer is:

(B) Uniform Resource Locator

URL stands for Uniform Resource Locator, which is the address used to access resources on the internet, such as websites.

Correct Answer: B) Uniform Resource Locator

The correct answer is:

(A) IBM

The term word processing was introduced by IBM (International Business Machines) when they developed systems for creating, editing, and formatting text documents electronically.

Correct Answer: A) IBM

The correct answer is:

(C) Alpha-commerce

Alpha-commerce is not a recognized type of e-commerce. The common types of e-commerce are:

• Business to Business (B2B)
• Business to Customer (B2C)
• M-commerce (Mobile commerce)

Correct Answer: C) Alpha-commerce

The correct answer is:

(B) Optical Character Reader

OCR stands for Optical Character Reader, a technology used to convert different types of documents, such as scanned paper documents, into editable and searchable data.

Correct Answer: B) Optical Character Reader

1 Petabyte (PB) is equal to 1,048,576 Gigabytes (GB).

This is because:

1 PB = 1024 Terabytes (TB)
1 TB = 1024 Gigabytes (GB)
Therefore, 1 PB = 1024 * 1024 = 1,048,576 GB

So, the correct answer is:

(B) 1048576 GB.

Correct Answer: B) 1048576 GB

The correct answer is:

(A) Yes

It is possible to convert a presentation into a video or PDF. Most presentation software, like Microsoft PowerPoint, allows you to export slides as a video file or save them as a PDF.

Correct Answer: A) Yes

The correct answer is:

(C) URL

http://www.google.com is an example of a URL (Uniform Resource Locator), which is the address used to access a specific resource on the internet.

Correct Answer: C) URL

In a computer spreadsheet, an absolute cell reference is represented as $A$3.

An absolute cell reference locks both the column and the row, ensuring that when you copy or move the formula, the reference stays fixed on that specific cell.

So, the correct answer is:

(B) $A$3.

Correct Answer: B) $A$3

The correct answer is:

(A) Bharat Interface for Money

BHIM stands for Bharat Interface for Money, which is a mobile payment application developed by the National Payments Corporation of India (NPCI) to enable quick, easy, and secure financial transactions using the UPI (Unified Payments Interface) system.

Correct Answer: A) Bharat Interface for Money

The correct answer is:

(C) Title Slide

The Title Slide is used to introduce a topic and set the tone for the presentation. It typically includes the title of the presentation, the presenter's name, and sometimes additional details like the date or organization.

Correct Answer: C) Title Slide

The correct answer is:

(C) Subscript

To type CO₂ with the 2 in its proper place, you should use the Subscript option, which places the number slightly below the baseline, as in chemical formulas.

Correct Answer: C) Subscript

The correct answer is:

(A) Note Master

The Note Master is used to insert related hints or speaker notes for a slide. These notes can be used by the presenter for reference during the presentation but do not appear on the slides themselves.

Correct Answer: A) Note Master

The correct answer is:

(C) Different for every access

A One-Time Password (OTP) is safe because it is unique for each login session or transaction, making it harder for unauthorized users to access an account or system even if they intercept the password.

Correct Answer: C) Different for every access

The correct answer is:

(A) Esc key

The Esc key is used to exit the slide show view, not to advance the slides. The other options, such as the Spacebar, Enter key, and Mouse button, are used to move forward in the presentation.

Correct Answer: A) Esc key

The correct answer is:

(A) Wireless Local Area Network

WLAN stands for Wireless Local Area Network, which is a type of network that allows devices to connect to the internet or communicate wirelessly within a local area, like a home or office.

Correct Answer: A) Wireless Local Area Network

The correct answer is:

(C) Portable Document Format

PDF stands for Portable Document Format, a file format developed by Adobe that allows documents to be shared and viewed on different devices without changing their formatting.

Correct Answer: C) Portable Document Format

If the active cell is M10 and you press the Enter key, the selection will move down by one row.

So, you will reach cell M11.

The correct answer is:

(B) M11.

Correct Answer: B) M11

The correct answer is:

(A) .ods

The file extension for a LibreOffice Calc file is .ods (Open Document Spreadsheet).

Correct Answer: A) .ods

The correct answer is:

(C) Security

A firewall is a security measure used to protect networks and systems from unauthorized access or cyber threats. It can be either hardware or software-based and controls incoming and outgoing network traffic based on predefined security rules.

Correct Answer: C) Security

The correct answer is:

(A) Title bar

The file name is typically displayed in the Title bar of the application window. It shows the name of the open document or file.

Correct Answer: A) Title bar

The correct answer is:

(C) Malware

Malware gets propagated through networks and technologies like SMS, Bluetooth, wireless mediums, USBs, and infrared to affect mobile phones. It refers to malicious software designed to damage, disrupt, or gain unauthorized access to systems.

Correct Answer: C) Malware

The correct answer is:

(C) Word processor

A Word processor is an application that allows the user to compose, format, and edit simple documents, such as Microsoft Word or LibreOffice Writer.

Correct Answer: C) Word processor

The correct answer is:

(B) Theme

A Theme is a collection of design choices that includes color, font, and special effects, which are applied to the entire presentation to maintain consistency in design.

Correct Answer: B) Theme

The correct answer is:

(D) All of the above

The UMANG app (Unified Mobile Application for New-age Governance) helps users avail various government services, including filling income tax, making Aadhaar and PF requests, and booking a gas cylinder, along with many other services.

Correct Answer: D) All of the above

When you zoom in on a document to 300%, both horizontal and vertical scroll bars might appear, depending on the content and window size.

Typically, when zooming in this much, 2 scroll bars (horizontal and vertical) will appear to allow navigation across the document.

So, the correct answer is:

(B) 2.

Correct Answer: B) 2

The correct answer is:

(B) Edit

The Cut, Copy, and Paste options are available in the Edit menu in most applications.

Correct Answer: B) Edit

The correct answer is:

(A) Macro

A Macro is a saved sequence of commands or keystrokes that are stored for later use, allowing users to automate repetitive tasks in software applications.

Correct Answer: A) Macro

The correct answer is:

(C) Short phrases or partial sentences

For better readability, bullet points should be short phrases or partial sentences as they make the information easier to read and understand quickly.

Correct Answer: C) Short phrases or partial sentences

The correct answer is:

(D) Attachments

Attachments allow a user to send a file with an email. You can attach documents, images, or other types of files to your email before sending.

Correct Answer: D) Attachments

The correct answer is:

(D) Auto content wizard

The Auto Content Wizard is a handy tool in presentation software that helps you create a presentation quickly by providing predefined content layouts and structure.

Correct Answer: A) Template

The correct answer is:

(D) Both Portrait and Landscape

In LibreOffice Writer, you can set the page orientation to either Portrait or Landscape, depending on the document's needs.

Correct Answer: D) Both Portrait and Landscape

The correct answer is:

(B) Windows

Windows is not an open-source operating system, whereas Ubuntu, Linux, and Drupal are open-source.

Correct Answer: B) Windows

The correct answer is:

(B) .ott

In LibreOffice Writer, the file extension .ott is used for templates.

Correct Answer: B) .ott

The correct answer is:

(B) Scanner

A Scanner allows a user to copy an external document and save it in electronic form onto a computer.

Correct Answer: B) Scanner

The correct answer is:

(C) Performance Monitor

A Performance Monitor is typically a tool used to assess and manage system performance, but it is not a core part of the operating system itself. The other options (Input/output control program, Job control programs, and Supervisor) are integral parts of an operating system.

Correct Answer: C) Performance Monitor

The correct answer is:

(D) Internet

In cloud computing, the term cloud refers to the Internet. It represents the network of remote servers that store, manage, and process data instead of using local servers or personal computers.

Correct Answer: D) Internet

The correct answer is:

(C) Transitions

In presentations, transitions are special effects used to introduce or move between slides. These effects help make the presentation visually engaging.

Correct Answer: C) Transitions

The correct answer is:

(B) Insert

In LibreOffice, the option to add comments is found under the Insert menu. You can use this to insert comments or notes into your document.

Correct Answer: B) Insert

The correct answer is:

(C) Mail merge

Mail merge in LibreOffice allows you to create multiple documents from a single document by using a data source, such as a database or a spreadsheet. This is often used for tasks like creating personalized letters or labels.

Correct Answer: C) Mail merge

The correct answer is:

(D) Readability

In LibreOffice, a signature is used primarily for Integrity, Authentication, and Non-Repudiation. These help ensure that the document has not been tampered with, verify the identity of the signer, and prevent the signer from denying the signature later. Readability is not a primary purpose of a signature.

Correct Answer: D) Readability

The correct answer is:

(A) Browser

A browser is a program used to view websites and access the internet, such as Google Chrome, Mozilla Firefox, or Microsoft Edge.

Correct Answer: A) Browser

The correct answer is:

(D) NEFT

NEFT (National Electronic Funds Transfer) is an online payment mode that allows the electronic transfer of funds from one bank account to another within India.

Correct Answer: D) NEFT

The correct answer is:

(C) Charts or Graphs

Spreadsheet data can be represented visually in the form of charts or graphs, making it easier to analyze and interpret the information.

Correct Answer: C) Charts or Graphs

The correct answer is:

(D) mp3

LibreOffice Writer is a word processing application and is primarily designed to work with text-based formats like XML, DOC, and DOCX. MP3 is an audio format, which cannot be saved directly in a LibreOffice Writer document.

Correct Answer: D) mp3

The correct answer is:

(D) LibreOffice Draw

LibreOffice Draw is a vector graphics editor, not a spreadsheet software. The other options, Microsoft Excel, OpenOffice Calc, and LibreOffice Calc, are all spreadsheet software.

Correct Answer: D) LibreOffice Draw

The correct answer is:

(C) Who breaks rule of netiquette

A "flame" refers to an aggressive or insulting message, often expressing strong opinions, and usually violates the rules of netiquette (online etiquette).

Correct Answer: C) Who breaks rule of netiquette

The correct answer is:

(B) Leaves current document intact

When you use the "Save As" option, it allows you to save the document with a new name or in a different location while leaving the current document intact.

Correct Answer: B) Leaves current document intact

The correct answer is:

(B) Insert, new slide

This option allows you to add a new slide to an existing presentation.

Correct Answer: B) Insert, new slide

The correct answer is:

(B) World Wide Web

Correct Answer: B) World Wide Web

The correct answer is:

(C) Libre Office

Correct Answer: C) Libre Office

The correct answer is:

(A) MAC Address

Correct Answer: A) MAC Address

The correct answer is:

(D) DuckDuckGo

Correct Answer: D) DuckDuckGo

The correct answer is:

(A) Animation

Correct Answer: A) Animation

The correct answer is:

(D) DBMS

DBMS (Database Management System) is not an application of artificial intelligence. It is a software system designed to manage databases, while face recognition systems, chatbots, and LIDAR (Light Detection and Ranging) are applications that can involve AI techniques.

Correct Answer: D) DBMS

The correct answer is:

(C) Radio Identification Technology

Radio Frequency Identification (RFID) technology is commonly used in the Internet of Things (IoT) to track and manage devices, objects, and data through wireless communication.

Correct Answer: C) Radio Identification Technology

The correct answer is:

(A) Mobile Devices

Android is primarily developed for mobile devices, such as smartphones and tablets.

Correct Answer: A) Mobile Devices

The correct answer is:

(B) Vint Cerf

Vint Cerf, along with Bob Kahn, is widely recognized as one of the fathers of the internet for his contributions to the development of TCP/IP protocols, which are the foundation of the internet.

Correct Answer: B) Vint Cerf

The correct answer is:

(B) WordStar

WordStar was one of the first widely used word processing software programs in the 1970s and early 1980s. It played a significant role in the early days of personal computing.

Correct Answer: B) WordStar

The correct answer is:

(D) Airtel

Airtel is an example of an Internet Service Provider (ISP), which offers internet connectivity services to users. Chrome, Firefox, and Internet Explorer are web browsers, not ISPs.

Correct Answer: D) Airtel

The correct answer is:

(C) PDF

PDF (Portable Document Format) allows you to share a document in a way that it can be viewed by others but not easily edited. This is ideal for ensuring that people can only read the document without making any changes.

Correct Answer: C) PDF

The correct answer is:

(C) Google

Google is a search engine used to search for information on the internet.

The other options are web browsers:

• Google Chrome
• Internet Explorer
• Mozilla Firefox

Correct Answer: C) Google

The correct answer is:

(B) Amazon

Amazon is an e-commerce platform, not a social site.

The other options:

• Twitter
• Instagram
• LinkedIn

are all examples of social networking sites.

Correct Answer: B) Amazon

The correct answer is:

(D) All of the above

Presentations are widely used for note outlines for teachers, communication of planning, and project presentations by students. All of these are common uses of presentations.

Correct Answer: D) All of the above

The correct answer is:

(C) 71A

In spreadsheet software like Excel or LibreOffice Calc, a valid cell address consists of a letter (representing the column) followed by a number (representing the row). In this case, "71A" is invalid because it does not follow the correct format. The column must be represented by a letter (A-Z), and the row by a number (1, 2, 3,...).

Correct Answer: C) 71A

The correct answer is:

(C) A1

In a spreadsheet, the address of the first cell is always A1, where "A" represents the first column and "1" represents the first row.

Correct Answer: C) A1

The correct answer is:

(D) Signature

A signature is a block of text automatically added to the end of outgoing emails, often including the sender's name, contact details, or other relevant information.

Correct Answer: D) Signature

The correct answer is:

(D) Range

In a computer spreadsheet, a block of cells is called a range. A range can consist of a single cell or a group of cells selected together.

जब आप किसी आइकन या बटन पर माउस ले जाते हैं, तो जो छोटा बॉक्स उस बटन का नाम या काम बताता है, उसे 'टूलटिप' कहते हैं

Correct Answer: D) Range

The correct answer is:

(C) Tooltip

A tooltip is a small box that appears when you place the mouse cursor over an icon, giving a brief explanation of what that icon does.

Correct Answer: C) Tooltip

The correct answer is:

(D) Delete Presentation

You cannot assign the action of deleting a presentation to an action button or slide object in PowerPoint. You can assign actions like running a macro, hyperlinking, or playing a sound, but not deleting a presentation.

पावरपॉइंट में आप एक्शन बटन से गाना बजा सकते हैं, मैक्रो चला सकते हैं या किसी लिंक पर जा सकते हैं, लेकिन प्रेजेंटेशन को डिलीट करने का कमांड सीधे असाइन नहीं किया जा सकता

Correct Answer: D) Delete Presentation

The correct answer is:

(B) 128

Version 6 of the IP address, also known as IPv6, has 128 bits.

IPv4 में 32 बिट्स होते हैं, जबकि IPv6 में 128 बिट्स होते हैं, जो बहुत अधिक संख्या में इंटरनेट एड्रेस प्रदान करते हैं।

Correct Answer: B) 128

The correct answer is:

(D) IRCTC

The Indian Railway Catering and Tourism Corporation (IRCTC) is responsible for handling railway reservations for Indian Railways.

IRCTC (Indian Railway Catering and Tourism Corporation) भारतीय रेलवे की आधिकारिक संस्था है जो ऑनलाइन टिकट बुकिंग और आरक्षण का कार्य संभालती है

Correct Answer: D) IRCTC

The correct answer is:

(A) ctrl + z, ctrl + y

• Ctrl + Z is used to undo the last action.
• Ctrl + Y is used to redo the undone action.
• Ctrl + Z का उपयोग गलती सुधारने (Undo) के लिए और Ctrl + Y का उपयोग उसे वापस लाने (Redo) के लिए किया जाता है।

Correct Answer: A) ctrl + z, ctrl + y

The correct answer is:

(D) mp3

• mp3 is a file format, and a spreadsheet cell can only contain text, numbers, or formulas. A file format like mp3 cannot be typed directly into a cell.
• सेल के भीतर आप टेक्स्ट, नंबर और फॉर्मूले टाइप कर सकते हैं, लेकिन एक ऑडियो फाइल (.mp3) को सेल के अंदर डेटा के रूप में टाइप नहीं किया जा सकता

Correct Answer: D) mp3

The correct answer is:

(C) Placeholders

• In a presentation, the dotted areas in an empty slide are called placeholders. These are used for adding content such as text, images, charts, or videos.
• नई स्लाइड में जो बिंदीदार बॉक्स (Dotted boxes) होते हैं जहाँ "Click to add title" लिखा होता है, उन्हें 'प्लेसहोल्डर' कहा जाता है

Correct Answer: C) Placeholders

The correct answer is:

(D) Integrated circuits

• Third-generation computers used integrated circuits (ICs). These ICs were smaller, faster, and more reliable compared to earlier technologies like vacuum tubes and transistors used in previous generations.
• पहली पीढ़ी में वैक्यूम ट्यूब, दूसरी में ट्रांजिस्टर और तीसरी पीढ़ी में इंटीग्रेटेड सर्किट्स (IC) का उपयोग हुआ था

Correct Answer: D) Integrated circuits

The correct answer is:

(D) Creating presentations

• Spreadsheet software like Excel or LibreOffice Calc is primarily used for managing data, financial and accounting documents, data analysis, and creating reports. However, it is not used for creating presentations. Presentations are typically created using presentation software like Microsoft PowerPoint or LibreOffice Impress.

• स्प्रेडशीट (जैसे Excel) का उपयोग गणना और डेटा विश्लेषण के लिए होता है। प्रेजेंटेशन बनाने के लिए पावरपॉइंट या लिबरऑफिस इम्प्रेस का उपयोग किया जाता है।

Correct Answer: D) Creating presentations