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
