Office Mixed Concepts Explained: Access, Clipboard, File Formats and Exam Traps

A mixed Office question asks you to choose the right application, object, data type, format or transfer method. That is why memorised menus fail. MS Office Applications for Knowledge of ICT: Worked Word, Excel and PowerPoint Tasks builds a Word-first report and slide deck from an Excel score sheet; the Access-first state trace uses a query and one-time export, then separates a refreshable PowerPoint link from a static Word picture. Use MS Office for CS Teaching Exams for suite fundamentals and classroom tools; menus shift between versions, so the concepts, not the screenshots, are what earn marks.

Choose the Office application from the shape of the task

Microsoft Support calls .accdb the current default Access format. Let the job decide:

1. Prose and page layout? Word.

2. Formulas and cell analysis? Excel.

3. Slides for an audience? PowerPoint.

4. Reusable records, forms, queries or reports? Access.

Copy, paste, save, print and undo are shared, but a Word paragraph, Excel cell, PowerPoint slide and Access record are different objects.

Access objects and field types without the usual confusion

In Classroom.accdb, a table stores, a query selects or calculates, a form controls entry or viewing, and a report lays data out. A form is not stored data; a report is not a filtering rule.

Microsoft Support uses Short Text and Long Text; older material says Text and Memo. .mdb is older, and conversion needs compatibility checks.

Save, export, copy, link and embed are different operations

Save updates the working file. Save As chooses another name, location or supported format. Export creates output for another use. Menus vary, and PDF is not the editable native format of all four applications.

Copy leaves the source and places a transferable representation on the clipboard. Cut marks or removes the source for movement; Paste inserts clipboard content. The current Office Clipboard holds up to 24 items in products listed on Microsoft's Office Clipboard support page, not necessarily every platform or historical version.

An Excel linked object can refresh from its source but depends on that source remaining available. An embedded object carries a non-live copy and can enlarge the destination. A pasted picture is a static snapshot, not editable worksheet data.

Worked example: move six records through four applications

Start with this Access table. Each row also has a Reflection field, irrelevant to this score query.

Apply Section = "A" AND QuizScore >= 60. It returns Asha 72, Deepak 64 and Farhan 90. Bhavna fails the score test; Charu and Esha fail the section test.

Export a one-time Excel copy, with names in A2:A4, scores 72, 64 and 90 in B2:B4, and =AVERAGE(B2:B4) in B5:

• 72 + 64 + 90 = 226

• 226 / 3 = 75.333...

• Formatted to two decimal places, the displayed average is 75.33.

Formatting changes only the display. Insert the chart in Review.pptx as linked, and in Brief.docx as a picture.

Now change Farhan's Excel score from 90 to 96:

• 72 + 64 + 96 = 232

• 232 / 3 = 77.333..., displayed as 77.33

• The rise is 77.33 - 75.33 = 2.00 score points.

After refresh, PowerPoint can show 96 and 77.33. The Word picture stays at 90 and 75.33. Access stays at 90 because Excel received an export, not a live link back.

Shared interface terms and shortcuts need context

The Ribbon holds tabs; each tab arranges related groups and commands. A dialog box collects settings, the Quick Access Toolbar exposes chosen commands, and the status bar shows state. Placement varies, so identify purpose rather than one screenshot.

Shared shortcuts include Ctrl+C, Ctrl+X, Ctrl+V, Ctrl+Z, Ctrl+S, Ctrl+P and Ctrl+F. Each acts on the current selection and app context. In PowerPoint presentation context, F5 can start from the beginning; elsewhere its effect or hardware modifier can differ.

Traps that make plausible distractors look correct

The query returns three records, not four, because Bhavna scores only 58. The first mean is 75.33, not a prematurely rounded 75.3. Editing Excel does not rewrite Access, and refreshing PowerPoint does not refresh Word's picture. “Paste” does not identify a link, embed, table, text or picture; “Office file” identifies no application or extension. Trace the resulting state.

How objective questions test mixed Office concepts

Recurring forms are task matching, extension matching, Access object or field-type selection, shortcuts in context, and linked-versus-static state traces.

1. Which Access object selects Section A scores of at least 60? A query. A table stores, a form provides an interface, and a report presents.

2. After Excel changes 90 to 96, which destination can update after refresh? The linked PowerPoint chart, not the static Word picture or the one-time Access export.

3. Which modern native-format set is correct? Word .docx, Excel .xlsx, PowerPoint .pptx, Access .accdb.

Practise the same distinctions in mixed Office questions, then check your own exam's official notice for marks, timing and syllabus detail.

The short version and the next revision step

• Prose and page layout point to Word.

• A calculation grid points to Excel.

• An audience sequence points to PowerPoint.

• Structured reusable records point to Access.

• Queries select; reports present.

• Links can refresh; pictures stay fixed.

Recompute 75.33 and 77.33, then explain why Access and Word stay unchanged. For the general paper, use the DSSSB Section A 2026 Complete Course. For computer science, use the DSSSB TGT Computer Science 2026 Section B Course. Government Teaching Job Exam Preparation compares related routes.