Umar Draz, Author at DocMCQs

FPSC Information Technology Test 1

Total Questions: 30

Total Marks: 30

Total Time: 22 min 30 sec

22:30

Student Information

Name:

Email:

Questions

Q1: Shortcut to select entire document or worksheet:

Ctrl + A Ctrl + S Ctrl + E Ctrl + W

Q2: GIGO stands for:

Great Input Great Output Garbage In Garbage Out Gigabyte Input Gigabyte Output General Input Output

Q3: Mail Merge in Word allows you to:

Send email Combine document with data source Merge two documents Attach file to email

Q4: Feature that creates presentation by answering questions:

Template Design Ideas AutoContent Wizard SmartArt

Q5: Excel function for loan payment calculation:

PMT FV PV RATE

Q6: Purpose of BIOS stored in ROM:

Perform calculations Manage internet connections Run POST and boot computer Store user files

Q7: Shortcut to apply/remove strikethrough:

Ctrl + 5 Ctrl + 4 Ctrl + 2 Ctrl + 1

Q8: Number of rows in Excel 2007+:

65,536 1,048,576 16,384 99,999

Q9: Which function finds current date?

TIME DATE TODAY() NOW()

Q10: Columns in Excel are labeled with:

Numbers Letters Symbols Both letters and numbers

Q11: The small green square used to copy formulas to adjacent cells is the:

Copy handle Fill Handle Drag handle Insert handle

Q12: The individual effects applied to text or objects on a slide are called:

Transitions Animations Schemes Presets

Q13: By default, slides in a PowerPoint presentation are oriented in which layout?

Portrait Landscape Thumbnail Wide

Q14: Pressing Shift + F5 in PowerPoint will:

Save the presentation Start slideshow from current slide Print the presentation Close the presentation

Q15: The "Slide Master" is found under which tab?

Home Insert Design View

Q16: What is the maximum zoom percentage allowed in MS PowerPoint?

200% 300% 400% 500%

Q17: Which feature controls the visual effects that appear when you move from one slide to the next?

Animations Transitions Slide Master Custom Shows

Q18: The feature that places text slightly above the normal line (e.g., in X²) is called:

Subscript Superscript Strikethrough Small Caps

Q19: The smallest unit of data in a computer is:

Byte Nibble Bit Word

Q20: Which port is commonly used to connect a mouse, keyboard, and printer?

HDMI VGA USB Ethernet

Q21: The process of starting or restarting a computer system is called:

Booting Loading Formatting Processing

Q22: A computer that is designed to be used by one person at a time, like a PC, is classified as a:

Mainframe Supercomputer Microcomputer Minicomputer

Q23: Which device is used to connect a computer to a telephone line for dial-up internet access?

Router Modem Switch Repeater

Q24: The small, high-speed memory located inside the CPU is called:

Registers Hard Disk RAM ROM

Q25: A user complains that their computer takes too long to boot and applications load slowly. Which component upgrade would provide the most noticeable improvement?

Larger monitor Faster processor Replacing HDD with SSD Adding more USB ports

Q26: A technician replaces a computer's 4 GB RAM with 8 GB RAM. What is the primary benefit of this upgrade?

Faster processor speed More programs can run simultaneously Larger files can be stored permanently Faster internet browsing

Q27: Which unit is used to measure the clock speed of a CPU?

Bytes Gigahertz (GHz) Megapixels DPI

Q28: If a computer has 8 GB of RAM and uses virtual memory, where is the data stored when the RAM becomes completely full?

CPU registers Cache memory Hard disk or SSD ROM BIOS

Q29: Which statement best explains why SRAM is used for cache memory while DRAM is used for main memory?

SRAM is slower but cheaper than DRAM SRAM does not require constant refreshing, making it faster but more expensive DRAM retains data even when power is off SRAM has higher storage density than DRAM

Q30: A computer architect is designing a new processor and wants to minimize the time taken to access frequently used instructions and data. Which memory hierarchy component should she focus on optimizing for the greatest impact on CPU performance?

Hard Disk Drive capacity RAM clock speed Cache memory hit rate Virtual memory page file size

Which function finds current date?

A. TIME

B. DATE

C. TODAY()

D. NOW()

Correct answer is: C. TODAY()

Function to look up value in first column of a table:

A. HLOOKUP

B. LOOKUP

C. VLOOKUP

D. FIND

Correct answer is: C. VLOOKUP

Number of columns in Excel 2007+:

A. 256

B. 65,536

C. 16,384

D. 1,048,576

Correct answer is: C. 16,384

Number of rows in Excel 2007+:

A. 65,536

B. 1,048,576

C. 16,384

D. 99,999

Correct answer is: B. 1,048,576

Which of the following is a valid mixed cell reference?

A. $A$1

B. A1

C. $A1

D. All of the above

Correct answer is: D. All of the above

Feature that fills cells automatically based on pattern:

A. AutoComplete

B. AutoFill

C. AutoCorrect

D. Flash Fill

Correct answer is: B. AutoFill

Shortcut to apply/remove strikethrough:

A. Ctrl + 5

B. Ctrl + 4

C. Ctrl + 2

D. Ctrl + 1

Correct answer is: A. Ctrl + 5

A chart on a separate sheet is called:

A. Embedded Chart

B. Chart Sheet

C. Graph Sheet

D. Pivot Chart

Correct answer is: B. Chart Sheet

Function returning number of characters in text:

A. COUNT

B. LEN

C. MID

D. CHAR

Correct answer is: B. LEN

Author name: Umar Draz

FPSC Information Technology Test 1

Student Information

Questions