Microsoft Challenge Exam 100 Questions

A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell. a. special b. sparkline c. sparkle d. section

b. sparkline

A word witha meaning similar to that of another word is called a ______. a. thesaurus b. synonym c. duplicate d. replacer

b. synonym

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message. a. #DIV/0! b. #N/A c. #NULL! d. #REF!

#REF!

A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. a. indirect b. indexed c. direct d. contiguous

a. indirect

Combining two or more selected cells into one cell is called ____ cells. a. merging b. combining c. spanning d. mixing

a. merging

Cell referenced in a formula are called _____. a. assumptions b. content c. comments d. numbers

a. assumptions

Charts can either be embedded in a worksheet or placed in a separate ____. a. chart sheet b. dialog box c. range d. worksheet

a. chart sheet

A _____ is a specific design with coordinating colors, fonts, and special effects. a. documented theme b. chart c. placeholder d. slide show

a. documented theme

The ____, or typeface, defines the appearance and shapes of letters, numbers, and special characters. a. font b. paragraph formatting c. point d. font size

a. font

An accompanying ____ gives audience members reference notes and review material for your presentation. a. handout b. file c. slide d. database

a. handout

Press the ENTER key in all of the following circumstances EXCEPT ____. a. when the insertion point reaches the right margin b. in response to prompts in Word dialog boxes c. to insert a blank line into a document d. to begin a new paragraph

a. when the insertion point reaches the right margin

Every theme has ____ standart colors. a. 4 b. 6 c. 10 d. 8

c. 10

Click ____ to move a stacked object to the top of the stack. a. Move to top b. Move to front c. Bring to front d. Slide to top

c. Bring to front

One way to delete a note is to click immediately to the left of the note reference mark in the document text and then press the ____ key twice. a. BACKSPACE b. ESC c. DELETE d. F3

c. DELETE

Pressing the ____ key instructs Word to replace a building block name with the stored building block entry. a. F1 b. F2 c. F3 d. F4

c. F3

Pressing the _____ key to complete an entry activates the adjacent cell to the right. a. LEFT ARROW b. UP ARROW c. RIGHT ARROW d. DOWN ARROW

c. RIGHT ARROW

To convert a hyperlink to regular text, right-click the hyperlink and then click ____ on the shortcut menu. a. Edit Hyperlink b. Select Hyperlink c. Remove Hyperlink d. Convert Hyperlink

c. Remove Hyperlink

If you use the ___ template, as opposed to a formatted theme, you must make all the design decisions. a. placeholder b. variant c. blank presentation d. ion theme

c. blank presentation

Color ____ indicates that one color is dominating a picutre. a. tone b. hue c. cast d. saturation

c. cast

A ____ may be composed of a few individual objects or several complex groups of objects. a. font b. shape c. clip d. text box

c. clip

A pie chart with one or more slices offset is referred to as a(n) ____ pie chart. a. rasterized b. outer c. exploded d. offset

c. exploded

A ____ paragraph places the first character of a text line near the left border of a placeholder. a. right line b. justified c. left aligned d. centered

c. left aligned

A ____ paragraph places the first character of a text line near the left border of a placeholder. a. justified b. centered c. left-aligned d. right-aligned

c. left-aligned

The bullets button is available on the HOME tab of the Ribbon in the ____ group. a. format b. options c. paragraph d. special characters

c. paragraph

Formatting text in a shape follows the same techniques as formatting text in a ____. a. smart guide b. gallery c. placeholder d. ribbon

c. placeholder

Formatting text ina shape follows the same techniques as formatting text in a ____. a. smart guide b. gallery c. placeholder d. ribbon

c. placeholder

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation. a. boxes b. graphics c. shapes d. background

c. shapes

The increase Font Size button appears on the ____ tab. a. FONTS b. STYLES c. LAYOUTS d. HOME

d. HOME

The default color scheme is called _____. a. Microsoft b. Standard c. Calibri d. Office

d. Office

To advance rightward from one cell to the next in a table, press the ____ key. a. BACKSPACE b. ENTER c. HOME d. TAB

d. TAB

To display the Color gallery, with the graphic selected, click the Color button in the ____ group on the PICTURE TOOLS FORMAT tab. a. format b. options c. tools d. adjust

d. adjust

If you use the ____ template, as opposed to a formatted theme, you must make all design decisions. a. placeholder b. ion theme c. variant d. blank presentation

d. blank presentation

Color ______ indicates that one color is dominating a picture. a. saturation b. hue c. tone d. cast

d. cast

In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text. a. increasing b. promoting c. decreasing d. demoting

d. demoting

A ____ is a specific design with coordinating colors, fonts, and special effects. a. slide show b. chart c. placeholder d. document theme

d. document theme

A ____ is text and graphics that print at the bottom of every page. a. toe b. stopper c. margin d. footer

d. footer

A ____ is a prewritten formula that is built into Excel. a. feature b. task c. calculation d. function

d. function

A powerpoint ___ can help you deliver a dynamic, professional-looking message to an audience. a. database b.calendar c. worksheet d. presentation

d. presentation

A ____ paragraph places the last character of text near the right border of a paragraph. a. left aligned b. centered c. justified d. right aligned

d. right aligned

Dragging or sizing affects only a _____. a. ungrouped object b. collections of objects c. regrouped object d. selected object

d. selected object

A word with a meaning similar to that of another word is called a ________. a. thesaurus b. replacer c. duplicate d. synonym

d. synonym

Clicking the ____ box completes an entry. a. cancel b. enter c. formula d. tab

d. tab

A slide ____ is a special effect used to progress from one slide to the next slide in a slide show. a. theme b. layout c. animation d. transition

d. tranition

An Excel ____ allows data to be summarized and charted easily. a. workflow b. presentation c. document d. worksheet

d. worksheet

Document ____ are the details about a file. a. Properties b. Themes c. Facts d. Keywords

a. Properties

A point is ____ of an inch in height. a. 1/72 b. 1/6 c. 1/5 d. 1/65

a. 1/72

A point is _____ of an inch in height. a. 1/72 b. 1/6 c. 1/5 d. 1/65

a. 1/72

All of the following are valid Excel arithmetic operators EXCEPT _______. a. > b. ^ c. % d. *

a. >

Click _____ to move a stacked object to the top of the stack. a. Bring To Front b. Move to Front c. Slide to Top d. Move to Top

a. Bring To Front

Press ____ to select the entire worksheet. a. CTRL + A b. F1 c. F4 d. ALT + A

a. CTRL + A

Press the ____ key(s) to erase one character to the right of the insertion point. a. DELETE b. END c. CTRL + HOME d. BACKSPACE

a. DELETE

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the paste button is to press the _____ key. a. ENTER b. SHIFT c. ALT d. CTRL

a. ENTER

To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Laucher, click the ____ tab, click the vertical alignment box arrow, click Center in the list, and then click the OK button. a. Layout b. Position c. Alignment d. Format

a. Layout

In the _____ letter style, the date, complimentary close, and signature block are positioned approximately one-half inch to the right of center or at the right margin. a. modified block b. block c. modified semi-block d. all of the above

a. modified block

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function. a. nested b. duplicate c. included d. other

a. nested

Document _____ are the details about a file. a. properties b. keywords c. facts d. themes

a. properties

A ____ reference is an adjusted cell reference in a copied and pasted formula. a. relative b. recycled c. retained d. revised

a. relative

Color ____ changes the intensity of colors. a. saturation b. density c. tone d. brightness

a. saturation

Dragging or sizing affects only a ____. a. selected object b. regrouped object c. collection of objects d. ungrouped object

a. selected object

Adding a _____ to text adds depth and helps the letters display prominently. a. shadow b. sizing handle c. font d. shape

a. shadow

A ______ is a named group of formatting characteristics. a. style b. group c. set d. plan

a. style

Error messages begin with the ____ symbol. a. ! b. # c. ? d. =

b. #

the file type ____ identifies a Word 2016 document. a. .doct b. .docx c. .doc d. .dot

b. .docx

Excel remembers the last ____ actions you have completed. a. 25 b. 50 c. 75 d. 100

b. 100

On most computers, the default font size in Word is _____. a. 8 b. 11 c. 14 d. 16

b. 11

How many chart types does Excel offer? a. 5 b. 15 c. 30 d. 50

b. 15

Press the ____ key(s) to erase one character to the left of the insertion point. a. END b. BACKSPACE c. CTRL + HOME d. DELETE

b. BACKSPACE

The shortcut keys used to center a paragraph are ____. a. CTRL + SHIFT + T b. CTRL + E c. CTRL + M d. CTRL + T

b. CTRL + E

In the _____ letter style, all components of the letter begin flush with the left margin. a. modified block b. block c. modified semi-block d. all of the above

b. block

Click ____ to move a stacked object toward the top of the stack. a. slide forward b. bring forward c. send forward d. move forward

b. bring forward

A ____ may be composed of a few individual objects or several complex groups of objects. a. shape b. clip c. text box d. font

b. clip

The Office ____ is a temporary storage area. a. gallery b. clipboard c. warehouse d. storehouse

b. clipboard

In a multilevel bulleted list slide, creating a lower-level paragraph is called _____ the text. a. increasing b. demoting c. promoting d. decreasing

b. demoting

By default, slides in a new presentation are in ____ orientation. a. right to left b. landscape c. portrait d. top to bottom

b. landscape

A ____ paragraph places the last character of text near the right border of a paragraph. a. justified b. right-aligned c. centered d. left-aligned

b. right-aligned

Color _____ changes the intensity of colors. a. density b. saturation c. brightness d. tone

b. saturation

Many of the shapes included in the ____ gallery can direct the viewer to important aspects of the presentation. a. boxes b. shapes c. background d. graphic

b. shapes

The small squares and circles around a selected graphic are called ____ handles. a. base b. sizing c. shape d. dimension

b. sizing

A _____ group is named group of formatting characteristics. a. group b. style c. set d. plan

b. style

Every theme has ____ standard colors. a. 4 b. 8 c. 6 d. 10

d. 10

If you do not assign a format to a cell or cells in a column, the column width will remain ____ characters. a. 11.65 b .7.52 c. 9.43 d. 8.43

d. 8.43

One wayto add a correctly spelled word to the custom dictionary is to click the ____ button in the Spelling and Grammar dialog box. a. Add to Custom b. Custom Entry c. New Entry d. Add to Dictionary

d. Add to Dictionary

The ____ feature automatically corrects typing, spelling, or grammer errors as you type them. a. Autoentry b. Autospell c. Autoadd d. Autocorrect

d. Autocorrect

Click ______ to move a stacked object toward the top of the stack. a. Send Forward b. Bring Forward c. Slide Forward d. Move Forward

b. Bring Forward

To decrease a font size, use the ____ shortcut keys. a. CTRL + SHIFT + > b. CTRL + SHIFT + < c. CTRL + < d. CTRL + >

b. CTRL + SHIFT + <

To enter a blank line into a document, press the ____ key without typing any text on the line. a. ESC b. ENTER c. CTRL d. ALT

b. ENTER

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide. a. textual elements b. graphical elements c. accents d. hyperlinks

b. graphical elements

By default, slides in a new presentation are in ____ orientation. a. right to left b. landscape c. portrait d. top to bottom

b. landscape

The default view in Word is _____. a. outline view b. headline view c. print layout view d. web layout view

c. print layout view

Adding a ____ to text adds depth and helps the letters display prominently. a. sizing handle b. shape c. shadow d. font

c. shadow

A ____ is text and graphics that print at the top of each page. a. crown b. topper c. margin d. header

d. header

A background feature called ____ allows you to move the background from the slide borders in varying distances by a percentage. a. onsets b. expansion c. reduction d. offset

d. offset

A background feature called _____ allows you to move the background from the slide borders in varying distances by a percentage. a. expansion b. onsets c. reduction d. offsets

d. offsets

Excel automatically appends the ____ to complete the AVERAGE function when you click the Enter box or press the ENTER key. a. left parenthesis b. right bracket c. left bracket d. right parenthesis

d. right parenthesis

A company or department may standardize with a specific ____ so that all of their documents have a similar appearance. a. theme b. scheme c. style d. gallery

a. theme

If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell. a. incline b. orientation c. position d. slope

b. orientation

A powerpoint _____ can help you deliver a dynamic, professional-looking message to an audience. a. calendar b. presentation c. worksheet d. database

b. presentation

A slide _____ is a special effect used to progress from one slide to the next slide in a slide show. a. animation b. transition c. theme d. layout

b. transition

One method of getting the audience's attention and reinforcing the major concepts being presented is to have ____ on the title slide. a. textual elements b. accents c. graphical elements d. hyperlinks

c. graphical elements

An accompanying ____ gives audience members reference notes and review material for your presentation. a. database b. file c. slide d. handout

d. handout