MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide. Eric Butow
is a Sparkline chart?A chart format that lets you add graphic sparkles to your chartA small chart that quickly summarizes what you see in a rowOne of the built‐in chart stylesAnother term for a win‐loss chart
43 When would you use the TEXTJOIN() function instead of the CONCAT() function?When you want to ignore blank cells in the selected rangeYou don't have to because TEXTJOIN() replaces CONCAT() in the latest version of Excel.To add a space between text in each cellWhen you don't want to type in the cell references within the formula
44 What does an error bar in a chart show? (Choose all that apply.)How inaccurate the data is in the chartMargins of errorStandard deviationHow much you can change the numeric value in a cell formula
45 When you format a table style, what formats can you change? (Choose all that apply.)FontAlignmentBorderFill color and pattern
46 Your boss likes your chart but wants the background of the chart to be dark so that the text will stand out. How do you do this quickly?Apply a chart layout.Change the background color of the chart.Apply a different chart style.Tell your boss that there are no chart backgrounds other than white.
47 What are the minimum and maximum magnification views in a worksheet?20 percent and 125 percent10 percent and 150 percent25 percent and 200 percent5 percent and 300 percent
48 If you delete a row or column and immediately decide that you didn't want to do that, what do you do?NothingOpen the Home menu ribbon.Add the new row or column again.Press Ctrl+Z.
49 In the Paste Special dialog box, what button do you click to paste a number from one cell into a blank cell?FormatsValuesNoneValidation
50 What file formats can you save an Excel file to? (Choose all that apply.)XMLWordPDFExcel
51 In what menu ribbon do you add a bulleted or numbered list?DesignHomeInsertSlide Show
52 When you want to add a slide from another presentation, what option do you select in the New Slide drop‐down list?Duplicate Selected SlidesThe custom theme slideReuse SlidesSlides from Outline
53 What are the two ways to configure animation paths in a slideshow? (Select all answers that apply.)Motion pathsThe Animation PaneThe Transitions ribbonMorph
54 What are the four table row and column insertion types?Row, Column, Header Row, First ColumnTop, Bottom, Left, RightAbove, Below, Left, RightLeft End, Right End, Top, Bottom
55 What do you have to do to add information into a slide?Add a themeAdd a new slide masterModify the slide master contentClick in a placeholder area
56 Why do you add a link to a slide? (Select all answers that apply.)To link to an email addressTo connect with a websiteTo create a new slideTo link to another slide
57 What options do you have when selecting a footer? (Select all answers that apply.)Date and TimeCompanyDon't Show on Title SlideCopyright information
58 When you want to add a SmartArt graphic, which menu option do you click?DesignSlide ShowInsertHome
59 What view do you use when you want to see thumbnail‐sized images of slides?Notes PageReading viewSlide SorterOutline view
60 What are some of the audio and video formats that you can add into a PowerPoint slideshow? (Select all answers that apply.)MPEGOGGWAVFLV
61 From what sources can you insert an image? (Select all answers that apply.)Office.comWeb imagesStock imagesJPEG format images
62 What slide content can you animate? (Select all options that apply.)Text3D ModelsPicturesSmartArt graphics
63 What menu option do you click to print a slideshow?HomeViewFileDesign
64 What can you move when you modify the order of slides? (Choose all that apply.)Master slidesOne or multiple slidesSectionsLayouts
65 What is the term for the effect that occurs when you move from one slide to another in your slideshow?AnimationMorphTransitionEffect
66 What are the three ways to change the text appearance in a shape or text box? (Select all answers that apply.)Convert to SmartArtText DirectionText EffectsAlign Text
67 When you change your mind immediately after setting a new slide background, what do you do? (Select all answers that apply.)Change the slide background back to what it was.Press Ctrl+Z.Close the slideshow without saving it and then reopen it.Click the Undo icon.
68 What are some of the elements that you can modify within a chart? (Select all answers that apply.)NumbersLegendGridlinesLines
69 Your boss wants you to create a slideshow that runs automatically for the big tradeshow coming up. What do you do to set the transition time between each slide?Set the duration in the Animations ribbon.Use the tools in the View ribbon.Select the After check box in the Transitions ribbon.Change the theme in the Design ribbon.
70 How do you get a good idea where PowerPoint places objects in a slide? (Select all answers that apply.)An object snapping to a point within the slideGridlinesThe mouse pointerGuides
71 After you add a transition, how do you add an effect to it?Change the theme in the Design ribbon.Change the view to Slide Sorter in the View ribbon.Click Effect Options in the Transitions ribbon.Add a new slide in the Insert ribbon.
72 What are the types of custom slideshows that you can create? (Select all answers that apply.)SimpleMulti‐SlideHyperlinkedTiming
73 Where can you find 3D models to insert into a slide? (Select all answers that apply.)The Insert ribbonStock modelsOn your computerThe Illustrations section in the Insert ribbon
74 Where do you modify the slide order in the PowerPoint window?The Design ribbonRight paneThe View ribbonLeft pane
75 What are the two ways that you can keep others from editing a slideshow? (Select all answers that apply.)Mark the slideshow as final.Email the users to tell them not to edit the slideshow.Add a slide that tells the users not to edit the slideshow.Use a password.
Answers to Assessment Test
1 B. The Table grid has enough cells for 10 columns and 8 rows. See Chapter 3 for more information.
2 C. When you open the Find and Replace box, click More, click Use Wildcards, and then add the asterisk ( * ) to the end of the search term. See Chapter 2 for more information.
3 C. Add a new comment by clicking the New Comment icon in the Review menu ribbon. See Chapter 6 for more information.
4 C. You can add a footnote on a page, an endnote at the end of the document, and citations on a page. See Chapter 4 for more information.
5 D. Click the Insert menu option, and then click the Link icon in the ribbon. See Chapter 1 for more information.
6 A, C, D. Word makes it easy to add pictures from your computer, stock images installed with Word, and images from Office.com. See Chapter 5 for more information.
7 A, C. You can add a one‐half indent in the Home menu ribbon and add more precise indent spacing in the Layout menu ribbon. See Chapter 2 for more information.
8 C. You can create a table of contents (TOC) easily so that readers can get a summary of what's in your document and click the entry they want in the table to go to the section on the appropriate page. See Chapter 4 for more information.
9 C. A pop‐up menu appears after you move the mouse pointer on the selected text so that you can change the format including the font style,