I85PREP
⌘ K
Haryana BSEH Secondary NSQF IT-ITeS study materials
Haryana BSEH Secondary NSQF IT-ITeS study resources

Haryana BSEH Secondary NSQF IT-ITeS practice questions

One question at a time. Build your Haryana BSEH Secondary NSQF 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 1Introduction to IT-ITeS Industry and Career Pathways

In the IT-ITeS industry, which term describes a company that provides services such as payroll processing or customer support to another organization under a contract?

  1. Hardware vendor
  2. Service provider Correct answer.
  3. Retail distributor
  4. Original equipment manufacturer

Explanation

The IT-ITeS sector is built around organizations that deliver information-technology and business-process services to client firms. A service provider delivers such contracted work, for example payroll processing or customer support, rather than selling physical goods.

Question 2Introduction to IT-ITeS Industry and Career Pathways

Which abbreviation refers to the business-process strand of the IT-ITeS industry, covering services such as finance and accounting or human-resource administration handled for clients?

  1. LAN
  2. ERP
  3. CAD
  4. BPM Correct answer.

Explanation

BPM stands for Business Process Management in the NSQF IT-ITeS nomenclature and covers outsourcing of business functions such as finance, accounting and HR administration. The other abbreviations name design, planning or networking technologies, not a service strand.

Question 3Introduction to IT-ITeS Industry and Career Pathways

A company sets up a dedicated offshore centre that it owns and operates itself to handle its own IT support work. Which sourcing model does this describe?

  1. Joint venture
  2. Captive centre Correct answer.
  3. Franchising
  4. Third-party outsourcing

Explanation

A captive centre is owned and operated by the client organization itself, so the work stays within the same corporate group even though it is located abroad. Outsourcing to another firm, sharing ownership, or licensing a brand are different arrangements.

Question 4Introduction to IT-ITeS Industry and Career Pathways

Which role in an IT-ITeS delivery team is mainly responsible for writing and testing program code to meet specified requirements?

  1. Business analyst
  2. Software developer Correct answer.
  3. Network administrator
  4. Help-desk executive

Explanation

A software developer converts requirements into working code and tests it, which is the core of the role described. The other roles focus on user support, requirement gathering, or maintaining network infrastructure.

Question 5Introduction to IT-ITeS Industry and Career Pathways

Which entry-level qualification pathway in the NSQF structure typically follows completion of secondary school and prepares a learner for a specific job role?

  1. Post-doctoral fellowship
  2. Level 4 certificate Correct answer.
  3. Level 1 certificate
  4. Doctorate

Explanation

In the NSQF framework, Level 4 is commonly aligned with secondary-school completion and prepares learners for skilled work in a defined job role. The lower levels cover basic preparation and the higher academic awards come after longer study.

Question 6Introduction to IT-ITeS Industry and Career Pathways

A candidate wants to demonstrate practical, job-ready competence in a specific IT-ITeS role to employers. Which credential is designed for exactly that purpose?

  1. A school sports participation certificate
  2. A driving licence
  3. A general science degree in an unrelated subject
  4. An NSQF-aligned vocational qualification for that job role Correct answer.

Explanation

NSQF-aligned vocational qualifications are built around defined job roles and assessed against industry-validated competencies, so they signal practical readiness for that role. The other credentials do not certify IT-ITeS job competence.

Question 7Introduction to IT-ITeS Industry and Career Pathways

Which behaviour best reflects professional etiquette when an IT-ITeS employee must tell a client about a delay in a promised deliverable?

  1. Submit the incomplete work silently on the due date
  2. Let a teammate discover the delay and report it later
  3. Inform the client promptly with the revised timeline and the reason Correct answer.
  4. Wait until the client asks about the deliverable

Explanation

Professional etiquette in client-facing IT-ITeS work requires proactive, honest communication so the client can plan around the change. Delaying the message or hiding the shortfall damages trust and is unprofessional.

Question 8Introduction to IT-ITeS Industry and Career Pathways

What does the term 'attrition' measure in an IT-ITeS company?

  1. The proportion of projects delivered on time
  2. The share of revenue spent on hardware
  3. The number of new clients signed each quarter
  4. The rate at which employees leave and are replaced Correct answer.

Explanation

Attrition refers to employee departures and the resulting need for replacement, and it is a key workforce metric in service companies where staff cost and continuity matter. The other options describe sales, delivery quality, or spending.

Question 9Introduction to IT-ITeS Industry and Career Pathways

Which document in an outsourcing engagement formally defines the scope, service levels, and responsibilities of each party?

  1. Employee appraisal form
  2. Purchase invoice
  3. Attendance register
  4. Service level agreement Correct answer.

Explanation

A service level agreement records what services will be delivered, the standards they must meet, and who is responsible for what. The other documents record transactions, staff performance, or attendance.

Question 10Introduction to IT-ITeS Industry and Career Pathways

A student is interested in the testing and quality side of software delivery and wants a role focused on finding defects before release. Which job title fits best?

  1. Technical writer
  2. Desktop support technician
  3. Quality assurance engineer Correct answer.
  4. Data entry operator

Explanation

Quality assurance engineers plan and run tests to detect defects before software is released, matching the student's stated interest. The other roles handle data capture, documentation, or end-user device support.

Question 11Introduction to IT-ITeS Industry and Career Pathways

Which skill set is most characteristic of the 'soft skills' expected in IT-ITeS workplaces, as distinct from technical skills?

  1. Debugging code
  2. Configuring routers
  3. Active listening and clear spoken communication Correct answer.
  4. Writing SQL queries

Explanation

Soft skills concern how a person communicates and works with others, and active listening with clear speech is a standard example in client-facing service work. Query writing, router configuration, and debugging are technical competencies.

Question 12Introduction to IT-ITeS Industry and Career Pathways

In the IT-ITeS context, what does 'offshoring' of a service mean?

  1. Delivering the service from a country different from the client's Correct answer.
  2. Delivering the service from the client's own building
  3. Selling software licences to foreign retailers
  4. Replacing staff with automated tools

Explanation

Offshoring describes moving service delivery to another country, often to access skills or lower costs, while the client remains elsewhere. Delivering on the client's premises is onshoring, and the other options describe sales or automation.

Question 13Introduction to IT-ITeS Industry and Career Pathways

A team receives a client requirement to reduce average call-handling time without lowering customer satisfaction. Which first step best reflects an analytical approach?

  1. Immediately cut all training sessions to save time
  2. Ask every agent to work faster without any data
  3. Reduce the number of customers served per day
  4. Measure current handling times and identify where delays occur Correct answer.

Explanation

An analytical approach begins with measurement and diagnosis so that improvement targets the actual causes of delay. Acting without data, cutting training, or restricting service volume does not address the dual goal of speed and satisfaction.

Question 14Introduction to IT-ITeS Industry and Career Pathways

Which statement best explains why the IT-ITeS industry is described as 'people-intensive'?

  1. Its main input and cost is skilled human effort rather than machinery Correct answer.
  2. It depends mainly on heavy industrial machinery
  3. It sells only physical products to consumers
  4. It requires large tracts of agricultural land

Explanation

Service delivery in IT-ITeS depends on the knowledge and effort of trained people, so salaries form a large share of cost. Machinery, physical products, and land are characteristic of other sectors.

Question 15Introduction to IT-ITeS Industry and Career Pathways

A help-desk executive receives a complaint that a password reset has failed twice. Which action sequence best follows standard incident-handling practice?

  1. Advise the user to stop using the account
  2. Log the incident, verify the user's identity, resolve the issue, and record the outcome Correct answer.
  3. Reset the password again without logging anything
  4. Forward the complaint to a colleague and close the ticket

Explanation

Incident handling requires recording the issue, confirming the caller is authorised, resolving it, and documenting the resolution so the history is traceable. Skipping logging or closing without resolution breaks the process.

Question 16Introduction to IT-ITeS Industry and Career Pathways

Which factor most directly explains a client's decision to outsource a payroll function to an IT-ITeS provider?

  1. A desire to own more office buildings
  2. Access to specialised process expertise and predictable costs Correct answer.
  3. A wish to reduce the number of employees to zero
  4. A plan to stop paying salaries entirely

Explanation

Outsourcing business processes is typically driven by access to specialist skills, scalability, and cost predictability under a contract. The other options misstate normal business motives.

Question 17Introduction to IT-ITeS Industry and Career Pathways

Which pairing of an IT-ITeS job role with its primary output is correct?

  1. Network administrator - legal contracts with clients
  2. Technical writer - hardware repair of laptops
  3. Help-desk executive - new software architecture designs
  4. Data analyst - interpreted reports and insights from data Correct answer.

Explanation

A data analyst collects and interprets data and produces reports or insights that guide decisions. The other pairings attach outputs to roles that do not normally produce them.

Question 18Introduction to IT-ITeS Industry and Career Pathways

Which statement about career progression in the IT-ITeS industry is most accurate?

  1. Progression usually combines experience, certified skills, and demonstrated performance Correct answer.
  2. Progression depends only on the number of years served
  3. Progression requires leaving the industry entirely
  4. Progression is impossible without a foreign degree

Explanation

Careers in IT-ITeS typically advance through a mix of hands-on experience, recognised certifications, and a record of delivering results. Seniority alone, foreign study, or leaving the sector are not requirements.

Question 19Introduction to IT-ITeS Industry and Career Pathways

An organisation wants its IT-ITeS staff to handle customer data responsibly. Which practice directly supports data privacy compliance?

  1. Posting customer records in a public team chat for convenience
  2. Sharing customer records only with authorised staff who need them Correct answer.
  3. Emailing full customer databases to personal accounts
  4. Storing passwords in a shared spreadsheet visible to all

Explanation

Data privacy principles require limiting access to personal information to those with a legitimate need, which reduces the risk of misuse or leakage. Broad sharing, personal email, and exposed passwords all increase the risk of a breach.

Question 20Introduction to IT-ITeS Industry and Career Pathways

Which of these is a recognised advantage of the IT-ITeS sector for a country's economy?

  1. It removes the need for any education or training
  2. It generates export earnings through services delivered to foreign clients Correct answer.
  3. It eliminates all competition from other countries
  4. It guarantees employment to every citizen

Explanation

Service exports such as software development and business-process support bring foreign exchange into the economy and create skilled employment. The sector still depends on trained people and faces global competition, so the absolute claims are false.

Question 21Computer Fundamentals, Hardware and Operating System Basics

Which unit of a computer is responsible for performing arithmetic operations such as addition and comparison of two binary numbers?

  1. Control Unit
  2. Program Counter
  3. Arithmetic Logic Unit Correct answer.
  4. Memory Address Register

Explanation

The Arithmetic Logic Unit, or ALU, is the combinational circuit inside the CPU that executes arithmetic operations such as addition and subtraction and logical operations such as AND, OR and comparison. The control unit only directs the flow of data and signals. Registers merely hold operands and addresses.

Question 22Computer Fundamentals, Hardware and Operating System Basics

A technician installs a 3.5-inch SATA hard disk in a desktop cabinet. Which two connections must be made for the drive to work normally?

  1. USB header and SATA data cable
  2. PCIe slot and power connector
  3. VGA cable and power connector
  4. Power connector and SATA data cable Correct answer.

Explanation

A SATA hard disk needs both a power connection from the SMPS and a SATA data cable that carries data to the motherboard controller. Without the data cable the drive is not detected, and without power it does not spin up.

Question 23Computer Fundamentals, Hardware and Operating System Basics

Which type of memory loses its stored contents as soon as the computer is switched off?

  1. Volatile memory Correct answer.
  2. Flash memory
  3. Non-volatile memory
  4. Read-only memory

Explanation

Volatile memory retains data only while power is supplied, and RAM is the standard example used in a computer system. Non-volatile and read-only memories keep their contents without power. Flash memory is also non-volatile.

Question 24Computer Fundamentals, Hardware and Operating System Basics

Which of the following is an example of system software?

  1. Operating system Correct answer.
  2. Web browser
  3. Spreadsheet package
  4. Image editor

Explanation

System software manages the hardware and provides a platform on which application programs run, and the operating system is the primary example. Spreadsheets, image editors and browsers are application software used for user tasks.

Question 25Computer Fundamentals, Hardware and Operating System Basics

In a computer, which component converts AC mains supply into the regulated DC voltages needed by the motherboard and drives?

  1. CMOS battery
  2. Modem
  3. SMPS Correct answer.
  4. UPS

Explanation

The Switched Mode Power Supply converts AC mains into the +3.3 V, +5 V and +12 V DC rails used inside the cabinet. A CMOS battery only maintains the real-time clock settings. A UPS provides backup AC power rather than internal DC conversion.

Question 26Computer Fundamentals, Hardware and Operating System Basics

Which key combination is commonly used in Windows to open Task Manager directly?

  1. Windows + L
  2. Alt + F4
  3. Ctrl + Alt + Delete
  4. Ctrl + Shift + Esc Correct answer.

Explanation

Pressing Ctrl, Shift and Esc together opens Task Manager immediately in Windows. Ctrl + Alt + Delete opens a security screen from which Task Manager can be chosen, and Alt + F4 closes the active window.

Question 27Computer Fundamentals, Hardware and Operating System Basics

Which file system is the default choice for formatting a pen drive that must be used on both Windows and most other operating systems?

  1. NTFS
  2. HFS+
  3. ext4
  4. FAT32 Correct answer.

Explanation

FAT32 is widely supported by Windows, Linux, macOS and most consumer devices such as cameras and media players, which makes it a common choice for removable drives. NTFS is Windows-centric, ext4 is native to Linux and HFS+ belongs to macOS.

Question 28Computer Fundamentals, Hardware and Operating System Basics

A user reports that a desktop powers on with fans spinning but shows no display on the monitor. Which first step is most appropriate for an IT support technician?

  1. Replace the hard disk
  2. Run a full disk defragmentation
  3. Check that the monitor cable and power are properly connected Correct answer.
  4. Reinstall the operating system

Explanation

A no-display fault with the fans running points to the display path, so the technician first verifies monitor power and the video cable seating before touching storage or the OS. Storage and OS problems cannot cause a blank screen at power-on. This follows the principle of checking the simplest physical cause first.

Question 29Computer Fundamentals, Hardware and Operating System Basics

Which statement correctly describes the difference between a cold boot and a warm boot?

  1. A cold boot is performed only after a virus attack, while a warm boot is a normal start
  2. A cold boot starts the computer from power-off, while a warm boot restarts it without removing power Correct answer.
  3. A cold boot restarts a running computer, while a warm boot starts it from power-off
  4. A cold boot loads the OS from a pen drive, while a warm boot loads it from the hard disk

Explanation

A cold boot, also called a hard boot, begins with the machine switched off and applies full power before POST and OS loading. A warm boot restarts a system that is already powered, typically through a restart command, without cutting the supply.

Question 30Computer Fundamentals, Hardware and Operating System Basics

During POST, a desktop emits a repeating pattern of short beeps and shows nothing on screen. What does this most likely indicate?

  1. A hardware fault detected by the BIOS Correct answer.
  2. An expired antivirus subscription
  3. A corrupted word processing document
  4. A full recycle bin

Explanation

Beep codes are generated by the BIOS or UEFI during the power-on self-test to report hardware problems such as faulty RAM, a missing graphics card or a keyboard error before any display is available. Software and file-level issues occur much later and cannot produce POST beeps.

Question 31Computer Fundamentals, Hardware and Operating System Basics

Which of the following best describes the function of the kernel in an operating system?

  1. It stores user documents permanently on the disk
  2. It compiles source code into machine instructions
  3. It manages hardware resources and provides core services to programs Correct answer.
  4. It provides a graphical interface for launching applications

Explanation

The kernel is the central part of the operating system that runs in privileged mode and controls memory, processes, devices and system calls. User interfaces, file storage and compilers are separate layers or tools built above or beside the kernel.

Question 32Computer Fundamentals, Hardware and Operating System Basics

A user wants a single physical disk divided into two independent logical drives, C: and D:. Which Windows utility is designed for this task?

  1. Control Panel
  2. Disk Management Correct answer.
  3. Device Manager
  4. Task Scheduler

Explanation

Disk Management is the built-in Windows console used to initialise disks, create, shrink, extend and delete partitions and assign drive letters. Device Manager handles hardware drivers, Task Scheduler automates tasks and Control Panel holds system settings categories.

Question 33Computer Fundamentals, Hardware and Operating System Basics

Which port is traditionally used for a wired local area network connection on a desktop motherboard?

  1. RJ-45 Ethernet port Correct answer.
  2. HDMI port
  3. USB Type-A port
  4. 3.5 mm audio jack

Explanation

The RJ-45 port accepts a twisted-pair Ethernet cable and connects the computer to a switch or router for LAN access. HDMI carries digital video and audio, USB connects peripherals and the audio jack carries analogue sound.

Question 34Computer Fundamentals, Hardware and Operating System Basics

Which of these devices is an input device used to capture a physical document into digital form?

  1. Speaker
  2. Scanner Correct answer.
  3. Plotter
  4. Projector

Explanation

A scanner converts printed text or images into a digital file that the computer can store and process, so it is classified as an input device. Plotters, speakers and projectors all produce output from the computer.

Question 35Computer Fundamentals, Hardware and Operating System Basics

Which of the following is a function of the BIOS during system startup?

  1. Compressing files before saving them to disk
  2. Testing hardware and locating a bootable device Correct answer.
  3. Assigning IP addresses to network computers
  4. Rendering 3D graphics for games

Explanation

The BIOS runs the power-on self-test, initialises essential hardware and then searches the configured boot order for a bootable device to hand control to the operating system. File compression, IP address assignment and 3D rendering are handled by other software and hardware.

Question 36Computer Fundamentals, Hardware and Operating System Basics

A user complains that a computer becomes very slow only when several applications are open at the same time. Which resource should be checked first in Task Manager?

  1. Keyboard language layout
  2. Memory usage Correct answer.
  3. Screen resolution
  4. Printer spooler status

Explanation

Slowness that appears when many programs run together usually indicates that physical RAM is exhausted and the system is paging to disk. Task Manager shows memory usage per process, which helps confirm this. Printer, display resolution and keyboard layout do not scale with the number of open programs.

Question 37Computer Fundamentals, Hardware and Operating System Basics

Which of the following correctly lists storage units in increasing order of size?

  1. Gigabyte, Terabyte, Kilobyte, Megabyte
  2. Terabyte, Gigabyte, Megabyte, Kilobyte
  3. Kilobyte, Megabyte, Gigabyte, Terabyte Correct answer.
  4. Megabyte, Kilobyte, Terabyte, Gigabyte

Explanation

Each storage unit is roughly one thousand times the previous one in decimal terms: a kilobyte is smaller than a megabyte, which is smaller than a gigabyte, which is smaller than a terabyte. The other sequences place larger units before smaller ones.

Question 38Computer Fundamentals, Hardware and Operating System Basics

Which Windows tool is used to view and update the driver of a display adapter?

  1. Disk Cleanup
  2. Device Manager Correct answer.
  3. Character Map
  4. Snipping Tool

Explanation

Device Manager lists installed hardware and lets a technician update, roll back or uninstall drivers for a display adapter. Disk Cleanup removes temporary files, Character Map inserts special characters and Snipping Tool captures screen images.

Question 39Computer Fundamentals, Hardware and Operating System Basics

A technician must replace a faulty CMOS battery on an old desktop. Which precaution matters most for retaining the saved BIOS settings?

  1. Increase the screen brightness before opening the cabinet
  2. Disconnect the printer cable before starting
  3. Note the existing BIOS settings before removing the battery Correct answer.
  4. Format the hard disk before replacing the battery

Explanation

Removing the CMOS battery clears the volatile CMOS memory that stores BIOS settings such as date, time and boot order, so the technician should record them beforehand to restore them afterwards. Brightness, printer cables and disk formatting have no bearing on CMOS contents.

Question 40Computer Fundamentals, Hardware and Operating System Basics

Which of the following is a characteristic of a solid state drive compared with a magnetic hard disk drive?

  1. It uses an optical laser to read and write data
  2. It requires defragmentation more often than a hard disk
  3. It stores data on rotating magnetic platters
  4. It has no moving mechanical parts and offers faster random access Correct answer.

Explanation

A solid state drive stores data in NAND flash memory cells, so it has no spinning platters or moving heads and delivers much faster random access and shock resistance. Magnetic platters belong to hard disks and optical lasers belong to CD and DVD drives.

Question 41Computer Fundamentals, Hardware and Operating System Basics

An operating system uses a time quantum to switch the CPU rapidly between several ready processes, giving each user the impression of a dedicated machine. Which scheduling concept does this describe?

  1. Batch processing without user interaction
  2. Time-sharing with round-robin scheduling Correct answer.
  3. Real-time scheduling with hard deadlines
  4. Spooling of print jobs

Explanation

Time-sharing divides CPU time into small slices and rotates among ready processes, which is exactly what round-robin scheduling does with its time quantum. Batch processing groups jobs for later execution, real-time scheduling guarantees deadlines and spooling buffers printer output.

Question 42Computer Fundamentals, Hardware and Operating System Basics

A 64-bit operating system is installed on a computer whose processor supports 64-bit operation. What is the main advantage of this setup over a 32-bit installation?

  1. It eliminates the need for a hard disk
  2. It can address far more RAM and run larger processes Correct answer.
  3. It allows the computer to work without a power supply
  4. It removes the requirement for device drivers

Explanation

A 64-bit address space allows the operating system to use much more physical and virtual memory than the roughly 4 GB limit of a 32-bit system, and individual processes can be larger. Storage, drivers and power are still required regardless of word size.

Question 43Computer Fundamentals, Hardware and Operating System Basics

A user reports that a pen drive shows a capacity of 0 bytes and Windows asks to format it before use. Which explanation is most consistent with these symptoms?

  1. The system clock is set to the wrong time zone
  2. The file system on the pen drive is corrupted or the partition table is damaged Correct answer.
  3. The keyboard driver is outdated
  4. The monitor refresh rate is set too high

Explanation

When Windows cannot read a valid file system or partition table on removable media, it typically reports zero capacity and prompts for formatting. Refresh rate, keyboard drivers and time zone settings do not affect how storage capacity is reported.

Question 44Computer Fundamentals, Hardware and Operating System Basics

Which sequence correctly describes the order of events when a Windows computer is switched on?

  1. Bootloader runs, user session starts, POST runs, kernel loads
  2. Kernel loads, POST runs, user session starts, bootloader runs
  3. POST, BIOS or UEFI hands over to the bootloader, the kernel loads, user session starts Correct answer.
  4. User session starts, kernel loads, bootloader runs, POST runs

Explanation

Firmware performs the power-on self-test first, then locates the boot device and passes control to the bootloader. The bootloader loads the operating system kernel, and only after the kernel and services are ready does the user session begin.

Question 45Word Processing and Spreadsheet Applications

In a spreadsheet, which type of cell reference stays fixed when the formula is copied to another cell?

  1. A range reference such as A1:B5
  2. A relative reference such as A1
  3. An absolute reference such as $A$1 Correct answer.
  4. A mixed reference such as A$1

Explanation

An absolute reference locks both the column and the row with dollar signs, so copying the formula leaves that address unchanged. Relative references shift by the same offset as the copy, and mixed references lock only one part. A range reference simply describes a block of cells and does not control copying behaviour.

Question 46Word Processing and Spreadsheet Applications

A word processor user wants the same heading text to appear at the top of every page automatically. Which feature should be used?

  1. Apply the Heading 1 paragraph style to the first page only
  2. Place the heading inside the page header area Correct answer.
  3. Insert a footnote at the end of the document
  4. Add the heading to the document properties

Explanation

Content placed in the header region is repeated on every page that uses that header, so a heading typed there appears automatically throughout. Footnotes belong to specific pages, and a style applied on one page affects only that paragraph. Document properties store metadata and never print on pages.

Question 47Word Processing and Spreadsheet Applications

Which spreadsheet function adds the values in cells B2 through B10?

  1. =SUM(B2:B10) Correct answer.
  2. =COUNT(B2:B10)
  3. =AVERAGE(B2:B10)
  4. =MAX(B2:B10)

Explanation

The SUM function totals all numeric values in the given range. COUNT only counts how many numeric cells exist, AVERAGE divides the total by the number of values, and MAX reports the largest single value. Therefore only SUM returns the addition of the range.

Question 48Word Processing and Spreadsheet Applications

In a word processor, what is the main purpose of the spelling and grammar check facility?

  1. To translate the document into another language
  2. To flag words not in the dictionary and possible grammar issues Correct answer.
  3. To change the font of the entire document
  4. To count the characters in the selected text

Explanation

The spelling and grammar checker compares words against a dictionary and applies grammar rules, marking suspected errors for the user to accept or ignore. It does not translate text, count characters, or restyle fonts. Those tasks belong to other tools such as word count and font formatting.

Question 49Word Processing and Spreadsheet Applications

A worksheet lists item prices in column A and quantities in column B, starting at row 2. Which formula gives the total cost for row 2?

  1. =A2+B2
  2. =A2*B2 Correct answer.
  3. =A2-B2
  4. =A2/B2

Explanation

Total cost is price multiplied by quantity, so the cell should contain the product of the two cells. Addition would give a meaningless combined figure, division would give a ratio, and subtraction would give a difference. The multiplication operator in spreadsheets is the asterisk.

Question 50Word Processing and Spreadsheet Applications

Which key combination is commonly used to save the current document in a word processor?

  1. Ctrl + V
  2. Ctrl + S Correct answer.
  3. Ctrl + P
  4. Ctrl + X

Explanation

Ctrl + S is the standard shortcut for saving, opening the Save or Save As dialog when needed. Ctrl + P opens the print dialog, Ctrl + X cuts the selection, and Ctrl + V pastes clipboard contents. Remembering these shortcuts speeds up routine document handling.