CS 110 Lecture Exam 2 Review - Correct Answers

When perusing a number of papers as a part of your research, what do you read first to see if it is a good fit for your paper?

Abstract

What are the 2 types of research papers?

Argumentative and Analytical

To delete a row or column, select the row or column and use the delete command in the ___ group of the Home tab.

Cells

According to the GCF Video over Conditional Formatting, which of the following is NOT one of the conditional formatting presets?

Data Background

What is a database activity?

Data Indexing

The presentation of data in a pictorial or graphical format is also know as

Data visualization

Which of the following are places where data may be found? (5)

1. Case studies 2. Published papers 3. Books 4. Subject matter databases 5. Web sites

Which of the following are characteristic(s) of a good document? (3)

1. Correct grammar and spelling 2. Organized information 3. Clear and concise

Data visualization is important for? (3)

1. Presenting research findings 2. Sharing ideas with colleagues 3. Conveying ideas

Which of the following are true about radar charts? (2)

1. Radar charts compare the aggregate values of multiple data sets 2. Radar chart plots the values of each category along a seperate axis that starts in the center of the chart and ends on the outer ring.

Which of the following are true about why we cite sources? (5)

1. To provide evidence for your arguments 2. To provide a trail for your reader to follow the research you performed. 3. To show the depth and scope of your research 4. To allow the readers to locate and further explore the sources you consulted. 5. To give credit where credit is due

According to the GCF Video over Functions, how do you write a correct syntax for a function?

=SUM(D4:D9)

Templates can be a key feature in the creation of a document. What does a template provide to aid the creator of the document?

A "Fill in the Blank" document that can be completed either by hand or through an automated iterative process.

In the GCF Video over Headers, Footers, and Page Numbers, you can restart the page numbering by inserting:

A section break

According to the Community Tool Box section on Collecting and Analyzing Data, what is a dependent variable?

A variable influenced by the independent variable

True or False: A bibliography or list of works cited is almost always placed immediately after the introduction.

False

True or False: According to the Community Tool Box section on Collecting and Analyzing Data, one of the key advantages of translating qualitative into quantitative data have to do with the human factor.

False

True or False: An argumentative research paper is usually an exercise in exploration and evaluation.

False

True or False: In the GCF Video over Pictures and Text Wrapping, the Design tab allows you to insert Pictures into a document.

False

True or False: Information and data are synonymous.

False

True or False: It is important to keep duplicates of information in your table.

False

True or False: Pie charts show the size of items in multiple data series proportional to one of the items.

False

True or False: The APA (American Psychological Association) allows research papers for journals to be submitted in any format, as long as it is clear and concise.

False

When Goldreich talks about how to serve the reader's needs, he identifies 4 key points. Which of the following is NOT one of those points?

Focus on the writer's desires rather than the reader's needs

In the GCF Video over Page Layout, the Page Dialog contained all of the following except:

Font Size

Which is not the three elements to successful data visualization?

It easily connects to the internet

Which of these is one of the most important keys to understanding how to visualize your data?

Knowing your audience

What is not a key to designing a table?

Make a matching chart to go with the table

According to the Community Tool Box section on Collecting and Analyzing Data, The term "significance" has a specific meaning when you're discussing statistics. The level of significance of a statistical result is:

The level of confidence you can have in the answer you get

In his paper on "How to Write a Paper", Goldreich comments on why we write papers. His main reason was:

To communicate an idea

True or False: A function is a predefined formula that performs calculations using specific values in a particular order.

True

True or False: A key question you should ask yourself when beginning to create a document is "Who are you trying to communicate to or persuade?" This allows you to know your audience.

True

True or False: A word processor is a computer application used for the production (including composition, editing, formatting, and possibly printing) of any sort of printable material.

True

True or False: Clustered column charts compare values across categories by displaying values in vertical rectangles.

True

True or False: Goldreich's paper is a revised and augmented version of his essay "How NOT to write a paper" written in 1991 and revised in 1996.

True

True or False: Markers are used to show individual data values. They can clutter up the effect, but can also illustrate key values. They can be used with any type of chart.

True

True or False: PivotCharts are charts that are made from PivotTables, and have the same options as other charts.

True

True or False: Similar to charts and sparklines, conditional formatting provides another way to visualize data and make worksheets easier to understand.

True

True or False: The filtering tools are added to the Header row.

True

True or False: The goal of a table is to represent data in a clear and accurate format.

True

True or False: The purpose of a document is to communicate or persuade.

True

True or False: Visualization is really a dynamic form of persuasion through telling a story.

True

True or False: When designing the table's rows and columns, keep your audience's needs in mind.

True

True or False: You can autosize a column by double-clicking the column header line.

True