CS110-Personal Computing- Lecture Exam 2 prep

To make your text stand out, which of the following can you use? -> All of the Answers -> Bold -> Underline -> Italic

-> All of the Answers

Data visualization is important for -> All the answers -> Presenting research findings -> Sharing ideas with colleagues -> Conveying ideas

-> All the answers

Which of the following are types of research papers? -> Presentation -> Analytical -> Web Page -> Argumentative -> Maniacal

-> Analytical -> Argumentative

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? -> Case Studies -> References -> Abstract -> Conclusion -> Experimentation

-> Abstract

According to the GCF video over Complex Formulas, using Order of Operations, what answer would Excel give after calculating this formula? =3+(2*6)/3 -> 5 -> 9 -> 12 -> 7

-> 7

According to the GCF Video over Functions, which of these is correct syntax for a function? -> SUM=(D4-D9) -> SUM(D4-D9) -> Autosum(D4:D9) -> =SUM(D4:D9)

-> =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? -> The ability to cut and paste information from one place to another. -> A process that allows the creator to create a set of tools that clearly define the boundaries of the document. -> A mechanism to translate from one programming language to another. -> A "Fill in the Blank" document that can be completed either by hand or through an automated iterative process.

-> 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 column break -> A paragraph marker -> A section break -> A clear number break

-> A section break

According to the Community Tool Box section on Collecting and Analyzing Data, what is a dependent variable? -> A variable that depends on an non-spreadsheet activity -> A variable influenced by the independent variable -> A variable that always stays the same -> A variable the does not depends on an non-spreadsheet activity

-> A variable influenced by the independent variable

According to Goldreich, the first thing to do before writing a paper is to do which of the following? -> Ask "What is the relevant community's needs ?" -> Ask "What is the relevant information the audience needs to access ?" -> Ask "What is the idea that the paper is intended to communicate ?" -> Ask "What is the relevant community ?"

-> Ask "What is the idea that the paper is intended to communicate ?"

If you have a situation where the axis labels are long and the values that are shown are durations, the best chart to use is which of the following? -> Line chart -> Pie chart -> Scatter chart -> Bar chart -> Radar chart

-> Bar chart

To add a row, select the row ___ the place where you want to add the row. -> Below -> Directly there -> Above -> Behind

-> Below

To delete a row or column, select the row or column and use the delete command in the ___ group of the Home tab. -> Editing -> Insert / Delete -> Alignment -> Cells

-> Cells

Which of these is not a PivotTable feature? -> Condense information in multiple tables -> Filter data quickly -> Summarize large worksheet information -> Change the original data

-> Change the original data

Which tool in Excel helps you visualize the meaning behind data? -> Tables -> PivotTables -> Charts -> Pictures

-> Charts

Which of the following are characteristic(s) of a good document? -> Clear and concise -> Organized information -> Random and scattered logic -> Correct grammar and spelling -> Abbreviations and slang words

-> Clear and concise -> Organized information -> Correct grammar and spelling

According to the GCF Video over Conditional Formatting, Icon Sets can be used to add all of the following except: -> Ratings -> Colors -> Symbols -> Indicators

-> Colors

Which of the following are true about column charts? -> Column charts are useful for illustrating comparisons among items. -> In column charts, categories are typically organized along the vertical axis, and values along the horizontal axis. -> A legend is used to provide a chart title. -> In column charts, categories are typically organized along the horizontal axis, and values along the vertical axis. -> Column charts are useful for displaying discrete data.

-> Column charts are useful for illustrating comparisons among items. -> Column charts are useful for displaying discrete data. -> In column charts, categories are typically organized along the horizontal axis, and values along the vertical axis.

Which of the following are tool(s) that allow you to organize your information in a document? -> Cross-references -> Tables to perform page layout -> Headers and Footers -> Heading, table of contents -> Appendix

-> Cross-references -> Tables to perform page layout -> Headers and Footers -> Heading, table of contents -> Appendix

According to the GCF Video over Conditional Formatting, which of the following is NOT one of the conditional formatting presets? -> Data Bars -> Icon Sets -> Data Background -> Color Scales

-> Data Background

According to the GCF Video over Conditional Formatting, which conditional formatting element is like a bar chart within the row? -> Data Formatting -> Icon Bars -> Color Scales -> Data Bars

-> Data Bars

The presentation of data in a pictorial or graphical format is also know as ____. -> PGP Data -> Data Presentation -> Data Visualization -> Data Pictures

-> Data Visualization

Which of these is a database activity? -> Using PivotTables -> Citing Answers -> Data indexing -> Creating charts

-> Data indexing

What is a PivotTable? -> Special chart with percentages -> A table that works from Powerpoint, Word, and Excel -> Data summarization tool -> Rotating table

-> Data summarization tool

According to the GCF Video over Complex Formulas, which of the following is calculated second in the order of operations: -> Parenthesis -> Addition / Subtraction -> Exponents -> Multiplication / Division

-> Exponents

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

-> False

According to Goldreich, as a writer, you should introduce as many of the new concepts and definitions pertaining to the subject that you can. This will ensure the reader has the necessary information. -> True -> False

-> 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. -> True -> False

-> False

An argumentative research paper is usually an exercise in exploration and evaluation. -> True -> False

-> False

If a job posting does not specifically require a cover letter, sending your resume in without one or with just a post-it note is perfectly acceptable. -> True -> False

-> False

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

-> False

Information and data are synonymous. -> True -> False

-> False

It is important to keep duplicates of information in your table. -> True -> False

-> False

Pie charts are best for showing trends over time. -> True -> False

-> False

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

-> False

Spreadsheets are easily for people to understand and visualize for data trends and patterns. -> True -> False

-> 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. -> True -> False

-> False

According to the Community Tool Box section on Collecting and Analyzing Data, ,which of these is not quantitative data? -> 100 students -> 20 years of age -> Female -> 90% average test score

-> Female

In Goldreich's 2004 paper on how to write a research paper, which of the following steps does he recommend? -> Focus on the reader's needs rather than the writer's desires -> Awareness of the knowledge level of the reader -> Balance between contradictory requirements -> Make the reading a non-painful experience -> Publish only in a top journal

-> Focus on the reader's needs rather than the writer's desires -> Awareness of the knowledge level of the reader -> Balance between contradictory requirements -> Make the reading a non-painful experience

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? -> The reading of the paper should be a non-painful experience. -> Balancing between contradictory requirements -> Focus on the writer's desires rather than the reader's needs. -> Awareness to the knowledge level of the reader

-> 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: -> Orientation -> Paper Size -> Font Size -> Margins

-> Font Size

Which of these is not an element of an excel table? -> Calculated Columns -> Formula Bar -> Banded Rows -> Sizing Handle -> Header Row

-> Formula Bar

In the GCF Video over Page Layout, to display information in the top and bottom margins of your document, use -> Paragraph Head -> Topper & Foot -> Margins -> Header & Footer

-> Header & Footer

According to the GCF videos on Text Basics, when you select text which of the following appears? -> Question mark -> Hover tool bar -> Text selection pulldown menu -> Text selection process menu

-> Hover tool bar

Which of these is not the three elements to successful data visualization? -> It sets up a clear framework -> It tells a story -> It understands the audience -> It easily connects to the Internet

-> It easily connects to the Internet

If a paper is cited by a large number of papers, it usually means which of the following? -> It has a large number of keywords associated with it. -> It is a key paper in the area of research. -> It has a large number of indexes. -> It was written by a large number of authors.

-> It is a key paper in the area of research.

Which of these is one of the most important keys to understanding how to visualize your data? -> Knowing your audience -> Presenting small bits of data in a PowerPoint presentation -> Writing down the data on paper -> Making headlines

-> Knowing your audience

Which of the following are true about line charts? -> Line charts can display continuous data over time. -> Line charts are best used when the data is not contiguous. -> Line charts are ideal for use when your scale varies across the axis. -> Line charts are ideal for showing trends in data at equal intervals. -> Line charts are usually set against a common scale

-> Line charts can display continuous data over time. -> Line charts are ideal for showing trends in data at equal intervals. -> Line charts are usually set against a common scale

Use ____ from the commands in the bottom corner to view how your worksheet will print. -> Print View -> Print Layout -> Page Layout View -> Page Orientation

-> Page Layout View

Which of the following are true about using charts in presentations? -> Putting complex charts up can cause the audience to lose focus on your voice. -> You should try to get all your charts on one slide to get them out of the way. -> You don't want them to cause you to become the voice-over to the video -> You don't want to use charts in presentations because they detract from the message you are presenting. -> They provide a visual aid to the topic

-> Putting complex charts up can cause the audience to lose focus on your voice. -> You don't want them to cause you to become the voice-over to the video -> They provide a visual aid to the topic

Which of the following are true about radar charts? -> Radar charts compare the aggregate values of multiple data sets. -> A radar chart plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring. -> The downside to radar charts is they can only plot one data series, where pie charts can plot one of more data series.

-> Radar charts compare the aggregate values of multiple data sets. -> A radar chart plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring.

When we refer to a document, which of the following could we be referring to? -> Resume -> Microsoft Excel 2013 -> Research Paper -> Microsoft Word 2013 -> Cover Letter

-> Resume -> Research Paper -> Cover Letter

Which of the following are true about scatter charts? -> Scatter charts are ideal to use when you want to track values related to duration. -> Scatter charts are ideal to use when trying to understand what the relationship is between two sets of values (i.e. linear, exponential, etc.) -> Scatter charts are typically used for displaying and comparing numeric values such as scientific, statistical, and engineering data. -> Scatter charts show the relationships among the numeric values in several data series. -> Scatter charts should not be used when you want to change the scale of the horizontal axis.

-> Scatter charts are ideal to use when trying to understand what the relationship is between two sets of values (i.e. linear, exponential, etc.) -> Scatter charts are typically used for displaying and comparing numeric values such as scientific, statistical, and engineering data. -> Scatter charts show the relationships among the numeric values in several data series.

When Goldreich talks about how to serve the reader's needs, what is the key point he illustrates? -> Make sure to keep the entertainment value low -> Single out clearly the new ideas presented in the paper -> Identify the structure of the paper -> Identify the requirements of the writer

-> Single out clearly the new ideas presented in the paper

Which of the following are feature(s) we expect from our word processor? -> Spell checking -> The ability to plug multiple devices into the computer system. -> Equation support -> Support for multiple fonts/colors -> Grammar checking

-> Spell checking -> Equation support -> Support for multiple fonts/colors -> Grammar checking

Which of the following are places where data may be found? -> Subject matter databases -> Case studies -> Books -> Published papers -> Web sites

-> Subject matter databases -> Case studies -> Books -> Published papers -> Web sites

Which of the following characteristic(s) are provided by the formatting created by templates? -> Tables of figures with caption titles and their page numbers -> Table of contents with section titles -> Cross-referencing with section or page numbers -> Indices of keywords and their page numbers -> Footnote numbering

-> Tables of figures with caption titles and their page numbers -> Table of contents with section titles -> Cross-referencing with section or page numbers -> Indices of keywords and their page numbers -> Footnote numbering

According to Goldreich, a writer is often overwhelmed with his desire to say certain things and neglects to ask what the real needs of the reader are. Which of the following symptoms are related to the latter state of mind? -> The "Checklist" Phenomenon. The writer wishes to put everything he knows about the subject matter in the paper. -> Idiosyncrasies. Some writers tend to use terms, phrases, and notations that only have a personal appeal. -> Obscure Generality. The write chooses to present his ideas in the most general form instead of the easiest to understand. -> Lack of Heirarchy or Structure. The write should make clear distinctions between the more important ideas/statements and the less important one. -> Talmud-ism. The write explores all the subtleties and refinements of his ideas when first presenting them before clarifying the basic ideas.

-> The "Checklist" Phenomenon. The writer wishes to put everything he knows about the subject matter in the paper. -> Idiosyncrasies. Some writers tend to use terms, phrases, and notations that only have a personal appeal. -> Obscure Generality. The write chooses to present his ideas in the most general form instead of the easiest to understand. -> Lack of Heirarchy or Structure. The write should make clear distinctions between the more important ideas/statements and the less important one. -> Talmud-ism. The write explores all the subtleties and refinements of his ideas when first presenting them before clarifying the basic ideas.

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 definition of the data's result and it's ability to change. -> The level of confidence you can have in the answer you get. -> A result of the activities placed upon the data's result.

-> The level of confidence you can have in the answer you get.

In the GCF Video over Pictures and Text Wrapping, one of the key items text wrapping controls is: -> The position of the margin -> The position of the borders -> The position of the image -> The position of the text box

-> The position of the image

uIn his paper on "How to Write a Paper", Goldreich comments on why we write papers. His main reason was: -> Because he is judged on his information -> To get published -> To communicate an idea -> To sell papers

-> To communicate an idea

Which of the following are true about why we cite sources? -> To provide evidence for your arguments -> To allow the readers to locate and further explore the sources you consulted. -> To give credit where credit is due -> To provide a trail for your reader to follow the research you performed. -> To show the depth and scope of your research

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

Which of the following are true about databases for storing data? -> Tools exist to allow a web interface -> Allows operations on the data -> Stores and retrieves data based on keys -> Microsoft Word makes an excellent data storage tool. -> One size fits all

-> Tools exist to allow a web interface -> Allows operations on the data -> Stores and retrieves data based on keys

Which of these is an important feature for understand column totals (for example, finding the SUM from the top of the table to the bottom)? -> Calculated Columns -> Total Row -> Total Sum -> Total Column

-> Total Row

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

-> True

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 -> False

-> True

According to Goldreich, the title and the abstract should be as informative as possible and yet not too cumbersome or too long. The difference between them is their length. -> True -> False

-> True

Area charts emphasize the magnitude of change over time. They can be used to draw attention to the total value across a trend by displaying the sum of the plotted values. This shows the relationship of the parts to the whole. -> True -> False

-> True

Citation management tools can correctly format the citation to the appropriate style. -> True -> False

-> True

Clustered column charts compare values across categories by displaying values in vertical rectangles. -> True -> False

-> True

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 -> False

-> True

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

-> True

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

-> True

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

-> True

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

-> True

Visualization is really a dynamic form of persuasion through telling a story. -> True -> False

-> True

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

-> True

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

-> True

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

-> Verifiable and accurate

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"? -> Websites -> Academic Journals -> Books -> Librarian

-> Websites

In the GCF Video over Headers, Footers, and Page Numbers, the Design tab is present under which of the following conditions: -> When you have clicked in the Header area -> Always -> When you have selected the appropriate text -> Never

-> When you have clicked in the Header area

The initial step in data visualization is to -> draw a picture -> create a Table -> cite your sources -> make a chart

-> create a Table

According to the GCF video over Complex Formulas, what are predetermined formulas in Excel that can calculate complicated or long formulas for you? -> Long Formula Builder -> Standard Formula Calculator -> Functions -> Operations

Functions