Skip to content

MS Office

Normal Study455 questionsPage 13/19

Questions 301–325 of 455 MS Office MCQs — start at page 1 for an overview.

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

Read Mode

Text Boundary Visibility

easy
MS Office

In Microsoft Word, the text boundary can be displayed or hidden from which menu option?

Correct answer: C

A
Customize from Tools menu
B
Auto text option from Insert menu
C
Options from Tools menu
Correct
D
All of above
Explanation and memory cue

In Microsoft Word, the text boundary can be displayed or hidden by going to the 'Options' under the 'Tools' menu. This setting is not found under 'Customize' or 'Auto text'.

302

Read Mode

Shortcut Keys

Easy
MS Office

In InPage, which shortcut key is used for the Title Text Box?

Correct answer: B

A
Ctrl+F7
B
Shift+F3
Correct
C
Ctrl+O
D
Ctrl+T
Explanation and memory cue

In InPage, the shortcut key Shift + F3 is used to create or access the Title Text Box. This feature is commonly used for adding headings or title text in Urdu publishing and page design.

303

Read Mode

Keyboard Shortcuts

easy
MS Office

In Microsoft Word, what is the function of the shortcut key CTRL+W?

Correct answer: C

A
open the Print dialog box
B
Update the current Web page
C
close the current window
Correct
D
None of these
Explanation and memory cue

In Microsoft Word, pressing CTRL+W closes the current document window. It does not open the print dialog or update a web page.

304

Read Mode

Keyboard Shortcuts

Easy
MS Office

In Excel, which key combination is used to select an entire row?

Correct answer: B

A
Ctrl+Space
B
Shift+Space
Correct
C
Alt+Space
D
None of these
Explanation and memory cue

In Microsoft Excel, pressing Shift + Space selects the entire row of the currently active cell. Ctrl + Space is used to select an entire column.

305

Read Mode

Slide Transitions

easy
MS Office

In Microsoft PowerPoint, the entry effect as one slide replaces another during a presentation is called a(n) ____?

Correct answer: B

A
animation
B
slide transition
Correct
C
custom animation
D
preset animation
Explanation and memory cue

In Microsoft PowerPoint, the effect that occurs as one slide replaces another during a presentation is called a slide transition. Animations, on the other hand, are effects applied to objects within a slide.

306

Read Mode

MS Office

easy
MS Office

In a computer spreadsheet, SUM, AVERAGE, MIN, and MAX are examples of ____?

Correct answer: C

A
Calculations
B
Formulas
C
Functions
Correct
D
Relative addressing
Explanation and memory cue

SUM, AVERAGE, MIN, and MAX are all built-in functions in spreadsheet software like Microsoft Excel or Google Sheets. Functions are predefined formulas that perform calculations using specific values, called arguments, in a particular order.

307

Read Mode

Selection Shortcuts

easy
MS Office

In Excel, which key combination is used to select an entire column?

Correct answer: A

A
Ctrl+Space
Correct
B
Shift+Space
C
Alt+Space
D
None of these
Explanation and memory cue

In Microsoft Excel, pressing Ctrl+Space selects the entire column of the active cell. This is a standard keyboard shortcut for column selection.

308

Read Mode

Format Cells Shortcut

easy
MS Office

In Excel, which key combination is used to open the Format Cells window?

Correct answer: D

A
Ctrl+F10
B
Ctrl+6
C
Ctrl+F1
D
Ctrl+1
Correct
Explanation and memory cue

Pressing Ctrl+1 in Excel opens the Format Cells dialog box, allowing users to change cell formatting options such as number, alignment, font, and border.

309

Read Mode

MS Office

easy
MS Office

In a computer spreadsheet, what happens if the current or active cell is B4 and you press the Enter key?

Correct answer: B

A
you will be in the cell A1
B
you will be in the cell B5
Correct
C
you will be in the cell B3
D
you will be in the cell B6
Explanation and memory cue

In most spreadsheet programs, pressing the Enter key moves the selection down to the next cell in the same column. Therefore, if the active cell is B4, pressing Enter will move the selection to cell B5.

310

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers in percentage format?

Correct answer: C

A
Ctrl+Shift+6
B
Ctrl+Shift+3
C
Ctrl+Shift+5
Correct
D
Ctrl+1
Explanation and memory cue

In Microsoft Excel, the keyboard shortcut Ctrl+Shift+5 formats the selected cells as a percentage. This is a quick way to apply percentage formatting without using the ribbon menu.

311

Read Mode

Function/Formula Shortcuts

easy
MS Office

In Excel, which key combination is used to open the formula window?

Correct answer: B

A
Shift+F6
B
Shift+F3
Correct
C
Alt+Shift+F3
D
Alt+Shift+F6
Explanation and memory cue

In Microsoft Excel, pressing Shift+F3 opens the Insert Function dialog box, which is commonly referred to as the formula window. This allows users to search for and insert functions into their worksheet.

312

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers in the currency format?

Correct answer: B

A
Ctrl+Shift+1
B
Ctrl+Shift+4
Correct
C
Ctrl+1
D
Shift+1
Explanation and memory cue

In Microsoft Excel, pressing Ctrl+Shift+4 applies the currency format to the selected cells. The number 4 corresponds to the dollar sign ($) on most keyboards, which is the symbol for currency formatting.

313

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers in the time format?

Correct answer: D

A
Ctrl+Shift+6
B
Ctrl+Shift+3
C
Ctrl+Shift+5
D
Ctrl+Shift+2
Correct
Explanation and memory cue

In Excel, pressing Ctrl+Shift+2 formats the selected cell(s) as time (h:mm AM/PM). This is the standard keyboard shortcut for applying the time format.

314

Read Mode

Columns Labeling

easy
MS Office

In Excel, columns are labeled as ____?

Correct answer: A

A
A, B, C, etc.
Correct
B
1, 2, 3, etc.
C
A1, A2, A3, etc.
D
$A$1, $A$2, etc.
Explanation and memory cue

In Excel, columns are labeled alphabetically as A, B, C, etc., while rows are labeled numerically. The other options refer to row labels or cell references, not column labels.

315

Read Mode

Formula Shortcuts

easy
MS Office

In Excel, which key combination is used to create a formula that sums all of the above cells?

Correct answer: C

A
Ctrl+=
B
Alt+-
C
Alt+=
Correct
D
Ctrl+-
Explanation and memory cue

In Microsoft Excel, pressing 'Alt' and '=' together (Alt+=) automatically inserts the SUM formula for the cells above the current cell. This is a quick shortcut for summing a column of numbers.

316

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers as dates?

Correct answer: C

A
Ctrl+Shift+6
B
Ctrl+Shift+4
C
Ctrl+Shift+3
Correct
D
Shift+1
Explanation and memory cue

In Microsoft Excel, pressing Ctrl+Shift+3 applies the Date format to the selected cells. The other shortcuts apply different number formats.

317

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers in the comma format?

Correct answer: A

A
Ctrl+Shift+1
Correct
B
Ctrl+Shift+4
C
Ctrl+1
D
Shift+1
Explanation and memory cue

In Microsoft Excel, pressing Ctrl+Shift+1 applies the 'Number' format with two decimal places, thousands separator, and a minus sign for negative values, which is commonly referred to as the comma format.

318

Read Mode

Number Formatting

easy
MS Office

In Excel, which key combination is used to format numbers in scientific format?

Correct answer: A

A
Ctrl+Shift+6
Correct
B
Ctrl+Shift+3
C
Ctrl+Shift+5
D
Ctrl+Shift+4
Explanation and memory cue

In Microsoft Excel, pressing Ctrl+Shift+6 applies the scientific number format to the selected cells. This displays numbers in exponential notation (e.g., 1.23E+04).

319

Read Mode

MS Office

Easy
MS Office

If you want to keep track of different editions of a document, which feature will you use?

Correct answer: B

A
Editions
B
Versions
Correct
C
Track Changes
D
All of the above
Explanation and memory cue

The 'Track Changes' feature in MS Word is used to monitor and record edits made within a single version of a document, showing insertions, deletions, and formatting changes as markup. However, to keep track of different editions or complete snapshots of a document over time, the 'Versions' or 'Version History' feature is used. Versions save entire document states at different points, allowing users to view or restore previous editions. Therefore, to keep track of different editions of a document, the correct feature to use is 'Versions'.

320

Read Mode

MS Office

Easy
MS Office

If you press ___, the cell accepts your typing as its contents.

Correct answer: C

A
Tab
B
Ctrl+Enter
C
Enter
Correct
D
Alt+Enter
Explanation and memory cue

In spreadsheet applications such as Microsoft Excel, pressing the Enter key confirms and accepts the data typed into the active cell. After accepting the entry, the selection usually moves to the next cell below.

321

Read Mode

MS Office

Medium
MS Office

If you need to double underline a word, how will you do that?

Correct answer: D

A
From the Format menu, choose the Font option, and then from the Font tab open Underline Style and select Double Underline
B
Go to the Format menu and then the Font option. Open Underline Style and choose Double Underline
C
Click the double underline tool on the formatting toolbar
D
Select the text, then choose Format >> Font, and on the Font tab open Underline Style and choose Double Underline
Correct
Explanation and memory cue

To apply double underline formatting in MS Word, you must first select the text. Then go to Format > Font and choose 'Double Underline' from the Underline Style options on the Font tab.

322

Read Mode

MS Office

Easy
MS Office

In a computer spreadsheet, a block of cells is called ____.

Correct answer: D

A
Workbook
B
Function
C
Column
D
Range
Correct
Explanation and memory cue

In spreadsheet applications like Microsoft Excel, a group or block of selected cells is called a range. A range can include multiple adjacent or non-adjacent cells and is commonly used in formulas and data operations.

323

Read Mode

MS Office

Easy
MS Office

In a computer spreadsheet, rows are labeled ____.

Correct answer: B

A
by letters
B
by numbers
Correct
C
by cell references
D
by symbols
Explanation and memory cue

In spreadsheet applications such as Microsoft Excel, rows are labeled with numbers (1, 2, 3, etc.), while columns are labeled with letters (A, B, C, etc.). This labeling system helps users easily identify and locate specific cells in a worksheet.

324

Read Mode

MS Office

Easy
MS Office

If you will be displaying or printing your document on another computer, you’ll want to make sure to select the ____ option under the ‘Save’ tab.

Correct answer: A

A
Embed Fonts
Correct
B
Embed TrueType Fonts
C
Save TrueType Fonts
D
Save Fonts
Explanation and memory cue

The 'Embed Fonts' option ensures that the fonts used in the document are included with the file. This helps maintain the document’s appearance when opened or printed on another computer that may not have the same fonts installed.

325

Read Mode

MS Office

Easy
MS Office

In a computer spreadsheet, the cell range from A3 through G3 should be entered as ____?

Correct answer: B

A
A3-G3
B
A3:G3
Correct
C
A3?.G3
D
A3 to G3
Explanation and memory cue

In spreadsheet applications such as Microsoft Excel, a colon (:) is used to represent a range of cells. Therefore, the range starting from cell A3 and ending at cell G3 is written as A3:G3.