Skip to content

MS Office

Normal Study455 questionsPage 1/19

The MS Office bank is small, at just over 120 published questions, and very specific. It exists because clerical posts such as UDC, LDC and Assistant include a computer-proficiency component in their written tests, and those questions are almost entirely about Microsoft Word and Excel. Word takes the larger share: the interface (ribbon, tabs, status bar), formatting, mail merge and the keyboard shortcuts for common actions. Excel questions focus on number formatting, cell references and basic functions.

A small number of PowerPoint questions round it out. The keyboard-shortcut questions repeat across papers with very little variation, so learning the twenty or so standard shortcuts (copy, paste, undo, save, find, bold, italic and their neighbours) covers a large part of this section. The FIA LDC and Sub Inspector papers from 2021 are the main past-paper sources here. Candidates who use Office daily will find the questions easy; those who have not will find the explanations give exactly the menu path or shortcut needed.

Deep Study ModeFree account required
Showing 1-25 of 455Deep Study (one question at a time, with progress saved) needs a free account.
1

Read Mode

MS PowerPoint

easy2018FIA Sub Inspector Paper 2018 Batch 2
MS OfficeFIA

What is the maximum zoom percentage in MS PowerPoint?

Correct answer: D

A
200%
B
300%
C
400%
D
500%
Correct
Explanation and memory cue

In MS PowerPoint, the maximum zoom percentage allowed is 500%, which enables users to closely inspect slide details. Therefore, option D (500%) is correct, not 400%.

2

Read Mode

MS Excel

easy2018FIA Sub Inspector Paper 2018 Batch 2
MS OfficeFIA

What is the active cell in MS Excel?

Correct answer: B

A
Nearing point of view
B
Rectangular box
Correct
C
Pointer
D
None of these
Explanation and memory cue

In MS Excel, the active cell is the rectangular box or cell that is currently selected and ready for data entry or editing. It is visually highlighted with a border, indicating where the user's input will appear.

3

Read Mode

MS Word

easy2018FIA Sub Inspector Paper 2018 Batch 2
MS OfficeFIA

What is the minimum and maximum font size in MS Word?

Correct answer: A

A
8-72
Correct
B
9-75
C
10-60
D
None of these
Explanation and memory cue

In Microsoft Word, the minimum font size available is 8 points and the maximum standard font size is 72 points. This range is commonly used for text formatting in documents.

4

Read Mode

MS Excel basics

easy2021FIA Sub Inspector Paper 13-12-2021
MS OfficeFIA

How are columns numbered in MS Excel?

Correct answer: A

A
Alphabetic
Correct
B
Numeric
C
Roman
D
None of these
Explanation and memory cue

In MS Excel, columns are labeled alphabetically starting from A, B, C, and so on, rather than numerically or using Roman numerals. This alphabetical labeling helps identify columns uniquely.

5

Read Mode

Microsoft PowerPoint

easy2021FIA Sub Inspector Paper 13-12-2021
MS OfficeFIA

What is the first slide called in Microsoft PowerPoint?

Correct answer: B

A
Title and Content slide
B
Title slide
Correct
C
Blank Slide
D
None of these
Explanation and memory cue

The first slide in Microsoft PowerPoint by default is called the 'Title Slide'. It is designed to include a title and a subtitle, serving as the introductory slide of a presentation.

6

Read Mode

Help options

easy2021FIA UDC Paper 15-12-2021
MS OfficeFIA

MS Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
What is this?
B
Help menu
C
Office assistant
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, Office Assistant, and contextual help like 'What is this?'. Therefore, 'All of them' is the correct answer as it encompasses all these help options.

7

Read Mode

Excel Formulas

easy
MS Office

How can you update the values of formula cells if the automatic calculation mode in Excel is disabled?

Correct answer: A

A
F9
Correct
B
F8
C
F7
D
F6
Explanation and memory cue

When Excel's automatic calculation mode is disabled, pressing F9 forces the workbook to recalculate all formulas, updating the values of formula cells.

8

Read Mode

MS Office Help Features

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

MS Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, Office Assistant, and 'What is this?' tool. Therefore, 'All of them' is the correct answer as it encompasses all these help options.

9

Read Mode

Formatting toolbar (MS Word)

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

How can you access the font size tool on the formatting toolbar in MS Word?

Correct answer: A

A
Ctrl + Shift + P
Correct
B
Ctrl + Shift + S
C
Ctrl + S
D
None of these
Explanation and memory cue

The font size tool in MS Word can be accessed quickly using the shortcut Ctrl + Shift + P, which opens the font size dialog box. The other options do not correspond to font size adjustment shortcuts.

10

Read Mode

MS Office features

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

Microsoft Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, the Office Assistant, and the 'What is this?' tool, so the correct answer is 'All of them'.

11

Read Mode

Microsoft Office help features

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

MS Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, Office Assistant, and the 'What is this?' tool, so 'All of them' is the correct answer.

12

Read Mode

MS Office formatting toolbar shortcuts

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

How can you access the font size tool on the formatting toolbar?

Correct answer: A

A
Ctrl + Shift + P
Correct
B
Ctrl + Shift + S
C
Ctrl + S
D
None of these
Explanation and memory cue

The font size tool shortcut in many MS Office applications is accessed by pressing Ctrl + Shift + P, which opens the font size dialog box. The other options do not correspond to font size adjustment shortcuts.

13

Read Mode

Help Features

easy2021
MS OfficeFIA

MS Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, the Office Assistant, and the 'What is this?' tool, so 'All of them' is the correct answer.

14

Read Mode

Help Features

easy2021
MS Office

MS Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, the Office Assistant, and the 'What is this?' tool, so 'All of them' is the correct answer.

15

Read Mode

MS Word

easy2021
MS Office

How can you access the font size tool on the formatting toolbar?

Correct answer: A

A
Ctrl + Shift + P
Correct
B
Ctrl + Shift + S
C
Ctrl + S
D
None of these
Explanation and memory cue

The font size tool in many MS Office applications can be accessed quickly using the shortcut Ctrl + Shift + P, which opens the font size dialog box. The other options do not correspond to font size adjustment shortcuts.

16

Read Mode

MS Office help features

easy2021FIA LDC Paper 15-12-2021
MS OfficeFIA

Microsoft Office provides help in many ways. Which of these is one of them?

Correct answer: D

A
Help menu
B
Office Assistant
C
What is this?
D
All of them
Correct
Explanation and memory cue

Microsoft Office provides help through multiple features including the Help menu, the Office Assistant, and the 'What is this?' tool, so all options listed are correct.

17

Read Mode

MS Word shortcuts

easy2021FIA Assistant Paper 13-12-2021
MS OfficeFIA

What is the function of Control + N in MS Word?

Correct answer: A

A
Open a new document
Correct
B
Open a new slide
C
Open a new presentation
D
None of these
Explanation and memory cue

In MS Word, pressing Control + N opens a new blank document, allowing the user to start a new file quickly. This shortcut is standard across many Microsoft Office applications for creating new files.

18

Read Mode

MS Word formatting

easy2021FIA Assistant Paper 15-12-2021
MS OfficeFIA

Which menu in MS Word can be used to change character size and typeface?

Correct answer: C

A
Tools
B
View
C
Format
Correct
D
None of these
Explanation and memory cue

The 'Format' menu in MS Word contains options to change character size and typeface, such as Font settings. Therefore, option C is correct.

19

Read Mode

MS PowerPoint

easy2021FIA ASI Paper 21-12-2021
MS OfficeFIA

What is the first slide called in Microsoft PowerPoint?

Correct answer: B

A
Title and Content slide
B
Title slide
Correct
C
Blank slide
D
None of these
Explanation and memory cue

The first slide in Microsoft PowerPoint is typically the 'Title Slide,' which is designed to hold the presentation title and subtitle or presenter information. This is the default first slide layout when creating a new presentation.

20

Read Mode

MS Excel

easy2021FIA ASI Paper 21-12-2021
MS OfficeFIA

How are columns numbered in MS Excel?

Correct answer: A

A
Alphabetic
Correct
B
Numeric
C
Roman
D
None of these
Explanation and memory cue

In MS Excel, columns are labeled alphabetically starting from A, B, C, and so on, which is why the correct answer is 'Alphabetic'.

21

Read Mode

Keyboard shortcuts

easy2021FIA ASI Paper 21-12-2021
MS OfficeFIA

Ctrl + Z is used for _____?

Correct answer: A

A
Undo
Correct
B
Redo
C
Paste
D
None of these
Explanation and memory cue

Ctrl + Z is the standard keyboard shortcut used to undo the last action in most software applications, including MS Office programs.

22

Read Mode

MS Office

easy
MS Office

Which method is used to combine user name and subject with a document in an email system?

Correct answer: A

A
Mail merge
Correct
B
Small Merge
C
Large merge
D
No merge
Explanation and memory cue

Mail merge is the standard method used to combine personalized data such as user name and subject with a document in an email system, allowing customized emails to be sent to multiple recipients efficiently.

23

Read Mode

MS Office

easy
MS Office

Which of the following is an example of word processing software?

Correct answer: B

A
Adobe Photoshop
B
Microsoft Word
Correct
C
VLC Media Player
D
Google Chrome
Explanation and memory cue

Microsoft Word is a widely used word processing software designed for creating, editing, and formatting text documents. The other options are not word processors: Adobe Photoshop is for image editing, VLC Media Player is for playing media files, and Google Chrome is a web browser.

24

Read Mode

Ms Office Macros

Easy
MS Office

Which of the following is the second step in creating a macro?

Correct answer: D

A
Using your mouse or keyboard, perform the task you want to automate
B
Give the macro a name
C
Assign a keyboard shortcut to the macro
D
Start recording
Correct
Explanation and memory cue

In MS Office applications, the typical steps for creating a macro are: first start recording the macro, then perform the actions you want to automate, and finally save or name the macro. Assigning a keyboard shortcut is optional and not necessarily the second step.

25

Read Mode

MS Office

Easy
MS Office

Which of the following fill effects can you use for the slide background?

Correct answer: D

A
Gradient
B
Texture
C
Picture
D
All of the above
Correct
Explanation and memory cue

In presentation software like MS PowerPoint, slide backgrounds can be customized using various fill effects including gradient fills, texture fills, and picture fills. All these options are available in the Format Background pane.

MS Office: common questions

Which Office applications are covered?

Mainly Microsoft Word, then Excel, with a handful of PowerPoint questions. Word questions cover the interface, formatting, mail merge and shortcuts. Excel questions cover number formatting, cell references and simple functions. Outlook and Access are not currently included because past papers did not ask about them.

Do I need a specific version of Office?

No. The questions are written around features and shortcuts that have been stable across versions since the ribbon interface arrived, and a validator checks that the marked answer holds in current versions before publishing. Where a version difference exists, the question is worded to avoid it.

Which posts test MS Office?

Among the FIA papers in the bank, the clerical posts (LDC, UDC and Assistant) ask the most, along with the Sub Inspector and ASI papers from December 2021. Inspector and Assistant Director papers rarely include Office questions, so candidates for those posts can treat this section as optional.