NIELIT CCC Exam Q&A: Previous Year Questions and Solutions


Top CCC Exam Question Bank with Answers

  • Bluetooth is an example of - Personal Area Network (PAN)
  • Mail-merge is a component of -MS-Word
  • Which of the following is correct about QR Code? - It can carry information both horizontally and vertically it is a 2D matrix machine readable code
  • Which of the following devices converts digital signals into a form that is intelligible to the user - Output devices
  • This type of software works with end users, application software and computer hardware to handle the majority of technical details - System Software 
  • MS-DOS is an operating system 
  • ANTIVIRUS is an utility software 
  • Firefox is an application software 
  • MS-DOS, Windows XP and Unix are examples of which type of software?-Operating System
  • Start' menu in a standard personal computer is -A set of options and commands
  • Which of the following is a characteristic of the Linux operating system? -Multiuser and Multitasking
  • Cyber security protects internet- connected systems
  • Choose a fit" option. The available options are "Fill," "Fit," "Stretch," "Tile," and "Center."
  • How can you add a page break in a document in LibreOffice Writer -By using the Insert menu
  • What is the full form DLP in 3D printing -Digital Light Processing
  • In the context of computer networking, what protocol is used to turn names, such as www.abc.edu, into IP addresses? -DNS
  • Where do you find clock and calendar in computer? -Task Bar
  • In Libre office, which of the following menu contain Macros Command? -Tools
  • To add or remove printers using Windows OS, click on the printer icon from - Control panel 
  • Rules for exchanging data between computers are called -Protocols
  • An Artificial Intelligence system that is created to complete a particular task is know as Weak AI ( Narrow AI)
  • OS that permits multiples programs to run simultaneously using single processor is referred as - Multitasking
  • From which menu one can insert Header and Footer into a word document? - Insert
  • A critical section is a program segment where shared resources are accessed
  • Which PowerPoint view displays each slide of the presentation as a thumbnail and is useful for rearranging slides? -Slide sorter
  • Which of the following is used to provide data and control signals to an information processing system? - Input device 
  • It is a graphics solution for Word Processors - Clipart
  • Which of the following shortcut key is used to open a new file in MS-Word 365?- Ctrl + N
  • One or more users simultaneously on two or more processors are known as , Multiprocessing 
  • Which of the following is an open source operating system? - Linux
  • In PowerPoint presentation, the collection of images in Clip Art is ready to use
Example of a Word Processor is
Microsoft Word,
WordPad,
OpenOffice Writer,
Wordpad,
Lotus word pro,
Notepad,
WordPerfect (Windows only),
AppleWorks (Mac only),
Work pages,
OpenOffice Writer.
  • What is the function of control lines in RAM - Hold data that is being transferred to or from memory
  • The primary job of the operating system of a computer is to - Manage resources
  • Which of the following is not a type of file allocation system -Non-contiguous system allocation
  • Which among the following is a compressed file extension? - .ARJ
  • The bar which shows your current status in the document is called -Status Bar
  • Which of the following is not types of Voice Services in the loT? -Hybrid-directional voice
  • Which of the following is a Programming Software - Visual Basics 
  • Cloud computing is a Service 
  • A star network consists of Hub/switch as a central device in star topology
  • What is the purpose of Block Chain -To secure the data
  • Which of the following is NOT an open source software -Adobe Photoshop
  • The Kernel is Unaware user-level threads
  • In a typical spreadsheet application, what is the term used to refer to the intersection of a row and a column Cell
  • In which of the following network topologies each connection (link) is a failure point, i.e. failure of a node affects the entire network -Ring
  • The file which is created through word processing is a: Document File
  • Mozilla Firefox among the following is not an operating system.
  • Which of the following statement correctly defines the word topology arrangement of networking devices in the network
  • While turning on the computer it will check the files: Command.com, io.sys, msdos.sys
  • In LibreOffice, Digital Signature option is available in which Menu? - File
  • What is the default file extension of LibreOffice Writer -.odt
  • How can you change the font size in a document in LibreOffice Writer -By using the Character Properties feature
  • How can you change the line spacing in a document in LibreOffice Writer -By using the Paragraph Properties feature
  • Which among the following is a compressed file extension? - .ARJ
  • What is the purpose of the Styles and Formatting feature in LibreOffice Writer? -To add custom styles to a document
  • What is the default file format used by LibreOffice Calc? - .ods
  • Which of the following is an important characteristic of LAN? Application Independent Interfaces
  • The main page of a website is called asHome Page
  • Which feature in LibreOffice Impress allows you to rehearse and time your presentation to ensure effective delivery?-Slide show rehearse timings.
  • Which feature in LibreOffice Impress allows you to collaborate with others in real-time during a presentation? - Live Comments
  • How can you add a footnote or endnote in a document in LibreOffice Writer -By using the Footnote/Endnote feature
  • Which of the following country designed QR code? - Japan in 1994
  • Google -Which of the following is an example of a search engine
  • What is the minimum limit of RTGS transactions - 2lakh
  • IMPS stands for Immediate Payment Service.
  • It is the science that attempts to produce machines that display the same type of intelligence that humans do. - AI
  • Which of the following algorithm is related to Artificial Intelligence -Hill Climbing Algorithm
  • What is the full name of NFTs which are cryptographic assets on a blockchain with unique identification codes and metadata that distinguish them from each other?-Non-fungible tokens
  • Use of internet to connect a wide variety of devices, machines and sensors for empowering brick and mortar stores by giving them the same access to data that online stores have is a facility falls under - IOT
  • Internet is described as a network of network.
  • WWW is a service that runs on the Internet
  • Millions of calculations can be performed by a computer with the same accuracy without any tiredness or lack of concentration. Which of the given options represents this property of a computer- Diligence
  • Which of the following was the first general-purpose electronic digital computer designed for corporate applications in the United States? - ENIAC
  • Apple II is an example of fourth Generation of computer.
  • Google Chrome was the first web browser to implement the omnibox.
  • Shortcut key in MS Word for close the document? -  Ctrl+W
  • Decrease the font size by 1 point in MS word? -  Ctrl+[
  • Increase the font size by 1 point in MS word? - Ctrl+]
  • The shortcut key to create subscript in MS Word is  - Ctrl + =
  • Input peripheral devices are mouse, keyboard, image scanner, barcode reader, light pen, microphone, digital camera, webcam.
  • Output peripheral devices are computer monitors, projectors, printers, headphones, and computer speakers.
  • input/output peripheral devices are computer data storage devices such as disk drive, USB flash drive, memory card, and tape drive.
  • Storage peripherals are used to store and record data, and include internal and external hard drives, CD-ROM and DVD drives, and flash memory drives.
  • IPv4 addresses are 32-bits long  & 8 NibbleThey are expressed in decimal.
  • IPv6 addresses are 128-bits. They are expressed in hexadecimal
  • Programs stored in which of the following memories can't be erased - ROM
  • What is meant by CCTV? - closed circuit television
  • Linux is an operating system 
  • Kaspersky, Norton and Avast are anti-virus software.
  • Windows, iOS, and Mac OS, Linux is an operating system.
  • Anti-virus software are McAfee, Norton, and Kapersky
  • Programming languages considered as low level language? - Assembly language
  • High-level programming languages in active use today include Python, Visual Basic, Delphi, Perl, PHP, ECMAScript, Ruby, C#, Java.
  • Which of the following symbols must be used before a formula in a Microsoft Excel sheet - =
  • Which of the following is an Internet browser - Internet Explorer
  •  WorldWideWeb is the world's first web browser. The WorldWideWeb was created in 1990 by Sir Tim Berners-Lee. It is also called 'Nexus'. The first web browser developed in India is 'Epic'. It was developed by Hidden Reflex, a Bangalore based software startup.
  • Google Chrome is the most used browser.
  • Important web browsers are: Opera. Mozilla Firefox. Google chrome. Safari. Epic. Mosaic.
  • Windows Explorer is a file manager application.
  • CD-ROM is a kind of - optical disc
  • Third Generation Computers -The period 1963 to 1971. The third generation computers were developed by using Integrated Circuit technology.
  • Fourth Generation Computers - The period 1972 to 2010 The fourth-generation computers were developed by using microprocessor technology.
  • Fifth Generation Computers  - The period 2010 to date. Popular advanced technologies of the fifth generation include Artificial intelligence, Quantum computation, Nanotechnology, Parallel processing, etc.

Word shortcut keys

Ctrl + A -- Select all contents of the page.
Ctrl + B -- Bold highlighted selection.
Ctrl + C -- Copy selected text.
Ctrl + X -- Cut selected text.
Ctrl + N -- Open new/blank document.
Ctrl + O -- Open options.
Ctrl + P -- Open the print window.
Ctrl + F -- Open find box.
Ctrl + I -- Italicise highlighted selection.
Ctrl + K -- Insert link.
Ctrl + U -- Underline highlighted selection.
Ctrl + V -- Paste.
Ctrl + Y -- Redo the last action performed.
Ctrl + Z -- Undo last action.
Ctrl + G -- Find and replace options.
Ctrl + H -- Find and replace options.
Ctrl + J -- Justify paragraph alignment.
Ctrl + L -- Align selected text or line to the left.
Ctrl + Q -- Removes all formatting from a highlighted paragraph
Ctrl + E -- Align selected text or line to the centre.
Ctrl + R -- Align selected text or line to the right.
Ctrl + M -- Indent the paragraph.
Ctrl + T -- Hanging indent.
Ctrl + D -- Font options.
Ctrl + Shift + F -- Change the font.
Ctrl + Shift + > -- Increase selected font +1.
Ctrl +] -- Increase selected font +1.
Ctrl + [-- Decrease selected font -1.
Ctrl + Shift + * -- View or hide non printing characters.
Ctrl + (Left arrow) -- Move one word to the left.
Ctrl + (Right arrow) -- Move one word to the right.
Ctrl + (Up arrow) -- Move to the beginning of the line or paragraph.
Ctrl + (Down arrow) -- Move to the end of the paragraph.
Ctrl + Del -- Delete word to the right of the cursor.
Ctrl + Backspace -- Delete word to the left of the cursor.
Ctrl + End -- Move cursor to end of the document.
Ctrl + Home -- Move cursor to the beginning of the document.
Ctrl + Space -- Reset highlighted text to default font.
Ctrl + 1 -- Single-space lines.
Ctrl + 2 -- Double-space lines.
Ctrl + 5 -- 1.5-line spacing.
Ctrl + Alt + 1 Change text to heading 1.
Ctrl + Alt + 2 Change text to heading 2.
Ctrl + Alt + 3 Change text to heading 3.
F1 -- Open help.
Shift + F3 -- Change case of selected text.
Shift + Insert -- Paste.
F4 -- Repeat the last action performed (Word 2000+).
F7 -- Spell check selected text and/or document.
Shift + F7 -- Activate the thesaurus.
F12 -- Save as.
Ctrl + S -- Save.
Shift + F12 -- Save.
Alt + Shift + D -- Insert the current date.
Alt + Shift + T -- Insert the current time.
Ctrl + W -- Close document.
  • SMTP(Simple Mail Transfer Protocol)
  • PPP(Point to Point Protocol)
  • FTP (File Transfer Protocol)

Computer Network Types

  • LAN(Local Area Network)
  • PAN(Personal Area Network)
  • MAN(Metropolitan Area Network)
  • WAN(Wide Area Network)
  • Which of the following is used in main memory - DRAM
  • Skimming is a type of fraud where a small electronic device is used to steal debit/credit card information during an authorised banking transaction.
  • Phishing is a fraudulent attempt to obtain sensitive information or data, such as usernames, passwords and credit card details.
  • When the user is tricked into downloading a Trojan horse or other malware onto his mobile through SMS is called Smishing.
  • Voice phishing or vishing is the criminal practice of using social engineering over the telephone system to gain access to private personal and financial information from the public for the purpose of financial reward.
  • What is maximum zoom percentage in MS-Word? - 500
Spooling - It is a process in which data is temporarily held to be used and executed by a device, program or the system
Swapping - It is a memory reclamation method wherein memory contents not currently in use are swapped to a disk to make the memory available for other applications or processes.
Paging - It is a memory management scheme that allows the processes to be stored non-contiguously in the memory.
Relocation - Sometimes, as per the requirements, data is transferred from one location to another. This is called memory relocation.
  • Which of the following languages does a computer use to process data? - Binary
  • Which of these is not an open source Operating System ? - Windows
  • Which of the following units produces a synchronization signal? - Control Unit
  • Which of the following shortcut key is used to switch to print preview in MS-Word 365? - Ctrl + Alt +I
  •  In MS Word, the Restrict Editing option lies in which menu? - review
  • Auxiliary memory is popularly known as secondary storage
  • How many types of page orientation are available in MS-Word software ?- two
  • WinRar is not a database. 
  • What does Cc in e-mail stand for? - Carbon Copy
  • Magnetic Disk is an example of: Non volatile storage
  • spider is a software program that travels the web locating and indexing websites for search engines
  • A software bug is an error, flaw, or fault in a computer program or system that causes it to produce an incorrect or unexpected result, or to behave in unintended ways.
  • Which of the following types of computer is used in climate research and weather forecasting? - Supercomputer
  • Thesaurus tool in MS-Word is used for: Synonyms & Antonyms words
  • point-to-point connection between the device and hub. - Star Topology
  • A computer in a network that cannot be accessed outside of the local network unless given permission is called Intranet
  • What is the keyboard shortcut to go to 'Home tab' in MS-Powerpoint? - Alt+H
  • Which of the following internet protocols allows us to access the data over the World Wide Web? - HTTP
  • The speed of supercomputers is measured in FLOPS
  • In power point, Themes could be found under - Design Tab
  • Which of the following languages is an example of fourth generation language in computer programming? - Perl, Python, Ruby, SQL, MatLab.
  • Third generation language: C, C++, Java, Visual Basic, and JavaScript
  • Second generation language: kernels and hardware devices
  • fifth-generation languages include Mercury, OPS5, and Prolog.
  • What is another name for a dot matrix printer - impact printer
  • Which of the following looks like a flat circuit board containing a computer circuitry? - motherboard
  • Which of the following has the highest storage - Terabyte
  • Which of the following consists of an electronic writing area and a special 'pen' that works with it? - Graphic tablet
  • Presentation pages in PowerPoint is called - slide 
  • F5 is shortcut key for slideshow
  • Pressing f12 key opens save as Microsoft Word
  • In the context of computers, tracker balls is a/an device input device
  • Which among the following is NOT a Basic logical operator in Boolean Algebra - NAND
  • In the MS Access, the columns are named as Fields
  • How many primary keys can a table have in MS- Access? - One
  • How many data types is in MS Access - 10
  • Microsoft Access belongs to which category - DBMS / RDMS
  • The device that performs signal conversion is modem
  • In an application window, a slider is a button that you can drag to the left or right to increase or decrease the setting value, respectively.
  • DMA is particularly suited for data transfer between the RAM and I/0
  • What is the main folder on a storage device called? - root directory
  • The operating system for mobile phones developed by google is: Android
  • Pirated software is the unauthorised use, duplication or sale of copyrighted software. 
  • Which tool helps better for what if analysis in MS Excel ? Goal seek
  • A computer program that converts an entire program into machine language at one time is called a/an - compiler
  • Which one of the following is not a computer virus but is, basically, a computer language? Python
  • Which tool is used to rearrange the data to find values quickly? - sort
  • Which of the following is the first screen to appear on the monitor after Windows 10 is loaded?-Desktop
  • Where do you select the paper size for a document? - Page Layout > Size.
  • The default alignment of numbers in Microsoft Excel spreadsheet is Right
  • As a default in Microsoft Excel, text typed into a cell is aligned to the left border of the cell while numbers are aligned to the right.
  • When an attacker forces a computer reset/reboot and then steals any data left over in the RAM is known as attack - Cold boot
  • Which of the following sections does not exist in a slide layout? - animation
  • Kernel is the core part of Linux Operating System
  • Which of the following is a line printer? - chain printer
  • What happens when you select a column and press CTRL SHIFT and Plus (+) at the same time in MS Excel ? - A new column is added before the selected column
  • The fastest hardware device in a computer is cache memory
  • A is a secondary window that allows users to perform a command, ask users a question, or provide users with information. - Dialogue box
  • Which one is not a Function in MS Excel ? - AVG
  • In MS Word, "Ctrl + Down Arrow" is used to Moves the cursor one paragraph down
  • Which of the following devices provides wireless connectivity to the client with LAN network - Wireless network adapters
  • Alt + = - Create the formula to sum all of the above cells
  • Optical Disc includes CDs, DVDs, and Blu-ray discs.
  • Hard disks, zip disks, and floppy disks are common examples of magnetic disks.
  • Which of the following shortcut key is used to switch to print preview in MS-Word 365?-Ctrl + Alt + I
  • The shortcut command of 'save' in MS Word:Ctrl + S, ALT + F + S
  • What is the shortcut to insert comment in MS Excel ?-Shift + F2
  • In ICT, which one of the following pairs of acronyms and its expansion is incompatible- .csv - Comma Separated Variables
  • URL stands for- Uniform Resource Locator
  • Taskbar is used for- Navigation program,switching between program,start a program
  • Which of the following toolbars allows changing Fonts and their sizes - Formatting
  • What is the shortcut key to split a table?-Ctrl + Shift + Enter
  • 1048576 - An excel worksheet can have a maximum number of rows.
  • In Microsoft PowerPoint, which of the following tool enables you to add text to a slide without using the standard placeholders - text tool box
  • Displays each slide of the PPT as a thumbnail and is used to re - arrange them: slide sorter
  • Which of the following allow you to select more than one slide in a presentation?- Ctrl + Click each slide
  • What is the purpose of headers and footers used in document:-To allow page headers and footers to appear on document when it is printed.
  • In which of the following types of Internet connections, conventional telephone lines are used to provide the Internet connection - dial up internet
  • Which of the following options is not available under the 'Tracking' group in the 'Review' ribbon tab in MS- Word365? - previous change
  • The output of an assembler program is called relative to the input source program - object program
  • Who invented 'Java-James -  A Gosling
  • What is the full form of ENIAC?- Electronic Numerical Integrator And Computer
  • Click jacking, a type of cyber attack, is-A malicious technique of tricking web users into revealing confidential information
  • MIDI stands for: Musical Instrument Digital Interface
  • The first mechanical calculator was called-Pascaline
  • Which component of a computer is responsible for managing and controlling data storage devices such as hard disk drives and solid-state drives- HDD Controller (Hard Disk Drive Controller)
  • Select the INVALID type of wireless communication medium. - Optical fibre
  • The default editor that comes with the UNIX operating system is called - vi editor
  • In the latest version of Windows 11, which command sequence should be used to protect a worksheet in an Excel file- Review -> Changes->Protect Sheet
  • Which file format is denoted by the following extension in Microsoft Excel as per the latest Windows 11 update? - .xlsx
  • Which of the following formulas can be used to create a pivot table?- =PIVOTTABLE()
  • The default extension of access database file is - mdb
  • Which tool do you use to create a query object in MS- ACCESS?- Simple query wizard
  • The process of division of memory spaces is called - Segmentation
  • Application layer - HTTP is protocol.
  • How many bits are there in hexadecimal code ? - 4
  • Data communication system within a building or campus is LAN
  • Cable - is medium which can transmit communication signals. It wired network uses special types of cables to connect computers on a network.
  • What is the purpose of the "$" sign in Excel formulas -It is used to fix the row or column in the formula
  • How do you create a chart from data in an Excel spreadsheet - Go to Insert(tab) -> click Charts(group)
  • What is the shortcut to auto sum all the numerical values in a column in MS Excel? - Alt + =
  • What does the VLOOKUP function do in Excel? - It looks vertically down the first column of a range for a key and returns the value of a specified cell in the row found
  • Which of the following protocols is used by email clients to send email to mail servers? - SMTP
  • What does the 'Print Range' option allow you to do when printing a document? - Choose the specific pages or range of pages to be printed
  • Which option allows you to import recipient addresses from a spreadsheet when creating mailing labels in MS Word - Mail Merge Wizard
  • What is the term for the unwanted and unsolicited messages that are sent over the internet - Spam
  • How can you insert a new row or column MS Excel? - Right-click the row or column and choose 'Insert
  • Which field should be used when you want to send a copy of an email to someone else without the original recipient knowing? - BCC
  • If you write criteria values vertically (one in a row) it will mean in Ms - Access - OR conditions
GIS is Geographic Information System.
GPS - Global Positioning System
ATM - Automated Teller Machine • ATM machine
SIM - Subscriber Identity Module
  • Which of the following is/are an example of utility program - Antivirus software, File Compression, Network Managers
  • Which of the following output devices is used for translating information from a computer into pictorial form on paper - plotter
  • Which of the following is a kind of non-impact printer? - Ink-jet printers
  • Machine Level Language is a/an Low level language
  • Default pointing device of a laptop is-Touchpad
  • What is the main directory of a disk called? - Root
  • Which of the following technique(s) used in networking? - Packet switching,Circuit switching, Message switching
  • What does PPP stands for with respect to Data Communication? - Point to Point Protocol
  • What is the keyboard shortcut for creating a chart from the selected cells? - F11
  • Fastest memory is:-- Cache memory
  • Which type of network we create when we connect two smartphones to transfer some photos through Bluetooth - PAN
  • A barcode is optical code that represents data with bars of varying widths or heights.
  • To move to the beginning of a line of text, we should press the key- Home
  • In page preview mode - You can see all pages of your document
  • In MS Word document, how can spelling and grammar errors are detected - F7
  • What is the default file extension for all Word Documents - .docx
  • The output quality of a printer is measured by Dot per inch
  • Microsoft Access does not directly support a data type known as "Picture / Graphic".
  • What are the columns in a Microsoft Access table called? - fields
  • RAM can store programs and data
  • ASCII stands for: American Standard Code for Information Interchange
  • How long is an IPv6 address:-128 bits
  • A software application capable of creating, storing, and printing documents is called word processor
  • What is the default vertical alignment of texts in an Excel worksheet? - Bottom
  • In MS Excel 2007, AutoSum option can be accessed from - formula tab
  • ROM stands for: Read only memory
  • Which of the following is an example of a single tasking operating system? - MS DOS
  • A Doughnut chart in Excel in similar to: Pie Chart
  • Which of the following shortcut is used to select a paragraph in MS Word?- triple-click on a paragraph
  • Which of the following is used to paste the copied item. - Shift+Insert
  • An Excel Workbook is a collection of Worksheets
  • What is the shortcut key to navigate between open applications Alt+tab
  • Which of the following options is a common function of an input device -Read input data
  • Structure of database" is known as schema
  • What is the mounting of file system? - attaching portion of the file system into a directory structure
  • The Windows sound file has the extension - .wav
  • In MS Word, which of the following do you use to change margins ?- page setup dialog box
  • Which key is used to move from one column to another without using the mouse in Excel?
  • Tab
  • Shortcut key is used in MS-Excel 2010 to select a column - Ctrl + Spacebar
  • In word processing, what is a hanging indent? - The indent to all the lines except the first line of a paragraph
  • The process of transferring files from one computer to another computer through the internet is called Uploading
  • PDF Full Form is-Portable Document Format
  • Which option offers a built in design through a dialog box? - Template
  • Malware is any kind of unwanted software that is installed without your adequate consent.
  • GNU/Linux is a free and open-source operating system
  • Slide show view is not present in Power Point.
  • What is the difference between Endnote and Footnote?- Endnotes are a series of notes placed at the end of the document. Footnote is a series of notes at the bottom of a page
  • Which MS Access query lets you combine records from two or more tables -Union query
  • Microsoft Windows is a software - proprietary software
  • Which of the following is an open-source time- sharing operating system-Linux
  • What is the default view when you open a document or create a new document? Print Layout view
  • The outline tab in PowerPoint is used to view - Only texts in slide
  • Sort option is not available in 'Cells' groups of Home tab in MS Excel 2007.
  • Firmware - is a specific class of computer software that provides the low-level control for a device's specific hardware.
  • Which among the following functions of Operating System includes a program called I/O controller? - Device Management
  • The tool can be used to expand or shrink a partition - Disk Management 
  • What is the size of an IPv4 address? - 4 Byte
  • To use a uniform background image/appearance to all the slides in a PowerPoint presentation, choose - Apply to All
  • Which of the following database is suitable for objects- Object-oriented DBMS
  • When data is in list format can be used to represent in neatly in MS Word-Bullets
  • Which among the following is a Flash memory device? - USB Drive
  • In MS-Excel, the spelling tool is placed on which menu bar - Review 
  • In Microsoft PowerPoint, Sound, Duration and On Mouse Click functions come under menu - Transition
  • Which object in MS Access is used to extract specific data from tables based on specified criteria?-Queries
  • Which of the following displays the address of the active cell in a Microsoft Excel worksheet - Name Box
  • Which of the following keyboard shortcuts is used to insert a footnote in MS-Word 2010 - Ctrl + Alt + F.
  • In Microsoft PowerPoint in order to see all the slides on one screen use: view slide sorter
  • You can merge the main document with data source in Excel. In mail merge operation, Word is usually:-Client
  • In MS Word - 2010 watermark option is found in-Page layout tab → Page background group
  • MS-Office 2000 included a full-fledged Web designing software called-Front page 2000
  • In the context of computer, DVD stands for-Digital Versatile Disc
  • The word wrap features-automatically move text to the next line when necessary
  • Which of the following keyboard shortcuts will launch the Start menu in Windows operating system-Windows
  • Which of the following is utility software- WinRAR
  • In MS-Access, Query design window has two parts. The upper part shows-Tables with fields and relationships between tables
  • Which of the following tools enables you to add text to a slide without using the standard placeholders in Microsoft PowerPoint?- Text toolbox
  • A device that is used to convert digital signals (or data) into analog signals and vice versa is called:-Modem
  • Which command is used to calculate the total characters in a cell? - Len
  • Which of the following is the default page setup orientation of slide in PowerPoint-Landscape
  • Java is an object-oriented bottom up programming language, whereas C, FORTRAN, and Pascal are considered top-down programming languages
  • Which of the following keyboard shortcuts is used to go to the File tab in MS-Word 2010- Alt + F
  • In MS Word, With which view can you see how text and graphics will appear on the printed page? - Print Layout
  • Data querying, tuple insert, remove, and modification capabilities are provided by. - DML (Data Manipulation Langauge
  • If the firewall is placed between two or more networks and monitors the network traffic between different networks, it is termed as:- Network Firewall
  • A flip-flop is a binary cell capable of storing of information. - One bit
  • The "Lookup Wizard" in MS access used for: to select value from another table
  • What is the decimal equivalent of the binary number 101011? - 43
  • When data changes in multiple lists and all lists are not updated, this causes: Data Inconsistency
  • Word by default, places a tab stop at every mark on the ruler-0.5"
  • The Physical layer is the lowest layer in the OSI Model
  • You can convert existing excel worksheet data and charts to an HTML document by using - Internet assistant wizard
  • What is necessary for booting a computer?-Operating System
  • In the split window mode, one title bar looks darker than the other because the-darker title bar shows active window
  • Plain-text editor that is the part of the Windows Operating System is-Notepad
  • In MS-Excel to select the entire row, which shortcut is used -Shift + Space
  • Which feature is used to apply motion effects in between a slide exits and another enters?-Slide Transitions
  • When the user places the mouse pointer on any of the buttons and not click them, after few seconds a text appears at the bottom of the pointer. It is called Tool Tip Text
  • Which one of the following is optical storage-CD
  • In word processing, what is a hanging indent?-The indent to all the lines except the first line of a paragraph 
  • Which cyber security measure involves verifying the identity of users before granting access to a system or network?-Multi-factor authentication
  • Every computer on the Internet is known as- Host
  • In how many different combinations do the standard ASCII codes come-128
  • The central part of the UNIX Operating System is: Kernel
  • What is the full form of NIC?-Network Interface Card
  • Timestamp - is a unique identifier created by database management system to identify the relative starting time of a transaction
  • Which short cut command is used to insert current date in Excel?-Ctrl+
  • In MS Access, which view allows you to enter and edit data directly in a table?-Datasheet View
  • The first page of a web site is called its:-Home page
  • At which port number, Simple Network Management Protocol (SNMP) operates? -161
  • ENIAC was the first electronic general-purpose computer. What does 'N' stand for in ENIAC-Numerical
  • MAC address is written in which format-Hexa decimal format
  • Dynamic packet filters firewall are fourth generation firewalls that work at-TCP, UDP
  • In MS - PowerPoint, multiple slides per page are printed using option-Hand outs
  • Which of the following is the correct option for using 'justify' alignment to a paragraph in a document?-Aligns text to both left and right edges
  • In context of computers, FAT stands for-File Allocation Table
  • Which one among the following commands is used to check the error status of hard disk drive-CHKDSK
  • Using Windows API, you can extend testing abilities and add usability and flexibility to your -Applications
  • To incorporate Microsoft Access data into a Microsoft PowerPoint presentation, which of the following options provides the most efficient and dynamic solution?-Using the "Paste Special" feature in PowerPoint to link an Access query and display real-time data updates.
  • What is the work of Home key?-Cursors reach the starting of the line
  • What components make up an RDBMS?-Collection of Tables
  • Melissa virus was spreaded through the-Microsoft word
  • What shortcut key is used to split a table in MS Word?-Ctrl + Shift + Enter
  • In a DBMS, the content and location of data is identified by-Metadata
  • ext file system was specially designed for linux kernel.
  • A kernel is the heart of the Operating System, which allocates time and memory to programs and handles communication and file store. 
  • Shell is the interface between the user and the kernel.
  • .temp is a: temporary file 
  • local directory - becomes the name of the root of the newly mounted directory 
  • What is the full form of DHCP -Dynamic Host Configuration Protocol
  • What is the full form of GPRS in mobile computing? - General Packet Radio Service
  • In the context of data stored in a computer, what is a byte?-group of binary digits, usually eight, that a computer usually deals with.
  • In the Internet architecture, which of the following protocol provides end-to-end transmission of data?-TCP
  • Radio waves are used by which of the following networks to transmit information across the network?-Wi-Fi
  • Size of an IPv4 address is 32 bits . IPv4 addresses are generally represented in decimal-dotted notation
  • This folder in Windows File Explorer is made to store all your document files which you have created and saved in it.-Documents
  • Name the final version of the Internet Explorer web browser by Microsoft -IE11
  • Hit is the term used when a search engine return a Web page that matches the search criteria 
  • Web servers - Computer system that delivers web pages
  • What is the email attachment size limit in Gmail? - 25MB
  • With reference to the email protocol IMAP, which of the following statements are true - By default, IMAP uses two ports, SMTP stands for Simple Mail Transfer Protocol,POP stands for Post Office Protocol
  • SMTP is used for sending emails, whereas POP used for receiving emails.
  • A block of text automatically added to the end of an outgoing email is called an/a-Signature
  • Which of the following applications has been chosen for the National e-Governance Awards 2019 -IRCTC Rail Connect
  • In November 2017. Indian Government launched 'UMANG' mobile app. What does 'G' stand for in 'UMANG'? -Governance
  • The Indian Railway Catering and Tourism Corporation (IRCTC) launched its own digital payment aggregator system -iPay
  • In Cloud computing, the acronym PAAS stands for-Platform As A Service
  • Cloud computing operates on big data and edge computing operates on real time data generated by sensors or users respectively.
  • Which delivery mode is an example of a cloud computing environment that provides users with a web based e-mail service? - Software as a service
  • Suppose a cloud contains software stack such as Operating system, Application software, etc. This model is referred as model. - SaaS
  • Laser printer is a non-impact printer.
  • / searches the string in file opened in vi editor?
  • Which command is used to extract specific columns from the file - Cut
  • Linux is a System Software
  • When was the world's first Laptop computer introduced in the market and by whom?- Epson, 1981
  • Opcodes are also know as- Operation code
  • Which of the following is a limitation of computer?- Inability to think
  • A cursor is a vertical blinking line in a text editor that indicates the place where anything that is typed will appear.
  • Which of the following operation is mainly performed by RAM?-Read and write
  • In which year was Windows 10 released? - 2015
  • The booting process does the following with the OS. - Portions of the operating system are copied from disk into memory
  • Which of the following correctly describes the Windows operating system?- both multitasking and multiprogramming
  • Every computer has a(n) many also have- Operating system; application program.
  • A complete operating system that works on a desktop computer, notebook computer, or a mobile computing device is called Stand-alone operating system. 
  • Operating system - contains and manages all the programs and applications that a computer or other device is able to run.
  • What among the following can be said to be the categories of PC and Apple Mac? - Platforms
  • How many operating systems can work on one computer at the same time? - only one
  • If a robot is able to change its own trajectory as per the external conditions, then the robot is considered as the -Intelligent
There are four main types of blockchain networks:

1. Public blockchain network
2. Private blockchain network
3. Consortium blockchain network
4. Hybrid blockchain network
  • Deep learning is comprised of Neural Network 
  • The digital footprints also known as digital shadow 
  • The term used for a blockchain splits is A fork
  • A patent protects an invention for 20 years, after which it can be freely used.
  • Digital footprints are stored Permanently
  • Which one is not view option in PowerPoint? - Slide show view
  • The outline tab in PowerPoint is used to view -Only texts in slide
  • What is the shortcut key to insert a new slide in MS PowerPoint?- Ctrl + M
  • In Powerpoint, two kinds of sound effect files can be added to the presentation are - .wav and mid files
  • Flipping feature creates a mirror image of the selected object in a PowerPoint presentation
  • Which of the following is a valid Master View option in Microsoft PowerPoint 2016 - Slide Master, Handout Master, and Notes Master.
  • In MS-PowerPoint, the Header & Footer button can be found on the insert tab in what group -Text group
  • How can we enter data in charts in MS PowerPoint? -Type it in excel spreadsheet that comes with Edit Chart option
  • Virtual keyboards or Online keyboards are commonly provided by Internet banking websites because - they allow users to type passwords securely
  • Format painter is used to copy formatting styles of selected text and apply to other texts in a word document
  • Which of the following buttons are present in the Quick Access Toolbar by default in MS-Word 2010 -Save, Undo, Redo
  • Hidden format symbols can be viewed by pressing - 'Ctrl + Shift + 8'.
  • Spell check" is under which menu-Tool
  • Which feature of a word processing software such as Microsoft Word enables the creation of a table of contents based on document headings -Styles
  • In Excel, How do you delete a column - Right-click the column heading you want to delete and select delete from the shortcut menu
  • In MS-Excel 365 which of the following appears across the top of the screen and below the title bar and contains all the commands, formulas and features needed to create data-intense spreadsheets? - Ribbon
  • Suppose the date '14-09-2022' is stored in cell A1, which is 'Wednesday'. Which of the following formula will display 'Wed' in cell B1?- =TEXT(A1, "ddd")
  • How many users can open the Excel file at the same time?-256 users
  • The error value corresponding to the Excel expression =SUM(1, "A")/0 is:-#VALUE!
  • Which of the following is the correct way to insert a new slide in a MS PowerPoint 2016 presentation -Right-click in the Navigation Pane under any existing slide and click on the New Slide option
  • Slide setup, slide orientation, presentation themes and background in MS-PowerPoint 2016 (MS- PowerPoint 2016) appear under which of the following menu - Design
  • Which group has the header and footer function in slides of MS PowerPoint?-Text

The six main components of the CPU are -

1. Control unit
2. Arithmetic Logic Unit
3. Register
4. Cache
5. Buses
6. Clock
  • One bit = 0 or 1 (binary value)
  • 8 bits = One byte
  • One KB or kilobyte = 1024 bytes
  • One MB or megabyte = 1024 KB or kilobytes
  • One GB or gigabyte = 1024 MB or megabytes
  • One TB or terabyte = 1024 GB or gigabytes
  • One PB or petabyte = 1024 TB or terabytes
  • ASCII is an 8-bit code, it uses eight bits to represent a letter or a punctuation mark.
  • Eight bits are called a byte.
  • A binary code with eight digits, such as 1101 10112, can be stored in one byte of computer memory.
The motherboard is also known as Mainboard, Planar board, System board, Main circuit board, baseboard, Mobo, and backplane.
  • Raymond Tomlinson is widely known for inventing network electronic mail, choosing the "@" sign-in emails to connect the username with the destination address.
Vint Cerf is known as the father of the internet.
  • UNIVAC-I was the first commercially produced computer that could perform general-purpose computations for business applications.
  • ENIAC, short for Electronic Numerical Integrator and Computer, was the basis for the UNIVAC-I computer and had almost similar functionalities.
  • IBM-701 was the first commercial scientific computer produced by IBM. It was also known as a defense calculator.
  • PDP-11 is a 16-bit minicomputer belonging to the second generation of computers.
First-generation computers utilized vacuum tubes to perform simple arithmetic calculations. 
Second-generation computers made use of transistors and magnetic cores to achieve computational goals.

  • Input Device: Keyboard, Mouse, Scanner, Joystick, Microphone, Magnetic Ink Character Recognition (MICR), Optical Character Reader (OCR), TouchPad, Touch screen, Webcam
  • Output devices: Headphones, Monitor, Plotter, Printer, Projector, Speakers
CPUs (Central Processing Units) are typically composed of three main functional sections: Control Unit (CU), Arithmetic Logic Unit (ALU),Registers
Port numbers : By default, HTTP uses port 80 and HTTPS uses port 443.

Types of Protocols

  1. Transmission Control Protocol (TCP)
  2. Internet Protocol (IP)
  3. User Datagram Protocol (UDP)
  4. Post office Protocol (POP)
  5. Simple Mail Transfer Protocoll (SMTP)
  6. File Transfer Protocol (FTP)
  7. HyperText Transfer Protocol (HTTP)
SUPERCOMPUTER - Weather forecasting, nuclear research.
MINICOMPUTER - Used in manufacturing or research labs (historical use, now rare). 
MAINFRAME - Banking systems, Airline ticket
MICROCOMPUTER - Desktops, laptops

  • 1st Generation - Machine Language 
  • 2nd Generation - Assembly language 
  • 3rd Generation - High Level Language Ex- Fortran ( Formula Translator) , Cobal (Common Business Oriented Language)  , Basic,(Beginner's All Purpose Symbolic Instruction Code) C, C++
  • 4th Generation - Very high language - SQL
  • 5th Generation - AI, Python, Prolog, LISP
Banking System is based on EXTRANET
FINACLE software is used in banking system
Analog to Digital digital to analog conversion - Modem
What is the name of first ever created virus - Creeper
Data about Data is know as Meta data 
Mobile Phone is an example of which transmission - Full Duplex
Irctc is a n example of client server
Who is know as father of AI - John Mcarthy
Java is product of which company - Sunmicrosystem 
Common cloud-based services are-
Software-as-a-Service (SaaS), Infrastructure-as-a-Service (laaS), Platform-as-a-Service (PaaS).
.mh - Marshall Islands, .ml - Mali., .mm - Myanmar.
The name of the cryptocurrency released by social media site 'Facebook' is 'Libra' or 'Diem'. Calibra is a wallet through which the transaction of currency will be done. The project was announced on June 18, 2019. Facebook has changed its name to 'Meta'.
The type of network that allows a regional internet service provider to connect its customers to the internet is: -WAN
Big data is generally characterized by the three V's. What re the three V's-Volume, Variety, Velocity
Non-impact printers do not touch the paper during the print. They use chemical heat or electrical signals to imprint symbols on paper -Dot matrix
Ctrl + W - is a shortcut key most often used to close a document in Windows.
Which of the following options enables the computer hardware to communicate with the computer software? - Operating System
In excel, which button do you click to add up a series of numbers - Auto sum button ( Alt+=)
'e-KALPA' initiative of the Ministry of Human Resources, Government of India is a project on -Creating Digital-learning Environment for Design
The earliest calculating devices are; - Abacus
Which description is appropriate among the following for e-governance? -To provide technology driven governance
The view that displays the slides on a presentation as miniature representations of the slides is called Slide sorter view
In magnetic disks, the time taken by the read-write head to move to the specified track is known as seek time
In which of the following network topologies the communication between any two nodes is very fast? -Mesh
N2 is an illustration of a subscript.
Different Types of projector are:
DLP Projector
LCD Projector
LED Projector
CRT Projector
Which of the following LibreOffice Calc formula counts the number of cells in a string in the range A1 to A20 in a worksheet? -CountIF(A1:A20, "*")
In Linux, what sign is used to erase or kill an entire line you have typed and start you on a new line (but not display a new prompt) - @
In Linux, which of the following command can you execute to count the number of lines in a file? -Wc - 1
In MS-DOS, which command is used to see the sub- directory structure of drive - Tree
Which command lists the contents of the current directory of a disk - Dir
The IEEE standard specification for "WiFi" is -IEEE 802.11
SD RAM stands for - Synchronous Dynamic RAM
What is the full form of SSL in Network Security -Secure Sockets Layer
First computer was installed in India at: -Indian Statistical Institute, Kolkata
The < dl > tag defines the description list, the < dt > tag defines the term (name), and the < dd > tag describe each term. An unordered list starts with the < ul > tag.
Each list item starts with the < li > tag. An ordered list start with the < ol > tag.
The idea of "cloud computing" entails combining physical resources and making them available as what kind of resource virtual 
FAT stands for -File Allocation Table
Which social network is considered the most popular for business to business marketing? -LinkedIn
Examples of font faces include Arial, Times New Roman, Calibri, Verdana, etc.
Font style, on the other hand, refers to the variations of the font face that convey different attributes, such as weight, width, or angle. Common font styles include Regular, Italic, Bold, and Bold Italic.
Which among the following keyboard shortcuts open the properties for the selected item on a Windows 10 home screen -Alt + Enter
ASCII uses 7bits to code each character
Which of the following type's memory is volatile? -RAM
A CPU has 32 bit program counter. This means that the CPU can address -4GB memory locations
E-bay is an example of which of the following type of E-commerce? -C2C
How can you maintain a consistent look for tables, headers, footers, and other elements throughout your document in LibreOffice Writer? -Using Styles and Formatting
Software in computer -Increase the speed of Central Processing Unit
Charles Babbage - designed and developed the Difference engine?
Which of the following views of MS Word shows the text as it appears in printed format without the headers and footers? -Draft view
How do you create a nested IF function in LibreOffice Calc -IF(B2>10; "Greater"; IF(B2<5; "Less"; "Equal"))
full form of SMPS -Switched Mode Power Supply
Which of the following options refers to the layout arrangement of different devices in a network -Network topology
No outline is used to remove border of a shape in MS word -True
What is the protocol that is used for downloading a file from server -File Transfer Protocol (FTP)
Which of the following screen comes first after starting the Windows operating system -desktop
As per a recent announcement the Government of India will assist which of the following countries to develop and set up digital locker service -Mauritius
Which feature allows you to define different page styles, such as left and right pages or the first page of a chapter in LibreOffice Writer -Manual Break