CS 110 Lecture Exam 3

1. Opening = tell them what you are going to tell them 2. Body = tell them 3. Summary = tell them what you told them 4. Closing = distribution of materials, summing up questions T or F

T

To layer sorting options within each other, use what command in the Sort dialog box? a. Add Level b. Levels c. Layered options d. Layered Sort

a

Which of the following are steps you might perform during the preparation phase of creating a presentation? a. Sequencing b. Create a thesis statement c. Identify your visual aids d. Identify the materials you are going to need e. Identify questions you might be asked

all

Which of the following are true about creating a presentation? a. Mix and match your capitalization rules. b. You should use lots of white space c. Slides should have short titles d. Use the same structure for text on a slide. e. You should use lots of animations and slide transitions.

b, c, d

In the GCF video over Inserting Videos, the video indicates that you can insert a video from your computer and from which of the following? a. Office.com b. Web c. Microsoft.com d. YouTube

b

In the GCF video over Managing Slides, the video indicates that the view that completely fills the screen with what the audience will see when you present is called: a. Normal View b. Slideshow View c. Edit View d. Outline view

b

One of the biggest threats to password security is social engineering, which are programs that use dictionary words and numbers to guess your password. a. True b. False

b

The 666 rule applies to the way in which you gather materials for the presentation. a. True b. False

b

The NOT function returns True when given two arguments that evaluate to True. a. True b. False

b

The SUMPRODUCT function returns which of the following: a. the sum of all products of a particular cell. b. the sum of all products of a particular range. c. the sum of a particular range. d. the products of a particular range.

b

The more security you have in place, the better your computer's performance is. a. True b. False

b

The more security you have, the easier your computer is to use. a. True b. False

b

To increase the size of your table, you can... a. Click the top left corner and drag to the desired side. b. Click the bottom right corner and drag to the desired side. c. Double click the bottom right corner and enter the desired size. d. Enter the desired size in the dialog box at the top of the screen.

b

What value will the following function return: =OR(False, True, 4<7) a. Error: the OR function only takes two arguments b. True c. Error: the OR function can not interpret argument 3 d. False

b

When you are identifying the materials you might need for putting together a presentation, stick to the "normal" materials to keep the presentation exciting. a. True b. False

b

=SUMIF(D2:D9,">10%",C2:C9) In the above SUMIF function which argument represents the range to be summed if the criteria is met? a. Argument 1 (D2:D9) b. The argument is not present c. Argument 3 (C2:C9) d. Argument 2 (">10%")

c

According to the article from EasyBib, which of these is a resource to approach with caution, mentioned in the online essay "Part A: Finding Sources"? a. Books b. Librarian c. Websites d. Academic Journals

c

In the GCF video over Inserting Videos, the video indicates that you can insert an audio from your computer by selecting which of the following? a. Insert / Media / Local File b. Insert / Audio / Local File c. Insert / Audio / On my PC d. Insert / Media / On my PC

c

Sorting T-Shirt sizes is best done using a custom sort that goes from small to x-large. a. True b. False

a

A thesis statement of a presentation is a clear and concise statement of the problem being presented. a. True b. False

a

According to the EasyBib article, books are still one of the best ways to find credible information about a source. a. True b. False

a

Every table includes filtering by default. You can filter data using the drop-down in the header row. a. True b. False

a

In computer security, authorization is which of the following? a. The act of ensuring you have the permissions to perform the operation you are attempting. b. The act of identifying the operation you are attempting to perform. The act of identifying yourself c. to the operation you are attempting to perform. d. The act of ensuring the operation you are attempting to perform can be done safely.

a

In the GCF Video over Applying Themes, the default theme that is applied when you open a document is: a. The default Office theme b. The default PowerPoint theme c. The default Windows theme d. The default Document theme

a

In the GCF Video over Formatting Pictures, the Corrections menu is found under which ribbon group: a. Adjustments b. Changes c. Modifications d. Arrange

a

In the GCF Video over Inserting Audio, the video indicates that you can insert audio from your computer, or by making a recording. a. True b. False

a

In the GCF Video over Reviewing Presentations, the video indicates that Compare allows you to look at two different presentations and combine or edit them. a. True b. False

a

In the GCF video over Inserting Videos, the video indicates that to make an excerpt of an audio piece, use which command? a. Trim Audio b. Cut Audio c. Make an excerpt d. Edit Audio

a

Why does Excel offer you so many tools? a. To provide you with as many tools to help you organize and interpret your data. b. To make it more difficult to learn c. To provide a confusing atmosphere to learn in. d. It offers so many tools so it can charge more.a

a

Which of the following are reasons we need security on computers? a. To protect money b. To ensure personal safety c. To protect information d. To allow us to perform backups e. To update the operating system regularly

a, b, c

Which of the following are steps to putting a presentation together? a. Preparing - in which you gather your materials and lay out the sequence. b. Create the presentation - in which you build the slide set. c. Planning - in which you clarify your subject and identifiy your audience. d. Delete the presentation - in which you remove the unnecessary presentations from your archive.

a, b, c

Which of the following are attributes you desire in possible visual aids to be used in a presentation? a. Size the materials appropriately b. Consist of charts, graphs, pictures, videos c. Consistent with your message d. Simple and clear e. Must be laid out in a chronological order

a, b, c, d

Which of the following are items you want to identify during the planning phase of putting together a presentation? a. Content expectations - purpose for the talk b. Type of talk - informal, formal, seminar c. Audience composition - general audience or specialists d. Time allotted for the talk e. Grammar - correcting the grammar of the slides

a, b, c, d

Which of the following are true about malware? a. Short for malicious software. b. Software is considered malware based on the intent of the programmer. c. These are programs that always cause damage to the infected computer. d. Programs designed to disrupt or deny operation, gather information, and gain unauthorized access.

a, b, d

Which of the following are personal habits you can do to help ensure privacy? a. Be careful about posting PII b. Use passwords that contain 8 or more characters c. Remove your virus checkers from your system. d. ALWAYS respond to phishing e. Use encryption

a, b, e

Which of the following are attributes you desire in possible visual aids to be used in a presentation? a. Consist of charts, graphs, pictures, videos b. Must be laid out in a chronological order c. Size the materials appropriately d. Consistent with your message e. Simple and clear

a, c, d, e

What does the Scenario Manager allow you to do? a. Helps you analyze how different variables affect your data b. Helps arrange all of your data in various ways. c. Helps you problem solve using various constraints. d. Create various scenarios with different input data

a, d

Which of the following would be considered Personally Identifying Information (PII)? a. Social Security Number b. Purchasing habits c. Surfing habits d. Name e. Bank Account Number

a, d, e

A Macro in Excel allows you to create new formulas and functions in your worksheet by combining ones you use often enough. a. True b. False

b

According to the article from EasyBib, the most useful part of a Wikipedia page is which of the following? a. Bibliography b. References c. Beginning summary d. Content and Evidence

b

Goal Seek will return the optimal value to set the selected cell to the desired value. a. True b. False

b

IF functions cannot be nested to allow multiple values to be tested a. True b. False

b

In computer security, authentication is which of the following? a. The act of ensuring you have the permissions to perform the operation you are performing. b. The act of identifying yourself to the operation you are attempting to perform. c. The act of identifying the operation you are attempting to perform. d. The act of ensuring the operation you are attempting to perform can be done safely.

b

In the GCF Video over Applying Themes, You apply a theme by: a. Selecting the name of the theme b. Clicking the thumbnail of the theme c. Right clicking the theme d. Opening the theme dialog box

b

In the GCF Video over Formatting Pictures, changing the border color and weight is done under: a. Picture Adjustment b. Picture Border c. Lines d. Area Adjustment

b

In the GCF Video over Reviewing Presentations, if the Notes pane is not present, it can be brought up by selecting the Notes tab from the ribbon. a. True b. False

b

In the GCF Video over Shapes and Word Art, Word Art is a feature that lets you add effects to your pictures: a. True b. False

b

Which of the following are true about creating a presentation? a. Use lots of formulas to back up your ideas. b. Minimize switching between programs c. Mix and match your subscripts d. Put no more than one idea on a slide. e. Spell check

b, d, e

According to the article from EasyBib, a source is credible if the data is which of the following? a. Graphed beautifully b. Thoroughly explained c. Presented in a unique manner d. Verifiable and accurate

d

According to the article from EasyBib, which of the following was an advantage to using Google search to do research. a. Google's results are focused on information available on the internet space that is easily accessed. b. Many of Google's search results are biased and non-academic. c. Google's search results are tailored to you d. It's fast and provides you with a lot of information.

d

In the GCF Video over Shapes and Word Art, selecting a WordArt style changes all of the following categories except: a. Text Effects b. Text Outline c. Text Fill d. Text Size

d

To create a table, select the cells you want to use and click which command? a. Convert b. Table-Maker c. Recreate as Table d. Format as Table

d

What can you use to visualize your data from a PivotTable? a. Pivot Displays b. Pivot Pictures c. PivotTable Fields d. Pivot Charts

d

What kind of table allows you to view and manipulate your table without actually changing the data in the worksheet? a. Mini Table b. Editing Tables c. PartialTables d. PivotTables

d

What number evaluates to false in an excel formula? a. positive b. negative c. 1 d. 0 e. -1

d