Computer Mcqs | For PPSC & FPSC | Set-4

Which function is used to find the length of the string “PPSC” in Excel?

• A. Count()
• B. LEN(PPSC)
• C. Size(PPSC)
• D. Length(PPSC)

An analog computer works on the supply of which type of electrical signal?

• A. Discrete Electrical Pulses
• B. Continuous Electrical Pulses
• C. Binary Electrical Signals
• D. Alternating Digital Waves

How can you open MS Word using the Run dialog box?

• A. Msword.Exe
• B. Winword.Exe
• C. WordApp.Exe
• D. MicrosoftWord.Exe

How many positions can you set for Drop Cap in MS Word?

• A. 1 (Dropped Only)
• B. 2 (Dropped & In Margin)
• C. 3 (Dropped, In Margin, Floating)
• D. 4

What is the title page of a Microsoft Word document commonly called?

• A. Title Bar
• B. Header
• C. Cover Page
• D. Page Layout

Which feature in MS Excel keeps specific rows or columns visible while scrolling through the worksheet?

• A. Split Pane
• B. Freezing Pane
• C. Lock Sheet
• D. Protect View

When working with formulas in Excel, how can you see the intermediate results of a calculation before the final answer?

• A. Evaluate Formula tool
• B. Evaluation cannot be done in between the calculation
• C. Using Show Formulas option
• D. By editing the cell

Which key should you press while clicking to select multiple files or folders in Windows?

• A. Alt
• B. Ctrl
• C. Shift
• D. Tab

In MS Excel, what is a group of cells called?

• A. Cluster
• B. Range
• C. Table
• D. Matrix

What is a set of commands grouped together that can be executed automatically called?

• A. Scripts
• B. Macros
• C. Functions
• D. Modules

Which option in the File menu is used to close a file in MS Word?

• A. Exit
• B. Close
• C. Save
• D. Quit

By default, what is the page size of a new document in MS Word (in inches)?

• A. 7 x 9
• B. 8.5 x 11
• C. 6 x 8
• D. 10 x 12

What is the function of the keyboard shortcut “Ctrl + End” in MS Word?

• A. Moves the cursor to the beginning of the document
• B. Moves the cursor to the end of the document
• C. Deletes selected text
• D. Selects the entire document

In MS Word, the “Go To” feature is part of which function?

• A. Navigation Pane
• B. Replace
• C. Find
• D. Page Layout

What is located to the left of the horizontal scroll bar in MS Word?

• A. Status Bar
• B. View Buttons
• C. Zoom Slider
• D. Ruler

What is the maximum zoom percentage available in MS Word?

• A. 200%
• B. 300%
• C. 400%
• D. 500%

To view the left side of a page in MS Word, which scroll bar should be used?

• A. Vertical Scroll Bar
• B. Horizontal Scroll Bar
• C. Zoom Bar
• D. Status Bar

Which print command in MS Word allows you to view the entire document before printing?

• A. Print Setup
• B. Print Preview
• C. Page Layout
• D. Print All Pages

What is meant by the vertical separation between columns in a document?

• A. Padding
• B. Margin
• C. Indentation
• D. Alignment

What is the primary function of the Recycle Bin in Windows?

• A. Store Installed Programs
• B. Store Deleted Files
• C. Backup Important Data
• D. Manage System Cache

Which shortcut key is used to decrease the text font size in MS Word?

• A. Ctrl+Shift+>
• B. Ctrl+Shift+<
• C. Ctrl+[
• D. Ctrl+]

What happens when new data is entered into a memory location that already contains data?

• A. It merges the data
• B. It overwrites the previous content
• C. It deletes the location
• D. It moves old data elsewhere

In MS Word, Superscript, Subscript, and Strikethrough are known as?

• A. Text Effects
• B. Font Effects
• C. Style Options
• D. Layout Features

What is the default file extension of MS Excel workbooks?

• A. .Docx
• B. .Pptx
• C. .Xls
• D. .Txt

What is the temporary area where text and data are stored before pasting elsewhere?

• A. Taskbar
• B. Folder
• C. Clipboard
• D. Cache

In MS Excel, how are columns labeled?

• A. 1,2,3
• B. A, B, C
• C. I, II, III
• D. a, b, c

Which MS Office tool copies and pastes character and paragraph formatting to other text?

• A. Clipboard
• B. Format Painter
• C. Font Dialog
• D. Copy Style

What does IP stand for in computer networking?

• A. Internet Procedure
• B. Internet Protocol
• C. Internal Program
• D. Information Process

A program representing eight symbols is known as:

• A. Binary
• B. Octal
• C. Hexadecimal
• D. Decimal

The fifth generation of computers is primarily associated with:

• A. Vacuum Tubes
• B. Microprocessors
• C. Artificial Intelligence
• D. Integrated Circuits

Animation means:

• A. Still Pictures
• B. Accelerated Static Images
• C. Graphic Icons
• D. Interactive Slides

By default, how many worksheets are available in a new Excel workbook?

• A. 1
• B. 3
• C. 5
• D. Unlimited

Which option is used to permanently delete files without sending them to the Recycle Bin?

• A. Shift + Delete
• B. Permanent Delete
• C. Ctrl + Delete
• D. Empty Recycle Bin

In MS Word, what is the primary use of the ruler?

• A. To Draw Shapes
• B. To Set Tabs and Margins
• C. To Align Pictures
• D. To Add Columns

What is the shortcut key for inserting a hyperlink in MS Word?

• A. Ctrl + H
• B. Ctrl + K
• C. Ctrl + L
• D. Ctrl + J

Internet Explorer is a type of:

• A. Search Engine
• B. Web Browser
• C. Operating System
• D. Software Language

MS Office is an example of a:

• A. Vertical Market
• B. Horizontal Market
• C. Specialized Software
• D. Hardware Product

When applying conditional formatting in Excel, you can check conditions against:

• A. Chart Data
• B. Formula & Cell Value
• C. Cell Borders
• D. Page Layout

Which feature can be used to convert a Word document into a PDF file?

• A. Export As
• B. Save As
• C. Save Copy
• D. Send To

Which query type is used to find employees earning more than $5000 per month?

• A. Update Query
• B. Select Query
• C. Delete Query
• D. Crosstab Query

Tape speed is commonly measured in:

• A. Bytes Per Second
• B. Inches Per Second
• C. Bits Per Minute
• D. Cycles Per Second

What does HTTP stand for?

• A. Hypertext Transfer Program
• B. Hypertext Transfer Protocol
• C. Hyperlink Text Protocol
• D. High Transfer Process

Which computer component connects with the motherboard and supplies power to all parts?

• A. CPU
• B. Power Supply
• C. RAM
• D. BIOS

A collection of interrelated files in a computer is called a:

• A. Folder
• B. Database
• C. Record
• D. Table

Who developed the idea for the Universal Turing Machine, which became the basis for modern computing?

• A. Charles Babbage
• B. Alan Turing
• C. John von Neumann
• D. Bill Gates

Functional dependencies in a database are constraints based on:

• A. Schema
• B. Key
• C. Record
• D. Field

In MS Word, by default, on which page is the header or footer printed?

• A. Every Page
• B. First Page Only
• C. Last Page Only
• D. Odd Pages Only

Shortcut key for Page Break in MS Word is:

• A. Ctrl + Enter
• B. Ctrl + Shift + Enter
• C. Alt + Enter
• D. Shift + Enter

What does DMA stand for?

• A. Direct Memory Access
• B. Data Memory Allocation
• C. Dynamic Memory Adjustment
• D. Digital Memory Access

AND, OR, XOR, NOT, NAND, NOR are examples of which type of gates?

• A. Logic Gates
• B. Control Gates
• C. Memory Gates
• D. Switching Gates

Which shortcut key is used to center align the selected text in MS Word?

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

Which key on the keyboard can be used to view slide show in MS PowerPoint?

• A. F5
• B. F7
• C. F8
• D. F9

What displays the content of the active cell in Excel?

• A. Formula Bar
• B. Name Box
• C. Title Bar
• D. Menu Bar

A light-sensitive device that converts drawings or printed text into digital form is:

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

RAM is also known as:

• A. Read-Write Memory
• B. Read-Only Memory
• C. Cache Memory
• D. Flash Memory

RAM stands for:

• A. Random Access Memory
• B. Readable Access Memory
• C. Rapid Action Memory
• D. Run Access Memory

Name the type of mouse which uses laser technology to detect the motion of the ball:

• A. Optical Mouse
• B. Mechanical Mouse
• C. Trackball Mouse
• D. Wireless Mouse

What type of connection would be used to connect a printer directly to a network?

• A. Ethernet Cable
• B. USB Cable
• C. Parallel Port
• D. HDMI Cable

Which is the keyboard shortcut to increase font size in Microsoft Word?

• A. Ctrl + ]
• B. Ctrl + [
• C. Ctrl + Shift + F
• D. Ctrl + +

Which of the following stores data permanently in a computer?

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

B2:B6 in MS Excel represents the:

• A. Range of Cells
• B. Column
• C. Row
• D. Function

Which key is used to move from one cell to another in MS Excel?

• A. Tab
• B. Shift
• C. Ctrl
• D. Alt

ICT stands for:

• A. Information and Communication Technology
• B. International Computer Technology
• C. Interconnected Communication Transfer
• D. Integrated Computer Techniques

EBCDIC stands for:

• A. Extended Binary Coded Decimal Interchange Code
• B. Electronic Binary Coded Data Information Code
• C. Extended Bit Code Decimal Input Code
• D. Extra Binary Communication Data Interchange Code

What is meant by a dedicated computer?

• A. A computer assigned for one specific task
• B. A shared computer
• C. A portable computer
• D. A gaming computer

What is the Internet?

• A. Interconnection of wide area networks
• B. A single local network
• C. A government database
• D. A software application

Which shortcut key is used to open an existing file in MS Word?

• A. Ctrl + O
• B. Ctrl + N
• C. Ctrl + P
• D. Ctrl + E

Which key deletes a character to the left side of the cursor?

• A. Backspace
• B. Delete
• C. Shift
• D. Esc

What does BIOS stand for?

• A. Basic Input Output System
• B. Binary Integrated Operating System
• C. Base Internal Operating Software
• D. Basic Internal Output Signal

How many bytes are there in one kilobyte?

• A. 1024
• B. 1000
• C. 512
• D. 2048

In Excel, two or more cells can be combined using which feature?

• A. Merge Cells
• B. Combine Cells
• C. Link Cells
• D. Join Cells

In MS Word, authors or reviewers can add annotations as what?

• A. Comments
• B. Notes
• C. Footnotes
• D. Marks

Dot-Matrix is a type of which device?

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

Compared to secondary storage, primary storage is?

• A. Faster and more expensive
• B. Slower and cheaper
• C. Larger and cheaper
• D. External and slower

What does CAD stand for in computer applications?

• A. Computer Aided Design
• B. Central Access Database
• C. Computer Advanced Data
• D. Controlled Application Device

In PowerPoint, what are the dotted areas in an empty slide called?

• A. Placeholders
• B. Frames
• C. Layout Boxes
• D. Text Panels

In PowerPoint, which option allows advancing slides automatically or on click?

• A. Transition & On Mouse Click
• B. Animation Pane
• C. Slide Sorter
• D. Slide Master

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

• A. Boolean
• B. Character
• C. Symbolic
• D. Numeric Text

Which option is used to open your account in an online service?

• A. Log In
• B. Sign Out
• C. Register
• D. Exit

In Excel, which operator is used to combine text from two cells?

• A. Ampersand (&)
• B. Plus (+)
• C. Equal (=)
• D. Comma (,)

Which device is a circular storage medium used in computers?

• A. Disk
• B. Tape
• C. Card
• D. Chip

In a CPU, all hardware components are attached to which part?

• A. Motherboard
• B. Processor
• C. Power Supply
• D. Chipset

What does the Edit > Delete command do in MS Excel?

• A. Deletes selected cells
• B. Clears formatting only
• C. Deletes entire worksheet
• D. Removes formulas only

Which page orientation is set by default in MS Word?

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

What is a Gutter Margin in MS Word?

• A. Margin added to the binding side of a printed page
• B. Space between paragraphs
• C. Left margin of a document
• D. Top margin of a document

What does ClipArt refer to in MS Word documents?

• A. Pre-made images ready for use
• B. Custom drawing tool
• C. Chart template
• D. Page layout setting

How many text layout options are available by default in PowerPoint Slide Layout panel?

• A. Four
• B. Three
• C. Five
• D. Six

What is the main difference between memory and storage in computers?

• A. Memory is temporary, storage is permanent
• B. Memory is permanent, storage is temporary
• C. Both are permanent
• D. Both are temporary

What is the shortcut key to add a new slide in PowerPoint?

• A. Ctrl + M
• B. Ctrl + N
• C. Alt + S
• D. Shift + M

What is the World Wide Web?

• A. A collection of linked information on computers connected via the internet
• B. A type of social media platform
• C. A single website
• D. A local network

Which keyword is used in SQL to count the number of values in a column?

• A. COUNT
• B. SUM
• C. TOTAL
• D. AVERAGE

Which of the following is NOT a portable computer device?

• A. Desktop Computer
• B. Laptop
• C. Tablet
• D. Smartphone

What is the printed output from a computer called?

• A. Hardcopy
• B. Softcopy
• C. Print File
• D. Document Output

Which slide is used to introduce a topic and set the tone for a PowerPoint presentation?

• A. Title Slide
• B. Summary Slide
• C. Introduction Slide
• D. Main Slide

What is the primary purpose of an operating system?

• A. To make efficient use of computer hardware
• B. To process user input only
• C. To display graphics
• D. To perform calculations

Which type of computer memory retains information even after power is removed?

• A. Non-Volatile Memory
• B. Volatile Memory
• C. RAM
• D. Cache

What was the name of the first computer network?

• A. ARPANET
• B. Internet
• C. Intranet
• D. World Wide Web

Unsystematic risk in finance is also known as what?

• A. Specific Risk
• B. Systematic Risk
• C. Market Risk
• D. Political Risk

What is the shortcut key for a manual line break in MS Word?

• A. Shift + Enter
• B. Ctrl + Enter
• C. Alt + Enter
• D. Ctrl + Shift + Enter

In MS Word, what does “5*2” represent when inserting a table?

• A. 5 rows and 2 columns
• B. 2 rows and 5 columns
• C. 5 pages and 2 columns
• D. 5 tables of 2 rows each

What happens if you select the first and second slides and then click “New Slide” in PowerPoint?

• A. A new slide is inserted as the third slide
• B. A duplicate of the first slide is created
• C. The slides are deleted
• D. The presentation restarts

Where is the RAM located in a computer system?

• A. Motherboard
• B. Hard Drive
• C. CPU
• D. ROM Chip

Which of the following is NOT an element of a computer spreadsheet interface?

• A. Pencil Work
• B. Cell
• C. Column
• D. Formula Bar

Which of the following represents an absolute cell reference in Excel?

• A. $A$1
• B. A1
• C. A$1
• D. $A1

Which shortcut key is used to select the entire document in MS Word?

• A. Ctrl + A
• B. Ctrl + S
• C. Ctrl + E
• D. Ctrl + C

Which technology is used in Compact Disks (CDs) to store data?

• A. Laser Technology
• B. Magnetic Disk
• C. Electrical Pulse
• D. Optical Film

WWW stands for?

• A. World Wide Web
• B. World Web Wide
• C. Web World Wide
• D. Wide Web World

Ctrl + 5 is used to add line spacing to how many points?

• A. 1.5
• B. 2.0
• C. 1.0
• D. 2.5

What does the AutoSum feature in Excel do?

• A. Automatically adds a range of cell values
• B. Finds the maximum value
• C. Calculates average
• D. Counts text entries

Which of the following is NOT a paper size?

• A. Landscape
• B. A4
• C. Letter
• D. Legal

The accuracy of floating-point numbers representable in two 16-bit words of a computer is approximately?

• A. 6 digits
• B. 8 digits
• C. 10 digits
• D. 4 digits

Which type of table constraint prevents the entry of duplicate rows in a database?

• A. Primary Key
• B. Foreign Key
• C. Check Constraint
• D. Unique Index

From which menu in Excel can you set the date format as YYYY/MM/DD?

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

Which of the following is NOT a characteristic of a computer?

• A. Intelligence
• B. Accuracy
• C. Speed
• D. Automation

Who is known as the father of the Internet?

• A. Vint Cerf
• B. Tim Berners-Lee
• C. Charles Babbage
• D. Steve Jobs

MS Excel is primarily used for what purpose?

• A. To organize and analyze data
• B. To edit videos
• C. To design websites
• D. To send emails

Which of the following is an output device?

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

The graph used to show data on a nominal scale is called?

• A. Pie Graph
• B. Line Graph
• C. Scatter Plot
• D. Histogram

What is the function of the F4 key in a spreadsheet?

• A. Repeat the last action
• B. Open Find and Replace
• C. Insert a function
• D. Create a chart

HTTP stands for?

• A. Hypertext Transfer Protocol
• B. Hyperlink Transfer Process
• C. High Transfer Protocol
• D. Hyper Text Processing

MB stands for?

• A. Megabyte
• B. Microbit
• C. Memory Byte
• D. Main Block

Which command is used to add data in MS Excel?

• A. SUM
• B. ADD
• C. INSERT
• D. COUNT

What is the shortcut key for inserting a page break in MS Word?

• A. Ctrl + Enter
• B. Ctrl + Shift + Enter
• C. Alt + Enter
• D. Shift + Enter

What was the first computer network that initiated the Internet?

• A. ARPANET
• B. NSFNET
• C. BITNET
• D. ICANN

Which type of chart is best used for categorical data in Excel?

• A. Vertical Bar Chart
• B. Line Chart
• C. Pie Chart
• D. Area Chart

Which programming language is primarily used to create web pages?

• A. HTML
• B. C++
• C. Python
• D. Java

Which is the largest hardware company in the world?

• A. Apple
• B. Dell
• C. HP
• D. Lenovo

Which tab in MS Word contains the Shapes option?

• A. Insert
• B. Design
• C. Layout
• D. View

What is the shortcut key to apply subscript to selected text in MS Word?

• A. Ctrl + =
• B. Ctrl + Shift + =
• C. Ctrl + Shift + +
• D. Alt + =

Which shortcut key is used for Undo in MS Word?

• A. Ctrl + Z
• B. Ctrl + Y
• C. Ctrl + X
• D. Ctrl + U

What is the shortcut key to decrease font size in MS Word?

• A. Ctrl + Shift + <
• B. Ctrl + [
• C. Ctrl + –
• D. Alt + <

Which is an example of a formula in MS Excel?

• A. =A1+A2
• B. SUM(A1:A2)
• C. A1+A2
• D. @A1+A2