Computer applications

Lukas is working on his PowerPoint presentation for the Marketing department. What would Lukas do, besides changing the content, to make the presentation look visually new and fresh?

Change the theme for the slides.

You are using a PowerPoint template from your school to present your research findings in front of the class. What would you do, besides changing the content, to make the presentation seem new and fresh?

Change the theme for the slides.

If you are reading instructions on how to do something in Windows 10 and in Windows 7, what can you do to make you follow the right instructions?

Check what operating system you are running.

The ________ is the easy way to insert a new slide between existing slides.

"New Slide" button in the Home tab "Slides" group

To place an image in the center of a slide, you can use the ________ option.

Arrange

Dan is in the middle of his PowerPoint presentation when the wireless internet goes down. Dan isn't worried because he uploaded the videos in his presentation. He continues without interruption. Why was Dan not worried about losing his internet connection?

Because the uploaded video can still be played even with no internet connection.

Cindy walks through these steps; Excel Chart > Ctrl +C > PowerPoint Slide > Ctrl+V > Resize. What did Cindy just do in her PowerPoint presentation?

Cindy copied and pasted an existing Excel chart into her PowerPoint slide.

What does Ctrl+Click let you do in File Explorer?

Select multiple files and folders

Which of the following is true of this file path? C:\Users\user\Documents\Rowan\Spreadsheets\Summer\Sales Reports

The Spreadsheets folder is in the Rowan folder.

If you use the "Format" button in the "Cells" group of the ribbon, you can quickly ________.

resize all the columns of a table

Which of the following best describes what the option Send Backward does?

sends the item behind one other item in the document

The ________ shortcut to add a new worksheet can be found at the bottom of the active workbook.

"+"

The "Insert" option can be used to add a new worksheet from the ________ menu.

"Cells" group of the ribbon

________ can be used to change the way a chart looks, such as bar versus lines.

"Change Chart Type"

If you wish to sort a column based on clothing size, use the ________ option.

"Custom Sort"

The ________ tab contains the "Filter" menu for quickly hiding some data.

"Data"

The ________ button lets a user hide some data but does not actually delete it from the worksheet.

"Filter"

The ________ button will also sort data from smallest to largest.

"Sort A to Z"

________ can be used to change what data is on which axis of a chart.

"Switch Row/Column"

Use the ________ option to set conditional formatting to highlight cells that contain a specific word.

"text that contains"

Which of the buttons below can be used to underline text?

(Button with a U.)

Which of the following buttons minimizes a program?

-(A button with a horizontal line.)

If you use the comma button in the "Numbers" group of the ribbon, you can quickly apply the ________ comma style.

1000 Separator

The ________ button within the Styles group is used to quickly apply a visual cue to selected cells in an Excel worksheet.

Cell Styles

The "Insert" tab contains the ________ group that is used to create charts in Excel.

Chart

If you wish to visualize data so that the information is represented as vertical bars, create a ________.

Clustered Column Chart

The ________ button in the "Numbers" group applies a comma and two decimal points to numbers in Excel.

Comma

Elias wants to italicize and bold the title of his newsletter. What keyboard shortcuts can he use?

Ctrl+B, Ctrl+I

What is the keyboard shortcut for the Find and Replace function?

Ctrl+H

You are working in Excel and realize you need to create a totally new, separate worksheet. What keyboard shortcut should you use?

Ctrl-N

Claire wants to save a document she's working on in Microsoft Word. What is the Windows keyboard shortcut she can use?

Ctrl-S

The ________ button in the "Cell" group of the ribbon has a simple dropdown for removing a row of data from a worksheet.

Delete

In Windows, which of the following is the primary way of interacting with files and folders?

File Explorer

How do you save a document in Microsoft Word?

File>Save

How can you add an image to a document?

Insert>Pictures

Which of the following puts two columns on a page?

Layout>Columns>Two

Rowan Retail must know who the specific audience is for the specialty Halloween costumes for the Fall catalogue. Melissa is put in charge of finding this out and starts with a general search in Google about these types of specialty costumes. How does she know how many search results were returned from her search?

Melissa can look at the line under the search box that says "About xxx,xxx results."

The ________ view will allow you to see image and texts on thumbnails.

Normal

The ________ group of the ribbon has a simple dropdown for changing the format of cells.

Numbers

If Ike wanted to open the first result for a search in the category made for news, which of the following steps should he follow?

Open Search Engine > Type search terms > Press Enter > Select News > Click on first result hyperlink

Emil wants to work in two Microsoft Word documents at once. Which of the following methods can he use to accomplish this?

Resize both Microsoft Word windows so that he can see both at once.

You are searching for videos on best practices for running work meetings and have over 200 thousand results from books, articles, websites, consulting services, and more. You need to narrow the results to fit your desired results. What can you do?

Select one of the category menu links and see the associated focused search results.

What is the difference between Sleep and Shut Down?

Sleep saves your session and enters a low-power state; Shut Down closes all programs and turns the computer off

From where can you open Explorer, Chrome, or Firefox?

Start menu

Which of the following is the best method for taking an irregularly shaped screenshot?

Take a free-form screenshot.

Which of the following is an operating system?

Windows 10

Zackary conducted a search using the terms software engineer and then ran a new search using the search "software engineer", what would happen to the results of the second search compared with the first search?

Zackary would see a large set of search results in the first search and a significant decrease in the number of search results in the second search.

The Normal view is useful for ________.

a snapshot of text and images on thumbnails

The "Insert" tab "Text" group can be used to ________.

adding a clarifying text box to a slide

Which of the following best describes a watermark?

an identifying image, shape, or piece of text over the text on each page of the document

Brandon has a table in Microsoft Word, and he wants to make it look nicer and be more readable. Which of the following is the fastest way to do this?

apply a table style

A table style can be used to ________.

apply an overall color scheme to a table

Which of the following best describes text effects?

applying graphic effects to text

Which of the following best describes what the option Bring Forward does?

brings the item in front of one other item in the document

When you wish to quickly indicate that certain cells in a table are different, you should apply a ________ style.

cell

Change Chart Type can ________.

change the visuals of a chart, such as bars versus columns

In order to remove a slide from a presentation, you should ________

click on the thumbnail view of the slide and click 'delete'

How do you enter data into a cell?

click the cell and start typing

Which of the following ends a column and sends text to the next column?

column break

Data can be filtered in Excel in order to ________.

hide, but not delete, some data from the worksheet

"IF" can be used to calculate ________.

how much over budget a department was every month

"COUNTIF" can be used to calculate ________.

how often Sarah answers the phone

Which of the following methods will let you work in a Word document and an Excel document at the same time?

switching between Word and Excel on the taskbar

If you want to create a new document in Microsoft Word, what is the right command to use?

File>New

To open a new worksheet in Excel, you should use the ________ command.

File>New

Which of the following methods opens a new document in Microsoft Word?

File>New

If you want to save a document you've created in Microsoft Word, what is the correct command?

File>Save

Ctrl-E' is the keyboard shortcut for ________.

Flash Fill

Kendra is writing promotional material in Microsoft Word when she sees a red wavy line underneath her company's name. After making sure she spelled the name correctly, what can she do to stop seeing the red wavy line under her company's name?

Right click on the word and select Add or Add to Dictionary

Which of the following methods will rename a file?

Right-click on the file and select Rename.

Peter's team at work has asked him to create an agenda for the team meeting next week. Peter has never used an agenda before and thinks his best option is to search for various examples online. After turning on his computer and starting up the Chrome browser, what should be his next step?

Search Google for templates for his meeting.

Todd works as the manager of a marketing department. He needs to find out if there are good marketing ideas about tires or wheels. To make sure that Todd can see the results of marketing tires, wheels or both together, what should Todd type into the search bar?

Todd should type tires OR wheels into the search bar.

Tina is the manager of the automotive department at Rowan Retail. She has received several customer requests for a product called Seafoam SF-16 Motor Tune-Up which removes moisture and cleans valves and fuel systems in cars. She has not heard of this product and wants to find out more about it. On her work computer she opens the Microsoft Edge browser and finds the Bing search bar. What should be Tina's next step?

Type in a specific search into Bing about Seafoam SF-16 product.

Lia creates a 5-by-5 cell table. How can she start adding information to each cell of her table?

click the cell and start typing

Tamara has a document with data that needs to be formatted into a table. Which of the following options is the best for her to use?

convert text to table

Using a button and dropdown within the "Cell" group of the ribbon, you can ________.

delete a row of data

You are working in PowerPoint and realize you need to create a totally new, separate presentation. What keyboard shortcut should you use?

Ctrl+N

The AutoSum button can be found on the ________ tab of Excel.

Formulas

________ is the keyboard shortcut to create a new presentation in PowerPoint.

Ctrl+N

Daisy has an uploaded video in a slide, but there is a loud noise at the beginning she doesn't wish to play in the video. What can Daisy do with the video to get rid of that noise?

Daisy should open the Playback Tab and trim the beginning of video.

David uploaded video in a PowerPoint slide, but there is a disruptive person running around in the last 30 seconds and he doesn't wish to play that in the presentation. What can David do with the video to cut out the person?

David should open the Playback Tab and trim the end of video.

The ________ tab can be used to change the color options of a SmartArt graphic.

Design

Kwan needs to insert a video he found online into his PowerPoint presentation. What is the last step he needs to take to fit the video in his presentation?

Drag the resized video to center is in the slide.

You need to create a new presentation in PowerPoint. Which command should you use?

File>New

You can resize all rows of a table using the ________ button in the "Cells" group.

Format

The ________ option can fuse multiple objects into a single object for editing.

Group

Holly ran a search while putting together her quarterly reports to find the most common mistakes made in producing financial reports and make sure she didn't make them. After looking at the search results, she needed to eliminate a few of them to see what else she needed to look out for. How could Holly change her search results so she did not see anything about taxes or payroll mistakes?

If Holly typed in her search and used the -payroll -taxes she would eliminate those results in her search.

If Gary wants to create a search for retail store supplies but already has plenty of shelves for his store. How would Gary eliminate shelves from his web search?

In the search bar Gary would type retail store supplies NOT shelves.

What is the process for Greta to integrate an internet video into her Word document?

Insert Tab > Media > Online Video Button > Search YouTube

Avery opens her new product purchase PowerPoint presentation and wishes to integrate a new Excel chart into it. What steps should she take?

Insert a new chart through the Insert > Chart button.

Titus would like to make his products stand out a little more in his Excel spreadsheet. What actions would help to distinguish one product from another?

Insert pictures from the internet of each product in the Excel spreadsheet.

Sam wishes to place a small, generic, representative symbol of a lightbulb in his Word document. Which choice would most closely fit his wishes?

Lightbulb icon

To add a video to a slide, you can use the ________ option.

Media

Mia needs to integrate a symbol of a dollar sign into her annual report in Word. Which steps does Mia take to insert a dollar sign symbol into an existing Word document and make it fit?

Open Word Document > Insert Tab > Illustrations > Icon Button > Select Icon > Select Insert Button > Resize Icon > Select Layout Option

Hector needs an Excel table of sales figures in his Word document but he doesn't have an existing table. How does Hector integrate a new Excel table into his document?

Opens Word Document > Selects Insert Tab > Selects Table Button > Selects Excel Spreadsheet > Types Data into Table

To add an image to a slide, you can use the ________ option.

Picture

Mary is in charge of putting together a presentation for her team's new hire training session. She is updating the presentation from last year and wants to use more images to make the presentation interesting. Mary ran a Google search by typing in the terms customer service training and now wishes to see just the images for her search. What steps are the most direct way for her to see images she can use in her presentation?

Search Results > Images Category > Select Further Image Focus Buttons

Felipe just walked through the following steps; Video Tools > Playback Tab > Start Button > On Click. What has he done to his embeded video?

The video will play when he clicks the video.

Roxie thinks her presentation slides are fairly bland and wants to add in a variety of ways to make the slides move from one slide to another in a more interesting manner. What steps does Roxie take to make each whole slide movement more dynamic?

Transition Tab > Effect Options Button > Select Effect Option

How would you use the Insert Tab in PowerPoint to access pictures on the internet?

You would select the Online Pictures button and find pictures using the Bing image search box.

The Picture option will allow you to ________.

add a number of different image types to slides

The SmartArt specific Design tab includes the ________.

color and layout options

To ________ a SmartArt graphic, you need to first ________ one.

create; insert

What does emptying the Recycle Bin do?

deletes everything in the Recycle Bin forever

The thumbnail view can be very helpful for ________.

deleting an entire slide

Which of the following best describes what a column break does?

ends a column and sends text to the next column

To create a SmartArt graphic, you need to ________.

first insert a SmartArt graphic

The "Insert" tab "Text" group can be used to ________.

insert a header or footer

Which of the following is the best method of using Microsoft Word to mark a sample document?

insert a watermark that reads "Sample"

If a paragraph lines up with the left margin, which of the following alignments does it have?

left-aligned

Which of the following is one of the effects of decreasing the line spacing?

more words fit on a page

Which of the following does the shortcut Ctrl+Alt+Delete do?

opens the Task Manager

The Playback tab includes the ________.

option to trim an embedded video

What text effects are available in Word?

outline, shadow, reflection, glow

Anika's is trying to organize her data files for inventory in Microsoft Excel and wants to see what kind of templates are available for her instead of having to create her own. First she Googles the terms Microsoft Excel templates and sees ________ .

over 26 million results

The Arrange option can ________.

place an object in a specific position on a slide

The thumbnail view shows you a ________.

smaller image of multiple slides

If you wish to quickly apply a color scheme to an entire set of rows and columns in Excel, you should apply a ________ style.

table

Which of the following describes colors, spacing, borders, and other effects that change the appearance of a table?

table style

Which of the following can be used as separators when converting text to a table?

tabs, commas, or other characters

Jan has finished writing her header. How can she go back to editing the rest of her document?

the Close Header and Footer button

After clicking a hyperlink, which of the following best describes what happens?

the hyperlink's color changes

By default, which of the following best describes what happens to a hyperlink after it has been clicked?

the hyperlink's color changes

The theme is ________.

the overall visual look of a presentation

What is the Recycle Bin?

the place where deleted files and folders go

On which part of the document is the header?

the top of the document

A ________ is the overall visual look of a presentation.

theme

How do you change the shape of the screenshot?

through the New dropdown menu in the snipping tool

The ________ view shows you a smaller image of multiple slides at once.

thumbnail

A(n) ________ is the way a slide appears or leaves the screen.

transition

How are ungrammatical words indicated in Microsoft Word?

two blue underlines or a green wavy underline

The ________ predominantly changes what is shown in the thumbnail display.

view

The main difference between the Normal and Outline view is ________.

what the thumbnails display

When you insert an image, where does the image appear?

wherever the cursor is

Grouped objects ________.

will be treated as a single object when arranging or resizing