Computer applications

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 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.

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

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

How do you save a document in Microsoft Word?

File>Save

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

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

Format

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

Formulas

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.

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.

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.

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

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.

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.

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

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

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

column break

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

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

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

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

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

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 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

How do you change the shape of the screenshot?

through the New dropdown menu in the snipping tool

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