Computer Applications Final Exam

(P) A rectangular box in a slide layout where you enter text is a/an:

(P) To change theme backgrounds, layouts, colors, and fonts in an existing PowerPoint presentation, use the:

(E) When you are creating formulas using a cell location, the default cell reference is:

(W) When Word breaks up words that you want to keep together, fix this by using a:

(W) To find a synonym for a word in your document and add variety to your content, Word provides a:

(W) To be compatible with Microsoft Word 2003, a Word 365/2019 document should be saved with this extension.

(P) When you open PowerPoint and click Blank Presentation, you go directly to:

(E) It is important to remember that Excel calculates these operations before any others are performed:

(P) PowerPoint helps unify your presentation by providing built-in collections of fonts and colors called:

(E) This symbol alerts Excel that you are entering a formula and not text:

(W) Title, Author, Comments, Subject, Company, Created, and Last Modified are examples of:

(W) Page margin settings affect the readability of the page. Why might you choose the Narrow setting?

(P) To copy formatting changes from text, shapes, or pictures and apply these changes to another selection, use:

(P) By default, PowerPoint presentations are saved with which file extension?

(E) By default, Excel 2019 files are saved with this extension.

(W) The Spelling and Grammar/Check Document button is found in this tab on the Ribbon.

(E) After you select and cut cells, the cells are temporarily placed:

(E) Use this button to combine two or more cells into one cell and center the text over a group of columns.

(E) When you click on a cell to activate it, the cell address appears in the:

(W) To give your document a designer-quality look with coordinating colors and fonts, you can apply:

(W) The default font for Microsoft Word is:

(P) The keyboard shortcut that duplicates a slide in a presentation is:

(E) Excel comes with many built-in formulas called:

(W) To change letters that are uppercase to lowercase and lowercase letters to uppercase, use (the):

(W) To add a bulleted item before the first item in a bulleted list:

(W) You can modify alignment, line spacing, and paragraph spacing in the:

(E) The thin black plus sign pointer is used to:

(W) This feature recognizes and corrects commonly misspelled words.

(E) In Excel, the acronym “Please Excuse My Dear Aunt Sally” helps the user remember:

(P) When developing your presentation, you should use this view to see it as your audience will see it:

(P) Document properties that help you manage and track your PowerPoint presentation files are also called:

(E) In Microsoft Excel, the file you create and edit is called a:

(E) The default view in Excel is:

(E) This type of cell reference does not change when copied and remains in a fixed position during operations:

(P) To make your notes area larger in Normal view, adjust the:

(E) This Excel feature allows users to use common arithmetic operations to perform a calculation:

(P) The visual effect of movement that occurs when one slide changes into another slide is called a(n):

(P) “Views” are important in PowerPoint for organization. The default view is:

(P) To add a picture to your presentation, which tab should you go to first?

(E) To quickly select all the cells in a worksheet:

(P) To include identifying information on all slides, insert:

(E) A rectangular group of cells in Excel is called a(n):

(E) This Excel feature allows you to view totals, averages, or other statistical information without creating a formula:

(E) A quick way to insert a new column or row in an existing worksheet is to select a column or row and press:

(W) The paper size default in Microsoft Word is: