computer applications 2

In the block style business letter, the inside address appears below the date, with one blank _______ in between.

paragraph

Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle wants to change the thickness of one of the shape outlines. Thickness is another word for ____.

weight

_____ handles are the small circles that appear in the corners and in the middle of the sides of the border of a selected object.

sizing

Clicking either the Date & Time button or the ____ button opens the Header & Footer dialog box.

slide number

Normal view displays slides one at a time in the ____.

slide pane

Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. PowerPoint files consist of what looks like pages in a document. Ethan correctly calls these buttons ____.

slides

A _____ indicates a manual page break.

solid blue line

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

spreadsheet

Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. To add visual interest, Kyle changes the ____ of the shape's border by changing the solid outline to a dashed line.

style

A second-level item in a list is sometimes called a ______

subitem

A(n) _______ is a window that helps you navigate through a complex feature.

task pane

A(n) ____, like any presentation, has a theme applied, but it also contains text, graphics, and placeholders to help direct you in creating content for a presentation.

templates

Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. Once Kamilla decides to work with the Title slide she sees that it has two ____.

text placeholders

Drag the ____ adjustment handle on a shape to change its proportions without changing the size of the shape.

yellow

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _____.

theme

Usually the date and slide number do not need to appear on the ____.

title slide

In ____, the ribbon increases in height, the buttons are bigger, and more space appears around each button so you can more easily use your finger or a stylus to tap the button you need.

touch mode

If a video is too long, or if there are parts you don't want to show during the slide show, you can ____ it.

trim

Fonts, colors, and cell styles are organized in _____ categories.

Theme and Non Theme

To apply a theme from a presentation stored on your computer or network, click the ____ button, and then click Browse for Themes.

Themes More

Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. Ivan tells Kamilla that the first slide of her presentation will be the ____ slide.

Title

A commonly used layout is the ____ layout.

Title and Content

If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.

alt-enter

When you copy a selection of cells using drag and drop, which appears before you release the mouse button?

an outline of the new location of the selected range

The Media ____ category appears only when a media object—either video or audio—is selected on a slide.

animation

The characters +, -, *, and / are examples of ____.

arithmetic operators

As a general rule you should _____.

center column titles, left-align text, and right-align numbers

A method for selecting multiple lines of text is to...

click and drag in the white space to the left of the lines

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold would like to center a title across the top of his data. His data runs across five columns, from column A to column E. One way he could accomplish this is to _____.

type the data in A1 and Merge cells A1:E1

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____.

use Format Painter

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way?

use the Number group to decrease number of digits displayed

Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. In his work on the letter, Kade inserts a sentence, then changes his mind and deletes the sentence using the Cut command. He then changes his mind again and _______.

clicks the Undo button to undo the delete

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

colon

Excel makes reading formulas simpler by ____ each cell reference in the formula and its corresponding cell in the worksheet.

color coding

"AZ" is an example of a ____.

column heading

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add _____ to the cell.

conditional formatting

Sequence options appear on the Effect Options menu in addition to the ____ options when an animation is applied to a text box.

direction

When you choose the ____ compression setting, photos are compressed to the resolution specified on the Advanced tab in the PowerPoint Options dialog box.

document resolution

Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. To change the speed of a transition, John shows Merlia how to change the ____.

duration

Header and footer elements such as worksheet name, current date, and time are _____ elements.

dynamic

Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. Merlia wants all of her slides to come "From Right" except the last slide. She can change the last slide to come "From Top" by clicking the ____ button.

effect options

Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle wants to add a 3D rotation to highlight one of the mountain ranges. To do this he clicks the Shape ____ button.

effects

An Excel formula always begins with a(n) ____.

equals sign

Which of the following takes precedence over multiplication?

exponentation

A theme and its variants are called a theme ____.

family

To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color.

fill color

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

find

To set a page break in Excel, select the _____.

first cell below the row where you want to insert a page break

A ____ item is a main item in a list.

first level

Like shapes, you can rotate or ____ pictures using the Rotate handle or the Rotate button.

flip

A _______ is a set of characters that uses the same typeface.

font

In common usage, a(n) ____ is any text that appears at the bottom of every page in a document or every slide in a presentation.

footer

To insert video stored on your computer or network, click the Insert Video button in a content placeholder, and then in the Insert Video window next to "____," click Browse to open the Insert Video dialog box.

from a file

Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. Kyle easily adds new shapes to a timeline. He simply clicks the shape he needs in the Shapes ____.

gallery

By default, numbers appear in the _____ and generally display values exactly as you type them.

general format

When you print ____, the presentation is printed with one or more slides on each piece of paper.

handouts

_____ are printed documents you give to your audience before, during, or after your presentation.

handouts

The main difference among different types of business letters is _______.

how parts of the letter are indented from the left margin

One of the benefits of Live Preview is...

it lets you see and evaluate different formats as you develop your workbook

The header and footer sections include a _____.

left, right and center section

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _____.

legend

If you press the Shift+Enter keys at the end of a line, this inserts a _______ line break.

manual

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.

nonadjascent

To duplicate, rearrange, or delete slides, you select the slides in the Slides tab in ____ view or switch to Slide Sorter view.

normal

Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. When Ethan first creates a new presentation it is displayed in ____ view.

normal

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value.

numbers

If you animate a list, the default is for the first-level items to appear ____.

one at a time

If you have closed a saved presentation, open it in Backstage view by using the ____ command.

open

The code _____ will display the filename of the current workbook.

&[File]

By default Word documents include _______ margins on all sides of the document.

1 inch

Put the following five steps in the order in which you would perform them to use the Paste Special function. 1. Select and copy a range. 2. Click the Paste button arrow in the Clipboard group on the HOME Tab. 3. Specify exactly what you want to paste. 4. Click Paste Special to open the dialog box. 5. Select the range where you want to paste the Clipboard contents.

1, 5, 2, 4, 3

An Excel worksheet can have a maximum of ____ columns in a worksheet.

16,384

To move or copy a range of cells, select the correct order: 1. Move the pointer over the border of the selection until the pointer changes shape. 2. Select the cell or range you want to move or copy. 3. To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

2,1,3

When you save a presentation that contains photos, PowerPoint automatically compresses the photos to a resolution of ____ pixels per inch (ppi).

220

The most commonly used video formats are the MPEG-____ format, the Windows Media Audio/Video format, and the Audio Visual Interleave format.

4

What is the result of the expression =50+20/10*5?

60

If photos need to be emailed or uploaded to a Web page, choose the ____ ppi compression setting.

96

he formula used to multiply cell A1 by cell C1 is ____.

=A1*C1

What is the syntax for a SUM formula adding the values of cell F6 to F9?

=SUM(F6:F9)

According to the order of operation in Excel:

A. Excel performs exponentiation, then multiplication and division, then addition, and subtraction.

In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.

A1

Antoinette is part of a college department creating a number of student files with Microsoft Excel. She is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function.

AVERAGE

Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. John tells Merlia that it is often best to use the same slide transition consistently. He shows her the ____ button which applies the transition to all the slides in the presentation.

Apply to All

To flip an object, you use the Flip commands on the Rotate button menu in the ____ group on the DRAWING TOOLS FORMAT tab.

Arrange

____ makes it easier to enter repetitive text in cells.

AutoComplete

Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. Anxious to apply, Gabrielle downloads the form and opens it on her computer. In the space allocated for today's date, Andrea types Janu and then is prompted by _______.

AutoComplete to insert the name of the month, January

Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. Gabrielle is very excited and rushing. She continually types "teh" instead of "the." Fortunately, the _______.

AutoCorrect feature corrects it automatically

____ adjusts default font sizes and line spacing to make the text fit.

AutoFit

To change a column width, you can click ____ on the Column submenu to make the column(s) as wide as the longest entry of the cells in the column.

Autofit

During your presentation, you can easily display a blank black slide by pressing the ____ key(s).

B

You can move to the previous or next sheet by pressing the ____ keys.

B. Ctrl + Page Up or Ctrl + Page Down

Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. When Ethan first opens PowerPoint, he has two ____ view options: 1) to open an existing presentation or 2) to create a new file.

Backstage

Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. When Kamilla clicks in the Title placeholder, the insertion point appears as a ____ line in the center of the placeholder.

Blinking

The Format Cells dialog box has six tabs, including _____.

Border

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold cannot increase the width of his worksheet because, if he does, he will not be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data?

Choose Wrap Text for the columns

To make A1 the active cell, you should press which of the following keys?

Ctrl + Home

Whenever you click the Save button on the Quick Access Toolbar or press the ____ keys, the workbook file is updated to reflect the latest content.

Ctrl + S

An installed theme can be applied by clicking on a theme in the Themes group on the ____ tab.

DESIGN

Kamilla is creating a presentation about her family for a homework assignment. Her friend Ivan, a PowerPoint 2016 expert, is helping her. When Kamilla clicks in the Title placeholder a contextual tab, the ____ tab, appears on the ribbon.

DRAWING TOOLS FORMAT

_____ are an example of conditional formats in Excel.

Data bars

When you use the Borders button arrow, the borders will be the style, weight, and color specified by the Pen Style, Pen Weight, and Pen Color buttons in the ____ Borders group.

Draw

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.

Duplicate Values

To switch to ____ mode, you double-click the cell.

Edit

Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. The next day Kade opens the letter in order to proofread it. He realizes that there is some formatting in part of the letter that he would like to use elsewhere in the letter. After using the Format Painter, he wants to turn it off. What key should he press?

Esc

Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas has just applied Header 1 to some selected text in his report. He needs to do the same thing again now. To save time, you suggest that he press the ____ key to repeat his most recent action.

F4

In Slide Sorter view, slides are displayed as thumbnails and the Slides tab appears.

False

____ enters text based on patterns it finds in the data.

Flash Fill

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

Format Cells

In a workbook's theme, _____ colors are designated for text and background, _____ colors are used for accents and highlights, and _____ colors are used for hyperlinks.

Four, six, two

Ctrl + G is used to access the ____.

Go to a location in the worksheet command

To go to column A of the current row, press ____.

Home

To draw a shape, click the Shapes button in the Illustrations group on the _____ tab, click a shape in the gallery, and then click and drag to draw the shape in the size you want.

INSERT

When you choose the ____ compression level for videos the file will be compressed to a quality suitable for streaming over the Internet.

Internet Quality

When you choose the ____ compression level for videos the file will be compressed as small as possible.

Low Quality

To compress the videos in a presentation, click the Compress ____ button.

Media

_____ merges each of the rows in the selected range across the columns in the range.

Merge across

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

Number

The Info screen in Backstage view contains a(n) ____ Media button as well as the Compress Media button.

Optimize

Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab.

Orientation

displays the location of the different page breaks within the worksheet.

Page Break Preview

Thomas is writing a report for his advertising class in which he analyzes corporate campaigns and ad slogans. To compile his report, he needs to copy several quotes and portions of articles from other documents, and needs to pay special attention to formatting. Thomas is working on his report, which has a lot of comments, on a small monitor. He would like to switch the document Zoom level so Word would automatically reduce the width of the document to accommodate the comments. Which of the following will do this for him?

Page Width

Use the Animation ____ to copy the animation, effects, and duration applied to one object to another object.

Painter

Kade is writing a cover letter that he will send with copies of his resume to different software development firms. Since a cover letter determines the first impression he will make, it has to be flawless. He has finished typing the letter but must stop to go to an evening class. He quickly saves it and exits Word. Kade thinks that a photo may help to illustrate a point he is making in the letter about a project on which he has worked. What is the term for the photo he wants to insert into this document?

Picture

Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. Ethan has not saved his PowerPoint file yet, and it appears with a temporary filename "____" followed by a number.

Presentation

When you choose the ____ compression level for videos the file will be compressed slightly and will maintain the quality of the videos.

Presentation Quality

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

Protection

Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting.

Quick Analysis Tool

____ view displays the slides so that they almost fill the screen, and a status bar appears identifying the number of the current slide and providing buttons to advance the slide show.

Reading

Using PowerPoint 2016, Ethan develops a short five-slide presentation for his marketing project. After opening PowerPoint, Ethan sees buttons to execute commands in the ____ area.

Ribbon

Using PowerPoint 2016, Kyle develops a presentation on the geography of Asia. His presentation includes several shapes. To open a menu of Rotate and Flip commands, Kyle clicks the ____ button.

Rotate

As you continue to add text at the end of a document, the text typed earlier will _______ and disappear from the top of the document window.

Scroll

____ is background color that you can apply to one or more paragraphs and can be used in conjunction with a border for a more defined effect.

Shading

To move the active cell up one row, press ____.

Shift + Enter

____ notes are information you add about slide content to help you remember to bring up specific points during the presentation.

Speaker

To insert a table, in a content placeholder, click the INSERT tab on the ribbon, click the Table button in the ____ group, and then click Insert Table.

Tables

Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. The first part of the form asks applicants to write one paragraph about why they would like to at work Channel 30. Right away, Gabrielle knows what she wants to write; she's grown up with Channel 30 and has always been impressed by the quality of the news anchors, especially Katie Couric. Each time she types Couric in her response, a red

Word considers "Couric" to be a misspelled word

Changing the _______ affects only the way the document is displayed on the screen.

Zoom

mm/dd/yyyy is known as ____.

a date format

Click the "Return to the previous slide" and "____ to the next slide" buttons to move from slide to slide in Slide Show view.

advance

Gabrielle wants very much to get a job in television. Each day she visits local television station websites and peruses the Help Wanted sections. To her surprise, there is an opening for a production assistant at Channel 30. To apply for the job, applicants must download a form from the Channel 30 website, fill it out, and then email it to the human resources manager. The form is a Microsoft Word 2013 document. The last part of the form asks applicants to create a bulleted list of their accomplishments. Gabrielle does not like the amount of space the program inserts between the bulleted items each time she presses Enter, so she adjusts the _______.

paragraph spacing

To change the order of operations, enclose part of the formula in ____.

parentheses

After you insert a video, you can modify it by changing ____ options, changing the length of time the video plays, and applying formats and styles to the video.

playback

In ____ orientation, a page is taller than it is wide.

portrait

If you see a black square when you insert a video, you can override this by setting a ____ frame.

poster

Click the _____ button on the TRANSITIONS tab to preview transitions.

preview

Merlia is creating a presentation about her ethnic heritage for a homework assignment. Her friend John, a PowerPoint 2016 expert, is helping her add transitions. After working for a while, Merlia wants to see how the transitions look. John shows her that there is a _____ on the TRANSITIONS tab to preview transitions.

preview button

Information that prints on each page, like a company name or logo, may be set as a _____.

print title

A(n) ____ is a group of cells in a rectangular block.

range

To find a template on Office.com, display the ____ or New screen in Backstage view.

recent

Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold has chosen green as the background color for his workbook. He should not use _____ for any of the font or highlight colors.

red

Use the ____ Picture button to undo formatting and sizing changes you made to a picture.

reset

In Excel, dates are _____-aligned in the cell by default, regardless of date format.

right

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

right

To edit a presentation without changing the original, create a copy of it. To do this, use the ____ command.

save as

You can ____ the width or the height of the printout so that all of the columns or all of the rows fit on a single page.

scale

The white space in the left margin is sometimes referred to as the ______ bar.

selection

Keyboard ____ can help you work faster and more efficiently because you can keep your hands on the keyboard.

shortcuts