Q&A: practice questions with answers

Concept: Follow the principle of 'need to know' – share only what the colleague needs.

1. Redacting (removing/masking) sensitive details before forwarding protects the data while still enabling action.
2. Forwarding as is exposes the data; a phone call does not accomplish the forwarding; deleting the mail stops the work.

Yaad rakhein: Sensitive info → redact, encrypt, minimise – never forward blindly.

Answer: (B) Redact the sensitive information before forwarding.

Concept: Ethernet switches forward frames in three ways.

1. Cut-through: starts forwarding as soon as the destination MAC (first 6 bytes) is read → lowest latency, but errors are not checked.
2. Store-and-forward: receives the whole frame, checks the CRC, then forwards → more reliable, higher latency.
3. Fragment-free: reads the first 64 bytes before forwarding (a compromise). Token passing is a media-access method (Token Ring), not switching.

Yaad rakhein: Cut-through = fast but careless; Store-and-forward = slow but safe.

Answer: (A) Cut-Through Switching

Concept: PCB = Printed Circuit Board.

1. A PCB is a physical board with etched copper tracks that connects and supports electronic components (chips, capacitors, connectors).
2. The motherboard, RAM modules and graphics cards are all PCBs.
3. It is not an input device, protocol or software.

Yaad rakhein: PCB = Printed Circuit Board = green board with copper tracks.

Answer: (B) A physical board connecting electronic components

Concept: Content from other Office applications is embedded through OLE (Object Linking and Embedding).

1. Insert > Object lets you insert a Word document or Excel worksheet (new or from file) as an embedded/linked object in a slide.
2. Insert > Table only draws a new PowerPoint table; there is no 'File > Import' or 'Home > Table' command.

Yaad rakhein: Anything from another program → Insert > Object (OLE).

Answer: (B) Insert > Object

Concept: Word offers several ways to add/delete rows and columns.

1. Statement 1 is false: Tab in the last cell adds a row at the end, but rows can also be inserted anywhere (Layout tab, right-click, or the '+' handle at the table edge).
2. Statement 2 is true: Table Tools → Layout → Insert Above/Below/Left/Right and Delete.
3. Statement 3 is true: right-click → Insert / Delete Cells, Rows, Columns.

Yaad rakhein: Any statement with 'only' in Office questions is usually false.

Answer: (A) Statement Only 2 and Statement 3

Concept: In R1C1 style a cell is written as R<row number>C<column number>.

1. Column E is the 5th column, row 8 → R8C5.
2. In the usual A1 style the same cell is E8. R1C1 can be switched on from File → Options → Formulas.

Yaad rakhein: R before C, row first, then column number (A=1, B=2, … E=5).

Answer: (B) R8C5

Concept: Word has mouse+key combinations for selecting text units.

1. Hold Ctrl and click anywhere in a sentence → the whole sentence is selected; double-click → word; triple-click → paragraph.
2. Ctrl + Shift + → selects one word to the right; Ctrl + Shift + End selects up to the end of the document.

Yaad rakhein: Click×2 = word, Ctrl+click = sentence, Click×3 = paragraph.

Answer: (D) Ctrl + Click anywhere in the sentence

Concept: Each ribbon tab groups related commands.

1. The Design tab holds Themes (design templates), Variants, Slide Size and Format Background.
2. Home = text/slide basics, Insert = pictures/tables/charts, View = slide sorter/master views.

Yaad rakhein: Look (theme, colours, background) → Design tab.

Answer: (D) Design tab

Concept: Windows task-switching shortcuts.

1. Alt + Tab cycles through open programs/windows (hold Alt, press Tab repeatedly).
2. Alt + F4 closes the active window; Alt + Del / Alt + Ins are not standard Windows shortcuts.

Yaad rakhein: Alt+Tab = switch, Alt+F4 = shut, Win+Tab = Task View.

Answer: (C) Alt + Tab

Concept: Print output depends on the settings chosen in the Print dialog.

1. Printer selection, paper size/type, print quality (draft/normal/best), colour vs greyscale and page range all change the result and the ink/paper used.
2. Options B, C and D claim settings do not matter or defaults are always right – both are false.

Yaad rakhein: Ctrl + P → check printer, pages, copies, quality, colour before clicking Print.

Answer: (A) Printer selection, paper type, print quality, colour options and page range settings affect printing outcomes and resource efficiency.

Concept: Classic Office (2003 and earlier) had named toolbars.

1. The Drawing Toolbar contained AutoShapes, lines, arrows, flowchart symbols, WordArt and fill/line colours.
2. Formatting toolbar = font/alignment; Standard toolbar = New/Open/Save/Print; Formula bar = cell formulas (Excel).
3. In ribbon versions these tools live under Insert → Shapes.

Yaad rakhein: Shapes, arrows, flowchart → Drawing.

Answer: (D) Drawing Toolbar

Concept: Attachments are added from the compose window.

1. Click the 'Attach File' / paperclip icon, browse to the file and select it (Gmail, Outlook, Yahoo all use the paperclip).
2. There is no 'Edit → Add File'; Send only dispatches the mail; Ctrl + A selects all text.

Yaad rakhein: Paperclip 📎 = attach, in every email client.

Answer: (C) Click the 'Attach File' or paperclip icon and select a file

Concept: Clip art is a library of ready-made graphics for documents and slides.

1. It includes drawings, illustrations, icons and animated GIFs (older Office clip galleries even had photos).
2. It is not limited to charts or videos, and sound files are media clips, not clip art.

Yaad rakhein: Clip art = pre-drawn pictures you can 'clip' into your document.

Answer: (C) Animated GIFs & drawings

Concept: Word can turn delimited text into a table if you tell it the separator.

1. Select the text → Insert → Table → Convert Text to Table…
2. In the dialog, set 'Separate text at' = Commas; Word uses commas for columns and paragraph marks for rows.
3. Quick Tables inserts a pre-formatted sample table; Table Properties and Text Direction do not convert text.

Yaad rakhein: CSV text → Convert Text to Table → separator = comma.

Answer: (B) Select the text, Insert → Table → Convert Text to Table, confirm separator = Commas

Concept: The Windows desktop has a taskbar, Start menu and system tray.

1. The taskbar (bottom bar) shows buttons for currently open programs and lets you click to switch to any of them; pinned apps also launch from here.
2. Task Manager shows processes/performance (Ctrl+Shift+Esc); Start menu launches programs; File Explorer browses files.

Yaad rakhein: Open windows as buttons at the bottom = taskbar.

Answer: (B) taskbar

Concept: Booting is the start-up process that loads the operating system.

1. BIOS/UEFI firmware (stored on a ROM/flash chip on the motherboard) runs POST, detects hardware and hands control to the bootloader of the OS.
2. CLI/GUI are user interfaces; HDMI/VGA are display ports; 'CGI/ETF' is meaningless here.

Yaad rakhein: Power on → BIOS/UEFI → POST → bootloader → OS.

Answer: (B) BIOS/UEFI

Concept: Word has no separate 'Power Saving Mode'; it follows the operating system's power plan.

1. When Windows battery-saver/power-saving is on, Office apps reduce background activity (animations, background sync, some rendering) to save energy – statement A.
2. Word never converts documents to plain text, nor permanently disables printing/spell-check, and there is no dedicated mode that disables editing.

Yaad rakhein: Power saving is an OS feature; apps only adapt to it.

Answer: (A) MS Word automatically adjusts performance and reduces background operations when the computer's power-saving mode is enabled

Concept: Excel inserts a new column to the left of the selected column.

1. Right-click the column C header → Insert: a blank column appears between B and C (old C becomes D).
2. Clear Contents only erases data; Delete removes a column instead of adding one.

Yaad rakhein: Insert adds to the left (columns) / above (rows) of the selection.

Answer: (A) Right-click on Column C header → Insert

Concept: Each Internet service has a specific job.

1. FTP – file transfer; VoIP – voice calls over the Internet; Email – sending/receiving messages. Option B matches all three correctly.
2. Other options mix them up: WWW is for browsing (not file transfer), Telnet is remote login, FTP is not for browsing or drivers.

Yaad rakhein: FTP = Files, VoIP = Voice, WWW = Web pages, Telnet = remote login, SMTP/POP = Email.

Answer: (B) FTP – transferring files; VoIP – voice communication; Email – sending and receiving messages

Concept: $a^4-b^4=(a^2-b^2)(a^2+b^2)$ and ${\sin }^2\theta +{\cos }^2\theta =1$.

1. ${\sin }^8\theta -{\cos }^8\theta =({\sin }^4\theta -{\cos }^4\theta )({\sin }^4\theta +{\cos }^4\theta )$
2. Dividing by $({\sin }^4\theta +{\cos }^4\theta )$ leaves ${\sin }^4\theta -{\cos }^4\theta =({\sin }^2\theta -{\cos }^2\theta )({\sin }^2\theta +{\cos }^2\theta )={\sin }^2\theta -{\cos }^2\theta$
3. Adding $2{\cos }^2\theta$: ${\sin }^2\theta -{\cos }^2\theta +2{\cos }^2\theta ={\sin }^2\theta +{\cos }^2\theta =1$

Trick: Put $\theta ={45}^{\circ }$: first bracket becomes 0, and $2{\cos }^2{45}^{\circ }=1$.

Answer: (A) 1