Office software is the part of the Auxiliar Administrativo exam that is most often left for last and the one that decides most. In the State exam it is 50 questions out of 110 and it breaks ties; in the Madrid region it is a whole exercise. These fifteen questions come from the Oposilab office-software tests, with the explanation and the syllabus section they are based on, so you can measure where you stand before planning.
How much office software weighs in each exam
| Exam | Office-software exercise | Questions | Time | Penalty | Source |
|---|---|---|---|---|---|
| Auxiliar Administrativo del Estado | Second part of the single exercise: block II, Windows 11 and Microsoft 365 | 50, plus 5 reserve | Included in the 90 minutes of the whole exercise | One third of a correct answer | BOE-A-2025-26262 |
| Auxiliar Administrativo, Comunidad de Madrid | Second exercise: block II, Windows 11 and Microsoft 365 | 30, plus 5 reserve | 35 minutes | One third of a correct answer | Order 1628/2026 (BOCM of 13 July 2026) |
In the State exam, moreover, ties are broken first by the score of the second part, the office-software one, according to the call itself. The details of each exam are in the "Call and exam" section of each exam page.
The 15 questions
Basic computing, Windows 11 and networks
1. Which type of memory holds the system's boot firmware?
- a)RAM
- b)ROM
- c)L1 cache
- d)Accumulator register
Show answer
Answer: b) ROM memory is non-volatile and holds the system's boot firmware, such as the BIOS or UEFI. Office-software syllabus · Basic computing
2. How do you open File Explorer in Windows 11 with a keyboard shortcut?
- a)Win+R
- b)Win+E
- c)Ctrl+E
- d)Alt+E
Show answer
Answer: b) The keyboard shortcut to open File Explorer in Windows 11 is Win+E. Office-software syllabus · Windows 11
3. What type of multitasking does Windows 11 implement?
- a)Cooperative multitasking
- b)Preemptive multitasking
- c)Sequential multitasking
- d)Distributed multitasking
Show answer
Answer: b) Windows 11 implements preemptive multitasking, where the operating system scheduler assigns CPU time slices to each process and can interrupt it to hand the processor to a higher-priority one. Office-software syllabus · Windows 11
4. Which Wi-Fi standard introduces the 6 GHz band?
- a)Wi-Fi 5
- b)Wi-Fi 6
- c)Wi-Fi 6E
- d)Wi-Fi 7
Show answer
Answer: c) Wi-Fi 6E introduces the 6 GHz band. Office-software syllabus · Networks and the Internet
5. Which type of attack inserts malicious SQL code into web applications?
- a)Man-in-the-Middle
- b)Spoofing
- c)Brute force
- d)SQL injection
Show answer
Answer: d) SQL injection inserts malicious SQL code into input fields of web applications to gain unauthorised access to databases. Office-software syllabus · IT security
6. What does the eIDAS Regulation establish in the context of e-Government?
- a)Rules for electronic archiving
- b)A legal framework for electronic identification and trust services
- c)Regulation of the electronic office
- d)Specifications for electronic invoicing
Show answer
Answer: b) The eIDAS Regulation establishes a legal framework for electronic identification and trust services. Office-software syllabus · e-Government
Microsoft Word
7. Which group on the Home tab in Microsoft Word lets you change the typeface and text size?
- a)Clipboard
- b)Font
- c)Paragraph
- d)Editing
Show answer
Answer: b) The Font group on the Home tab includes options to change the typeface and the text size. Office-software syllabus · Microsoft Word
8. Which option on the Home tab is used to create a bulleted list?
- a)Font
- b)Paragraph
- c)Styles
- d)Editing
Show answer
Answer: b) The Paragraph group on the Home tab includes the option to create bulleted lists. Office-software syllabus · Microsoft Word
Microsoft Excel
9. Which ribbon tab contains the tools to sort and filter data?
- a)Insert
- b)Home
- c)Data
- d)Review
Show answer
Answer: c) The Data tab includes options to sort and filter, as well as other data tools. Office-software syllabus · Microsoft Excel
10. Which of the following is not a text function in Excel?
- a)CONCAT
- b)UPPER
- c)MID
- d)RAND
Show answer
Answer: d) RAND is a mathematical function, not a text function. Office-software syllabus · Microsoft Excel
Microsoft Access, PowerPoint and Outlook
11. How is a many-to-many relationship implemented in Access?
- a)Through an intermediate junction table
- b)Directly between two tables
- c)With unique indexes
- d)Using macros
Show answer
Answer: a) A many-to-many relationship is implemented through an intermediate junction table containing the foreign keys of both tables. Office-software syllabus · Microsoft Access
12. What is a relational database in the context of Microsoft Access?
- a)A set of data organised in tables with relationships established through common fields
- b)A file system that stores documents and media
- c)A program to create charts and presentations
- d)An application to edit text and spreadsheets
Show answer
Answer: a) A relational database in Access organises data in related tables through common fields, following E. F. Codd's relational model. Office-software syllabus · Microsoft Access
13. What does Presenter View allow during a presentation?
- a)Editing the content of the slides
- b)Seeing the speaker notes and the next slide
- c)Rearranging the slides
- d)Applying transitions to the slides
Show answer
Answer: b) Presenter View shows the current slide, the next one and the speaker notes, plus navigation tools. Office-software syllabus · Microsoft PowerPoint
14. Which is a security feature in Outlook mail?
- a)Sending unencrypted messages
- b)Filtering only important emails
- c)Encrypting messages with Microsoft 365 Message Encryption
- d)Automatically deleting all old emails
Show answer
Answer: c) Outlook offers message encryption through Microsoft 365 Message Encryption to protect email content. Office-software syllabus · Microsoft Outlook
Microsoft 365
15. On how many devices can a licensed user install the Microsoft 365 desktop apps?
- a)Three devices
- b)Five devices
- c)Ten devices
- d)Two devices
Show answer
Answer: b) Each Microsoft 365 desktop app can be installed on up to five devices per licensed user. Office-software syllabus · Microsoft 365
How to study office software without it eating the syllabus
- Twenty minutes a day, not one weekend a month. Office software is procedural memory: ribbon tabs, shortcuts, function names. It fades quickly if crammed.
- With the program open. Every missed question is checked by doing the action in Word, Excel or Windows, not by reading.
- Shortcuts on cards. Win+E, Ctrl+E, F2, F4: they are frequent questions and are learnt with spaced repetition.
- One office-software test per week from the first month, even if the legal syllabus is still on topic 3.
On Oposilab the office-software topics have their own topic tests and are part of the mock exams with the call's structure (50 questions in the State exam, 30 in Madrid). You can start with the sample test for Auxiliar Administrativo del Estado or for Auxiliar Administrativo of the Madrid region.
- Which version of Windows and Office is in the exam?
- The 2025 and 2026 calls for Auxiliar Administrativo del Estado and for the Madrid region refer to Windows 11 and Microsoft 365. Always check your call's programme, which is what the board applies.
- How much does office software weigh in the State exam?
- 50 of the 110 questions of the single exercise, in its second part, with 5 reserve questions, and the score of that part is also the first tie-break criterion under the 2025 call.
- And in the Madrid region exam?
- It is its own exercise, the second one: 30 questions plus 5 reserve in 35 minutes, with a one-third penalty, under Order 1628/2026.
- Where do these questions come from?
- From the Oposilab office-software tests for Administrativo and Auxiliar Administrativo del Estado and for Auxiliar Administrativo of the Madrid region, with the explanation and the syllabus section of each one.
