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