I85PREP
⌘ K
Assam ASSEB Higher Secondary Skill Subject IT/ITeS study materials
Assam ASSEB Higher Secondary Skill Subject IT/ITeS study resources

Assam ASSEB Higher Secondary Skill Subject IT/ITeS practice questions

One question at a time. Build your Assam ASSEB Higher Secondary Skill Subject IT/ITeS understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1IT/ITeS Fundamentals and Digital Literacy

In an IT/ITeS workplace, which unit is used to express the clock speed of a computer processor?

  1. Gigabyte (GB)
  2. Kilobit per second (kbps)
  3. Megapixel (MP)
  4. Gigahertz (GHz) Correct answer.

Explanation

Clock speed measures how many cycles a processor completes each second, and one gigahertz equals one billion cycles per second. Storage capacity is measured in bytes, camera resolution in megapixels, and network throughput in bits per second, so those units describe different quantities.

Question 2IT/ITeS Fundamentals and Digital Literacy

A data-entry operator wants to copy the same formatting from one spreadsheet cell to several other cells in a spreadsheet application. Which tool is designed for this task?

  1. Format Painter Correct answer.
  2. Spell Check
  3. Mail Merge
  4. Freeze Panes

Explanation

Format Painter captures the formatting attributes of a selected cell and applies them to other cells with a single click or drag. It copies appearance such as font, colour and borders without copying the underlying value or formula.

Question 3IT/ITeS Fundamentals and Digital Literacy

Which statement correctly describes the purpose of a strong password in an IT/ITeS work environment?

  1. It reduces the chance that an attacker can guess or brute-force the credentials. Correct answer.
  2. It removes the need for any other security control on the account.
  3. It guarantees that no malware can ever reach the workstation.
  4. It encrypts all files stored on the local hard disk automatically.

Explanation

A strong password increases the search space an attacker must cover, making guessing and brute-force attacks impractical. Password strength is one layer of defence and does not by itself block malware, replace other controls, or encrypt stored files.

Question 4IT/ITeS Fundamentals and Digital Literacy

In a word-processing document, what is the main effect of inserting a page break?

  1. It permanently deletes all text after the cursor position.
  2. It forces the following content to begin at the top of a new page. Correct answer.
  3. It applies bold formatting to the next paragraph.
  4. It converts the document into a read-only PDF file.

Explanation

A page break is a manual instruction telling the word processor to end the current page and continue on the next one. It is used to control layout, for example before a new chapter or section heading, and it does not alter the text itself.

Question 5IT/ITeS Fundamentals and Digital Literacy

A customer-support executive in a BPO centre needs to send the same standard reply to many customers while personalising each with the recipient's name. Which feature of a word processor is most appropriate?

  1. Mail Merge Correct answer.
  2. Track Changes
  3. AutoCorrect
  4. Thesaurus

Explanation

Mail Merge links a main document template to a data source such as a spreadsheet of customer names and addresses, producing one personalised copy per record. This is the standard approach when a common template must be reused across many recipients.

Question 6IT/ITeS Fundamentals and Digital Literacy

In a spreadsheet, cells A1, A2 and A3 contain 10, 20 and 30 respectively. What value is returned by the formula =SUM(A1:A3)*2?

  1. 30
  2. 90
  3. 120 Correct answer.
  4. 60

Explanation

The SUM function adds the values in the range A1:A3, giving 10 + 20 + 30 = 60. The multiplication operator is then applied to the result, so 60 × 2 = 120, which is the value stored in the cell.

Question 7IT/ITeS Fundamentals and Digital Literacy

Which internet protocol is responsible for reliably delivering data segments, retransmitting lost packets and preserving their order between two hosts?

  1. ICMP
  2. UDP
  3. ARP
  4. TCP Correct answer.

Explanation

Transmission Control Protocol establishes a connection and uses acknowledgements, sequencing and retransmission so that data arrives complete and in order. Protocols such as UDP send datagrams without these guarantees and are used where speed matters more than reliability.

Question 8IT/ITeS Fundamentals and Digital Literacy

An IT/ITeS technician is asked to identify the private IPv4 address range reserved for use inside local networks only. Which range is correct?

  1. 1.0.0.0 to 1.255.255.255
  2. 224.0.0.0 to 239.255.255.255
  3. 8.8.8.0 to 8.8.8.255
  4. 192.168.0.0 to 192.168.255.255 Correct answer.

Explanation

The block 192.168.0.0/16 is one of the three private IPv4 ranges defined for internal addressing, alongside 10.0.0.0/8 and 172.16.0.0/12. Addresses in these ranges are not routed on the public internet and are translated by NAT at the network edge.

Question 9IT/ITeS Fundamentals and Digital Literacy

A user reports that a website is unreachable, but the same site opens normally from another machine on the same office network. Which step is the most sensible first diagnostic action on the affected machine?

  1. Reinstall the operating system on the affected machine.
  2. Ping a known public address to test basic connectivity from that machine. Correct answer.
  3. Reset the website's domain registration with the registrar.
  4. Replace the office network switch immediately.

Explanation

Because other machines reach the site, the fault is likely local to the affected machine, so testing basic connectivity with ping isolates whether the problem is network reachability or application-level. This follows the principle of starting with the simplest, least disruptive diagnostic test.

Question 10IT/ITeS Fundamentals and Digital Literacy

Which file extension typically identifies a compressed archive that a user must extract before accessing the documents inside?

  1. .docx
  2. .html
  3. .exe
  4. .zip Correct answer.

Explanation

A .zip file is an archive container that holds one or more compressed files, and extraction restores the original documents. The other extensions denote a word-processing document, an executable program and a web page respectively.

Question 11IT/ITeS Fundamentals and Digital Literacy

In a database table of customer records, which field is the best choice for the primary key?

  1. The customer's full name
  2. The customer's city of residence
  3. A system-generated customer ID that is unique and never reused Correct answer.
  4. The date on which the customer first contacted the company

Explanation

A primary key must uniquely identify each row and must not be null, so a system-generated identifier that is guaranteed unique and stable is the safest choice. Natural attributes such as names, cities or dates can repeat or change and therefore cannot reliably serve as the key.

Question 12IT/ITeS Fundamentals and Digital Literacy

An employee receives an email claiming to be from the bank and asking them to click a link and re-enter their net-banking password urgently. Which term best describes this attempt?

  1. Defragmentation
  2. Phishing Correct answer.
  3. Load balancing
  4. Version control

Explanation

Phishing is a social-engineering attack that impersonates a trusted entity and creates urgency to trick a user into revealing credentials or clicking a malicious link. Defragmentation, load balancing and version control are unrelated technical processes.

Question 13IT/ITeS Fundamentals and Digital Literacy

A company wants its IT/ITeS staff to follow a documented rule that customer data must not be copied to personal pen drives. Which type of policy document should contain this rule?

  1. An acceptable use and data handling policy Correct answer.
  2. A network switch configuration manual
  3. A hardware warranty certificate
  4. A software licence agreement for a spreadsheet product

Explanation

Acceptable use and data handling policies define what employees may and may not do with organisational systems and information, including restrictions on removable media. The other documents are vendor or technical artefacts that do not govern employee behaviour.

Question 14IT/ITeS Fundamentals and Digital Literacy

Which practice best protects the confidentiality of a customer's personal data while it is being transmitted over the internet?

  1. Sending the data as an uncompressed plain-text file
  2. Storing the data in a shared folder with full read access for everyone
  3. Using HTTPS so that traffic is encrypted with TLS Correct answer.
  4. Printing the data and keeping the paper copy on the desk

Explanation

HTTPS wraps HTTP traffic in TLS, which encrypts the data in transit so that intermediaries cannot read it. Plain-text transfer, open shared folders and unattended printed copies all expose the information to unauthorised access.

Question 15IT/ITeS Fundamentals and Digital Literacy

In a spreadsheet, what is the difference between a relative cell reference such as B2 and an absolute reference such as $B$2 when a formula is copied to another cell?

  1. Both references always change to point to the first row of the sheet.
  2. The absolute reference adjusts to the new position, while the relative reference stays fixed.
  3. Both references always remain fixed regardless of where the formula is copied.
  4. The relative reference adjusts to the new position, while the absolute reference stays fixed. Correct answer.

Explanation

Relative references are stored as offsets from the formula cell, so copying the formula shifts them by the same number of rows and columns. The dollar signs in an absolute reference lock the column and row, so the reference continues to point at the same cell.

Question 16IT/ITeS Fundamentals and Digital Literacy

A user needs to present a set of slides with transitions and speaker notes at a client meeting. Which type of application is designed for this purpose?

  1. Antivirus utility
  2. Presentation software Correct answer.
  3. Database management system
  4. Spreadsheet application

Explanation

Presentation software is built for creating slide decks with visual layouts, transitions and speaker notes for live delivery. Spreadsheets handle numerical analysis, database systems manage structured records, and antivirus utilities protect against malicious software.

Question 17IT/ITeS Fundamentals and Digital Literacy

An IT/ITeS team is designing a backup plan for a client's records. Which combination best protects against both accidental file deletion and a complete disk failure?

  1. Copying files to another folder on the same disk each evening
  2. A single full backup taken once when the system was first installed
  3. Keeping all data only on the workstation's internal hard disk
  4. Regular incremental backups to a separate location plus periodic full backups kept off-site Correct answer.

Explanation

A sound backup strategy combines frequent incremental copies with periodic full backups stored separately from the original system, so recovery is possible after either deletion or hardware loss. Backups kept on the same disk or taken only once do not survive disk failure or later changes.

Question 18IT/ITeS Fundamentals and Digital Literacy

Which statement best explains why an IT/ITeS organisation separates duties between the person who approves a payment and the person who enters it into the accounting system?

  1. It increases the clock speed of the accounting workstations.
  2. It reduces the electricity consumed by the accounting servers.
  3. It allows the accounting system to run without any user accounts.
  4. It prevents one individual from both creating and approving a fraudulent transaction. Correct answer.

Explanation

Separation of duties is an internal control that requires two people to complete a sensitive action, so fraud or error by one person is likely to be detected by the other. It is a governance control and has no effect on power consumption, user accounts or hardware performance.

Question 19IT/ITeS Fundamentals and Digital Literacy

A spreadsheet cell displays ##### instead of a number. Which cause is most consistent with this behaviour?

  1. The formula contains a division by zero.
  2. The workbook has been saved in read-only mode.
  3. The column is too narrow to display the formatted value. Correct answer.
  4. The cell reference points to an empty cell.

Explanation

Spreadsheet applications show a row of hash marks when a numeric or date value is wider than the current column width, and widening the column reveals the value. Error values such as #DIV/0! appear when a formula itself cannot be evaluated, which is a different symptom.

Question 20IT/ITeS Fundamentals and Digital Literacy

Which statement correctly distinguishes system software from application software in an IT/ITeS environment?

  1. Application software manages hardware devices, while system software edits documents.
  2. Both categories are identical because every program is installed on the same disk.
  3. System software is any program that a user opens from the desktop shortcut.
  4. System software manages hardware and provides a platform on which application software runs. Correct answer.

Explanation

System software, including the operating system and device drivers, controls hardware resources and offers services that other programs depend on. Application software such as word processors or billing systems performs tasks for the end user on top of that platform.

Question 21Computer Hardware, Operating Systems and Peripherals

Which type of computer memory is described as volatile, meaning its stored contents are lost when the power is switched off?

  1. RAM Correct answer.
  2. Hard disk drive
  3. ROM
  4. Flash drive

Explanation

Volatile memory loses its data when electrical power is removed, and RAM is the classic example used as the main working memory of a computer. ROM, hard disks and flash drives all retain their contents without power, so they are non-volatile.

Question 22Computer Hardware, Operating Systems and Peripherals

A technician needs to connect a modern monitor that carries both video and audio over a single cable. Which port should be chosen?

  1. RJ-45
  2. HDMI Correct answer.
  3. PS/2
  4. VGA

Explanation

HDMI carries digital video and digital audio together over one cable, which is why it is standard on modern monitors and TVs. VGA carries analogue video only, PS/2 is for legacy keyboards and mice, and RJ-45 is an Ethernet networking connector.

Question 23Computer Hardware, Operating Systems and Peripherals

Which component on the motherboard is responsible for holding the CPU and providing the electrical interface between the processor and the rest of the board?

  1. SATA header
  2. PCIe slot
  3. DIMM slot
  4. CPU socket Correct answer.

Explanation

The CPU socket is the mechanical and electrical receptacle that seats the processor and links it to the chipset and memory buses. DIMM slots hold memory modules, PCIe slots take expansion cards, and SATA headers connect storage drives.

Question 24Computer Hardware, Operating Systems and Peripherals

In a Windows file system, a user creates a shortcut to a document. Which statement best describes what the shortcut file contains?

  1. A backup that restores the file after deletion
  2. A pointer that records the location of the original file Correct answer.
  3. A full duplicate copy of the document data
  4. A compressed archive of the original file

Explanation

A shortcut is a small link file that stores the path to the target, so opening it launches the original rather than a copy. Deleting the shortcut therefore leaves the target file untouched, and editing the target is reflected when the shortcut is used.

Question 25Computer Hardware, Operating Systems and Peripherals

Which of the following is an example of an output peripheral in a typical IT lab setup?

  1. Laser printer Correct answer.
  2. Microphone
  3. Barcode scanner
  4. Graphics tablet

Explanation

A printer takes data from the computer and produces a physical result, which makes it an output device. Scanners, tablets and microphones all convert real-world input into digital data for the computer.

Question 26Computer Hardware, Operating Systems and Peripherals

Which file system is the default choice for formatting a large external hard disk that must be readable on both Windows and macOS without extra drivers?

  1. APFS
  2. NTFS
  3. ext4
  4. exFAT Correct answer.

Explanation

exFAT is designed for removable media and is natively readable and writable by both Windows and macOS, without the 4 GB per-file limit of FAT32. NTFS is read-only on macOS by default, ext4 is a Linux file system, and APFS is Apple's native file system.

Question 27Computer Hardware, Operating Systems and Peripherals

A desktop powers on, the fans spin, but nothing appears on the monitor and the motherboard emits a repeating beep pattern. What is the most appropriate first diagnostic step?

  1. Replace the monitor with a new unit
  2. Replace the power supply unit immediately
  3. Reinstall the operating system from a USB drive
  4. Reseat the RAM modules and check the POST beep code Correct answer.

Explanation

Beep patterns during power-on self-test usually indicate a hardware fault, and faulty or loose memory is one of the most common causes. Consulting the motherboard manual for the specific beep code and reseating the RAM is a low-cost, reversible first step before replacing parts.

Question 28Computer Hardware, Operating Systems and Peripherals

Which characteristic distinguishes an SSD from a conventional hard disk drive when used as a system drive?

  1. It requires a SATA power connector to operate
  2. It has no moving parts and offers faster random access Correct answer.
  3. It stores data only while the computer is powered on
  4. It stores data on spinning magnetic platters

Explanation

An SSD uses flash memory cells with no moving mechanical parts, which gives very low latency for random reads and writes compared with the seek time of a spinning platter. Both drive types are non-volatile and both may use SATA, so those points do not separate them.

Question 29Computer Hardware, Operating Systems and Peripherals

A user reports that a USB keyboard works in the BIOS setup but not inside the installed operating system. Which layer should be investigated first?

  1. The operating system's USB and HID device drivers Correct answer.
  2. The monitor's refresh rate setting
  3. The hard disk's partition table
  4. The keyboard's physical key switches

Explanation

The BIOS works without operating system drivers, so a keyboard that functions there proves the hardware and port are sound. Failure only inside the OS points to missing or corrupted USB host controller or human interface device drivers, which should be checked in Device Manager.

Question 30Computer Hardware, Operating Systems and Peripherals

Which Windows utility is most directly used to view and stop a background process that is consuming excessive CPU time?

  1. Disk Management
  2. Event Viewer
  3. Device Manager
  4. Task Manager Correct answer.

Explanation

Task Manager lists running processes with their CPU, memory and disk usage, and it allows a selected process to be ended. Disk Management handles partitions, Device Manager manages hardware drivers, and Event Viewer displays logged system events.

Question 31Computer Hardware, Operating Systems and Peripherals

Which statement correctly describes the role of the power supply unit in a desktop computer?

  1. It converts DC voltages from the battery into AC for the monitor
  2. It stores electrical charge to keep RAM refreshed during shutdown
  3. It regulates the clock speed of the processor
  4. It converts AC mains power into regulated DC voltages for the components Correct answer.

Explanation

The PSU takes alternating current from the wall outlet and converts it into the direct current rails, such as 12 V, 5 V and 3.3 V, that the motherboard and drives require. It does not manage processor clock speed or provide backup power during shutdown.

Question 32Computer Hardware, Operating Systems and Peripherals

A laboratory wants to install a second internal hard disk in a desktop cabinet. Which two connections are normally required for the drive to work?

  1. An RJ-45 cable and a SATA power cable
  2. A SATA data cable and a SATA power cable Correct answer.
  3. A USB header and a Molex power cable
  4. A PCIe slot and a SATA data cable

Explanation

An internal SATA drive needs one cable for data to the motherboard and one cable for power from the PSU. Without the data cable the drive is not detected, and without the power cable the motor and electronics cannot operate.

Question 33Computer Hardware, Operating Systems and Peripherals

Which action best protects data on a pen drive before it is physically removed from a Windows computer?

  1. Logging off the user account
  2. Compressing all files on the drive
  3. Renaming the drive letter
  4. Using the Safely Remove Hardware option to flush pending writes Correct answer.

Explanation

Windows may cache write operations, so ejecting through Safely Remove Hardware forces pending data to be written and marks the device safe to unplug. Removing the drive while writes are buffered can corrupt the file system or the files being copied.

Question 34Computer Hardware, Operating Systems and Peripherals

A motherboard supports dual-channel memory. A user installs two matched modules in slots A1 and A2, which belong to the same channel. What is the likely effect?

  1. The modules will run in single-channel mode, reducing memory bandwidth Correct answer.
  2. The CPU will automatically disable one module
  3. The system will refuse to boot in every case
  4. The modules will run at double their rated frequency

Explanation

Dual-channel operation requires the matched pair to be split across different channels, typically A1 and B1 or A2 and B2 as described in the manual. Placing both in one channel still works but leaves the memory controller in single-channel mode, so bandwidth is lower than the board is capable of.

Question 35Computer Hardware, Operating Systems and Peripherals

Which partition style is required to boot a Windows installation in UEFI mode on a drive larger than 2 TB?

  1. GPT Correct answer.
  2. MBR
  3. FAT16
  4. NTFS boot sector

Explanation

GPT uses 64-bit logical block addressing, so it supports volumes far larger than the 2 TB limit imposed by MBR's 32-bit addressing. UEFI firmware on modern boards also expects a GPT disk with an EFI system partition for booting.

Question 36Computer Hardware, Operating Systems and Peripherals

An office PC with 4 GB of RAM runs several browser tabs and a spreadsheet simultaneously and becomes very slow, with the disk active light almost constantly on. Which explanation is most consistent with these symptoms?

  1. The monitor resolution is set too high
  2. The system is paging heavily because physical memory is exhausted Correct answer.
  3. The processor is running at its base clock speed
  4. The network cable is faulty

Explanation

When physical RAM is full, the operating system moves pages to the page file on disk, and constant paging produces heavy disk activity and sluggish response. Adding RAM or reducing the number of open applications addresses the root cause rather than the symptom.

Question 37Computer Hardware, Operating Systems and Peripherals

A motherboard has an M.2 slot with a keying that supports NVMe. Which statement about installing an NVMe SSD in this slot is accurate?

  1. The drive requires an external power cable from the PSU
  2. The drive must be connected to a SATA port with a separate data cable
  3. The drive will operate over the PCIe bus and does not need a SATA data cable Correct answer.
  4. The drive will only work if the M.2 slot is keyed for SATA

Explanation

NVMe drives communicate over PCIe lanes routed to the M.2 connector, so no SATA data or power cabling is involved; the slot supplies both data path and power. A SATA-mode M.2 drive would use the SATA controller instead, but that is a different interface from NVMe.

Question 38Computer Hardware, Operating Systems and Peripherals

A user complains that a laptop battery drains quickly even when the machine is idle. Analysis shows a background indexing service and a discrete GPU both active continuously. Which combination of actions is most appropriate?

  1. Adjust power plan settings and disable or schedule the unnecessary background services Correct answer.
  2. Replace the battery and reinstall the operating system
  3. Increase the screen resolution and refresh rate
  4. Disable the antivirus and remove all startup programs permanently

Explanation

Idle drain caused by continuously active services and a discrete GPU is a power-management problem, so tuning the power plan and scheduling or disabling the offending services targets the cause. Replacing hardware or reinstalling the OS does not address software that keeps components awake.

Question 39Computer Hardware, Operating Systems and Peripherals

During a hardware upgrade, a technician installs a graphics card that requires an 8-pin PCIe power connector, but the existing PSU provides only a 6-pin connector. What is the correct course of action?

  1. Force the 6-pin connector into the 8-pin socket
  2. Run the card without any auxiliary power connector
  3. Use a PSU that provides the required PCIe connector and adequate wattage Correct answer.
  4. Connect the card to a SATA power cable with an adapter rated for the load

Explanation

The auxiliary PCIe connector supplies current the slot alone cannot deliver, and the PSU must have the correct connector and sufficient total wattage for the card. Improvised adapters or forcing incompatible connectors risks overheating, instability or damage to the card and PSU.

Question 40Computer Hardware, Operating Systems and Peripherals

A technician is assembling a desktop PC and must connect the front-panel power switch of the cabinet to the motherboard. Which statement best describes how this switch works with the board's header pins?

  1. It communicates with the chipset over a two-wire serial data bus to request a power-on event.
  2. It supplies 12 V from the power supply directly to the CPU voltage regulator through the header.
  3. It is a momentary contact switch that briefly short-circuits two header pins to signal the power controller. Correct answer.
  4. It is a latching switch that must stay closed to keep the system running after boot.

Explanation

The front-panel power button is a momentary push button wired to the PWR_SW header; pressing it momentarily shorts the two pins, and the motherboard's power control circuitry interprets this as a request to start or shut down the system. Because it is momentary, the switch does not need to remain closed for the PC to keep running, and it carries no power rails or data signals of its own.

Question 41Office Productivity Software (Word Processing, Spreadsheets, Presentations)

In a word processor, which formatting feature is used to make selected text appear slanted to the right for emphasis without changing the font?

  1. Superscript
  2. Italic Correct answer.
  3. Underline
  4. Strikethrough

Explanation

Italic applies a slanted style to characters while keeping the same typeface, and it is commonly used for titles and emphasis. The other options change position or add lines rather than slanting the glyphs.

Question 42Office Productivity Software (Word Processing, Spreadsheets, Presentations)

A student wants every page of a report to show the page number automatically at the bottom. Which feature should be used?

  1. Add a footnote to the last paragraph
  2. Insert a footer with a page-number field Correct answer.
  3. Insert a text box on the first page only
  4. Type the number manually on each page

Explanation

A footer repeats on every page of its section, and a page-number field updates automatically as the document grows. Manual typing does not update when content shifts.

Question 43Office Productivity Software (Word Processing, Spreadsheets, Presentations)

In a spreadsheet, what does the formula =SUM(B2:B10) do?

  1. Counts the non-empty cells in B2 through B10
  2. Finds the largest value in B2 through B10
  3. Adds the values in cells B2 through B10 Correct answer.
  4. Multiplies B2 by B10

Explanation

SUM adds all numeric values in the referenced range, and the colon indicates an inclusive range from the first to the last cell. Counting, multiplying, and finding a maximum require different functions.

Question 44Office Productivity Software (Word Processing, Spreadsheets, Presentations)

Which spreadsheet reference is an absolute reference that stays fixed when copied to another cell?

  1. $A$1 Correct answer.
  2. A1
  3. A$1
  4. $A1

Explanation

Dollar signs before both the column letter and the row number lock the reference fully, so copying does not change it. References with only one dollar sign are mixed and shift in one direction.

Question 45Office Productivity Software (Word Processing, Spreadsheets, Presentations)

In presentation software, which view is best for rearranging the order of slides before a final review?

  1. Slide Sorter view Correct answer.
  2. Notes Page view
  3. Reading view
  4. Slide Show view

Explanation

Slide Sorter view displays thumbnails of all slides so they can be dragged into a new order. Slide Show view runs the presentation, and Notes Page view focuses on speaker notes.

Question 46Office Productivity Software (Word Processing, Spreadsheets, Presentations)

Which file format is most suitable for sharing a finished report so that its layout cannot easily be edited by the recipient?

  1. PDF Correct answer.
  2. TXT
  3. CSV
  4. DOCX

Explanation

PDF preserves the visual layout and is intended for distribution, while editing requires special tools. DOCX remains editable, and TXT and CSV drop most formatting.

Question 47Office Productivity Software (Word Processing, Spreadsheets, Presentations)

In a spreadsheet, what is the purpose of freezing the top row?

  1. It locks the row so its values cannot be edited
  2. It keeps the top row visible while scrolling down Correct answer.
  3. It prevents the row from being printed
  4. It hides the row from other users

Explanation

Freezing panes keeps specified rows or columns on screen while the rest of the sheet scrolls, which helps track headings in long tables. It does not protect data or affect printing.

Question 48Office Productivity Software (Word Processing, Spreadsheets, Presentations)

What is the default file extension of a presentation created in typical presentation software?

  1. .pptx Correct answer.
  2. .docx
  3. .xlsx
  4. .mp4

Explanation

Presentation files are saved with the .pptx extension in modern office suites. The other extensions belong to word processing, spreadsheets, and video respectively.

Question 49Office Productivity Software (Word Processing, Spreadsheets, Presentations)

A user wants to apply the same font, size, and colour to several non-adjacent headings quickly. Which tool is most efficient?

  1. Format Painter Correct answer.
  2. Find and Replace
  3. Word Count
  4. Spelling and Grammar check

Explanation

Format Painter copies character and paragraph formatting from a source selection and applies it elsewhere with a click. The other tools handle proofing, statistics, or text substitution, not formatting transfer.

Question 50Office Productivity Software (Word Processing, Spreadsheets, Presentations)

In a spreadsheet, a cell displays #### instead of a number. What is the most likely cause?

  1. The formula contains a syntax error
  2. The cell is formatted as text
  3. The column is too narrow to display the value Correct answer.
  4. The workbook is password protected

Explanation

Spreadsheets show hash marks when a numeric result does not fit the current column width. Widening the column reveals the value, and the underlying data is unaffected.