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