Computer Applications 2 Exam Review

38) A template document that contains a macro has the ________ extension. A) .dotm B) .html C) .docx D) .dotx

A) .dotm

393) A newly created template will be saved with a ________ extension. A) .potx B) .pptm C) .pptx D) .ptem

A) .potx

284) When using the QUARTILE.INC function which quartile would include the lowest value in the dataset? A) 0 B) 1 C) 2 D) 3

A) 0

276) How many condition arguments can be defined with the SUMIF function? A) 1 B) 2 C) 3 D) unlimited

A) 1

39) The margins of the Normal template are left, right, top, and bottom. A) 1.00" B) 0.75" C) 1.25" D) 1.5"

A) 1.00"

376) By default, PowerPoint files are saved every ________ minutes. A) 10 B) 15 C) 35 D) 20

A) 10

426) Of the following, which file is NOT a file type? A) 2012 sales prom letter.poxt B) nonprofit collaboration event.png C) report for september conference.pdf D) sales agenda 2012.pptx

A) 2012 sales prom letter .poxt

189) What is the maximum number of scenarios supported by Scenario Manager? A) 32 B) 50 C) 23 D) 45

A) 32

316) PowerPoint allows up to ________ rows and columns in a table. A) 75 B) 25 C) 250 D) 50

A) 75

26) The Ungroup option is available in Word when: A) a group of objects were previously grouped. B) you want to set up a group of objects for the first time. C) you want to add another object to a group of objects. D) you want to regroup a bunch of objects.

A) A group of objects were previously grouped

176) Where are the Expand Field and Collapse Field buttons located within the PivotTable Tools tab? A) Active Field group B) Filter group C) Calculations group D) Data group

A) Active Field group

255) Which of the following functions has the ability to copy all results to a new location? A) Advanced Filter B) IPMT C) DSUM D) DMIN

A) Advanced Filter

243) Which of the following functions will calculate the total interest paid between select periods? A) CUMIPMT B) PPMT C) CUMPRINC D) IPMT

A) CUMIPMT

9) All of the following EXCEPT ________ are preset designs for column settings in Word. A) Center B) Two C) Left D) One

A) Center

241) Which of the following functions will return the interest payment of a loan? A) IPMT B) PPMT C) PMT D) CUMPRINC

A) IPMT

320) Which of the following is TRUE of a subtitle for a table in PowerPoint? A) If you include a subtitle, it should be in a smaller font size. B) A subtitle typically detracts from a table in PowerPoint. C) If a subtitle is used, the font should be slightly larger than the title. D) A subtitle should always be included in a table.

A) If you include a subtitle, it should be in a smaller font size

331) Which of the following happens when you create a chart in PowerPoint? A) Information is entered in Excel and embedded in your presentation. B) Excel opens with a message asking whether you want to open a new worksheet. C) Information is entered in Excel and linked in your presentation. D) The chart is created within PowerPoint.

A) Information is entered in Excel and embedded in your presentation

170) Which of the following is NOT one of the rules regarding good table design? A) Insert rows to separate data B) Use meaningful column labels C) Ensure data accuracy D) Avoid blank rows

A) Insert rows to separate data

100) Which of the following statements about Mark as Final is FALSE? A) It will completely secure the document. B) it will not retain the read-only status if opened in an earlier version of Word. C) It is a toggle setting and anyone can remove the status from the document. D) It enables you to set it as read-only.

A) It will completely secure the document

25) The process of stacking objects one on top of another is called: A) Layering. B) Ungrouping. C) Regrouping. D) Grouping.

A) Layering

237) Which of the following functions does NOT support multiple conditions? A) MATCH B) NOT C) AND D) OR

A) MATCH

30) You embed an object in a document, rather than link it, when you want to: A) make editing changes directly to the embedded object. B) make sure that the object does not appear directly in the Word document. C) make changes to the source file and have the object in Word be updated automatically. D) store the embedded object in its own file and simply tie it to the Word document.

A) Make editing changes directly to the embedded object

416) Which of the following is NOT a content area checked by the Document Inspector? A) Mark as Final B) Custom XML C) Document Properties and Personal Information D) Comments and Annotations

A) Mark as Final

248) Which function will return the total number of periods on a $20000 loan at 5% interest and a $600 payment? A) NPER B) IPMT C) RATE D) PPMT

A) NPER

259) =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n): A) Nested IF function. B) Look Up function. C) Advanced Filter. D) Database function.

A) Nested IF function

195) Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula? A) One-variable data table B) Scenario Manager C) Goal Seek D) Solver

A) One-variable data table

49) All the following statements about Building Blocks are true, EXCEPT that: A) only items approximately a paragraph or less can be saved as a Building Block. B) watermarks and tables can be Building Blocks. C) you can individually name a Building Block that you have created. D) Building Blocks can be used repeatedly without having to recreate or retype the content.

A) Only items approximately a paragraph or less can be saved as a Building Block

288) Which of the following functions will determine the standard deviation of a sample? A) STDEV.S B) STDEVA C) VARA D) STDEV.P

A) STDEV.S

274) Which of the following functions is best suited to add numbers based on one condition? A) SUMIF B) COUNTIF C) COUNTIFS D) SUMIFS

A) SUMIF

364) Which of the following is NOT a timing option setting available for a slide object? A) Set the animation to repeat unlimited times B) Set the animation to rewind C) Set the method for starting an animation D) Determine how an animation is triggered

A) Set the animation to repeat unlimited times

142) All the following are reasons to collaborate online EXCEPT for: A) several friends working on their tax returns. B) small business owners presenting their products or services to potential clients. C) a bunch of college students working on a group project. D) a team of IT professionals living in different countries collaborating on a big project.

A) Several friends working on their tax returns

79) A user can enter data in a form if the fields are: A) shaded. B) in red. C) in bold. D) empty.

A) Shaded

20) ________ displays information in a space along the side of the featured information. A) Sidebar B) Pull quote C) Masthead D) Reverse

A) Sidebar

158) Which is the best tool for managing multiple filters within a PivotTable? A) Slicers B) Refreshing the data C) Sorting D) PivotChart

A) Slicers

388) The ________ is the top slide in a hierarchy of slides. A) slide master B) handout master C) title slide D) notes master

A) Slide master

211) This analysis tool has the ability to handle multiple adjustable cells while minimizing, maximizing, or meeting goals. A) Solver B) Scenario Manager C) Two-variable data table D) Goal Seek

A) Solver

225) Which of the following what-if analysis tools has the ability to limit values to whole numbers? A) Solver B) Scenario Manager C) One-variable data table D) Goal Seek

A) Solver

226) ________ is an Excel add-in. A) Solver B) Goal Seek C) Scenario Manager D) One-variable data table

A) Solver

229) ________ is the best what-if analysis tool to solve complex linear and nonlinear problems. A) Solver B) One-variable data table C) Goal Seek D) Scenario Manager

A) Solver

230) ________ has the ability to restrict variable cells to integers. A) Solver B) Two-variable data table C) Goal Seek D) Scenario Manager

A) Solver

391) The two tabs included in the Colors dialog box to make color choices are: A) Standard and Custom. B) Cold and Warm. C) Custom and Select. D) Color1 and Color2.

A) Standard and Custom

313) Which of the following primarily uses lines, circles, bars, and other shapes to visually depict numerical relationships? A) Statistical charts and graphics B) Posters C) Text-based charts D) Banners

A) Statistical charts and graphics

108) A good password will consist of: A) symbols, letters, and numbers. B) letters. C) numbers. D) symbols.

A) Symbols, letters, and numbers

298) Which of the following is NOT included in an ANOVA summary report? A) TF B) df C) SS D) MS

A) TF

78) In a form template, pressing the ________ key moves a user from one field to the next. A) Tab B) Alt C) Enter D) Shift

A) Tab

37) A ________ is a partially completed document that contains preformatted text and/or graphics. A) template B) Building Block C) Quick Part Galley D) placeholder

A) Template

75) Which of the following is NOT affected by theme effects? A) Text B) Borders around graphics C) Shapes D) SmartArt

A) Text

314) What is a primary difference between text-based charts and statistical charts and graphs? A) Text-based charts are used primarily to illustrate relationships; statistical charts and graphs use points, lines, and other shapes to communicate numerical relationships. B) Text-based charts are limited to text only; statistical charts and graphs can include numbers as well as text. C) Text-based charts add visual description to a presentation; statistical charts and graphs must be interpreted and described only by a presenter. D) Text-based charts have been available in previous versions of PowerPoint; statistical charts and graphs are a new feature of PowerPoint 2013.

A) Text-based charts are used primarily to illustrate relationships; statistical charts and graphs use points, lines, and other shapes to communicate numerical relationships.

129) It is NOT a good idea to substitute spaces in folder and file names with: A) the %20 combination. B) underscores. C) CamelCase notation. D) hyphens.

A) The %20 combination

406) If a slide has several comments, how do you know which is the active comment? A) The comment icon changes color. B) The comment icon changes to bolded border and bolded text. C) The border changes to bold. D) The border color changes.

A) The comment icon changes color

34) When you link a worksheet to a Word document,: A) the formulas remain as formulas B) an error message displays. C) the cells with formulas display as blank cells in the Word document. D) the formulas automatically become values.

A) The formulas remain as formulas

400) How do you know whether a slide is hidden when in Slide Sorter view? A) The slide number displays with a slash. B) The slide number is bold. C) The slide number shows behind a red stop sign image. D) The slide thumbnail shows with a light orange background.

A) The slide number displays with a slash

76) ________ CANNOT be modified. A) Theme effects B) A master document C) Font effects D) Color effects

A) Theme effects

268) When the DAVERAGE function returns #DIV/0: A) there are no records that fit the criteria. B) the incorrect function was used. C) there is a typo in the function. D) a second criteria is needed.

A) There are no records that fit the criteria

180) Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force? A) % of Row Total B) % of Grand Total C) Running Total D) % of Column Total

B) % of Grand Total

380) The ________ and ________ symbols are used to expand and collapse the view of groups within the Customize the Ribbon options of the PowerPoint Options dialog box. A) *; - B) +; - C) #; ! D) ++; +

B) +; -

382) What is the file extension for a customization file that offers a new, customized Ribbon available on other computers? A) .export B) .exportedUI C) .UIRibbon D) .cust

B) .exportedUI

390) How many colors are combined for a color theme? A) 16 B) 12 C) 35 D) 24

B) 12

236) If there are four possible outcomes, how many logical tests are required? A) 4 B) 3 C) 2 D) 1

B) 3

258) What is the maximum number of IF statements in a formula? A) 54 B) 64 C) 32 D) 100

B) 64

235) Which of the following is a nested function? A) =SUM(B6:B10) B) =IF(AND(B7>5),"Yes","No") C) =HLOOKUP(B8,A10:B20,2) D) =VLOOKUP(B8,A10:B20,2)

B) =IF(AND(B7>5),"Yes","No")

12) Which of the following is TRUE about a grid in a document? A) A grid includes only a set of vertical lines in a document. B) A grid does not appear when printed. C) A grid includes only a set of horizontal lines in a document. D) A grid establishes the number of pages a document should have.

B) A grid does not appear when printed

16) When you click a SmartArt design in the Choose a SmartArt Graphic dialog box, ________ displays in the right gallery pane. A) a selection of font styles B) a short description of that specific design C) a gallery of SmartArt styles D) the formatting options for that specific design

B) A short description of that specific design

301) When using the CORREL function a value of 1 would indicate: A) a mild relationship. B) a strong relationship. C) no relationship. D) a weak relationship

B) A strong relationship

422) When you use the Mark as Final feature for a presentation, what does that mean? A) A user can open and edit the file but cannot save it. B) A user can open but cannot edit the file. C) A user cannot open the file. D) A user has unlimited access to the file.

B) A user can open but cannot edit the file

249) Which of the following functions requires all arguments to be true in order to return the value if true? A) OR B) AND C) NOT D) IT

B) AND

252) Which of the following logical functions will return a value if false if one of the arguments is false? A) IF B) AND C) NOT D) OR

B) AND

412) Where does the Document Properties panel appear when in Normal view? A) In a separate dialog box B) Above the selected slide C) In a panel to the right of the selected slide D) Below the selected slide

B) Above the selected slide

227) A list of active add-ins can be viewed in the ________. A) Data tab B) Add-Ins Dialog box C) Scenario Dialog box D) View tab

B) Add-Ins Dialog box

410) When merging and comparing presentations, when does the Revisions pane open? A) Immediately after you open the original presentation B) After you click Merge on the Review tab C) After you click Compare on the Review tab D) As soon as you click the Review tab

B) After you click Merge on the Review tab

322) Which of the following is NOT a vertical alignment option in PowerPoint? A) Center Vertically B) Align Text Left C) Align Top D) Align Bottom

B) Align Text Left

66) Which of the following statements is TRUE about the headings in the Navigation Pane? A) Each heading has an associated thumbnail. B) All headings are formatted with the styles feature. C) All headings are displayed in bold and italics. D) Each heading is defined as a subdocument.

B) All headings are formatted with the styles feature

256) When using Advanced Filtering empty cells in the criteria range will return which of the following? A) Select records B) All records C) No records D) NA

B) All records

275) Which of the following functions is best suited to count numbers based on multiple conditions? A) SUMIF B) COUNTIFS C) SUMIFS D) COUNTIF

B) COUNTIFS

65) Which of the following statements is TRUE about master documents and subdocuments? A) When a master document is locked, all subdocuments are automatically unlocked. B) Changes can be made to a master document at any time, but to subdocuments only when they are unlocked. C) You can issue locks to all the subdocuments collectively. D) When a master document is locked, all subdocuments are locked.

B) Changes can be made to a master document at any time, but to subdocuments only when they are unlocked

337) When a chart is selected and you click the Chart Tools Design tab and the Change Chart Type button, ________ display in the left pane and ________ display in the right pane. A) common charts; less common charts B) chart types; chart subtypes C) 3-D chart types; 2-D chart types D) chart subtypes; chart types

B) Chart types; chart subtypes

368) How do you animate text beyond the first bulleted-level on a slide? A) Click the Effect Options button on the Animations tab B) Click the Animation Dialog Box Launcher C) Right-click and click Animate Text D) Right-click and click Beyond

B) Click the animation dialog box launcher

403) Of the following, ________ can be described as similar to sticky notes on slides of a presentation. A) collaboration B) comments C) markups D) ink annotations

B) Comments

60) The ________ feature in Word evaluates the contents of two or more documents and displays the differences between them. A) View Side by Side B) Compare C) Combine D) Track Changes

B) Compare

299) Which data analysis tool is best suited to measure how two sets of data vary simultaneously? A) Correlation B) Covariance C) Variance D) Histogram

B) Covariance

379) Which of the following is NOT an option available in the Customize Ribbon option of PowerPoint 2013? A) Create a new tab. B) Create a new button . C) Change the order of tabs. D) Change the order of groups on a tab.

B) Create a new button

164) Which of the following is NOT a benefit of PowerPivot? A) Create relationships B) Create web queries C) Maintain connections D) Import data from multiple sources

B) Create web queries

250) Which database function will return the largest value from a dataset based on preset criteria? A) DMIN B) DMAX C) DSUM D) DCOUNT

B) DMAX

228) When active the Solver add-in is located on the ________ tab. A) Formulas B) Data C) Insert D) View

B) Data

175) Which of the following is NOT an area of the PivotTable Fields task pane? A) Filters Area B) Data Area C) Rows Area D) Columns Area

B) Data area

167) Where is the Subtotal command located on the Ribbon? A) Backstage B) Data tab C) View tab D) Insert tab

B) Data tab

147) When using subtotal, what does the 4th button of the outline levels do? A) Collapses the outline to display the grand total only B) Displays the entire list C) Displays subtotals by the main subtotal category and the grand total D) Displays subtotals by the main subtotal category, the secondary subtotal category, and the grand total

B) Displays the entire list

163) When setting custom calculation options in a PivotTable, what does Running Total calculate? A) Displays each value as a percentage of the respective column total. The values in each column total 100% B) Displays values as running totals C) Displays values as: (value for the item) / (value for the parent item on rows) D) Displays each value as a percentage of the grand total

B) Displays values as running totals

319) Which of the following buttons is part of the Table Tools Design tab? A) Table Row Height B) Draw Table C) Merge Cells D) Distribute Columns

B) Draw Table

62) Which of the following statements about subdocuments is TRUE? A) You cannot edit a subdocument as an independent document once it is inserted into a master document. B) Each subdocument is stored in its own file. C) Each subdocument must be printed separately. D) If you delete a subdocument from within a master document, it will be deleted permanently.

B) Each subdocument is stored in its own file

295) The Analysis ToolPak can be activated in: A) Formula tab. B) Excel Options. C) Developer tab. D) Review tab.

B) Excel Options

99) All the following functions are available from the Macros dialog box, EXCEPT ________ a macro. A) run B) export C) delete D) edit

B) Export

169) Which of the following is NOT true regarding data mining? A) Analyzes large amounts of data B) Exports data C) Uses advanced statistical techniques D) Identifies trends

B) Exports data

246) Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years? A) IPMT B) FV C) NPV D) PV

B) FV

157) Which of the following options is the best tool when using a PivotTable that contains more data than you currently need? A) Removing a value field B) Filtering C) Refreshing the data D) Sorting

B) Filtering

197) In order to complete a two-variable data table, which of the following must be included in the table? A) Constraint B) Formula C) Integer D) Absolute reference

B) Formula

209) Which what-if analysis tool is best for manipulating one variable to determine one result? A) One-variable data table B) Goal Seek C) Solver D) Scenario Manager

B) Goal Seek

214) Which what-if analysis tool is best to determine the number of t-shirts to sell in order to earn $500 with no constraints? A) Two-variable data table B) Goal Seek C) Solver D) Scenario Manager

B) Goal Seek

215) Which what-if analysis tool is best suited to determine the input value needed to achieve a specific output? A) Solver B) Goal Seek C) Scenario Manager D) Two-variable Data Table

B) Goal Seek

2) All of the following EXCEPT ________ are considered techniques for readability and attractiveness of desktop publishing documents. A) borders B) grids C) tables D) lists

B) Grids

401) When you are viewing a presentation and arrive at a hidden slide, press ________ to reveal the slide. A) R B) H C) F4 D) the slide number

B) H

389) How can you differentiate the slide master from the layout masters when in Slide Master view? A) A unique tab displays when it is selected. B) It is larger than the other masters. C) It retains an orange background to show it is different than the rest. D) It has a black, bold outline and the others do not have an outline.

B) It is larger than the other masters

348) It is recommended that when you link from a menu slide in a presentation to a topic slide in the same presentation, you should create a(n): A) automatic link to the following slide. B) link back to the menu slide. C) submenu on the follow-up slide. D) link to the final slide in the presentation.

B) Link back to the menu slide

22) ________ is NOT a category of shapes in the Shapes gallery. A) Equation Shapes B) List C) Rectangles D) Callouts

B) List

143) All the following are ways that you can share your document or meeting invitation's hyperlink with your audience EXCEPT to: A) click Copy Link to copy and paste the meeting invitation's hyperlink. B) mail a printed copy to the attendees' home or work address. C) click Send in Email to send the meeting hyperlink. D) post to Blog.

B) Mail a printed copy to the attendees' home or work address

7) Of the following options, ________ is NOT part of a style in Word. A) tabs B) margins C) indents D) line spacing

B) Margins

186) What what-if analysis tool would you use to compare the impact of different interest rates on a car payment? A) Solver B) One-variable data table C) Goal Seek D) Two-variable data table

B) One-variable data table

281) Which function is best suited to determine a student's test score percentile based on all class scores? A) AVERAGEIFS B) PERCENTRANK.EXC C) RANK.AVG D) AVERAGE

B) PERCENTRANK.EXC

245) Which function will calculate the current value on an investment that will earn 5% interest on yearly payments of $100 over 10 years? A) PMT B) PV C) NPV D) FV

B) PV

407) When you select Pointer Options while running a slide show, you can select ________ or ________. A) Felt Pen; Ball Point Pen B) Pen; Highlighter C) Marker; Pen D) Pen; Pencil

B) Pen; Highlighter

172) Which of the following is the best tool for analyzing employee performance over a period of time? A) Subtotals B) PivotTable C) Data table D) Outline

B) PivotTable

19) A phrase or sentence copied from an article to emphasize a key point is known as a ________. A) reverse B) pull quote C) masthead D) sidebar

B) Pull Quote

277) Which of the following functions will use average values to determine the rank of a number within a list if duplicate values are present? A) PERCENTILE B) RANK.AVG C) RANK.EQ D) RANK

B) RANK.AVG

294) Which of the following tools is NOT included in the Analysis ToolPak? A) Correlation B) Rank Average C) Anova: Single Factor D) Covariance

B) Rank Average

80) When printed, the data entered into fields appears as ________ text. A) italicized B) regular C) bolded D) bigger

B) Regular

165) What is the best PowerPivot tool when attempting to link to tables with a common related field? A) Links B) Relationships C) External references D) Pivot

B) Relationships

114) The Ribbon can be customized by: A) clicking the Home tab. B) right-clicking the Ribbon. C) clicking the Design tab. D) right-clicking the File tab.

B) Right-clicking the ribbon

98) Which of the following statements about running a macro is TRUE? A) Running a macro is the same as recording a macro. B) Running a macro is faster than manually choosing each command. C) A macro can be run from the Review tab. D) A macro can be run from the NewMacros dialog box.

B) Running a macro is faster than manually choosing each command

290) Which function is best suited to determine how the data set is spread around the mean? A) CORREL B) STDEV.P C) VARA D) COVARIANCE

B) STDEV.P

177) What is the default summary statistic for numerical fields in a PivotTable? A) Average B) SUM C) COUNT D) STDEV

B) SUM

398) To show a hyperlinked presentation, click the: A) File tab and all custom show names will display. B) Slide Show tab, click the Custom Slide Show button, and select the name of the main custom slide show. C) Design tab, click the Custom Slide Show button, click Hyperlinked File, and click a file name. D) Slide Show tab, click the Custom Slide Show button, and select the file name of the custom show.

B) Slide Show tab, click the Custom Slide Show button, and select the name of the main custom slide show

204) Which of the following tools can manipulate changing variable cells? A) Goal Seek B) Solver C) One-variable data table D) Two-variable data table

B) Solver

212) How can you determine if the Solver add-in is active? A) Solver appears in the Goal Seek dialog box. B) Solver appears on the Data tab. C) Solver is an option on the Home tab. D) Solver is available via right-click.

B) Solver appears on the Data tab

64) A padlock is associated with the ________ feature in Word. A) Master documents B) Subdocuments C) Combine D) Compare

B) Subdocuments

424) Which of the following is TRUE about passwords? A) It is best to use a word located in a standard dictionary. B) Symbols can be included in a password. C) Passwords are not case-sensitive. D) Repeated characters signify a strong password.

B) Symbols can be included in a password

53) When the documents display side by side, the ________ command is active by default. A) Reset Window Position B) Synchronous Scrolling C) Combine D) Compare

B) Synchronous scrolling

89) Which of the following statements is TRUE about passwords? A) They must include letters and numbers. B) They are case sensitive. C) They must consist of letters, numbers, and symbols. D) You type the password into the General Options tab.

B) They are case sensitive

58) The ________ feature of Word is most often preferred when you submit a document to others and request feedback. A) Side by Side B) Track Changes C) Combine D) Compare

B) Track changes

14) Headings in a newsletter should be set in type sizes at least ________ points larger than the text in the body of the document. A) three B) two C) four D) five

B) Two

289) Which of the following will determine the variance of a population? A) VAR.S B) VAR.P C) VARPA D) VARA

B) VAR.P

381) Which of the following is TRUE about adding a new tab to the PowerPoint Ribbon? A) Three default groupsNew Group1, New Group2, and New Group3are added to the new tab. B) When a new tab is created, one new group is automatically added to it. C) Once a tab is added, it cannot be removed. D) When a new tab is added, only one group, originally named New Group (Custom), can be included on the tab.

B) When a new tab is created, one new group is automatically added to it

377) What are the two primary options that can be changed in the PowerPoint Save options? A) In what format and where to save the backup file B) When and where to save the backup file C) How and when to save the backup file D) In what format and when to save the backup file

B) When and where to save the backup file

361) When would a motion path only display a starting point and not an ending point? A) When the motion path is combined with a second motion path B) When the motion path is a closed path like an oval C) When the motion path ends somewhere off of the slide D) When the motion path follows a straight line

B) When the motion path is a closed path like an oval

306) When using the CORREL function, a value of .00007 would indicate: A) a strong relationship. B) an inverse relationship. C) a weak relationship. D) no relationship.

C) A weak relationship

262) Which of the following functions should be used to evaluate multiple conditions with only two possible outcomes? A) DSUM B) DMAX C) AND D) IF

C) AND

383) Which of the following is NOT a shape-related command that can be added to a new tab? A) Combine Shapes B) Intersect Shapes C) Add Shapes D) Subtract Shapes

C) Add shapes

240) Which of the following has the ability to restrict data view to only information that fits predetermined criteria? A) INDEX B) VLOOKUP C) Advanced Filter D) HLOOKUP

C) Advanced Filter

365) Which of the following is FALSE in regard to animations? A) Direction, smoothing, and sound are animation effects associated with some animations. B) Each animation has associated settings that vary. C) All animation effects are accessible from the Effect Options in the Animation group. D) Some animations are only available by clicking the Animation Dialog Box Launcher.

C) All animation effects are accessible from the Effect Options in the Animation group

111) A digital certificate is: A) an electronic stamp that displays information about a person or an organization. B) the digital signing of a document. C) an attachment that guarantees authenticity of a file, provides a verifiable signature, or enables encryption. D) a service that is designed to help control who has access to particular documents.

C) An attachment that guarantees authenticity of a file, provides a verifiable signature, or enables encryption

413) Which of the following document properties is entered automatically? A) Author and subject B) Date and time C) Author and title D) Title and keywords

C) Author and title

375) The feature that automatically changes something that you type in PowerPoint to something else is ________. A) AutoFormat B) Contextual spelling C) AutoCorrect D) the Spelling checker

C) Auto Correct

136) A ________ can be a way for current or future journalists and authors to share their work. A) Web page B) Web server C) blog D) background

C) Blog

31) One of the advantages of linking an Excel worksheet to a Word document is that the Excel worksheet: A) becomes part of the Word document and is no longer tied to Excel. B) is no longer connected to the original source. C) can be linked to more than one document at the same time. D) can be edited in Word.

C) Can be linked to more than one document at the same time

174) Which of the following appears in the PivotTable Fields task pane? A) Filter area B) Plot area C) Choose fields to add to report D) Rows area

C) Choose fields to add to report

23) All of the following EXCEPT ________ are fill options for a shape. A) Texture B) Gradient C) Clip art D) Picture

C) Clip art

335) A ________ is the default chart style in the Insert Chart dialog box. A) 3-D Column B) Clustered Bar C) Clustered Column D) Line

C) Clustered Column

104) If you set the ________ or No changes (Read only) restrictions, you can specify user exceptions for a document. A) Tracked Change B) Styles C) Comments D) Filling in Forms

C) Comments

408) Which of the following is TRUE about printing comments? A) A maximum of 10 comments can be printed with one presentation. B) Annotations can be printed, but comments cannot. C) Comments are printed on a separate page. D) Comments are only printed when you print handouts.

C) Comments are printed on a separate page.

362) The mouse arrow changes to a ________ when you draw a motion path for an object to follow. A) four-headed arrow B) double-headed arrow C) crosshair pointer D) hand

C) Crosshair pointer

77) Which of the following statements is FALSE about a form template? A) A form template enables the user to enter data but NOT edit the form. B) Data can be entered only in specific places. C) Data can be entered in any location on a document form. D) It includes the standard layout, structure, and formatting of a form.

C) Data can be entered in any location on a document form

199) Where is Scenario Manager located in Excel? A) View tab B) Backstage C) Data tab D) Formula tab

C) Data tab

302) When active, where does the Analysis ToolPak appear? A) Insert tab B) View tab C) Data tab D) Formulas tab

C) Data tab

18) WordArt can be used to create ________ text to add interest to the text. A) straight B) cursive C) decorative D) pull quote

C) Decorative

126) The Page Color command is accessible from the ________ tab. A) Insert B) Home C) Design D) File

C) Design

96) Which of the following macro security settings is the default setting in Word? A) Disable all macros except digitally signed macros B) Disable all macros without notification C) Disable all macros with notification D) Trust access to the VBA project object model

C) Disable all macros with notifications

156) What does the Values Area of a PivotTable do? A) Organizes and groups data into categories on the left side. Each group name occupies a single row B) Subdivides data into one or more additional categories C) Displays summary statistics, such as totals or averages D) Filters the data to display results based on particular conditions you set

C) Displays summary statistics, such as totals or averages

182) Which of the following is NOT a PivotTable Subtotals option? A) Show All Subtotals at Bottom of Group B) Do Not Show Subtotals C) Do Not Include Filtered Items in Totals D) Include Filtered Items in Totals

C) Do Not Include Filtered Items in Totals

56) You open two documents in the Side by Side view. When you close the Side by Side view, the ________ will be the active one. A) document that you made major changes to B) second document that you opened when you enabled the Side by Side view C) document that contained the insertion point when you closed the Side by Side view D) first document that you opened when you enabled the Side by Side view

C) Document that contained the insertion point when you closed the Side by Side view

83) A ________ form control enables a user to select from a list of the 50 states. A) check box B) combo box C) drop-down list D) text

C) Drop-down list

85) The ________ form control is most often used. A) date picker B) option button C) drop-down list D) rich text

C) Drop-down list

378) Which of the following is TRUE about embedding fonts in a presentation? A) Embedding fonts in a presentation compresses the file. B) Embedding fonts ensures that your entire font set on your computer will be installed on another computer. C) Embedding fonts increases the file size of a presentation. D) Embedding fonts is a new feature of PowerPoint 2013.

C) Embedding fonts increases the file size of a presentation

307) What function is best suited to determine how often a set of numbers appears within a dataset? A) SUMIFS B) AVERAGEIF C) FREQUENCY D) SUMIF

C) FREQUENCY

133) ________ is the most common way to upload Web pages to a location view able through the Internet. A) HTML B) WWW C) FTP D) XML

C) FTP

145) Search for blank design templates on the ________ tab. A) Home B) Design C) File D) Insert

C) File

139) Of the following blog Web sites, only ________ is NOT supported by Word. A) SharePoint Blog B) Telligent Community C) Flickr D) Blogger

C) Flickr

198) What is the best tool to determine the required down payment to reach a $700 car payment? A) Scenario Manager B) One-variable data table C) Goal Seek D) Solver

C) Goal Seek

219) If Doug would like to determine how many hot dogs to sell at a profit margin of $10.00 to raise $250.00 without constraints, which what-if analysis tool should he use? A) Two-variable data table B) Solver C) Goal Seek D) Scenario Manager

C) Goal Seek

185) What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded? A) Slicers B) Outlines C) Grouping D) PivotTables

C) Grouping

346) How is the color of hyperlinks determined in a presentation? A) Accessed hyperlinks are always green and bold; unaccessed hyperlinks are always blue and underlined. B) Accessed hyperlinks are always black and italics; unaccessed hyperlinks are always black and underlined. C) Hyperlink colors are determined by the theme you apply to the presentation. D) Hyperlink colors are determined by the type of object or page to which you link.

C) Hyperlink colors are determined by the theme you apply to the presentation

239) Which function will return the intersection of a specific row and column? A) VLOOKUP B) MATCH C) INDEX D) HLOOKUP

C) INDEX

3) Shading is especially useful in a newsletter: A) to provide predefined styles for characters and/or paragraphs. B) to help organize information by emphasizing important topics. C) in the absence of clip art or other graphics. D) to represent a process or a hierarchy chart.

C) In the absence of clip art or other graphics

86) When a user enters data into an electronic form, the fields in the form are automatically accessed: A) from the top of the page to the bottom. B) from the top-left corner to the bottom-right corner. C) in the order in which the developer inserted them. D) from the left to the right of the table.

C) In the order in which the developer inserted them

153) Where is the command to insert a PivotTable located in the Ribbon? A) Developer tab B) Data tab C) Insert tab D) Formulas tab

C) Insert tab

417) The Accessibility Checker locates accessibility issues and assigns them to a category. Which of the following is NOT one of the Accessibility Checker categories? A) Warning B) Error C) Issue D) Tip

C) Issue

88) If you forget the password of a form,: A) you can still open the document. B) the file can still be accessed by the creator of the form. C) it cannot be recovered. D) you can click the Stop Protection button in the Restrict Editing pane.

C) It cannot be recovered

257) When using Advanced Filtering < > is the equivalent of: A) less than. B) equal to. C) not equal to. D) greater than.

C) Not equal to

315) How many slides are needed to create a poster or banner in PowerPoint? A) A minimum of five B) A minimum of three C) One D) Two

C) One

130) ________ is an allowable bookmark. A) 123Main B) 1 period C) Order_Number D) Order Number

C) Order_Number

5) The purpose of using lists in a newsletter is to: A) emphasize the top portion of a newsletter. B) stick to one font family or size. C) organize information by emphasizing important topics. D) add personality to a newsletter.

C) Organize information by emphasizing important topics

429) If your default e-mail client is ________, you can send a presentation file directly from PowerPoint. A) Hotmail B) Yahoo! C) Outlook D) Gmail

C) Outlook

73) Which of the following is NOT a part of theme colors? A) Text and background colors B) Accent colors C) Page color D) Hyperlink colors

C) Page color

332) Which of the following PowerPoint charts is limited to only one data series? A) Line chart B) Bar chart C) Pie chart D) Column chart

C) Pie chart

181) Where are PivotTable formatting tools located? A) Data tab B) Insert tab C) PivotTable Tools Design tab D) PivotTable Tools Analysis tab

C) PivotTable Tools Design tab

282) Which of the following functions will exclude quartiles 0 and 4 in its calculations? A) QUARTILE.INC B) PERCENTILE.EXC C) QUARTILE.EXC D) QUARTILE

C) QUARTILE.EXC

247) Which function will calculate the periodic interest rate of a loan with a $500 payment on a $20000 loan paid back over 5 years? A) NPV B) FV C) RATE D) PV

C) RATE

222) Which of the following calculations on the target cell is NOT supported by Solver? A) Minimize B) Exact value C) Range D) Maximize

C) Range

144) Which of the following statements about sharing meeting notes during an online presentation is FALSE? A) You can share a particular page of a whole document. B) You can share meeting notes with an audience. C) The attendees cannot receive updated document instantly. D) You can share a section of a whole document.

C) The attendees cannot receive updated document instantly

109) What happens when you attempt to open a document that is password-protected against unauthorized modifications? A) The file opens as usual, but a Password box opens when a user tries to modify the file. B) The file will not open unless the user changes the options in the Word Options dialog box. C) The Password dialog box opens. D) The file cannot be opened and is inaccessible.

C) The password dialog box opens

329) What happens when you double-click a linked object in PowerPoint? A) The shortcut menu pops up and you can click Open to edit the file. B) The object opens for editing in PowerPoint. C) The source application opens and you can edit the source object. D) An error pops up that notifies you that the source application cannot be accessed.

C) The source application opens and you can edit the source object

352) Which of the following is NOT a ready-made action button in PowerPoint? A) Home B) Sound C) Title D) End

C) Title

95) Which of the following macro security settings is ONLY to be used by developers? A) Enable all macros B) Disable all macros with notification C) Trust access to the VBA project object model D) Disable all macros without notification

C) Trust access to the VBA project object model

266) When using Advanced Filtering, the criteria range must contain at least: A) three rows. B) one columns. C) two rows. D) three columns.

C) Two rows

402) While in Slide Show view, if you want to reveal a hidden slide and you are aware of the slide number: A) type the slide number and press H to display it. B) press F12. C) type the slide number and press Enter to display it. D) press F3 and choose the title from the list.

C) Type the slide number and press Enter to display it

384) Which of the following shape commands combines overlapping objects so they become one shape? A) Add B) Intersect C) Union D) Combine

C) Union

123) What is the relationship between Word and HTML? A) The majority of Word templates include HTML code. B) The Word program is written in HTML code. C) When saved as web pages, documents created in Word generate HTML code. D) The Word program uses HTML code

C) When saved as web pages, documents created in Word generate HTML code

69) All the following statements about bookmarks are true, EXCEPT that: A) a bookmark will help you return to a specific location quickly. B) you can bookmark anything in Word, including headings , charts, and pictures. C) you should try to use long, descriptive names for your bookmark. D) you may sort bookmarks according to the bookmark name or the bookmark location in the document.

C) You should try to use long, descriptive names for your bookmark

286) The second quartile of both QUARTILE.EXC and QUARTILE.INC defines what percentile? A) 0 B) 25th C) 75th D) 50th

D) 50th

312) When using the QUARTILE.INC function a quartile of 3 represents which percentile? A) 25th B) 100th C) 50th D) 75th

D) 75th

51) ________ is a type of Building Block. A) Quick Part Gallery B) Template C) Bookmark D) AutoText

D) Autotext

323) The ________ option formats even columns differently than odd columns. A) Header Row B) Banded Rows C) Table Style D) Banded Columns

D) Banded Columns

394) How are slides listed in the left pane of the Define Custom Show dialog box when you are ready to create a custom show? A) By the type of slide layout B) By the slide number and slide text C) By the slide title D) By the slide number and title of the slide

D) By the slide number and title of the slide

419) Which of the following could prevent you from saving features that will not be visible when your coworker with PowerPoint 2003 views your presentations? A) Accessibility Checker B) Document Inspector C) Mark as Final D) Compatibility Checker

D) Compatibility Checker

55) All the following statements about the purpose of viewing documents side by side are true, EXCEPT to: A) display two documents on the same screen. B) cut or copy a portion from one document to another. C) compare an original to a revised document. D) create master and subdocuments.

D) Create master and subdocuments

110) All of the following are options for passwords EXCEPT: A) changing a password once you have created one. B) removing a password. C) creating one password to open a file and a different one to modify the file. D) creating two different passwords to open a document.

D) Creating two different passwords to open a document

97) All of the following statements are ways to open and access a macro, EXCEPT: A) View tab, click Macros, click View Macros. B) Alt+F8. C) Developer tab, click Macros. D) Ctrl+F8.

D) Ctrl+F8

421) Which of the following is NOT part of the Protect Presentation feature of PowerPoint? A) Encrypt with Password B) Mark as Final C) Add a Digital Signature D) Document Inspector

D) Document Inspector

112) A digital signature ensures all of the following EXCEPT that the information: A) is valid. B) comes from you. C) has not been changed after you signed it. D) does not contain a virus.

D) Does not contain a virus

74) Shadowing, glows, and borders are part of the theme: A) templates. B) colors. C) fonts. D) effects.

D) Effects

357) Which of the following is NOT a type of PowerPoint animation? A) Motion Path B) Entrance C) Emphasis D) End

D) End

318) When you've finished drawing a table in PowerPoint using the drawing tool, press the ________ key. A) Alt B) Delete C) Ctrl D) Esc

D) Esc

41) Templates can be selected from the Backstage View by clicking the ________ tab. A) Page Layout B) Home C) Insert D) File

D) File

155) What does the Filters Area of a PivotTable do? A) Displays summary statistics, such as totals or averages B) Organizes and groups data into categories on the left side. Each group name occupies a single row C) Subdivides data into one or more additional categories D) Filters the data to display results based on particular conditions you set

D) Filters the data to display results based on particular conditions you set

423) When you send a file that you have marked as Final to a coworker, which of the following is TRUE? A) It is not possible for the coworker to edit the file. B) The file will automatically open for editing. C) Opening the file will require a password. D) Final status of the file can be turned off.

D) Final status of the file can be turned off

369) How many outline levels can be animated in PowerPoint 2013? A) Six B) Four C) Eight D) Five

D) Five

396) Which of the following is FALSE about a hyperlinked custom slide show? A) You can divide one presentation into several custom shows and hyperlink to various slides while presenting the information. B) A hyperlinked custom show connects a main custom show to other custom shows using hyperlinks. C) For a hyperlinked custom show, all slides must be in the same presentation. D) For a hyperlinked custom show, you can link to slides in multiple presentations.

D) For a hyperlinked custom show, you can link to slides in multiple presentations

105) ________ is NOT a type of editing restriction in Word. A) Comments B) Filling in Forms C) Track Changes D) Format

D) Format

70) When you press Ctrl+G in Word, the ________ dialog box opens. A) Go To tab of the Bookmark B) Go To tab on the Ribbon C) Go To Bookmark D) Go To tab of the Find and Replace

D) Go to tab of the find and replace

187) Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years? A) Scenario Manager B) Solver C) One-variable data table D) Goal Seek

D) Goal Seek

148) Which of the following tools is best suited for maximum control when creating an outline? A) Slicers B) Subtotals C) PivotTable D) Grouping

D) Grouping

261) Which of the following functions returns a value or the reference to a value within a range based on X and Y coordinates? A) HLOOKUP B) VLOOKUP C) MATCH D) INDEX

D) INDEX

431) Which of the following is FALSE regarding the Office Presentation Service? A) There is no fee for the service. B) To share a presentation, send the URL to invited participants. C) It is a service provided by Microsoft. D) If a participant has the URL to a presentation, that user can edit the presentation.

D) If a participant has the URL to a presentation, that user can edit the presentation

330) Where is the data stored for a linked object in PowerPoint? A) In a separate linked PowerPoint file B) In the destination file C) In the PowerPoint file that has the linked object D) In the source file

D) In the source file

146) Which of the following is NOT a calculation that can be completed with the SUBTOTAL function? A) Min B) Count C) Average D) Index

D) Index

397) After you've selected text on a slide that you want to hyperlink to another slide, click the ________ tab to access the Hyperlink button. A) Design B) Home C) File D) Insert

D) Insert

52) When only one document is open, the View Side by Side command: A) shows with an orange background indicating it is active. B) shows other file names that have been revised. C) appears active similar to all other buttons in the Window group. D) is grayed out.

D) Is grayed out

28) The ________ options allow you to fix an image's position on the page. A) Top and Bottom B) Tight C) Through D) Layout

D) Layout

32) If you have a worksheet with quarterly data that you want to show in a PowerPoiint presentation as well as a Word document and have editing changes reflected in both, you should use: A) grouping. B) embedding. C) copying. D) linking.

D) Linking

254) Which of the following functions returns the position of a value in a list? A) INDEX B) HLOOKUP C) VLOOKUP D) MATCH

D) MATCH

271) Which of the following is the best choice to lookup values when VLOOKUP and HLOOKUP are not possible? A) LOOKUP B) SUM C) DGET D) MATCH and INDEX

D) MATCH and INDEX

420) Which of the following PowerPoint features deactivates most PowerPoint tools and converts a presentation to read-only? A) Compatibility Checker B) Document Inspector C) Accessibility Checker D) Mark as Final

D) Mark as Final

140) To use the Office Presentation Service for free, you must have Microsoft Office 2013 and a(n) ________ account. A) Share B) Flickr C) YouTube D) Microsoft

D) Microsoft

359) Arcs, hearts, and stars are examples of PowerPoint ________. A) action buttons B) triggers C) animation effects D) motion paths

D) Motion paths

353) Which of the following are action buttons? A) Entrance, Emphasis, Exit B) Arc, Wave, Heart C) Fly In, Fade, Grow & Shrink D) Movie, Return, Custom

D) Movie, Return, Custom

269) Which of the following calculates the net present value of an investment, given a fixed discount rate? A) IPMT B) FV C) PV D) NPV

D) NPV

205) When calculating the optimal blend of down payment and interest rate to purchase an automobile, a limit of no more than a $10,000 down payment is an example of which of the following? A) Integer B) Objective cell C) Set cell D) Nonbinding constraint

D) Nonbinding constraint

395) When you have added slides to a custom show in the Define Custom Show dialog box, how are the slides displayed? A) Listed by slide title only B) By original slide number and slide title C) Numbered based on their original slide number D) Numbered based on their position in the new show

D) Numbered based on their position in the new show

224) Which of the following options is required to complete a Solver model? A) Scenario B) Constraint C) Set cell D) Objective cell

D) Objective cell

217) Which of the following what-if analysis tools updates date in real time? A) Goal Seek B) Scenario Manager C) Solver D) One-variable data table

D) One-variable data table

122) When Web pages were first developed in the early 1990s, they were created: A) with a program like FrontPage. B) with HTML or XML. C) only with XML. D) only with HTML.

D) Only with HTML

409) To compare and merge presentations, start by: A) clicking the Review tab. B) clicking Merge on the Review tab. C) opening both the original and the merged document. D) opening the original presentation.

D) Opening the original presentation

125) All of the following are examples of Web pages EXCEPT: A) Default.htm. B) Order.mhtml. C) Index.html. D) Order.docm.

D) Order.docm

270) In the FV function, the rate argument refers to the: A) total number of periods. B) payment. C) repayment type. D) periodic rate.

D) Periodic rate

149) Which of the following tools is best suited for data mining and summarizing data? A) Subtotal B) Column chart C) Data table D) PivotTable

D) PivotTable

430) The ________ app is used to store, share, and access files and folders. A) Collaboration B) Windows Live C) Encryption D) SkyDrive

D) SkyDrive

178) Which tool is best suited for use with PivotTables when the data is based on multiple tables? A) PivotCharts B) Filters C) Sorting D) Slicers

D) Slicers

399) Slides can be hidden using the ________ views. A) Reading and Slide Show B) Slide Show or Slide Sorter C) Slide Show and Normal D) Slide Sorter or Normal

D) Slide Sorter or Normal

354) How does the Home action button differ from the Beginning action button? A) The Home button goes to the first slide; the Beginning button goes to the first line of the current slide. B) The Beginning button can be set to go to any slide; the Home button moves to the first slide. C) Both can be set to go to any slide, but the Beginning button can also be set to go to the final slide. D) The Home button can be set to go to any slide; the Beginning button moves to the first slide.

D) The Home button can be set to go to any slide; the Beginning button moves to the first slide

336) What does ##### represent in a cell in Excel? A) There is an error in the cell. B) The cell contains a formula that has not yet displayed. C) That cell is linked to a PowerPoint slide. D) The cell is not wide enough to display the data.

D) The cell is not wide enough to display the data

35) When you embed a worksheet in a Word document,: A) an error message displays. B) the formulas remain as formulas. C) the cells with formulas display as blank cells in the Word document. D) the formulas become values .

D) The formulas become values

4) ________ is NOT an option available in the Drop Cap dialog box. A) How far from the text the drop cap displays B) Number of lines to drop C) The size of the drop cap initial D) The letter for the drop cap initial

D) The letter for the drop cap initial

366) Which of the following animation settings can be changed from the Animation Dialog Box Launcher and not simply from the Timing group on the Animations tab? A) Setting the method of starting an animation B) Setting the duration of an animation C) Setting the delay for an animation D) The number of times an animation is repeated

D) The number of times an animation is repeated

358) On a slide, what indicates the order in which animation will play? A) Numbered triggers on a slide B) The alphabetic letters in the Animation Pane C) Numbered ScreenTips attached to each animated object D) The numbered animation tags on the slide

D) The numbered animation tags on the slide

71) ________ is a small graphical image. A) Template B) Document theme C) Subdocument D) Thumbnail

D) Thumbnail

297) Which of the following is NOT an ANOVA calculation that can be performed? A) Two-factor without replication B) Two-factor with replication C) Single-factor D) Two-tail

D) Two-tail

386) Which of the following is NOT controlled by the handout master? A) Number of slides per page B) Layout of fields C) Orientation of the page layout D) Type of slide layouts allowed

D) Type of slide layouts allowed

15) ________ is most often associated with hyperlinks and should be used sparingly. A) Italics B) Bold C) Upper case D) Underlining

D) Underlining

234) What is the second argument of the IF function? A) logical_test B) lookup_value C) Value_if_false D) Value_if_true

D) Value_if_true

260) In the function =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)), F5*K7 is the: A) Value_if_false. B) Modifier. C) Logical_test. D) Value_if_true.

D) Value_if_true

117) Which of the following buttons is NOT found on a Default tab in Word 2013? A) Page Color B) Insert C) Cut D) Web Page Preview

D) Web Page Preview

124) All of the following are options to save Web pages EXCEPT: A) Single File Web Page. B) Web Page. C) Web Page, Filtered. D) Web Page, Template.

D) Web Page, Template

120) Microsoft Expression is a: A) Microsoft's Web page name. B) Word add-in for Web page design. C) Web page template for Word. D) Web page design tool.

D) Web page design tool

132) You must upload your Web pages to a(n) ________ before they can be viewed on the Internet. A) XML B) FTP C) WWW D) Web server

D) Web server

127) When you save a Word document as a Web page, the width of the Web page automatically becomes: A) narrower. B) considerably longer. C) shorter. D) wider.

D) Wider

47) If you want to save a file as a template, you need to change the Save as type to: A) Word Macro-Enabled Document. B) Word Document. C) PDF. D) Word template.

D) Word template

113) Which of the following statements about the Ribbon is FALSE? A) You can create a new tab and a new group and put it on the Ribbon. B) You are allowed to change the order of the tabs on the Ribbon. C) You can customize the Ribbon to contain just the commands you want to use. D) You cannot restore the Ribbon to its original arrangement.

D) You cannot restore the ribbon to its original arrangement

339) Which of the following chart elements is LEAST likely to be included in an Excel chart? A) Legend B) Axis titles C) Chart title D) Z-axis

D) Z-axis

363) How can you reshape a motion path? A) Display the edit points and drag a point to a new location. B) Click each point of the motion path you want to change and drag it. C) Right-click and select Change. D) You must redraw a new path over the old.

A) Display the edit points and drag a point to a new location

159) What does a slicer caption do? A) Displays text in the header at the top of the slicer window B) Creates caption meta data C) Provides access to slicer options D) Provides feedback on slicers that are engaged

A) Displays text in the header at the top of the slicer window

162) When setting custom calculation options in a PivotTable, what does % of Parent Row Total calculate? A) Displays values as: (value for the item) / (value for the parent item on rows) B) Displays each value as a percentage of the respective column total. The values in each column total 100% C) Displays each value as a percentage of the respective row total. The values in each row total 100% D) Displays each value as a percentage of the grand total

A) Displays values as: (value for the item) / (value for the parent item on rows)

92) All of the following would be recorded in a macro if the Record Macro feature is active, EXCEPT: A) dragging the mouse to select a word. B) inserting a signature line. C) pressing F4. D) pressing Ctrl+Home.

A) Dragging the mouse to select a word

192) Which of the following is NOT a method supported by Solver? A) Duplex B) Evolutionary C) GRG Nonlinear D) Simplex LP

A) Duplex

102) You set ________ to prevent users from changing the content of a document. A) editing restrictions B) user exceptions C) formatting restrictions D) IRM

A) Editing restrictions

328) When you copy and paste an object into PowerPoint, it is ________. A) embedded B) linked C) removed from the original location and pasted into the new location D) cut from the original application and pasted to the clipboard

A) Embedded

309) Which of the following is included in an ANOVA summary report? A) F crit B) Correlation C) Covariance D) STDEV

A) F crit

264) Which of the following is NOT an argument in a database function? A) Filter B) Database C) Field D) Criteria

A) Filter

82) Form controls are also known as ________ fields. A) form B) legacy C) text D) shaded

A) Form

342) To make multiple formatting changes to an element of a chart, click: A) Format Selection on the Format tab. B) the element, and right-click and choose Edit. C) Edit Selection on the Format tab. D) Current Selection on the Design tab.

A) Format Selection on the Format tab

101) You set ________ to ensure that users do not modify the styles in the document. A) formatting restrictions B) IRM C) editing restrictions D) user exceptions

A) Formatting restrictions

311) This function is best suited to determine ranks within a data set based on percentile. A) PERCENTRANK.INC B) RANK.AVG C) PERCENTILE D) RANK.EQ

A) PERCENTRANK.INC

36) The Paste Special dialog box offers two options: A) Paste and Paste link. B) Link and Embed. C) Copy and Paste. D) Paste and Copy Special.

A) Paste and paste link

333) Which of the following type of chart is known for its capability to explode a segment or piece? A) Pie chart B) Column chart C) Doughnut chart D) Bar chart

A) Pie chart

171) Which of the following tools is best suited to analyze the most productive students in a school district over a period of time? A) PivotTable B) Subtotal C) Slicer D) Pie Chart

A) PivotTable

17) You can type text into the Text pane or ________ of a SmartArt diagram. A) placeholder B) shape C) text box D) masthead

A) Placeholder

45) A field, or block, available in a template for personalized information that you add to the document is known as a: A) placeholder. B) subdocument. C) thumbnail. D) Normal template.

A) Placeholder

103) Which of the following is NOT an editing restriction that you can set in Word? A) Preventing users from formatting the document. B) Restricting data entry to unprotected areas of a form. C) Restricting data entry to fields. D) Preventing users from making changes to a letterhead template.

A) Preventing users from formatting the document

283) Which function is best suited to calculate quartiles including quartiles 0 and 4? A) QUARTILE.INC B) QUART C) RANK.AVG D) QUARTILE.EXC

A) QUARTILE.INC

279) Identify the statistical function used if the rank value returned for duplicate values was 8.5? A) RANK.AVG B) RANK C) RANK.SP D) RANK.EQ

A) RANK.AVG

1) You can use ________ to emphasize text in a document. A) reverse B) fill C) a placeholder D) a text pane

A) Reverse

210) Which dialog box enables you to specify the result cells for a scenario summary report? A) Scenario Summary B) Add Scenario C) Scenario Values D) Solver Options

A) Scenario Summary

166) Which of the following is NOT true about a PivotChart? A) They function independently from the PivotTable. B) They update as the PivotTable updates. C) They can be placed on a separate worksheet. D) They can be formatted similar to a regular chart.

A) They function independently from the PivotTable

93) The ________ in Microsoft Office helps protect users from unsafe macros. A) Trust Center B) Check for Issues button C) NewMacros project D) Protect Document button

A) Trust center

8) A good rule of thumb is to limit a document to ________ font type(s). A) two B) four C) just one D) three

A) Two

194) Which of the following tools is best suited for comparing the effects of two variables on a formula? A) Two-variable data table B) Solver C) One-variable data table D) Goal Seek

A) Two-variable data table

425) When you access the Restrict Permission feature, point to Restrict Access, and click Connect Digital Rights Management Servers and get templates, what is the default? A) Unrestricted Access B) Restricted Access C) Service Sign-Up D) Manage Credentials

A) Unrestricted Access

128) Hyperlinks can do all of the following EXCEPT: A) update the content of the Web page. B) jump to a different location within the same document. C) jump to a different Web page. D) open another document.

A) Update the content of the Web page

304) Which of the following functions does NOT base its calculations on data samples? A) VARPA B) STDEVA C) STDEV.S D) VAR.S

A) VARPA

193) When creating a one-variable data table that depicts the effect of different interest rates on a car payment, the interest rate is an example of which of the following? A) Variable B) Set cell C) Objective cell D) Constraint

A) Variable

90) The macro commands are available from the ________ and ________ tabs. A) View; Developer B) Home; Review C) Review; Developer D) Review; View

A) View; developer

63) One of the advantages of using a master document is that you can: A) work with several smaller subdocuments, rather than one large document. B) open and edit the subdocuments in the master document more quickly and easily. C) collapse all the subdocuments to shrink the file size of the master document. D) lock and unlock the subdocuments frequently.

A) Work with several smaller subdocuments, rather than one large document

87) After you click the Yes, Start Enforcing Protection button to restrict editing,: A) you are prompted for a password. B) the form is officially protected. C) the form cannot be accessed by unauthorized users. D) the tools on the Developer tab are grayed out.

A) You are prompted for a password

428) What is the primary benefit of using the Package Presentation for CD feature of PowerPoint? A) You can play the presentation without having PowerPoint on the computer. B) The file size is substantially reduced from that of a standard presentation. C) It runs faster than a standard PowerPoint presentation. D) You can play the presentation on two screens simultaneously.

A) You can play the presentation without having PowerPoint on the computer

233) What is the first argument of the IF function? A) logical_test B) Value_if_false C) Value_if_true D) lookup_value

A) logical_test

367) Which of the following is NOT an option of how text can be animated on a slide? A) Animate text by outline level B) Animate all objects as one C) Animate all paragraphs to come in together D) Animate text as one object

B) Animate all objects as one

355) What is required of a trigger? A) An object B) Animation C) A URL D) A ScreenTip

B) Animation

33) When you paste Excel data into a Word document, the data: A) convert to symbols. B) are pasted into table cells. C) retain Excel spreadsheet capabilities. D) retain Excel spreadsheet formatting.

B) Are pasted into table cells

137) When pictures are included in a blog, they are stored: A) together with the text of the blog as one file. B) as a separate file with a link in to the text file. C) as a placeholder in the text file. D) as a separate file that is unrelated to the blog.

B) As a separate file with a link in to the text file

91) Macros that you record can be accessed from all of the following, EXCEPT: A) on the Quick Access Toolbar. B) as an option from the File tab. C) through a keystroke combination. D) in the Macros dialog box.

B) As an option from the file tab

232) A________ is a rule that Solver has to enforce to reach the objective value. A) nonbinding constraint B) binding constraint C) step value D) stop value

B) Binding constraint

392) A zero for each of the RGB colors in the color model represents: A) blue. B) black. C) white. D) no color at all.

B) Black

405) How are comments by various reviewers differentiated? A) By Roman numerals B) By color C) By shape D) By numbers

B) By color

291) Which of the following functions will help determine the strength of a relationship between two variables? A) STDEV.P B) CORREL C) VAR.P D) VARPA

B) CORREL

11) Insert a ________ break when you want to force a paragraph to start at the top of the next column of a document. A) next page section B) column C) continuous section D) page

B) Column

84) The ________ form control enables a user to select from a list of choices, but also allows the user to modify the choices in the list. A) drop-down list B) combo box C) combo D) rich text

B) Combo box

373) Which of the following is NOT a setting in the PowerPoint Options dialog box? A) Startup options B) Handout master options C) User Interface options D) Personalize your copy of Microsoft Office

B) Handout master options

67) Thumbnails are an alternative to ________ in the Navigation Pane. A) subdocuments B) headings C) AutoText D) pages

B) Headings

321) Which of the following is NOT a method to eliminate a border when combining cells in a table? A) Select the cells and click Merge Cells. B) Highlight the border and press Delete. C) Select cells, right-click, and select Merge Cells. D) Erase the border

B) Highlight the border and press Delete

50) Building Blocks can be accessed from all the following tabs, EXCEPT: A) References. B) Home. C) Design. D) Insert.

B) Home

272) Returns the value or the reference to a value within a range based on X and Y coordinates. A) PPMT B) INDEX C) IPMT D) DSUM

B) INDEX

107) ________ must be installed to add users in the Add Users dialog box. A) Digital certificate B) IRM C) Digital signature D) VBA

B) IRM

168) How are grouped columns ungrouped? A) Right-click and select Ungroup B) Select all grouped columns and click Ungroup in the Outline group C) Select the entire worksheet and click Ungroup in the Subtotal group D) Select one cell in the grouped columns and click Ungroup in the Outline group

B) Select all grouped columns and click Ungroup in the Outline group

201) Which what-if analysis tool is best used for creating optimization models? A) One-variable data table B) Solver C) Two-variable data table D) Goal Seek

B) Solver

231) ________ has the ability to generate Answer Reports. A) One-variable data table B) Solver C) Goal Seek D) Two-variable data table

B) Solver

371) What does a 0 tag in the Animation Pane indicate? A) The timing of all animations on the slide starts with 0 seconds delay. B) The animation starts with the previous animation. C) There are no animations on that slide. D) The timing between all animations on that slide is 0 seconds.

B) The animation starts with the previous animation

415) Personal data in a presentation can be discovered using: A) the Accessibility Checker. B) the Document Inspector. C) Document Properties. D) Mark as Final.

B) The document inspector

61) Which of the following statements about the Create from file feature in Word is TRUE? A) The Create from file option is available by clicking the Review tab, then the Object arrow. B) The file does not have to be open to be inserted into a document. C) Only a portion of the file can be inserted into the open document. D) You do not have to place the cursor where you want the closed file to be inserted because a dialog box will pop up and ask you for the desired location.

B) The file does not have to be open to be inserted into a document

94) Which of the following statement about macros is TRUE? A) A macro cannot be assigned to a button. B) The maximum number of characters for a macro name is 80. C) A macro cannot be placed on the Quick Access Toolbar. D) A macro name can consist of spaces.

B) The maximum number of characters for a macro name is 80

350) What is the purpose of a ScreenTip in a slide? A) To offer PowerPoint help features B) To offer a way for the user to determine the purpose of a hyperlink C) To show the options available from a link D) To show the URL of a link so a viewer can click it and link to the Web page

B) To offer a way for the user to determine the purpose of a hyperlink

131) A bookmark for the ________ of the Web page is created automatically. A) end B) top C) center D) bottom

B) Top

218) Where should the formula or formula reference be located in a two-variable date table? A) Lower left corner B) Top left corner C) Lower right corner D) Upper right corner

B) Top left corner

305) Which of the following functions is best suited to calculate the variance of a population including logical values and text? A) VAR.S B) VARPA C) VAR.P D) VARA

B) VARPA

57) All the following statements describing Side by Side view are true, EXCEPT that: A) windows can be repositioned and moved. B) when you close the Side by Side view, both documents are automatically saved and closed. C) windows can be resized. D) synchronous scrolling is automatically enabled.

B) When you close the Side by Side view, both documents are automatically saved and closed

68) Which of the following is a valid bookmark name? A) Works Consulted B) Works_Consulted C) Semi-Circle D) 101_Main_Street

B) Works_Consulted

48) All the following statements about Building Blocks are false, EXCEPT that: A) watermarks and tables cannot be Building Blocks. B) you can individually name a Building Block that you have created. C) only items approximately a paragraph or less can be saved as a Building Block. D) Building Blocks can be used repeatedly only in the document that they are created.

B) You can individually name a Building Block that you have created.

138) When you open the Blog post template,: A) all of the Blog commands are included on the Insert tab. B) you only have tabs on the Ribbon that will provide commands you need to complete the blog post. C) the Blog Post tab is added to the existing tabs on the Ribbon. D) a new Blog group is included on the Home tab.

B) You only have tabs on the ribbon that will provide commands you need to complete the blog post

46) Of the following choices, the ________ file extension is NOT a Word template. A) .dotm B) .dotx C) .docx D) .dot

C) .docx

360) What symbol indicates the beginning of a motion path on a slide? A) A green GO icon B) A small square C) A small arrow D) A red arrow

C) A small arrow

40) The default alignment of text for the Normal template is: A) Right. B) Justify. C) Left. D) Center.

C) Left

263) Which of the following is NOT a function for evaluating multiple conditions with only two possible outcomes? A) AND B) NOT C) MAX D) OR

C) MAX

385) ________ control the layouts, background designs, and color combinations for handouts, notes pages, and slides of a presentation. A) UI customization files B) Custom shows C) Masters D) Placeholders

C) Masters

411) Another name for document or presentation properties is ________. A) encryption B) markups C) metadata D) annotations

C) Metadata

119) The default name of the new group that you create is: A) New_Group_(1). B) Custom Group 1(Custom). C) New Group (Custom). D) New Group (1).

C) New Group (Custom)

324) Which of the following is NOT a border option for a table? A) Only inside borders B) No border C) Only double outside borders D) Only top and bottom borders

C) Only double outside borders

59) Which of the following statements about Word's Compare feature is FALSE? A) Differences are displayed in markup balloons. B) The Compare command is located on the Review tab. C) Only two documents can be evaluated at one time. D) Differences between documents can be displayed in a new document, separate from the original and revised documents.

C) Only two documents can be evaluated at one time

151) From which of the following locations can you create a PivotTable? A) Formulas tab B) Data tab C) Quick Analysis gallery D) Backstage

C) Quick Analysis gallery

278) Which of the following functions will rank two values evenly if there is a duplicate value present? A) RANK.AVG B) PERCENTILE C) RANK.EQ D) RANK

C) RANK.EQ

44) If you have a report that you update on a(n) ________ basis, that is contained in a very structured and detailed table, you should consider making it into a template. A) case-by-case B) infrequent C) regular D) rare

C) Regular

351) Which of the following is NOT a default action button viewable in Slide Show view? A) Activate a pen tool B) Display a shortcut menu C) Return to the title slide D) Advance to the next slide

C) Return to the title slide

188) Which of the following tools has the ability to generate a report? A) Goal Seek B) Two-variable data table C) Scenario Manager D) One-variable data table

C) Scenario Manager

220) Which what-if analysis tool is best suited to calculate the impact of interest rate changes based on different economic climates? A) Solver B) Goal Seek C) Scenario Manager D) One-variable data table

C) Scenario Manager

216) Comments can be added to Scenarios in which tab or dialog box? A) Home tab B) Goal Seek dialog box C) Scenario Manager dialog box D) View tab

C) Scenario Manager Dialog box

308) Which of the following is a new statistical function in Excel 2013? A) VARPA B) CORREL C) Skew.P D) STDEV.P

C) Skew. P

344) A hyperlink can be activated in ________ views. A) Reading and Normal B) Slide Show and Normal C) Slide Show and Reading D) Normal and Slide Sorter

C) Slide Show and Reading

191) Which of the following tools has the ability to manipulate constraints? A) Goal Seek B) Two-variable Data Table C) Solver D) Scenario Manager

C) Solver

213) Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials? A) Goal Seek B) Scenario Manager C) Solver D) Two-variable Data Table

C) Solver

196) When creating substitution values using the Series dialog box, what is the last number used in the substitution values? A) Integer B) Constraint C) Stop value D) Step value

C) Stop value

72) All the following are part of a document theme in Word, EXCEPT: A) Fonts. B) Effects. C) Style Set. D) Colors.

C) Style set

121) HTML consists of a set of codes, or ________, that are assigned to content in a document. A) elements B) links C) tags D) protocols

C) Tags

349) Which of the following is TRUE about an e-mail link on a slide? A) As you type an e-mail address in the E-mail address box of the Insert Hyperlink dialog box, E-mail: is automatically added before the e-mail address. B) The text on the slide must display as the actual e-mail address. C) The E-mail Address link option is most helpful for presentations available on the Web. D) Text such as "Send me a message" cannot be used for an e-mail link.

C) The E-mail address link option is most helpful for presentations available on the web

280) What does the order argument of the RANK.EQ function define? A) The ranking stop value B) The lowest ranked value C) The order in which numbers are ranked D) The ranking order scale

C) The order in which numbers are ranked

374) What is the best reason to add your user name and initials to PowerPoint options? A) To acquire discounts on the next version of Microsoft Office B) To provide this information to Microsoft C) To identify yourself when you work with others on presentations D) It is required at installation.

C) To identify yourself when you work with others on presentations

54) When using the View Side by Side feature, the maximum number of documents that you can display at one time is: A) five. B) three. C) two. D) four.

C) Two

347) If you create a picture link in a presentation, which of the following is NOT important? A) If you change the picture, save it as the same file name in the same location. B) Use the Link to File PowerPoint option. C) Use all lower-case letters in the file name. D) Save the picture to the same folder as the presentation.

C) Use all lower-case letters in the file name

135) Office 365 is available to anyone who has a(n): A) SkyDrive. B) cloud integration technology. C) user subscription. D) Office 2013.

C) User subscription

427) Which of the following file formats saves an individual slide or all slides and uses a lossy format, making the file size smaller? A) .odp B) .png C) .sldx D) .jpg

D) .jdp

238) When using the MATCH function with an exact match lookup_value, the match type must be set to: A) -1. B) 1. C) 2. D) 0.

D) 0

287) Which of the following percentiles is excluded when using the PERCENTILE.EXC function? A) 50th B) 75th C) 25th D) 0

D) 0

285) When using the QUARTILE.INC function which quartile would include the highest value in the dataset? A) 1 B) 2 C) 3 D) 4

D) 4

345) How does a hyperlink attached to text appear in comparison with other typed text on the slide? A) A different color and bolded B) Bolded and italics C) Underlined D) A different color and underlined

D) A different color and underlined

116) Which of the following statements about creating a new tab is TRUE? A) Two new groups are automatically created with a new tab. B) New tabs retain the new tab name of Custom tab 1, Custom tab 2, etc. C) New groups can be created for a new tab; individual commands cannot. D) A new group named New Group (Custom) is automatically created.

D) A new group named New Group (Custom) is automatically created

221) Where do scenario summary reports appear? A) A pop up box B) The current worksheet C) A new workbook D) A new worksheet

D) A new worksheet

296) Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population? A) Correlation B) Descriptive Statistics C) Histogram D) ANOVA

D) ANOVA

223) Where is the check box to activate Solver located? A) Add-Ins tab B) Data tab C) View tab D) Add-Ins dialog box

D) Add-ins dialog box

418) A text-based description for an image is: A) metadata. B) encrypted text. C) XML. D) alternative text.

D) Alternative text

372) If an animation in the Animation Pane includes a tag, what displays directly to the right of the tag? A) A timeline B) The full name of the animation C) A green arrow indicating the start of the animation D) An icon that represents the type of animation effect applied

D) An icon that represents the type of animation effect applied

202) The Solver add-in appears in which tab group when active in Excel? A) Outline B) Data Tools C) Sort & Filter D) Analysis

D) Analysis

343) All EXCEPT ________ can turn a linear presentation into a non-linear presentation. A) action buttons B) interactivity C) hyperlinks D) animation

D) Animation

370) Which of the following is a new feature of PowerPoint 2013? A) Using text as a trigger B) ScreenTips added to hyperlinks C) The mouse over feature for ScreenTips D) Animation effects are color-coded

D) Animation effects are color-coded

265) The first argument of the INDEX function is: A) match type. B) row_num. C) column_num. D) array.

D) Array

300) Which of the following functions is best suited to calculate the covariance of a population? A) COVAR B) COVARIANCE.S C) VARPA D) COVARIANCE.P

D) COVARIANCE.P

244) Which of the following functions will calculate the total principal paid between select periods? A) PPMT B) IPMT C) CUMIPMT D) CUMPRINC

D) CUMPRINC

160) What is the best option for adding a calculation to a PivotTable that does not already exist? A) Function B) PivotTool Calculation C) Custom function D) Calculated field

D) Calculated field

253) Which database function should be used to count records with empty cells? A) DCOUNT B) DGET C) DSUM D) DCOUNTA

D) DCOUNTA

251) Which database function will return the smallest value from a dataset based on preset criteria? A) DCOUNT B) DMAX C) DSUM D) DMIN

D) DMIN

267) Which of the following database functions is best suited to add total salaries from a database that are higher than $30,000? A) DMIN B) DCOUNTA C) DMAX D) DSUM

D) DSUM

273) Which of the following is NOT a statistical function? A) AVERAGEIF B) COUNTIFS C) MAX D) DSUM

D) DSUM

203) Goal Seek appears in which tab group within Excel? A) Sort & Filter B) Outline C) Data Tools D) Analysis

D) Data Tools

327) A PowerPoint file with an Excel chart embedded in it is an example of a ________. A) destination application B) source file C) source application D) destination file

D) Destination file

404) When a reviewer returns a presentation to you, determine which changes you'd like to keep and which you'd like to reject based on ________ in the presentation. A) accessibility B) reviews C) metadata D) markups

D) Markups

242) Which of the following functions will return the principal payment of a loan? A) IPMT B) PMT C) CUMPRINC D) PPMT

D) PPMT

317) The ________ tool is used to draw a table in PowerPoint. A) Marker B) Line C) Pen D) Pencil

D) Pencil

152) Which of the following tools is best suited for complex cross referenced subtotals? A) Data table B) Subtotal C) Outline D) PivotTable

D) PivotTable

154) When editing a PivotTable where are values field settings edited? A) Formulas tab B) Data tab C) PivotTable Design tab D) PivotTable Fields task pane

D) PivotTable Fields task pane

173) What is the name of the tab that appears in the Ribbon when a PivotTable is selected? A) PivotTable Options B) Analysis C) PivotTable D) PivotTable Tools

D) PivotTable Tools

150) Which of the following is NOT true about PivotTables? A) PivotTables can arrange data in columns or rows. B) PivotTables can summarize data. C) PivotTables are dynamic. D) PivotTables can Auto Refresh data.

D) PivotTables can Auto Refresh data

115) The ________ expands the view of the groups within a tab in the Word Options dialog box. A) asterisk B) check mark C) negative sign D) plus sign

D) Plus sign

183) What tool is best suited for incorporating manufacturing information from one table with shipping information from a related table within one PivotTable? A) Slicers B) Grouping C) Pivot Charts D) PowerPivot

D) PowerPivot

141) All the following are options on the Share feature on the File tab EXCEPT: A) Email. B) Post to Blog. C) Invite People. D) Present Offline.

D) Present offline

310) Which function would be best used to determine the rank of each student in a graduating high school class? A) QUARTILE.INC B) QUARTILE.EXC C) RANK.AVG D) RANK.EQ

D) RANK.EQ

432) Which of the following is NOT a feature of SharePoint collaboration? A) Save and reuse your own or others' presentations stored in the library. B) Store presentations in a document workspace. C) Online discussions as presentations are being developed. D) Receive e-mail notifications when slides are changed in the library.

D) Receive e-mail notifications when slides are changed in the library

42) After you have accessed a template, it will show in the ________ category. A) New from existing B) Sample templates C) Featured or Personal template D) Recent templates

D) Recent templates

326) With your insertion point in Row 2, what is a viable alternative for deleting the selected row other than using the buttons on the Layout tab? A) Press Shift+Delete . B) Press the Delete key. C) Right-click and select Delete Row. D) Right-click, select Delete, and click Delete Rows.

D) Right-click, select Delete, and click Delete Rows

29) All of the following EXCEPT ________ are commands available from the Rotate command in the Arrange group. A) Rotate Right 90 degrees B) Flip Vertical C) Flip Horizontal D) Rotate Right 180 degrees

D) Rotate Right 180 degrees

303) Which of the following functions is best suited to determine the standard deviation of a sample including logical values and text? A) STDEV.P B) STDEVPA C) STDEV.S D) STDEVA

D) STDEVA

292) Which of the following is NOT a function for measuring central tendency? A) CORREL B) VAR.P C) STDEV.P D) SUMIFS

D) SUMIFS

208) Which what-if analysis tool is the best tool for evaluating various scenarios based on variables within a formula? A) One-variable data table B) Goal Seek C) Solver D) Scenario Manager

D) Scenario Manager

10) Insert a ________ break when you want to change the number of columns in a document. A) line B) hard return C) page D) section

D) Section

356) What is the first step in setting up a trigger on a slide? A) Click Trigger on the Animations tab. B) Create a motion path for the trigger. C) Choose the animation for the trigger. D) Select the object that will serve as the trigger.

D) Select the object that will serve as the trigger

206) When saving a Solver model which of the following is NOT saved? A) Changing variable cells B) Objective value C) Constraints D) Set cell

D) Set cell

341) Which of the following is NOT a button in the Shape Styles group on the Chart Tools Format tab? A) Shape Effects B) Shape Fill C) Shape Outline D) Shape Border

D) Shape Border

27) Use the ________ key to select multiple objects that you want to group together. A) Ctrl B) F2 C) Alt D) Shift

D) Shift

6) In desktop publishing, the selection of fonts, font styles, and font ________ that enhance the appearance of a document is a critical element in the success of a document. A) alignment B) shapes C) design D) sizes

D) Sizes

190) Which of the following tools is an add-in? A) Scenario Manager B) Goal Seek C) One-variable data table D) Solver

D) Solver

207) Which is the best tool for determining the optimal blend of products to produce in order to maximize profit? A) Scenario Manager B) Two-variable data table C) Goal Seek D) Solver

D) Solver

325) To add a row to the bottom of the table when the insertion point is in the last cell of the table, press ________. A) Ctrl+Tab B) Shift+Enter C) Enter D) Tab

D) Tab

414) When you enter property keywords, they appear as ________ when you display the Properties panel in the Info view in Backstage. A) encrypted data B) metadata C) comments D) tags

D) Tags

134) Hyperlinks CANNOT be assigned to: A) graphics. B) HTML tags. C) text. D) videos.

HTML Tags

338) Which of the following is NOT a chart variation option? A) Changing from a pie chart to a doughnut chart B) Stacking chart data C) Changing the marker shape D) Changing 2-D formatting to 3-D formatting

A) Changing from a pie chart to a doughnut chart

334) The ________ is bound by the placeholder borders. A) chart area B) plot area C) legend D) surface

A) Chart area

106) User exceptions are differentiated in a restricted document by: A) color. B) comment box style. C) font type. D) font size.

A) Color

13) A grid is distinguished by the number of ________ it contains. A) columns B) cells C) rows D) horizontal lines

A) Columns

293) When using an array of data with the FREQUENCY function, the following keystroke is required. A) Ctrl+Shift+Enter B) Ctrl+Shift+Delete C) Ctrl+Alt+Delete D) Ctrl+Enter

A) Ctrl+Shift+Enter

43) A ________ displays your skills, accomplishments, job history, or other employment information. A) curriculum vitae B) template C) placeholder D) building block

A) Curriculum vitae

184) Where are PowerPivot tools located on the Ribbon? A) Data tab B) Formulas tab C) Review tab D) Insert tab

A) Data tab

200) Where is Goal Seek located in Excel? A) Data tab B) View tab C) Backstage D) Formula tab

A) Data tab

81) The commands to create a form are available on the ________ tab. A) Developer B) Review C) Home D) Insert

A) Developer

179) Once a slicer is inserted into a worksheet which of the following actions cannot be performed? A) Append the slicer B) Remove a filter C) Filter data D) Move the slicer

A) Append the slicer

387) In the default handout master, where is the page number located? A) At the bottom of the page B) On the left of the page C) At the top of the page D) In different locations dependent on the theme

A) At the bottom of the page

161) Which of the following calculations cannot be completed with subtotal? A) Average B) Sum C) Max D) Standard Deviation

A) Average

118) When you enter the Word Options dialog box and add a new tab, the new tab is automatically added: A) below the tab that is active in the document. B) as the first tab on the Ribbon. C) as the last tab on the Ribbon. D) at whatever location the user chooses.

A) Below the tab that is active in the document

21) The best use for linking text boxes is to create a: A) Booklet. B) Flyer. C) Newsletter. D) Brochure.

A) Booklet

24) The ________ option will move an object on top of the other object directly in front of it. A) Bring Forward B) Bring in Front of Text C) Group and Ungroup D) Bring to Front

A) Bring forward

340) By default, how are the measurements or increments on a chart's Y-axis determined? A) By the data you enter in the worksheet B) Every other number in the worksheet is included C) Every number in the worksheet is included D) Manually by the user

A) By the data you enter in the worksheet