COMP 1000 Final Exam Practice
The "Blank worksheet" "Add worksheet" "Insert" option can be used to add a new worksheet from the "Cells" group.
"Insert"
A text box can be added to a slide using the: "Insert" tab, "Text" group "Edit" group of the ribbon "Insert" tab, "Add note" group
"Insert" tab, "Text" group
The "Insert" tab, "New Slide" button thumbnail view "Add slide" option "New Slide" button in the Home tab "Slides" group is the easy way to insert a new slide between existing slides
"New Slide" button in the Home tab "Slides" group
Which of the following would be the best subject line in an internal message to your fellow employees regarding a change in an "All Hands" meeting time? "Update - All Hands Meeting Changed from 2:00 to 3:00 on Friday June 7" "Update" "Meeting" "New Meeting Time"
"Update - All Hands Meeting Changed from 2:00 to 3:00 on Friday June 7"
Comma styles can be applied using a dropdown menu under "Format" in the Number General Cells group of the ribbon.
Cells
What is the keyboard shortcut for the Find function? Ctrl+B Ctrl+J Ctrl+F
Ctrl+F
Win+N Ctrl+N Alt+N is the keyboard shortcut to create a new presentation in PowerPoint.
Ctrl+N
What is the Windows keyboard shortcut used to save a document in Microsoft Word? Windows+S Alt+S Ctrl+S
Ctrl+S
Which of the following is line spacing? the space between the margin and the line of text the space between lines of text the space between words on a line
the space between lines of text
A color scheme branding theme is the overall visual look of a presentation.
theme
How do you change the shape selection of the screenshot? through the Print Screen button through the New dropdown menu in the snipping tool through the Shape dropdown menu in the snipping tool
through the New dropdown menu in the snipping tool
The design display view predominantly changes what is shown in the thumbnail display.
view
What does this button in Microsoft word do? Italicize text Bold text Underline text
Underline text
Robert has an image on his work computer of a chart for how a work project is to be divided amongst the team. He is wondering if there is a nicer way to present this chart and wishes to conduct a search on Google for other examples similar to his chart. What is the most efficient way for Robert to find images similar to his chart? Upload his chart image directly to Google and it will search for similar images quickly. Open his chart image on his computer and a new browser window. Search for chart images in Google and compare his chart with the search results.. Type into Google chart images and sort through the chart images results.
Upload his chart image directly to Google and it will search for similar images quickly.
When would be the most likely time to move an email message from the Inbox to another folder? Before you read the message. When you have already answered or otherwise processed the message. When the message contains an attachment. When the message is from an unfamiliar sender.
When you have already answered or otherwise processed the message.
Which of the following is an operating system? MacBook Air Windows 11 Dell
Windows 11
When you wish to quickly indicate that certain cells in a table are different, you should apply a table comma cell style.
cell
When creating a uniform way to identify relevant files for a team, project or other grouped activity a naming convention is beneficial to use. What naming convention example works the best to use for the human resource department's files? Responses 2020_InterviewHR.doc InterviewResultsName.doc 2020_HR_InterviewResults_Name.doc HR_InterviewResults_Name20.doc.
2020_HR_InterviewResults_Name.doc
What happens when Tiana selects New Meeting in Outlook Calendar? A Meeting Wizard opens to help walk Tiana through the process of creating a new meeting. An event is automatically added to Tiana's calendar. A message is generated to Tiana's Inbox. A new window opens allowing Tiana to enter relevant information about the meeting to be scheduled.
A new window opens allowing Tiana to enter relevant information about the meeting to be scheduled.
Sanjay shares his Outlook calendar with a friend by email. What does the email contain? An iCalendar file that can be opened in Outlook or another email program. An Outlook Calendar file that can only be opened in Outlook. An image showing free/busy time for the current month. A PDF file that can be viewed in any PDF reader.
An iCalendar file that can be opened in Outlook or another email program.
Annalisa will be traveling internationally and unable to access her emails for a week. In order to answer incoming emails automatically to let her colleagues know that she is unavailable, Annalisa should set up: Auto-Read. Automatic Forwarding. Automatic Replies. AutoArchive.
Automatic Replies.
Anthony is composing a new email and selects Attach File. Which of the following options is a menu option he will see after selecting Attach File? Send Without Attachments New Attachment Browse this PC Attach this File
Browse this PC
What does a dark blue color code indicate on an attendee's calendar in the scheduling assistant? Time is outside working hours. Available. Reserved for a tentative event. Busy.
Busy.
The Format Delete Insert button in the "Cell" group of the ribbon has a simple dropdown for removing a row of data from a worksheet.
Delete
The Insert Design Animation tab can be used to change the color options of a SmartArt graphic.
Design
To open a new workbook in Excel, you should use the File>Open Insert>New Page File>New command.
File>New
Which of the following methods opens a new document in Microsoft Word? Insert>New Page File>New File>Open
File>New
The "Refine" area in the Search tab of the ribbon provides quick options for refining your search including: From, Subject, Has Attachments, Date Received. From, Subject, Has Attachments, Sent To. From, To, Has Attachments, Flagged. From, Subject, Show Attachments, Sent To.
From, Subject, Has Attachments, Sent To.
Which of the following collaboration platforms does NOT support video conferencing? Google Meet Microsoft Teams Google Chat Slack
Google Chat
What is the primary component a computer needs to keep documents, files, pictures, music, video files or anything saved on a computer? Motherboard Hard drive—HDD or SDD Random-Access Memory Monitor
Hard drive—HDD or SDD
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 Holly typed in her search and used the (payroll, taxes) she would eliminate those results in her search. If Holly typed in her search and used the OR (payroll, taxes) she would eliminate those results in her search.
If Holly typed in her search and used the -payroll -taxes she would eliminate those results in her search.
What is one of the main causes of privacy issues when it comes to private or sensitive information stored on computers? Lack of understanding of potential threats. Improper or non-existing privacy disclosure control. Little software available to block sharing sensitive information. Lack of enough data to share.
Improper or non-existing privacy disclosure control.
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 AND shelves. In the search bar Gary would type retail store supplies OR shelves. In the search bar Gary would type retail store supplies NOT shelves.
In the search bar Gary would type retail store supplies NOT shelves.
The Design Insert Animation tab can be used to add clip art to slides.
Insert
What would be the best communication channel for a message that required quick response? Instant messaging Email. Fax. Memo.
Instant messaging
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 find the results number by clicking on the More button under the search box. Kevin can find out the number by hovering over the Google icon. Kevin can look at the line under the search box that says "About xxx,xxx results."
Kevin can look at the line under the search box that says "About xxx,xxx results."
Taryn had been working for weeks on a work project and saving all of her work on her laptop. Yesterday, while she was moving file boxes onto her desk, she knocked over her coffee cup, spilling it all over her laptop. The liquid quickly shorted out the CPU and killed all of the work she had done in one moment. Life tends to create moments like this from time to time. What would have prevented Taryn from losing all her work files? Working solely on a different computer other than her laptop. Drinking tea instead of coffee. Making a backup of all her work on her laptop. Making a backup of all her work on multiple sources.
Making a backup of all her work on multiple sources.
What is this browser tool called and what does it do? Minimize button—minimizes the window to the taskbar. Refresh button—refreshes a webpage to update information. Maximize button—enlarges window to fill computer screen.
Minimize button—minimizes the window to the taskbar.
What are the three organization levels in OneNote? Notebooks, chapters, pages. Notebooks, sections, pages. Folder, files, pages. Notebooks, sections, files.
Notebooks, sections, pages.
Which group of the ribbon has a simple dropdown for changing the format of cells? Styles Comma Numbers
Numbers
Maria needs to send an email to her manager to let her know the project status. To do this she must: Open Outlook and select "Address Book". Open Outlook and select "New SMS Message". Open Outlook and select "New Email". Open Word to create the message and then cut and paste it into Outlook.
Open Outlook and select "New Email".
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 More > Click on first result hyperlink Open Search Engine > Type search terms > Press Enter > Select News > Click on first result hyperlink Open Search Engine > Type search terms > Press Enter > Select ALL > Click on first result hyperlink
Open Search Engine > Type search terms > Press Enter > Select News > Click on first result hyperlink
What type of software makes it possible for computer hardware to work together and perform various tasks specifically for a computer's hardware? Utility software Microsoft Office software Chrome browser software Operating system software
Operating system software
Nolan wants to draw attention to a word by making it blue. Which of the options shown above can he use to make his text a different color? Option 1 Option 3 Option 2
Option 3
Ethel discovered a great new cell phone for sale at a department store offering a discount if she signed up for a store credit card. She decided the discount was worth it and signed up. While filling out the paperwork she had to put down her social security number, driver's license, annual income, address and name. What type of information, did Ethel just disclose to be accessed by this department store? Personally identifiable information Contact information Biometric records Non-specific information
Personally identifiable information
Caleb received an email that looked like it was from his auto insurance company. However, the link in the email went to a fraudulent website that asked for Caleb's personal information and social security number to verify his identity. This is an example of: Trojan horse. Worm. Spam. Phishing.
Phishing.
Emil wants to work in two Microsoft Word documents at once. Which of the following methods can he use to accomplish this? Close the first document, then open the second document. Resize both Microsoft Word windows so that he can see both at once. He can't work in two documents at once.
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 Turn off red line Right click on the word and select Add or Add to Dictionary Home>Paragraph>Spell Check
Right click on the word and select Add or Add to Dictionary
Frederick receives a daily newsletter email from a professional organization he belongs to. He wants future newsletters to go directly to a folder he's created called "Newsletters" so he can just check it periodically. How should Frederick set up a rule to do this? Right-click on one of the newsletter emails he's previously received and select Move>Newsletters. Select one of the newsletters he's previously received from the message list and select Move>Newsletters from the ribbon. Right-click on the Inbox and select Properties>Rules. Right-click on one of the newsletter emails he's previously received and select Rules>Create Rules.
Right-click on one of the newsletter emails he's previously received and select Rules>Create Rules.
Which of the following methods will rename a file? Ctrl+R Right-click on the file and select Rename. Win+E
Right-click on the file and select Rename.
Besides grouping objects through the 'Arrange' button in the 'Drawing' group on the ribbon, how can a group be created? Using the 'Order Objects' buttons. Opening the 'Shape Format' tab. Using the 'Position Objects' options. Right-clicking and selecting 'Group' in the menu.
Right-clicking and selecting 'Group' in the menu.
In the Save As dialog box, which field lets you choose the file type of the saved document? File name Save as type Extension
Save as type
The sales team from Galactic Software is constantly traveling to meet clients. The sales manager just created various folders housing presentations, data, reports and contact info by moving them to a cloud storage service provider. The sales team can now access all their needed files from the road. What else can the sales team do with cloud storage? Use a flash drive's files to run presentations for clients. Use software on the cloud storage provider's server to work on documents. Keep personal files and documents in the company's cloud storage folders. Share files or folders with each other and a few select clients through a permission based restriction.
Share files or folders with each other and a few select clients through a permission based restriction.
The following collaboration platforms have instant messaging capability for both direct and group messaging: Zoom, Google Chat, Microsoft Teams, Facebook Messenger. Slack, Google Meet, Microsoft Teams, Facebook Messenger. Apple's FaceTime, Google Chat, Microsoft Teams, Facebook Messenger. Slack, Google Chat, Microsoft Teams, Facebook Messenger.
Slack, Google Chat, Microsoft Teams, Facebook Messenger.
What is the difference between Sleep and Shut Down? Responses Sleep saves your session and turns the computer off; Shut Down saves your session and saves battery power Sleep turns the computer off; Shut Down closes all programs Sleep saves your session and enters a low-power state; Shut Down closes all programs and turns the computer off
Sleep saves your session and enters a low-power state; Shut Down closes all programs and turns the computer off
What is the advantage of creating folders in OneDrive? OneDrive folders are more secure than folders on your local devices. So files can be organized as if they were on your local device. So files can be both on your local device and in the cloud. For automatic updates of your folders.
So files can be organized as if they were on your local device.
Which of the following is true of this file path? C:\Users\user\Documents\Rowan\Spreadsheets\Summer\Sales Reports The Summer folder is in the Sales Reports folder. The Spreadsheets folder is in the Rowan folder. The Sales Report folder is on the A drive.
The Spreadsheets folder is in the Rowan folder.
What does a "blue cloud with person" icon mean in OneDrive? File sync is pending. The file is being shared with another user. File is only available online. File needs IT support.
The file is being shared with another user.
What happens when text is added to grouped objects that is larger than an object? The text turns a different color. The text is cut off and the full text is hidden. The text automatically resizes itself. The text style changes to match the slide style.
The text is cut off and the full text is hidden.
In order to edit content on a slide, you should: click on the part of the slide you wish to edit in the main view click on the thumbnail view of the slide add a new slide and start from scratch
click on the part of the slide you wish to edit in the main view
Which of the following will select text? running a search for the text you want to select File>Select clicking and dragging the mouse across the text
clicking and dragging the mouse across the text
What does emptying the Recycle Bin do? undeletes everything in the Recycle Bin deletes everything in the Recycle Bin forever restores everything in the Recycle Bin to its former location
deletes everything in the Recycle Bin forever
When entering data into a column, you should use the tab shift enter button to proceed to the next cell.
enter
The join group unite option can fuse multiple objects into a single object for editing.
group
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? best mens casual boots hottest mens winter boots 2010 mens winter boots trends 2017
mens winter boots trends 2017
Which of the following does the shortcut Ctrl+Alt+Delete do? Responses deletes selected text automatically quits the active program opens the Task Manager
opens the Task Manager
If you use the "Format" button in the "Cells" group of the ribbon, you can quickly: resize all the columns of a table delete columns in a table insert rows in a table
resize all the columns of a table
Which of the following alignments is shown? justified right-aligned left-aligned
right-aligned
Winry wants to make this block of text a bulleted list. What is the first thing she should do? click the bulleted list button select the text right-click one of the lines
select the text
Finish this sentence. It is important for a business to secure its computer data because: computers automatically prevent security breaches from happening. competitors play fair and will not steal information. sensitive information and data could be corrupted or stolen by a competitor. computers are not accessible by unwanted individuals.
sensitive information and data could be corrupted or stolen by a competitor.
If a business engaged in, sharing research participant confidential information to 3rd parties continually producing reports and research which contradict other findings fully disclosing product research information to the public settling litigious clams clients bring against them, it is engaging in unethical business practices.
sharing research participant confidential information to 3rd parties
If you wish to quickly apply a color scheme to an entire set of rows and columns in Excel, you should apply a cell table comma style.
table
