MS Office & Windows — Practice

Question 1

In MS Word, the shortcut key to centre-align the selected text is:
(a) Ctrl+C  (b) Ctrl+E  (c) Ctrl+M  (d) Ctrl+T

Accepted Answer

Ctrl+E centre-aligns (E/L/R/J family). Ctrl+C is copy, Ctrl+M indents, Ctrl+T is a hanging indent.

Answer: (b) Ctrl+E.

Question 2

Which Excel function counts only the cells that contain numbers?
(a) COUNTA  (b) COUNT  (c) SUM  (d) COUNTIF

Accepted Answer

COUNT counts numeric cells; COUNTA counts all non-empty cells; COUNTIF counts by condition.

Answer: (b) COUNT.

Question 3

In Excel, which of these is an absolute cell reference?
(a) A1  (b) $A1  (c) A$1  (d) $A$1

Accepted Answer

$A$1 fixes both the column and the row — copying the formula never shifts it. $A1 and A$1 are mixed references; A1 is relative.

Answer: (d) $A$1. (F4 toggles between the four while editing.)

Question 4

Which key starts a PowerPoint slideshow from the first slide?
(a) F2  (b) F5  (c) F7  (d) F9

Accepted Answer

F5 starts the show from slide 1; Shift+F5 starts from the current slide.

Answer: (b) F5.

Question 5

A PowerPoint file saved with the .ppsx extension will:
(a) open in edit mode  (b) open directly as a slideshow  (c) not open without a password  (d) open only in Word

Accepted Answer

The 's' means show — .ppsx launches straight into presentation mode.

Answer: (b).

Question 6

Files deleted using Shift+Delete in Windows:
(a) move to the Recycle Bin  (b) move to the Documents folder  (c) are permanently deleted, bypassing the Recycle Bin  (d) are compressed automatically

Accepted Answer

Shift+Delete bypasses the Recycle Bin — the file is permanently deleted (recoverable only with special tools).

Answer: (c).

Question 7

In Excel, the shortcut Alt+= (Alt plus equals) performs:
(a) AutoSum  (b) Insert chart  (c) Format cells  (d) Insert current date

Accepted Answer

Alt+= inserts the AutoSum (=SUM of the adjacent range). Ctrl+1 = Format Cells; Ctrl+; = current date.

Answer: (a) AutoSum.

Question 8

The Mail Merge feature in MS Word is used to:
(a) merge two documents into one  (b) create personalised copies of a letter for many recipients  (c) send emails from Excel  (d) combine cells in a table

Accepted Answer

Mail merge combines a main document with a data source (names, addresses) to generate personalised letters/labels for each record.

Answer: (b).

Question 9

The number of rows in an Excel (2007 and later) worksheet is:
(a) 65,536  (b) 262,144  (c) 1,048,576  (d) 16,384

Accepted Answer

2007+ worksheets have 1,048,576 rows (2²⁰) and 16,384 columns (A to XFD). 65,536 rows was the pre-2007 limit.

Answer: (c) 1,048,576.

Question 10

Which shortcut opens the Windows Task Manager directly?
(a) Ctrl+Alt+Del  (b) Ctrl+Shift+Esc  (c) Alt+F4  (d) Win+L

Accepted Answer

Ctrl+Shift+Esc opens Task Manager directly. Ctrl+Alt+Del opens the security screen (with Task Manager as an option); Alt+F4 closes the window; Win+L locks the PC.

Answer: (b).

Question 11

The Excel function =VLOOKUP(value, table, col_index, FALSE) searches for the value:
(a) in the top row of the table  (b) in the first column of the table  (c) across the whole table  (d) in the last column of the table

Accepted Answer

VLOOKUP (Vertical lookup) searches the FIRST COLUMN of the table range and returns a value from the given column index of the matched row. FALSE forces an exact match. (HLOOKUP searches the top row.)

Answer: (b).

Practice — MS Office & Windows

Sign in to save attempts to your dashboard and track your accuracy over time

Find a verified tutor

Join a live course

Browse coaching centres

About

Categories

Support

Documentation

Get Study Tips & Updates

Download Our App

Download for iOS

Download for Android

Popular Cities