Computer Mcqs | For PPSC & FPSC | Set-2

To add two cells (A1 and A2) together in MS Excel, which formula is used?

• A. =A1+A2
• B. =SUM(A1+A2)
• C. =A1A2
• D. =ADD(A1,A2)

Which one is the spreadsheet application that comes with the MS Office software group?

• A. MS Excel
• B. MS Word
• C. MS Access
• D. MS PowerPoint

Microsoft Excel function arguments are always written in:

• A. Parentheses ()
• B. Brackets []
• C. Curly Braces {}
• D. Quotes “”

What is the shortcut key to mark a citation in MS Word?

• A. Alt + Shift + I
• B. Ctrl + Shift + I
• C. Alt + Ctrl + I
• D. Shift + F9

Which of the following is not an essential component to perform a Mail Merge operation?

• A. Word Fields
• B. Main Document
• C. Data Source
• D. Merge Fields

Which menu or group is used if you want to change the typeface of selected text?

• A. Format Menu
• B. Insert Menu
• C. View Menu
• D. Layout Menu

In MS Excel, the command used to combine/merge the consecutively selected cells and center align the content is:

• A. Merge & Center
• B. Wrap Text
• C. Align Center
• D. Merge Across

In MS Excel, which function returns one value if a condition is true and another value if it’s false?

• A. IF Function
• B. SUM Function
• C. OR Function
• D. AND Function

The cell referencing that does not change when copied is called:

• A. Absolute Reference
• B. Relative Reference
• C. Mixed Reference
• D. Fixed Formula

Which of the following functions is used to get the current date in MS Excel?

• A. TODAY()
• B. DATE()
• C. NOW()
• D. TIME()

Which of the following is not a valid data type in MS Access?

• A. Picture
• B. Text
• C. Number
• D. Currency

To restore the last undone action, which option is used?

• A. Redo
• B. Undo
• C. Repeat
• D. Restore

The processed output given by a computer is also called:

• A. Information
• B. Data
• C. Program
• D. Command

In MS Excel, what should be added before a fraction to prevent it from being treated as a date?

• A. Space
• B. Apostrophe
• C. Hyphen
• D. Equal Sign

The shortcut key to insert a new worksheet in MS Excel is:

• A. Shift + F11
• B. Ctrl + N
• C. Alt + F11
• D. Shift + F12

Which key combination is used in MS Excel to insert the current time?

• A. Ctrl + Shift + ;
• B. Ctrl + :
• C. Alt + T
• D. Shift + Ctrl + T

Which key is used for moving one screen down in MS Word?

• A. Page Down Key
• B. Ctrl + Down Arrow
• C. Shift + Down
• D. End

Microprocessor is the ______ of the computer and performs all the computational tasks.

• A. Heart
• B. Brain
• C. Mind
• D. Unit

MS Word offers how many different views of a document?

• A. 5
• B. 3
• C. 4
• D. 6

Which type of memory holds the computer startup routine?

• A. ROM
• B. RAM
• C. Cache
• D. Flash

Whose work laid the foundation for building computers and encryption in the 20th century?

• A. Al-Khwarizmi
• B. Alan Turing
• C. Charles Babbage
• D. Ada Lovelace

Which of the following holds data and processing instructions temporarily until the CPU needs it?

• A. Main Memory
• B. Hard Disk
• C. CD-ROM
• D. Cache

A computer program that translates one program instruction at a time into machine language is called a/an:

• A. Interpreter
• B. Compiler
• C. Assembler
• D. Decoder

If you press ______, the cell accepts your typing as its contents in MS Excel.

• A. Enter
• B. Tab
• C. Esc
• D. Shift

The common name for the crime of stealing passwords is:

• A. Spoofing
• B. Phishing
• C. Hacking
• D. Cracking

Another term for main memory is:

• A. RAM
• B. ROM
• C. Cache
• D. Register

A wireless technology built into electronic gadgets used for exchanging data over short distances is:

• A. Bluetooth
• B. Wi-Fi
• C. NFC
• D. Infrared

Which shortcut key is used for justifying the text in a Microsoft Word document?

• A. Ctrl + J
• B. Ctrl + E
• C. Ctrl + L
• D. Ctrl + R

WAN stands for:

• A. Wide Area Network
• B. Web Access Network
• C. Wide Access Node
• D. Wireless Area Network

MS Word is an example of which type of software?

• A. Application software
• B. System software
• C. Utility software
• D. Firmware

Which key is used to move to the beginning of a line of text in MS Word?

• A. Home key
• B. End key
• C. Page Up
• D. Ctrl + Left Arrow

Which function key is used to refresh a webpage in most browsers?

• A. F5
• B. F2
• C. F3
• D. F7

Which of the following is a shortcut to ‘Save As’ in MS Word?

• A. F12
• B. Ctrl + S
• C. Shift + S
• D. Alt + S

Which computer generation used vacuum tubes?

• A. First generation
• B. Second generation
• C. Third generation
• D. Fourth generation

The basic unit of a worksheet into which you enter data in Excel is called a:

• A. Cell
• B. Row
• C. Column
• D. Sheet

From which menu can you access Picture, Text Box, and Chart options in MS Word?

• A. Insert
• B. View
• C. Format
• D. Tools

No computer can do anything without a:

• A. Program
• B. Mouse
• C. Printer
• D. Monitor

Which protocol provides an e-mail facility among different hosts?

• A. SMTP
• B. HTTP
• C. FTP
• D. POP

What is used to identify a user who returns to a website?

• A. Cookies
• B. History
• C. Cache
• D. IP Address

Which one of the following converts printed documents into digital images?

• A. Scanner
• B. Printer
• C. Monitor
• D. Keyboard

Binary codes are in the form of:

• A. 0 & 1
• B. 1 & 2
• C. A & B
• D. True & False

Which key is used for renaming a file or folder?

• A. F2
• B. F5
• C. F6
• D. Ctrl + R

What is defined by the Handout Master in MS PowerPoint?

• A. Layout of handout
• B. Slide Design
• C. Animation Order
• D. Transition Style

Which of the following controls the process of interaction between the user and the operating system?

• A. User Interface
• B. System Bus
• C. Command Processor
• D. Kernel

Any data or instruction entered into the memory of a computer is considered as:

• A. Input
• B. Output
• C. Processing
• D. Storage

What should be done after fixing a problem or installing a new application or making configuration changes in a computer?

• A. Restart
• B. Shutdown
• C. Refresh
• D. Reset

Circular divisions of a disk used to store and retrieve data are known as:

• A. Track
• B. Sector
• C. Block
• D. Cluster

Which of the following is the file extension of the PowerPoint application?

• A. .ppt
• B. .doc
• C. .xls
• D. .mdb

Which of the following shortcut keys is used to close a tab on a browser?

• A. Ctrl + W
• B. Ctrl + Q
• C. Ctrl + T
• D. Ctrl + Tab

In which of the following storage devices data is stored permanently?

• A. Hard Disk
• B. RAM
• C. Cache
• D. Register

Which of the following is the smallest unit of information that a computer can process?

• A. Bit
• B. Byte
• C. Nibble
• D. Word

The process of copying software from secondary storage to the hard disk is called:

• A. Installation
• B. Execution
• C. Uploading
• D. Compilation

Which of the following keys is used to refresh the content on a computer screen?

• A. F5
• B. F1
• C. F2
• D. F8

In MS Excel, the formula used to perform calculations in the worksheet can be inserted with the help of:

• A. Insert Formula Icon
• B. AutoCorrect Option
• C. Data Validation
• D. Review Tab

Where is a list of all functions displayed in MS Excel?

• A. Function Box
• B. Ribbon Bar
• C. Title Bar
• D. Name Box

Main window in a computer spreadsheet is called:

• A. Workbook
• B. Worksheet
• C. Spreadsheet
• D. File Window

In MS Excel, two common wildcard characters recognized are:

• A. * (Asterisk) and ? (Question Mark)
• B. + and –
• C. ^ and %
• D. & and @

The process of verifying the identity of a user is termed as:

• A. Authentication
• B. Verification
• C. Validation
• D. Encryption

PIN stands for:

• A. Personal Identification Number
• B. Private Information Network
• C. Personal Internet Name
• D. Public Identification Number

For hearing and playing sound, which device is required?

• A. Sound Card and Speakers
• B. Microphone
• C. Modem
• D. Monitor

Which command is used to generate a series of data directly from the values of the selected cells in Excel?

• A. Fill
• B. AutoSum
• C. Copy
• D. Merge

By default, the orientation of a document when printing is:

• A. Portrait
• B. Landscape
• C. Horizontal
• D. Vertical

The most commonly used type of software in industry, offices and WAN is:

• A. Horizontal Market Software
• B. Vertical Market Software
• C. Custom Software
• D. Firmware

After creating a table in a database, which of the following is correct?

• A. Fields can be added and deleted as needed
• B. Fields cannot be changed
• C. Only data can be added
• D. Structure remains fixed

Ctrl + S is used to:

• A. Save the document with the same name
• B. Save As a new document
• C. Open document
• D. Close document