IC3 GS5 Key Applications Post-Assessment and Practice Test Answers

Which of the following file types stores tabular data and uses fields separated by commas?

.csv

Sort the steps in sequence for downloading an image from the internet and inserting it into an Excel document.

1) Save the Image 2) Place cursor in Excel 3) Click Insert picture under the Insert Tab 4) Browse to the saved image 5) Double-click the saved image file

In the answer field below, use a function and cell reference to calculate average quarterly sales for Dwight Barker.

=AVERAGE(B5:E5) (Make sure to use capitals)

Which are options available when accepting changes through to track changes?

>Accept All Changes >Accept All Changes and Stop Tracking >Accept and Move to Next

Which of the following aspects of a website typically uses a database?

>Authentication

Download and Install VLC media player using all defaults. Do not run the app after finishing the installation.

>Click Go to Download >Download VLC button >Click Run >Uncheck the Run VLC Media player checkbox >Finish

Select Cell Range A2:D2 to a Row Height of 25 units.

>Click and drag A2:D2 >Home Tab >Under Cell Group, Select Format >Select Row Height >Enter 25 >Click Ok

Which are metadata of a text file?

>Date Created >Date Modified >File Permissions

To use your own image file as a background for one of your PowerPoint slides, click the________tab. Then in the_______ group, click _______ . Expand the______ dropdown, and ensure that the______radio button is selected.Finally, click the_________ button and navigate to the image you want to use in the File Explorer.

>Design >Customize >Format Background >Fill >Picture of Text File >File

Right click on an empty space on your desktop and click __________. In the new window, you scroll to the dropdown menu under, ____________ and select _________.

>Display Settings >Multiple Displays >Duplicate these Displays

Which of the following are common parts of the Access 2016 Interface?

>Fields >Ribbons >Tabs >Tables >Forms

Hide the Spelling errors so that they do not show up on any computer.

>File >Options >Proofing >Hide spelling errors in the document only >Click ok

Hide the Spelling errors so that they do not show up on the computer.

>File >Options >Proofing >Select 'Hide spelling errors in the document only' >Click OK

To save paper, print the document using 2 pages per sheet

>File >Print >Under Settings, change 1 page to 2 pages per sheet >Click Print

Protect the current sheet and change the settings so that users cannot select locked or unlocked cells but can format columns and format rows.

>File Tab >Info Tab >Protect Workbook >Protect Current Sheet >Uncheck Locked and Unlocked cells >Check Format columns and rows >Click Ok

Print the documnet on Legal sized paper, on both sites (Flip both pages on long edge) of the paper and Landscape orientation.

>File Tab >Print >Select 'Print on both sides (Flip both pages on long edge)' >Select Legal Sized Paper >Select landscape orientation >Click Print

Which of the following are common parts of the Excel 2016 Interface?

>Formula Bar >Sheet Tabs >Tabs >Groups >Ribbons >Cells

Add Best Fit Data Labels to the pie chart.

>Go to File>Chart Layouts >Add Chart Element >Data Labels >Best Fit

You want to quickly move some text to a different place in your document. Using only keyboard shortcuts, cut the text June 24, 2015 and paste it under the text Anna Western at the bottom of the document.

>Highlight June 24, 2015 >Press Ctrnl+X on your keyboard >Click next Anna Western to place Caret at the end of document >Click Enter to create new line >Press Ctrnl+v to paste

Create a hanging indent that is 0.5 inches from the margin, and set the line spacing to Single for the selected text.

>In Home>Paragraph Group, select corner arrow button >Under Paragraph Menu>Indentation Group >Under By, Type 0.5 >In Spacing Group, select single >Click OK

Download and install Adobe Acrobat Reader. Do not install third party content such as Google Chrome.

>In Option offer, Uncheck 'Yes, install Google Chrome" >Click Install Now >Click Run

Convert the selected text into a table with 2 columns and 5 rows

>Insert >Under Tables Group,select Table >Select Convert to table >Under Table Size Group, Change number of columns and rows >Click OK

You've typed up an annual sales report in a Word document, and now you wish to convert this text to a table. First, you highlight the text. Next, you click on the ________ tab, click on the ________ dropdown, and select ________Spreadsheet .

>Inset >Table >Convert Text to Table

Which options are available in the Merge and Center drop-down menu?

>Merge Cells >Merge Across >Merge and Center >Unmerge Cells

Which are options to export a Powerpoint presentation as a video?

>Portable Devices >Computer and HD Displays >Internet and DVD

Which two cable types allow for the transmission of audio and video when connecting a computer to a projector?

>RCA >HDMI

This document contains spelling errors. Use the Spelling and Grammar feature to fix the misspelled words.

>Review Tab >Proofing Group >Select Change for each word >Click Ok

Which of the following are common parts of the Powerpoint 2016 interface?

>Ribbons >Slides >Slide Sorter View Button >Tabs

There is a Word Document on your desktop that you want to make Read Only. To do this you would _______ the file and select _______. Under the ______ tab, you would check the box labeled _______.

>Right-click >Properties >General >Read Only

Change the column width of the Column titled "Country" to be 2.0 inches and the column titled "Tons of Apples" to have a width of 0.5 inches

>Select Any cell in the column >Select Layout under Table Tools >Under Layout Group, select Cell Size >Change width >Repeat Process for second column

Copy all the data from Column B in Sheet 1 and paste it in Column A on Sheet 2

>Select Column B >In Home Tab Clipboard Group, select Copy >Select Sheet 2 >Select A1 >In Home Tab Clipboard group, Select paste >Paste Menu >Paste Values >Values

You want to add more data to the Blackbread Books spreadsheet. Insert a new column between columns C and D.

>Select Column D, by clicking its name >In Home Tab, Cells group, select Insert >Insert Sheet Columns

Column D is too small to display the numbers in the column. Change the width of Column D so that the numbers can be properly displayed.

>Select D2 >Home tab >Select Format >Select Column Width >Enter information >Click Ok

Using only Keyboard shortcuts, move the last paragraph beginning with 'Toxins can reach a critical mass' and place it below "Dr.Jane Miller, Ph.D'. Make it so that there is a space above the moved paragraph.

>Select Toxins Paragraph >Select Ctrnl+x on your keyboard >Place the caret right after Dr.Jane Miller, Ph.D >Press enter >Press Ctrnl+v to paste paragraph

Which are options found in the Page Layout ribbon tab on Microsoft Word?

>Size >Orientation >Columns

Using the Control Panel, disconnect Display 1

>Start >Control Panel >Under Appearance and Personalization, Click Adjust screen resolution >Select Display 1 >Select Multiple Displays >In Drop Down, select Disconnect the display >Click Ok >Keep Changes

Which of the following are options are examples of data?

>Street Address >Image >User ID >Video Clip

Set photo2.jpg in the documents folder as the background for Slide 1.

>Under Design Tab, click Customize >Format Background >File >Select photo2.jpg >Insert

Set a filter so only Defenders is visible. Do not format as a table.

>Under Home Tab, Editing Group select Sort &Filter >Select Filter >In Cell D2, select arrow to display Sorting menu >Uncheck everything except Defender >Click Ok

Use the Find and Replace feature to replace each instance of the word reader with readers.

>Under Home Tab, in Editing Group, click Replace >Type Reader in "Find what" textbox >Type Readers in "Replace with" textbox >Continue to replace until completion dialogue pops up >Click ok

Which are two ways you can adjust column width?

>Use the format menu in cells group >Right-click the cell-range

Which are some preset Margin Options?

>Wide >Normal >Narrow >Moderate

Which file types can be opened using Microsoft Word?

>XML Files >Word Macro-Enabled Templates >All Web pages

Which keyboard key can be used to navigate to the first cell in a row.

Home

Which ribbon tab includes the options to insert comments, WordArt, Headers and Footers, and pictures?

Insert

A pie chart is a visual way to display groups of data in a project document. You can Create a pie chart in Excel but not word. You can create 2D and 3D pie charts

Yes No Yes

You can double-click the lines separating column letters and row numbers to auto-fit the column or row to the size of the biggest cell in that column or row. You can click and drag the lines separating column letters and row numbers to manually adjust their size You can auto-fit or manually set cell width/height using the format dropdown in the Home tab > Cells group. You can manually set cell size by right-clicking the row or column and selecting Row Height or Column Width

Yes Yes Yes Yes

How do you access the Picture Tools> Format Tab in order to access the crop tool?

You must select the image

In Microsoft Excel, which Protect Workbook option allows you to restrict users from adding new columns while allowing them to make other changes?

Protect Current Sheet

You want to easily read the open document. For best results, change the document to _______

Read Mode

When first opening a word document, which options are available to the user?

Templates

Which of the following group of applications would be best for web design?

Adobe Illustrator, Abode Photoshop, Adobe Premiere Pro

When saving a PowerPoint presentation, which is an ideal option to save the documents for presenting it to an audience?

PowerPoint Show

According to this relational diagram, which statement is correct?

Each professor is responsible for multiple classes.

Which dropdown gives you the ability to play the effect on each paragraph individually?

Effect Options

Which group on View Tab allows a user to change the view of the slides, such as Outline View and Slide Sorter?

Presentation Views

Which Home tab group on the Microsoft Excel ribbon is used to insert columns and rows?

Cells

Which keyboard shortcut is used to select all text in a document?

Ctrl+A

How can you recover any paid apps that you lost without having to pay for them again?

Download it again from the App Store

If you set your presentation to Presented by Speaker, your presentation will advance in what way?

Manually

Which option allows a user to navigate to the apps for a Firefox browser?

Marketplace

Which Master View allows a user to make changes to headers and footers and to page orientation?

Note Master

Which Master View allows a user to make changes to headers and footers and to page orientation?

Notes Master

_____ are the symbols and signs which are used to represent a mathematical equation.

Operators

Which option allows a user to change the style of a chart in Excel?

Option B (paint brush)

Which option allows a user to add more data to an Access database?

Option C

Which presentation view option is shown in Powerpoint?

Outline View

The Notes pane is open and you want to hide it again. Hide the Notes pane

Under View Tab, deselect Notes button