Final Exam Review Computer Applications

What does a red wavy underline in a document or presentation mean?

(a) A word is misspelled or not recognized by the Microsoft 365 dictionary.

Which would you choose to find all forms of communication within a team?

(a) Activity feed

In which of the following situations would you consider inserting a soft return instead of a hard return?

(a) At the end of a single line of an address, with more address lines to follow

Which of the following separates participants into smaller groups in a meeting?

(a) Breakout room

Which of the following activities enables various layout settings to be present within the same document?

(a) Creating sections

You can get help when working with a Microsoft 365 appli-cation in which one of the following areas?

(a) Search box

What object is most useful for drawing attention to such items as contact information or store hours

(a) Text box

Why might you consider saving a document in PDF format?

(a) When uploading a document to a proprietary website for easy accessibility by others

You plan to place a function or formula in cell B4 of a Word table to total the cells in the column above. How would that function or formula display?

(b) =B1+B2+B3+B4

Which sharing option enables you to share content from your entire screen?

(b) Desktop

To access commands that are not on the ribbon, you need to open which of the following?

(b) Dialog box

What feature would you use to visually coordinate various elements of an entire document at one time, including color, font, and other format settings?

(b) Document theme

Which of the following is not considered good etiquette when participating in a Microsoft Teams meeting?

(b) Keep your microphone on at all times

What is the result when you restore down a window?

(b) Make the window smaller, but keep it displayed on the desktop.

Which of the following best describes Snap layouts?

(b) Prearranged settings for how open windows display

Which of the following is a method of switching between open desktops?

(b) Task view

What would you consider adjusting to correct for text that flows to the side of a newsletter heading (WordArt object) that you intended to occupy a line by itself?

(b) Text wrapping.

What are the rectangular icons on the Windows 10 Start menu called?

(b) Tiles

Why might you choose to use tabs when arranging text?

(b) To align text in columns

Which of the following is a reason to use the Accessibility Checker?

(b) To comply with federal legislation related to disabilities

When is an @mention used?

(b) To direct part of a conversation to a team or channel member

In Word or PowerPoint, which of the following is a quick way to select an entire paragraph?

(b) Triple-click inside the paragraph.

Which is the preferred method for resizing a picture so that it keeps its proportions?

(b) Use a corner-sizing handle

To identify a document as a draft, and not in final form, which of the following would you most likely add to the document?

(b) Watermark

In which of the following scenarios would you filter a data source in preparation for a mail merge?

(b) When mailing a promotional document to recipients in a particular zip code, excluding others

Which of the following would be considered a connector app?

(b) YouTube

Which of the following is a section of a team that relates to a particular project?

(c) Channel

Which of the following displays when an object, such as a picture, is selected?

(c) Contextual tab(s)

Which of the following is true about headers and footers?

(c) Headers appear at the top of every page in a document.

Suppose you find that a column heading within a newsletter is displayed at the end of a column, with remaining text continuing at the top of the next column. How would you keep the heading with the text so that it is not divided awkwardly?

(c) Insert a Column break before the heading.

Which term describes the process of adding a tile to the Start menu or an icon to the taskbar?

(c) Pinning

Which of the following should you use to create a docu-ment without knowing much about the software?

(c) Template

What happens when you modify an existing style?

(c) The new style settings are automatically applied to text formatted in that style.

Why might you want to display nonprinting characters?

(c) To assist with troubleshooting a document and modifying its appearance

What feature is used to organize and access groups of open windows for different purposes, such as schoolwork and entertainment?

(c) Virtual Desktop

Which situation is the most logical for using the Go To command?

(d) Cell D10 is the active cell, and you want to go to cell D50.

Which action would you take when you want to copy the format of a selection but not the content?

(d) Click Format Painter in the Clipboard group.

Which of the following does not describe a tag in a Word document?

(d) Document title

Which of the following represent the file management systems on Windows and macOS?

(d) File Explorer and Finder

Which of the following best describes Snap assist?

(d) Fix an app window(s) to either side or the corners of the screen.

Which sharing feature in a meeting lets participants follow a presentation at their own pace?

(d) PowerPoint Participant View

Which of the following is necessary before you rely on AutoSave to automatically save a document?

(d) Save the document to OneDrive, OneDrive for Business, or SharePoint Online.

What happens when you enter search keywords in the Search box of File Explorer and the OneDrive option is selected?

(d) The search is limited to the selected location but can be expanded if you like.

Which of the following cannot be done to a channel file?

(d) Upload the file to a whiteboard

Which feature available in a Microsoft Teams meeting acts like a shared canvas?

(d) Whiteboard

Which of the following features formats a table with column and row dimensions that accommodate all cell entries, even if resulting widths and heights are not uniform?

A) AutoFit

A mail merge process requires which of the following?

A. (a) A main document and a merged list

Which of the following is an advantage of saving Word documents to OneDrive?

Answer: (a) AutoSave is on, which means a document is automatically saved every few seconds as it is being edited.

What is required before a table of figures can be created?

Answer: (a) Captions in a document identifying tables and figures

In which of the following situations would you need to edit a citation?

Answer: (a) If you misspelled an author's name when creating a source

Why might you choose to apply a table style to an existing table?

Answer: (a) To match the table theme to the document theme

Which feature provides the most uncluttered view of comments and tracked changes made to a document?

Answer: (b) All Markup

Why is it recommended that a table include column headings if data in the table is to be sorted later?

Answer: (b) Because column headings can be used as categories to sort by

Having applied custom borders to a table, what feature do you use to copy the border style to another table?

Answer: (b) Format Painter

What kind of indent is often used in preparing a bibliography for a research paper?

Answer: (b) Hanging indent

When is Auto Fill appropriate to use?

Answer: (b) To enter the days of the week down a column

When might it be necessary to use a dot leader when set-ting a tab?

Answer: (b) When you want to add style and interest to a mundane document

How does a table of contents differ from an index?

Answer: (c) A table of contents is based on a hierarchy of headings in a document, shown in page number order, while an index is an alphabetical listing of selected terms and related page numbers.

What feature enables you to apply special formats such as shadow, outline, reflection, or glow to text?

Answer: (c) Text Effects

Why is paragraph spacing necessary for some documents?

Answer: (c) To ensure that paragraphs can be differentiated from one another, particularly if the first line of each paragraph is not indented.

How would you choose whether to use a footnote or an endnote?

Answer: (c) You would consult the writing style you are following.

Cell C6 contains the value 1.2546. How does the value display if you format the cell with Percent Style with 1 decimal place?

Answer: (d) 125.5%

Which type object would you include in a document de-scribing a house that should be visible from all angles within the document?

Answer: (d) 3D model

Which of the following is not considered an accepted writing style?

Answer: (d) APA

How would you identify a series of sequential steps to sev-eral levels?

Answer: (d) Create a numbered list.

Which of the following objects is best suited to diagram-ming an organization chart?

Answer: (d) SmartArt

Why might it be beneficial to show the Reviewing Pane?

Answer: (d) So that you can more easily keep track of all changes and comments in a heavily edited document.

How is Word for the web limited?

Answer: (d) Word for the web can only open Word documents that are less than 15 KB in size.

Cell A2 contains the regular price $100. Cell B2 contains the discount rate 15%. Cell C3 contains =A2*(1-B2) to calculate the sale price of $85. Which of the following formulas produces the same result?

Answer: =A2*(1-B2)

What should you do if you see pound signs (###) instead of values or results of formulas?

Answer: C. Increase the column width.

You just selected and cut column D. Now you want to move it to be located before data in column B. What should you do next?

Answer: d) Right-click the column B heading and select Insert Cut Cells.

What is an advantage of using the Recommended Charts command?

C) The Insert Chart dialog box displays recommended chart types based on the selected data.

How could you modify the appearance of a caption so that any changes affect all captions in a document?

D. Modify the Caption style

The label Souvenir Shop is in cell A1, and April Sales Report is in cell B1. What happens when you select the range A1:E1 and click Merge & Center?

D. Souvenir Shop is combined with April Sales Report. The new combined label is then centered over the range A1:E1.

What is the keyboard shortcut to create an absolute reference?

F4

A worksheet contains columns listing new movie releases, total production costs, week 1 gross revenue, and week 2 gross revenue. Which of the following would least likely form a data series in a column chart?

Movie names

The function =PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C5?

a) APR

You are working with a large worksheet. Your row head-ings are in column A. Which command(s) should be used to see the row headings and the distant information in col-umns X, Y, and Z?

a) Freeze Panes command

Currently, a column chart shows values on the value axis, years on the category axis, and state names in the legend. What should you do if you want to organize data with the states on the category axis and the years shown in the legend?

a) Switch the rows and columns in the chart.

If the function =XLOOKUP(H13,C4:C10,B4:B10,"Item Not Found",1,1) is used, what will happen if an exact match is not found?

a) The function will return the value #NA.

Which of the following best describes the purpose of a mail merge process?

a. To produce a document or email message in which variable data is drawn from a data source and combined with a main document

When using the 1900 date system, the date 1/1/1900 is equivalent to what number?

b) 1

What function would most efficiently accomplish the same thing as =(B5+C5+D5+E5+F5)/5?

b) =AVERAGE(B5:F5)

What type of chart would display the names of seven city names (such as Jefferson City and Salt Lake City) on a category axis that is the easiest to read?

b) Bar Chart

When you start to type =AV, what feature displays a list of functions and defined names?

b) Formula AutoComplete

The value axis currently shows increments such as 50,000 and 100,000. What option would you select to display the values in increments of 50 and 100?

b) More Primary Vertical Axis Title Options

Why would you add Alt Text to a combo chart?

b) To adhere to accessibility compliance for screen reader capabilities

Which of the following is not a comparison operator?

c) &

What value will the MAXA function return if given the values -.02, -.07, -.09, and NA?

c) -.09

Which of the following functions should be used to insert the current date and time in a cell?

c) =NOW()

You want to copy the March worksheet to use it to enter data for April. After you right-click the March sheet tab and select Move or Copy, you click OK in the Move or Copy dialog box without changing any settings. What happens?

c) A copy of the March sheet is inserted to the left of the original March sheet. The new sheet is named March (1).

Office for the web is a collection of Microsoft Office apps with what primary purpose?

c) Serving as a subscription version of Microsoft Office

Which of the following is a purpose of a caption?

c) To provide a title or brief explanation of the table.

You want to create a single chart that shows the proportion of yearly sales for five divisions for each year for five years. Which type of chart can accommodate your needs?

d) 100% Stacked Column Chart

You have a large dataset that will print on several pages. You want to ensure that related records print on the same page with column and row labels visible and that confiden-tial information is not printed. You should apply all of the following page setup options except which one to accom-plish this task?

d) Change the print page order.

Which chart element should you display to show exact val-ues for a data series in a bar chart?

d) Data labels

You created a worksheet that tracks data for a basketball team. The range B10:F10 contains the difference in final points between your team and the other team. What is the recommended sparkline to create to represent this data?

d) Plus/Minus

Which of the following is not impacted when you apply a chart style?

d) The fill colors for data series change.

Which function is best utilized to perform a lookup when the lookup array and return array are in different tables within the workbook?

d) XLOOKUP

Where does a file deleted from OneDrive end up?

he Recycle bin