Eric Butow - MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide

11 How does Word allow you to sort in a table?By number and dateBy text, number, and dateBy text and numberText only

12 You need to send your document to several coworkers for their review. How do you make sure that you see all their additions, changes, and deletions?Click the Show Comments icon in the Review menu ribbon.Add a comment at the beginning of the document.Click Read Mode in the View menu ribbon.Turn on Track Changes.

13 Your boss wants you to convert a Word document and share it as a PDF file. How can you do that?Print to a PDF printer.Use the Send Adobe PDF For Review feature.Use Adobe Acrobat.Use the Home menu ribbon.

14 How do you go to each comment in your document? (Choose all that apply.)By using the View menu ribbonBy using the Review menu ribbonBy scrolling through the document to read themBy using the Find And Replace dialog box

15 Your boss wants you to create a nice‐looking organization chart for the company. What do you use to create one in Word?PicturesShapesSmartArtScreenshot

16 What are the two types of lists that you can add to a document?Cardinal and ordinalRoman and alphabeticalBulleted and numberedSymbol and picture

17 How do you select all of the text in a document?Click the first word in the document and then hold and drag until all of the words are selected.Press Ctrl+A.Use the Home menu ribbon.Use the View menu ribbon.

18 What category of paragraph styles does Word look for when you create a table of contents?TitleSubtitleStrongHeading

19 What WordArt styles can you add to text within a text box? (Choose all that apply.)Text FillText DirectionText AlignmentText Outline

20 Why would you change a number value in a numbered list?Word gets confused as you add more entries.You have one list separated by other text or images.You need to add a number value manually for each entry in the list.You can't change a number value in a numbered list.

21 What wrapping style do you use to get an image to sit on a line of text?SquareTightIn line with textTop and bottom

22 How do you check a document so that you can make sure everyone can read it before you share it with others?Look through the entire document.Use Find and Replace.Use the Document Inspector.Use the spell checker.

23 How do you change the color for each reviewer in a document?You can't.Use the Review menu ribbon.Add different styles with different text colors.Show all comments.

24 How do you start a new section on a new page?Add a page break.Add a continuous page break.Add an even or odd page break.Add a next page break.

25 How do you add descriptive information to an image or graphic?By selecting the appropriate style in the Home menu ribbonBy adding Alt textBy typing the description above or below the textBy using the Insert menu ribbon

26 What does the header row do in a table? (Choose all that apply.)It tells you what the columns are about.It allows you to sort data in a column.It sets apart the table from the rest of the worksheet.It allows you to filter data in a column.

27 When you copy a cell, what's the fastest way of copying it?Clicking Copy in the Home ribbonRight‐clicking the cell and then clicking Copy in the context menuPressing Ctrl+CAdding the Copy icon to the Quick Access Toolbar

28 What are ways in which you can identify data in a chart? (Choose all that apply.)AxesLegendTableTitles

29 What are the three reference types that you can add in a formula? (Choose all that apply.)RelativeAbsoluteNumericMixed

30 What two types of files can you import into an Excel workbook? (Choose all that apply.)WordTextCSVPowerPoint

31 How can you select a chart element in your chart? (Choose all that apply.)Click the chart element.Click within the chart.Click the Chart Area box in the Format ribbon.Click Select Data in the Chart Design ribbon.

32 What option do you use to rotate text but not make the text itself change its orientation?Rotate Text UpAlign CenterVertical TextRotate Text Down

33 What does the SUM() function do?Adds all of the numbers in selected cellsSummarizes the numbers in selected cellsCalculates the average of all numbers in selected cellsCounts all of the selected cells that have numbers in them

34 What drop‐down list box do you select when you want to find information in an entire workbook?SearchLook InWithinFind What

35 What function do you use in a new cell to have Excel return the first few characters in a cell that contains text?MID()UPPER()LEN()LEFT()

36 What information can you show and hide in a table style? (Choose all that apply.)Header rowFirst columnFilter buttonBanded rows

37 Why would you assign a name to a range of cells?You don't have to because cells automatically have row numbers and column letters.You need to do this before you save the workbook.You can't find cells in a worksheet without naming them.You want to find groups of cells in a worksheet more easily.

38 What is the default row height in an Excel worksheet?10 points15 pointsOne inch72 points

39 How does the COUNTA() function differ from the COUNT() function?COUNTA() counts all the blank cells in a selected range.You can count specific numbers in the COUNTA() function. COUNTA() allows you to only count text, not numbers.The COUNTA() function counts selected cells that are not empty.

40 What does Excel call a chart created in a new worksheet?Chart sheetChart1Whatever you decide the new worksheet should beExcel creates a new workbook and then you must give it a name.

41 When you need to sort table data with text and numbers in it, what is the best way to sort?In ascending orderUsing the sort and filter buttons in the header rowA custom sortIn descending order

42 What 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