CS 110 Lecture Exam 2

What is the average of the following set of numbers? 4,8,12,16,20

12

Given the following spreadsheet formula and values, evaluate the value returned from the formula: =A1*B1+C1*D1 A1=2, B1=3, C1=4, D1=2

14

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

b

Given the following spreadsheet formula and values, evaluate the value returned from the formula: =B1*C1/D1+A1 A1=2, B1=3, C1=4, D1=2

8

In Excel, if you copy the following formula from cell B1 and paste it into C1, what will be the result pasted into C1? =A1*$D$1

=B1*$D$1

A bibliography or list of works cited is almost always placed immediately after the introduction. T or F

F

A cell range is a group of cells. A non-adjacent range of cells is a rectangular block of cells. An adjacent range of cells is two or more non-adjacent ranges. T or F

F

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. T or F

F

According to the article from EasyBib, an interview is not a reliable source for research. T or F

F

Formulas begin with a plus sign (+). T or F

F

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. T or F

F

In statistics, the mode is the value that occurs least frequently in a data set. T or F

F

Information and data are synonymous. T or F

F

Pie charts are best for showing trends over time. T or F

F

Pie charts show the size of items in multiple data series proportional to one of the items. T or F

F

Spreadsheets are easily for people to understand and visualize for data trends and patterns. T or F

F

A function is a predefined formula that performs calculations using specific values in a particular order. T or F

T

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. T or F

T

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. T or F

T

According to the EasyBib article, books are still one of the best ways to find credible information about a source. T or F

T

As students, you have access to bibliographic and subject matter databases through the library. T or F

T

Calculating a confidence interval for a set of observations assumes a normal distribution. T or F

T

Citation management tools can correctly format the citation to the appropriate style. T or F

T

Every table includes filtering by default. You can filter data using the drop-down in the header row. T or F

T

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. T or F

T

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. T or F

T

The goal of a table is to represent data in a clear and accurate format. T or F

T

The purpose of a document is to communicate or persuade. T or F

T

Visualization is really a dynamic form of persuasion through telling a story. T or F

T

When designing the table's rows and columns, keep your audience's needs in mind. T or F

T

You can preview the font style if you use the dropdown menu. T or F

T

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

a

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

a

According to the GCF videos on Text Basics, Cut and Paste options can be found by selecting the text and doing which of the following? a. Right click b. Select from Hover Bar c. Select from Text pulldown c. Left click

a

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. Websites b. Books c. Academic Journals d. Librarian

a

According to the the GCF Video over Cell References, what type of reference is the default? a. Relative b. Normal c. Default d. Absolute

a

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

a

In the GCF Video over Formatting Cells, adding a fill color to a range of cells causes the lines between the cells to: a. Disappear b. Become Bold c. Be replaced with a dotted line d. Blink

a

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

a

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

a

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

a

What tool in Excel allows you to rearrange and organize data based on categories? a. Sorting b. Filtering c. Data Hunt d. Finding

a

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

a

hich tool in Excel helps you visualize the meaning behind data? a. Charts b. Pictures c. PivotTables d. Tables

a

Which of the following are absolute cell references? a. $AA$1 b. $B$1 c. $A$1 d. B1 e. A1

a, b, c

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

a, b, c

Which of the following are types of citations? a. Books b. Conference proceedings c. Web sites d. Journals e. Databases

a, b, c, d

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

a, b, c, e

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

a, b, e

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

a, b, e

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

a, c, d, e

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

all

To make your text stand out, which of the following can you use? a. Bold b. Italic c. Underline

all

Which of the following are places where data may be found? a. Case studies b. Subject matter databases c. Web sites d. Published papers e. Books

all

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

all

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

all

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

all

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

b

According to the GCF Video over Simple Formulas, the operator for an exponent is which of the following? a. ** (Double asterisk) b. ^ (Caret) c. ! (Exclamation point)bar d. @ (At sign)

b

According to the GCF videos on Formatting Text, you can change the font size by choosing the numeric font size or by clicking which of the following? a. Up and down arrows b. Shrink and grow buttons c. Left and right shift arrows d. Font color

b

According to the article from EasyBib, it is important to check for ___ when considering the credibility of a source. a. A YouTube video explaining the source b. How current the source is c. MLA style formatting d. More pages of the paper

b

The initial step in data visualization is to a. draw a picture b. create a Table c. make a chart d. cite your sources

b

To add a row, select the row ___ the place where you want to add the row. a. Above b. Directly there c. Below d. Behind

b

Which of these is not a PivotTable feature? a. Summarize large worksheet information b. Change the original data c. Condense information in multiple tables d. Filter data quickly

b

Which of these is not a key to designing a table? a. Arrange table rows and columns logically b. Make a matching chart to go with the table c. Summarize the data to assist in comparison d. Simplify data entries as much as possible

b

Which of the following are true about radar charts? a. The downside to radar charts is they can only plot one data series, where pie charts can plot one of more data series. b. Radar charts compare the aggregate values of multiple data sets. c. A 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.

b, c

Which of the following are characteristic(s) of a good document? a. Random and scattered logic b. Organized information c. Clear and concise d. Abbreviations and slang words e. Correct grammar and spelling

b, c, e

Which of the following are types of research papers? a. Maniacal b. Argumentative c. Web Page d. Analytical e. Presentation

b, d

To add a filter to your data, click the Filter command under which tab? a. Page Layout b. Formulas c. Data d. View

c

To get rid of outliers, we use which of the following? a. Magic b. Regression testing c. Standard Deviation d. Mode e. Median

c

What is a PivotTable? a. Rotating table b. A table that works from Powerpoint, Word, and Excel c. Data summarization tool d. Special chart with percentages

c

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)? a. Calculated Columns b. Total Column c. Total Row d. Total Sum

c

A ___ is something that comes with its own design and content placeholders. a. Brochure b. Format c. Premade document d. Template

d

According to the GCF Video over Complex Formulas, which of the following is calculated second in the order of operations: a. Addition / Subtraction b. Parenthesis c. Multiplication / Division d. Exponents

d

According to the GCF videos over Creating and Opening Documents, to create a document you click on File to go to which of the following? a. New Command tab b. Open Command tab c. File Command tab d. Back Stage View

d

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

d

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

d

What shows you only the data you need or helps you find a specific type of data? a. Data Hunt b. Finding c. Sorting d. Filtering

d

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? a. Case Studies b. Experimentation c. References d. Abstract e. Conclusion

d

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

d