PNRD Assam Computer Proficiency MCQ 2026 | 50 Practice Qs – Mytestseries.in

Mail Merge in MS Word automates the creation of personalised letters, envelopes, labels, and emails. You connect a main document (the letter template) to a data source (an Excel sheet or Outlook contacts list) containing recipient details. Word then generates individual copies for each record — useful for sending government notices to multiple beneficiaries, for instance. Track Changes records edits made to a document. AutoCorrect fixes common spelling errors automatically. Macros record repetitive tasks as automated scripts.

Ctrl + E is the shortcut to centre-align selected text or the paragraph where the cursor is placed. The four alignment shortcuts to memorise are: Ctrl+L (Left), Ctrl+E (cEntre), Ctrl+R (Right), and Ctrl+J (Justify). These are among the most commonly tested shortcut questions in Assam government computer sections.

Track Changes (found under the Review tab) marks every insertion, deletion, and formatting change made to a document. Reviewers can see exactly what was changed, by whom, and when — and can Accept or Reject each change individually. It is commonly used when a document is reviewed or edited collaboratively, such as drafting official reports or policy documents.

Ctrl + H opens the Find and Replace dialog box in MS Word. You type the word to find in the “Find what” field and the replacement word in the “Replace with” field, then click Replace All to replace every instance at once. Ctrl + F opens the Find (search only) panel. Ctrl + G opens the Go To dialog (navigate to a specific page or line). Ctrl + R right-aligns selected text.

Since Microsoft Office 2007, Word uses the .docx format (XML-based) as its default. The older .doc format (binary) was the default in Word 97–2003. The “x” in .docx stands for XML. Other related formats: .dotx (Word template), .xlsx (Excel), .pptx (PowerPoint). The .txt format is plain text with no formatting, and .wrd is not a real file format.

The Review tab in MS Word contains all document-review related tools: Spelling & Grammar (F7), Thesaurus, Word Count, Track Changes, Comments, and the Compare Documents feature. The Home tab contains basic formatting (font, paragraph). The Insert tab adds objects (tables, pictures, headers). The View tab changes how the document is displayed on screen.

A Bookmark in MS Word marks a specific location or selected text in the document. You can then create a hyperlink pointing to that bookmark, allowing readers to click and jump directly to that section — useful in long reports and official documents. Cross-references link to numbered items (figures, headings, footnotes). Captions label images and tables.

The Gutter margin in MS Word is the additional space added to the inside or top margin of a document to account for the binding (stitching or ring binding). This ensures that text near the binding edge is not hidden when the document is bound into a book or report. It is commonly used when printing official reports or bound government documents.

Pressing the Alt key in MS Word displays letter labels (called KeyTips) on every Ribbon tab and command button. Pressing the corresponding letter then activates that command without using a mouse. For example, Alt → H opens the Home tab, then F changes the font. This is useful for keyboard-only navigation and is tested in advanced computer MCQs.

Print Layout view (the default Word view) displays the document exactly as it will appear on paper — with page margins, headers, footers, page breaks, and multi-column layouts all visible. Draft view shows text only (faster editing, no margins/headers). Web Layout view shows how the content would appear as a web page. Outline view shows the document’s heading hierarchy for structural editing.

=AVERAGE(A1:A3) calculates the arithmetic mean of the values in cells A1 through A3. Mean = (10 + 20 + 30) ÷ 3 = 60 ÷ 3 = 20. If the question asked for SUM, the answer would be 60. If it asked for MAX, the answer would be 30. Always read carefully to identify which function is being used.

When you copy a formula with a relative reference (e.g., =A1+B1) to another cell, the references shift accordingly — so copying it one row down gives =A2+B2. An absolute reference like =$A$1 always points to cell A1 regardless of where the formula is copied. The $ sign locks either the row, the column, or both. This is one of the most frequently tested Excel concepts in government exams.

VLOOKUP (Vertical Lookup) searches the first column of a table for a value and returns a value from any specified column in the same row. Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). HLOOKUP does the same but searches horizontally across the first row. INDEX returns a value at a specific row/column intersection. MATCH returns the position of a value within a range.

The IF function checks a logical condition and returns one value if true, another if false. Here: Is A1 (45) greater than 50? No — the condition is FALSE. So Excel returns the value_if_false argument, which is “Fail”. If A1 were 60, the condition would be TRUE and Excel would return “Pass”. The IF function is fundamental for data management in government records and is a common exam question.

A Pie chart displays data as slices of a circle, showing each category’s share of the total — ideal for percentage/proportion comparisons. A Line chart shows trends over time. A Bar chart (or Column chart) compares values across categories. A Scatter chart plots data points to show relationships between two numeric variables. For PNRD/government exam context: showing budget allocation percentages across departments would use a Pie chart.

Pressing Ctrl + ; (semicolon) inserts the current date as a static value in the selected Excel cell — it does not update when the file is reopened. To insert the current time, use Ctrl + Shift + ; (colon). To insert a dynamic date that updates automatically, use the formula =TODAY() instead. Ctrl + D fills the cell below with the content of the cell above (Fill Down), not the date.

=COUNT(range) counts only cells containing numbers. =COUNTA(range) counts all non-empty cells (numbers AND text). =COUNTBLANK(range) counts empty cells. =COUNTIF(range, criteria) counts cells meeting a specific condition — for example, =COUNTIF(A1:A10,”>50″) counts how many cells have values greater than 50. Remembering the distinction between COUNT and COUNTA is a classic trick question in government computer exams.

Freeze Panes (View tab → Freeze Panes) locks specific rows and/or columns in place so they remain visible as you scroll through a large spreadsheet. For example, freezing the top row keeps the header row (containing column titles like Name, Age, Address) visible even when you scroll down to row 500. This is very useful when working with large data sets like MGNREGA beneficiary lists or PMAY-G records.

In Excel, 18% is automatically treated as 0.18, so =B2*18% correctly calculates 18% of the value in B2. Equivalently, =B2*0.18 gives the same result. =B2*18 would multiply by 18 (not 18%). =B2/18% divides by 0.18, giving a much larger number. Option D (=18%*B2/100) would calculate 18% ÷ 100 = 0.18% of B2, which is incorrect. Applied percentage formulas like this appear regularly in government exam computer sections.

=NOW() returns the current date and time and updates automatically whenever the workbook is recalculated or reopened. =TODAY() returns only the current date (no time). =DATE(year, month, day) creates a date from specific values (e.g., =DATE(2026,5,1) returns 01-May-2026). =TIME(hour, minute, second) creates a time value. =CLOCK() is not a valid Excel function.

Slide Sorter view displays all slides as small thumbnails in a grid layout, making it easy to drag, rearrange, copy, delete, or add transitions to multiple slides at once. Normal view is the default editing view (slide panel on left, editing area in centre, notes at bottom). Reading view plays the presentation in a window. Presenter view shows the current slide on screen while displaying speaker notes and the next slide privately to the presenter.

The Slide Master (View tab → Slide Master) is a master template that controls the fonts, colours, backgrounds, logos, and layout placeholders for all slides in a presentation. Changes made on the Slide Master automatically apply to all slides. This is useful when creating official presentations where every slide must have the same branding — like a PNRD department report. It is not the first slide, and it is not locked.

F5 starts the PowerPoint slideshow from the very first slide. Shift + F5 starts the slideshow from the currently selected slide — useful when you want to check a specific slide’s appearance. Pressing Escape exits the slideshow. Pressing F4 in Office apps repeats the last action. Memorising both F5 and Shift+F5 is important as exam questions sometimes ask for both variants.

A Transition is the visual effect that plays when you advance from one slide to the next (e.g., Fade, Wipe, Push). It applies to the entire slide. An Animation is an effect applied to a specific object within a slide (e.g., making a text box fly in from the left, or a chart appear one element at a time). Both are accessed from different tabs — Transitions tab and Animations tab respectively.

Speaker Notes are typed in the Notes panel below each slide in Normal view. During Presenter view, these notes appear on the presenter’s screen but are not visible to the audience on the projector. They are essentially talking-point reminders for the presenter. Comments are for collaborative review (like Word’s Track Changes equivalent). Annotations are hand-drawn marks made during a live slideshow using the pen/highlighter tools.

Since PowerPoint 2007, the default format is .pptx (XML-based, Open XML format). The older .ppt format (binary) was used in PowerPoint 97–2003. A .ppsx file is a “PowerPoint Show” that opens directly in full-screen slideshow mode rather than editing mode — useful for distributing a presentation that should only be viewed, not edited. .odp is the OpenDocument Presentation format used by LibreOffice.

“Browsed at a kiosk (full screen)” under Slide Show → Set Up Slide Show automatically runs the presentation on a loop without requiring a presenter to click. The advance timing is set in the Transitions tab (Advance Slide → After: X seconds). This is commonly used for information displays at offices, exhibitions, and government scheme awareness booths.

Rehearse Timings (Slide Show tab → Rehearse Timings) plays your presentation and records exactly how long you spend on each slide. After the rehearsal, PowerPoint asks whether you want to save these timings — if yes, the slideshow will auto-advance each slide after the recorded duration. This is useful for presentations that must run within a fixed time slot without manual control.

HTTPS (HyperText Transfer Protocol Secure) is the encrypted version of HTTP. It uses SSL/TLS (Secure Sockets Layer / Transport Layer Security) to encrypt data exchanged between a user’s browser and the website server. This protects passwords, financial data, and personal information from being intercepted. Government websites like nrega.nic.in and pmayg.nic.in use HTTPS to protect beneficiary data. A padlock icon in the browser address bar indicates HTTPS.

A URL (Uniform Resource Locator) is the complete web address of a resource on the internet. For example, https://mytestseries.in/pnrd-computer-proficiency-mcq-2026/ is a URL. It has three main parts: Protocol (https://), Domain (mytestseries.in), and Path (/pnrd-computer-proficiency-mcq-2026/). The word “Uniform” means every URL follows a standard consistent format recognised by browsers worldwide.

Incognito / Private Browsing mode prevents Chrome, Firefox, Edge, or any browser from locally saving your visited websites, cookies, login sessions, or form inputs. However, it does NOT hide your activity from your Internet Service Provider (ISP), your employer’s network, or the websites you visit — they can still see your IP address. It also does not block ads or make you anonymous online. It is simply a local privacy feature on your own device.

CC stands for Carbon Copy — all recipients in the CC field can see everyone else who received the email. BCC stands for Blind Carbon Copy — BCC recipients receive the email but their addresses are hidden from all other recipients (both To and CC recipients). BCC is used when sending emails to many people while protecting their privacy — useful in government mass communications. The “To” field is for the primary recipient.

Phishing is a cyberattack where criminals send fake emails, messages, or create fake websites that look like legitimate organisations (banks, government portals, OTP screens) to trick users into revealing passwords, OTPs, bank account details, or personal information. A classic example is a fake email claiming to be from a bank asking you to “verify your account” by clicking a link. Awareness of phishing is tested in government computer sections as it affects the security of official data systems like NREGASoft.

Bandwidth is the capacity of a network connection — measured in bits per second (bps), kilobits per second (Kbps), megabits per second (Mbps), or gigabits per second (Gbps). Higher bandwidth means faster data transmission. For example, a 100 Mbps broadband connection can theoretically transfer 100 megabits of data every second. In rural areas with low bandwidth, government apps like NREGASoft are designed to function on slower connections (2G/3G).

DigiLocker (digilocker.gov.in) is a Government of India platform under the Digital India initiative that provides citizens a secure digital wallet for official documents — Aadhaar, driving licence, vehicle registration, marksheets, PAN card, and more. Documents stored in DigiLocker are legally equivalent to physical originals for most government purposes. PNRD field staff use DigiLocker as part of their digital literacy requirement.

A search engine (like Google, Bing, or Yahoo) continuously crawls the web using automated bots, indexes the content of billions of pages, and then uses ranking algorithms to return the most relevant results for a user’s search query. Google is the most widely used search engine globally and in India. For government use, candidates and staff frequently use search engines to find scheme guidelines, circulars, and NIC portals.

NREGAMobile (also known as the Muster app or MIS NREGA app) allows field-level staff including the GRS to digitally record daily worker attendance at MGNREGA worksites using a smartphone. The app captures attendance data, geo-tags the worksite location, and syncs to the NREGASoft MIS portal. This digital muster roll system replaced paper-based attendance to reduce fraud and improve transparency in wage payments.

An Operating System (OS) is the foundational software that manages all hardware resources (processor, memory, storage, input/output devices) and provides an environment in which application software (like MS Word or NREGASoft) can run. Common OS examples: Windows (Microsoft), macOS (Apple), Linux, Android (mobile), iOS. In government offices and PNRD field operations, Windows-based systems running Windows 10 or 11 are standard.

Task Manager (opened with Ctrl + Alt + Delete → Task Manager, or Ctrl + Shift + Esc directly) displays all currently running applications and background processes, CPU and memory usage, and allows you to forcibly end unresponsive programs. It is the go-to tool when a computer “freezes” or a program stops responding. Disk Defragmenter optimises hard drive performance. Control Panel changes system settings. File Explorer navigates files and folders.

Pressing F2 after selecting a file or folder in Windows File Explorer puts the file/folder name into rename-edit mode. F1 opens Help in most Windows applications. F3 activates the search bar in File Explorer. F4 in File Explorer highlights the address bar so you can type a path directly. F5 refreshes the File Explorer window. F2 for rename is one of the most frequently tested OS shortcut questions in government exams.

The Windows Control Panel is a system administration hub for configuring hardware, software, and system settings. You can change display resolution, manage user accounts, set up printers, uninstall programs, configure the firewall, and more — all from Control Panel. However, editing text documents is not a Control Panel function — that is done in Notepad, WordPad, or MS Word. “Negative knowledge” questions like this (identifying what something does NOT do) are common in government computer sections.

When you delete a file in Windows (using the Delete key), it moves to the Recycle Bin — not permanently erased. You can open the Recycle Bin and restore a file to its original location if deleted by mistake. To permanently delete without sending to Recycle Bin, press Shift + Delete. To permanently empty the Recycle Bin (free up the disk space), right-click the Recycle Bin and select “Empty Recycle Bin.” Files deleted from USB drives do not go to the Recycle Bin.

RAM (Random Access Memory) is volatile — it temporarily holds data and programs currently in use (like an open Excel file or a running browser). When you shut down the computer, all data in RAM is lost. ROM (Read-Only Memory) is non-volatile — it permanently stores firmware (like BIOS/UEFI) that is needed to start the computer. ROM data survives power-off. More RAM allows more programs to run simultaneously without slowing down.

Ctrl + Shift + Esc is the fastest way to open Windows Task Manager in one step, without going through the Ctrl + Alt + Delete screen first. This shortcut is particularly useful when a program freezes and you need to end it immediately. Windows + L locks the screen. Windows + I opens Windows Settings. Ctrl + Alt + Delete shows the security options screen (where Task Manager is one of several options).

Windows + Print Screen captures the entire screen and automatically saves it as an image file in the Pictures → Screenshots folder. The screen briefly dims to confirm the screenshot was taken. PrtSc (alone) copies the screen to clipboard only — you must paste it into Paint or Word manually. Alt + Print Screen captures only the active window (not the full screen) and copies to clipboard. Windows + Shift + S opens the Snip & Sketch tool for selecting a specific area.

Ctrl + Z undoes the last action. Ctrl + Y redoes it — that is, it re-applies the action you just undid. You can press Ctrl + Z multiple times to undo multiple steps, then press Ctrl + Y to redo them one by one. In some contexts, Ctrl + Y can also repeat the last command performed (not just undo/redo). Ctrl + A selects all. There is no standard shortcut for yellow highlight — you apply that from the Home tab font formatting tools.

Ctrl + T opens a new browser tab in Chrome, Firefox, Edge, and most modern browsers. Ctrl + N opens a new browser window. Ctrl + W closes the current tab. Ctrl + Tab switches between open tabs (moves to the next tab to the right). Ctrl + Shift + T reopens the most recently closed tab — a very useful shortcut to know when you accidentally close a tab containing government portal data entry.

When you are inside a formula and click on a cell reference (like A1), pressing F4 cycles through: A1 (relative) → $A$1 (absolute) → A$1 (row locked) → $A1 (column locked) → back to A1. This is the fastest way to apply dollar signs for absolute referencing without typing them manually. In other Office contexts (outside formula editing), F4 repeats the last action. Ctrl + 1 opens the Format Cells dialog.

Windows + D minimises all open application windows instantly to reveal the Desktop. Pressing Windows + D again restores all those windows back to their previous positions. This is the same as clicking the “Show Desktop” button at the far right of the Windows taskbar. Windows + E opens File Explorer. Windows + L locks the screen. Windows + R opens the Run dialog. Windows + I opens Windows Settings.

The three core text-formatting shortcuts every exam candidate must know: Ctrl + B (Bold), Ctrl + I (Italic), Ctrl + U (Underline). These work in MS Word, MS Excel, MS PowerPoint, and most other text editors. Pressing the same shortcut again on already-formatted text removes the formatting (toggles it off). Ctrl + T in MS Word creates a hanging indent. These three shortcuts are among the first computer basics tested in any government exam.