Final Introduction to Computer Applications EHS
The ________ option can quickly add up all the numbers in a column or row.
AutoSum
What does Ctrl+Click let you do in File Explorer?
Select multiple files and folders
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 true of this file path? C:\Users\user\Documents\Rowan\Spreadsheets\Summer\Sales Reports
The Spreadsheets folder is in the Rowan folder.
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
Jan has finished writing her header. How can she go back to editing the rest of her document?
the Close Header and Footer button
What has changed between the two sentences in the screenshot above?
the font of the text
How are ungrammatical words indicated in Microsoft Word?
two blue underlines or a green wavy underline
In the screenshot above, which text is bold?
vary widely from computer to computer
When you insert an image, where does the image appear?
wherever the cursor is
Which of the following does the shortcut Alt+F4 do?
automatically quits the active program
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
The SmartArt specific Design tab includes the ________.
color and layout options
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
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 ________ button lets a user hide some data but does not actually delete it from the worksheet.
"Filter"
The ________ tab contains the buttons for creating a sparkline in Excel.
"Insert"
________ can be used to change what data is on which axis of a chart.
"Switch Row/Column"
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.)
Which of the following file types works with newer versions of Word (2007 and newer) but not older ones?
.docx
If you use the comma button in the "Numbers" group of the ribbon, you can quickly apply the ________ comma style.
1000 Separator
Which of the following can be used as separators when converting text to a table?
tabs, commas, or other characters
What is the Recycle Bin?
the place where deleted files and folders go
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
The ________ button within the Styles group is used to quickly apply a visual cue to selected cells in an Excel worksheet.
Cell Styles
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.
Which of the following methods will rename a file?
Click on the file, wait one second, then click it again
The ________ button in the "Numbers" group applies a comma and two decimal points to numbers in Excel.
Comma
Rowan Retail needs to know who their target audience is for marketing speciality hair coloring products. Kevin is put in charge of finding this out and starts with a general search in Google. How does he know how many search results were returned from his query?
Kevin can look at the line under the search box that says "About xxx,xxx results."
Which of the following is a right tab stop?
L in the other side
Which of the following puts two columns on a page?
Layout>Columns>Two
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 shortcuts to bold and italicize text?
Ctrl+B, Ctrl+I
What is the keyboard shortcut for the Find function?
Ctrl+F
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
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
Roy needs to make the following documents: a single flyer to put on several bulletin boards, several copies of a memo to be distributed to his coworkers, and a series of letters addressed to each member of his project team thanking them each by name for their work. Which of those documents is best suited for using a template?
the thank-you letters
On which part of the document is the header?
the top of the document
The ________ button in the "Cell" group of the ribbon has a simple dropdown for removing a row of data from a worksheet.
Delete
The AutoSum button can be found on the ________ tab of Excel.
Formulas
You have navigated back to a previous webpage on your browser and now wish to move ahead to the current webpage. What browser button would you use to advance toward the most currently displayed webpage?
Forward Arrow Button
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 methods will rename a file?
Right-click on the file and select Rename.
In the Save As dialog box, which field lets you choose the file type of the saved document?
Save as type
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.
Kayla wants to add a text wrap to her image. Which of the following icons should she press?
U upside down
Which of the following icons represents the text wrap option?
U upside down
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.
What happens when you open a template in Microsoft Word?
a copy of the template is created as a new document
When inserting a hyperlink, what goes in the Address field?
a website URL, email address, or file path
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
What is different about uploading a video into a slide rather than inserting or embedding a video?
If the video is uploaded, no internet connection is needed to play it.
Which of the following best describes what a column break does?
ends a column and sends text to the next column
If you use the "Format" button in the "Cells" group of the ribbon, you can quickly ________.
resize all the columns of a table
What does Restore All in the Recycle Bin do?
restores everything in the Recycle Bin to its former location
The theme is ________.
the overall visual look of a presentation
The ________ tab contains the "Filter" menu for quickly hiding some data.
"Data"
A text box can be added to a slide using the ________.
"Insert" tab, "Text" group
Use the ________ option to change how closely the worksheet is printed to the edge of the paper.
"Margins"
The ________ is the easy way to insert a new slide between existing slides.
"New Slide" button in the Home tab "Slides" group
Use the ________ option to set conditional formatting to highlight cells that contain a specific word.
"text that contains"
The Insert tab includes the ________.
'Online Picture' option for searching for clip art
Samuel needs to begin conducting research on the internet for a presentation. He will access the internet from his desktop and want to open the Edge browser to begin. Which icon identifies the Edge browser?
A is the Edge browser icon.
Abigail needs an Excel table in her PowerPoint presentation so she can type in product information. What would be the best way to accomplish this?
Abigail inserts a new Excel table into a new slide.
Angenette is conducting a web search to see about her company's tagline and what also may be associated with the same phrase. How would Angenette search the exact phrase to see what other search results are associated with her company's tagline?
Angenette should put the company tagline between quotation marks "tagline".
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.
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.
If you wish to visualize data so that the information is represented as vertical bars, create a ________.
Clustered Column Chart
You are working in PowerPoint and realize you need to create a totally new, separate presentation. What keyboard shortcut should you use?
Ctrl+N
________ 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.
The ________ tab can be used to change the color options of a SmartArt graphic.
Design
Themes can be changed using the ________ tab.
Design
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
You need to create a new presentation in PowerPoint. Which command should you use?
File>New
The ________ option can fuse multiple objects into a single object for editing.
Group
The ________ tab can be used to add clip art to slides.
Insert
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.
If Ava creates a table of grocery prices in Excel and wishes to use it in her presentation, what should she do?
Integrate the existing Excel table by selecting it, copy it with Ctrl+C and paste it in a PowerPoint slide with Ctrl+V.
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
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."
What is this browser tool called and what does it do?
Minimize button—minimizes the window to the taskbar.
What does Layout>Columns do?
Moves text into columns on the page
The ________ group of the ribbon has a simple dropdown for changing the format of cells.
Numbers
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
Which of the options shown above changes the color of text?
Option 3
To add an image to a slide, you can use the ________ option.
Picture
The ________ tab can be used to shorten the length of an embedded video.
Playback
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.
Richard is working on his work presentation and finished with the text content, but realizes he needs images to support his text. The first image he needs are modern women in business attire. Richard ran a Google search by typing in the terms business attire first and now wishes to see just the images he needs. What steps does Richard take to see the images he needs for his presentation?
Search Results > Images Category > Right Arrow > Woman Professional > Right Arrow > Modern
Evie clicks through her presentation slides and realizes they all have transition effects coming from the same location, from the bottom up. She wants to change some of the slides to have transition effects from different locations. What steps can she take change slide transition effects?
Transition Tab > Effect Options Button > Select Effect Option
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 Normal view is useful for ________.
a snapshot of text and images on thumbnails
The Picture option will allow you to ________.
add a number of different image types to slides
The "Insert" tab "Text" group can be used to ________.
adding a clarifying text box to a slide
Which of the following best describes text effects?
applying graphic effects to text
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
"Sparkline Tools" can be used to ________.
change the visuals of a chart, such as bars versus columns and colors
How do you enter data into a cell?
click the cell and start typing
What does emptying the Recycle Bin do?
deletes everything in the Recycle Bin forever
When entering data into a column, you should use the ________ button to proceed to the next cell.
enter
To create a SmartArt graphic, you need to ________.
first insert a SmartArt graphic
Data can be filtered in Excel in order to ________.
hide, but not delete, some data from the worksheet
"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
Bart is just learning to conduct searches on his work computer. He now knows what a web browser is and even a few of the different search engines. His boss in the retail company's men's department, asked him to search for information about the latest winter boot trends this year? What should Bart type into the Google search engine to get the best search result that fit his boss's request?
mens winter boots trends 2017
Which of the following is one of the effects of decreasing the line spacing?
more words fit on a page
A footer is useful for ________.
noting the department that created a slide deck
The Playback tab includes the ________.
option to trim an embedded video
What text effects are available in Word?
outline, shadow, reflection, glow
The image above shows an example of which of the following?
square text wrap
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
After clicking a hyperlink, which of the following best describes what happens?
the hyperlink's color changes
A transition is ________.
the way a slide enters or leaves the view during a presentation
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
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
Grouped objects ________.
will be treated as a single object when arranging or resizing
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.
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.
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.
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
Which of the following is the most efficient method for taking a screenshot of a window?
Take a window screenshot.