Читать книгу MCA Microsoft Office Specialist (Office 365 and Office 2019) Complete Study Guide - Eric Butow - Страница 21

1 How big of a table can you create using the Table grid in the Insert menu ribbon?12 columns and 10 rows10 columns and 8 rows10 columns and 10 rows12 columns and 12 rows

2 What search option do you use to find all words in a document that start with the same three letters?Match SuffixMatch PrefixUse WildcardsSounds Like (English)

3 What menu option do you click to create a new comment in a document?InsertReferencesReviewHome

4 What are the three reference elements that you can add to a document?Citation, source, and bibliographyCaption, table of figures, cross‐referenceFootnote, endnote, citationTable of contents, table of figures, table of authorities

5 You need to have a link on page 30 of your document that goes back to page 1. What menu option do you click on to get there?HomeReferencesViewInsert

6 Where can you find pictures to add into a Word document? (Choose all that apply.)On a drive connected to your computerOn the InternetStock imagesOffice.com

7 When you need to indent a paragraph, where can you do this? (Choose all that apply.)In the Home menu ribbonIn the Insert menu ribbonIn the Layout menu ribbonUsing the Tab key

8 Your customers want an easy way to see what's in your document and go to a location quickly. How do you do that?Add links.Add a bibliography.Add a table of contents.Add a bookmark.

9 How can you quickly change the format of selected text?By using the Insert menu ribbonBy using the Layout menu ribbonBy moving the mouse pointer over the selected text and selecting formatting options from the pop‐up menuBy selecting the style in the Home ribbon

10 What do you have to do before you cite a source?Select the writing style guide to use.Add a bibliography.Add the source to the document.Add a table of contents.

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

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.