MS Excel, Word and PowerPoint MCQs Review

A comprehensive set of flashcards based on repeated MS Office MCQs for review.

Header and Footer

Insert option in MS Word found in the Insert Menu.

Symbol dialog box

Accessed by clicking the Insert menu and choosing ‘Symbol’.

Cut & Paste

Clipboard option used to move data from one place to another.

Strikethrough

Font option that draws a line through the text.

Highlighter tool

Used to highlight text in Word.

Document Views toolbar

Shortcut is found in the Status bar.

Bullets and Numbering

Found in the Home tab of MS Word.

Open a document

Click on the MS Office button and select Open.

Clipboard Group

Group in the Home tab that includes Cut, Copy and Paste.

Toggle case

Used to switch text from upper case to lower case.

F8 Key

Pressing it three times selects a sentence.

Copyright symbol

Created by pressing Alt+Ctrl+C.

Font size tool

Smallest and largest font sizes available are 8 and 72.

Graphics solution

Includes Clipart, WordArt, Drop Cap in Word.

Ctrl + I

Keystrokes to apply italic format to selected text.

Superscript

A character that is raised and smaller above the baseline.

Thesaurus tool

Used in MS Word for finding synonyms and antonyms.

Drop Caps

Large dropped initial capital letters used to start a paragraph.

Bookmark

Identifies a name for future reference in a document.

Valid version of MS Office

Office XP, Office 2007, but Office Vista is invalid.

Close MS Word application

Cannot be done using File menu then Close submenu.

F12 key

Opens the Save As dialog box.

Shortcut to open a dialog box

Ctrl + F12 opens the Open dialog.

AutoSave feature

Automatically saves the document after a certain interval.

Ruler in MS Word

Does not have the Center Indent option available.

Winword.exe

File that starts MS Word.

Track Changes

Feature to keep track of document editions.

Background effects

Not visible in Print Preview.

Section in Word

A portion of document where certain page formatting options apply.

Borders in Word

Can be applied to Cells, Paragraphs, and Text.

Type of page margin

Center is not a standard margin.

Default left margin in Word 2003

1.25 inches.

Page Orientation

Includes Portrait and Landscape modes.

Change Typeface

Accessed from the Format menu.

Font styles

Superscript is not a recognized font style.

Insert >> Picture >> Clip Art

Displays the Clip Art taskbar.

Insert Table Autofit behavior

AutoFit to Column is not an available option.

AutoFit column width

Done by double-clicking the right border of a column.

False statement about headers

You cannot set different header/footer for the last page of a section.

Vertical alignment

Can be changed in the Page Setup dialog box.

AutoCorrect function

Originally designed to replace misspelled words.

Second step in creating a macro

Assign a keyboard shortcut to the macro.

Mailing list in Word

Known as the Data source.

Mail Merge Helper

Third step is to create the data source.

Button to manage Data Source

‘Edit Data Source’ button.

Modify data source

Possible before merging.

Insert comments in Excel

Done through Insert -> Comment.

Invalid Zoom percentage in Excel

500 is not valid.

Spelling tool location

Found on the Standard toolbar.

Valid data type in Excel

Character is not a valid data type.

Comments in Excel cells

Known as Cell Tip.

Split windows feature

Accessed via View -> Window -> Split.

Activate a cell in Excel

Done by pressing the Tab key.

Fill effects in Excel

Cannot rotate text on the chart.

Insert three columns

Select column E to insert columns between D and E.

Hyperlinks in Excel

All shapes and pictures can be hyperlinks.

Insert picture in template

Done from the Picture toolbar.

Drag selected data to worksheet

Done using Ctrl key.

Print preview in Excel

May display the entire worksheet or selected range.

Sort dialog box

Found under Data menu.

Page break preview

Allows viewing and changing page breaks.

Maximum invalid Zoom percentage

500 is not valid.

Spelling tool location in Excel

Found on the Standard toolbar.

Formatting Currency in Excel

Specify Decimal Places and Currency Symbol.

Number format limitations

Cannot set Currency Symbol.

=TODAY() function

Returns the date value for the current day.

=NOW() function

Enters the current time in a cell.

Merge cells option in Excel

Found in Format Cells dialog box, Alignment Tab.

AutoFormat dialog box decision

Can apply or not apply all formats.

Removing cell borders

Choose None on Border tab.

Page Borders in Excel

Not applicable for Excel worksheets.

Conditions in conditional formatting

Check against both cell value and formula.

Activate previous cell

Not done with any keys.

Sheet types in Excel workbook

Data sheet cannot be a sheet type.

Non-toggle screen components

None can be turned off.

Paste Special dialog options

SQRT is not an available option.

Cell pointer indicator for series fill

Mouse Pointer with anchor at the tip.

Absolute cell reference

$A$1 is the correct format.

Formula initiation symbol

Must begin with = symbol.

Invalid formula entry

10+50 is not correctly entered.

Calculable formulas in Excel

=SUM(A1:A5)/(10-10) will cause a divide by zero error.

Worksheet range

A group of cells.

Auto calculate feature

Provides quick arithmetic results.

Excel cell identification

Uses column letters and row numbers.

Dragging selected range to another worksheet

Must use Ctrl key.

All hyperlink types

Text, Drawing objects, and Pictures.

Selecting a previous cell in range

None of the keys activate this function.

Autosum feature

Used to add a series of numbers.

Formula bar active functions

Edit formula button, Cancel button, and Enter button are visible.

Excel worksheet selections

Rows can be selected entirely.

Entering values in Excel

Using the Formula bar.

Edit embedded Excel worksheet

Use the Excel menu in Word application.

Formula creation

Both values and cell references can be used.

Status indicators

Those are found on the Formula bar.

Excel workbook definition

A collection of worksheets.

Default Excel file extension

.xls.

Logical function outcome

IF function can show TRUE or FALSE.

Running macros in PowerPoint

Done from the Tools menu.

Open Consolidate dialog box

From Tools menu.

Data organization in spreadsheet

Organized in rows and columns.