CS-110 Lecture Exam 2

In the GCF Video over Cell References, to can make a cell reference absolute by putting what in front of the cell reference? % ! $ ^

$

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 28 14 11 18 22

14

Given the following sequence, what would be the median of the values? 1,2,2,3,3,3,4,5,5,6,6,6,14 2 4 3 5 14

4

If the ratio of bananas to apples is 2:1 and there are 24 apples, how many bananas are there? 24 36 96 48 12

48

If the ratio of bananas to apples is 2:1 and there are 24 apples, how many bananas are there? 36 12 24 48 96

48

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 11 22 16 24 8

8

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

=SUM(D4:D9)

When examining a set of recorded observations, what is an outlier? An observation that is numerically distant from the rest of the data. A value that is the median of the data. A value that is the average of the data. An observation that is numerically similar from the rest of the data. A value that is the mode of the data.

An observation that is numerically distant from the rest of the data.

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

How current the source is

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

It's fast and provides you with a lot of information

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

Knowing your audience

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

Make a matching chart to go with the table

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

Organized information Clear and concise Correct grammar and spelling

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

PivotTables

According to the GCF Video over Simple Formulas, you specify that a cell contains a formula by doing which of the following? Right clicking and selecting cell formula Putting an equal sign as the first character Left clicking and selecting cell formula Formatting the cell as a cell formula

Putting an equal sign as the first character

Which of the following are true about scatter charts? Scatter charts should not be used when you want to change the scale of the horizontal axis. Scatter charts are typically used for displaying and comparing numeric values such as scientific, statistical, and engineering data. 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 show the relationships among the numeric values in several data series. Scatter charts are ideal to use when you want to track values related to duration.

Scatter charts are typically used for displaying and comparing numeric values such as scientific, statistical, and engineering data. 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 show the relationships among the numeric values in several data series.

To get rid of outliers, we use which of the following? Magic Standard Deviation Regression testing Median Mode

Standard deviation

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. A result of the activities placed upon the data's result. 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.

Which of the following are true about using charts in presentations? 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 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

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

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

To communicate an idea

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? Talmud-ism. The write explores all the subtleties and refinements of his ideas when first presenting them before clarifying the basic ideas. Idiosyncrasies. Some writers tend to use terms, phrases, and notations that only have a personal appeal. The "Checklist" Phenomenon. The writer wishes to put everything he knows about the subject matter in the paper. 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.

all of them

Which of the following are categories of functions available in Excel? Math and Trig Financial Text Date and Time Logical

all of them

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

all of them

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

all of them

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

all of them

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

all of them

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? Bar chart Pie chart Line chart Radar chart Scatter chart

bar chart

In the GCF Video over Cell Basics, identification of a cell, such as D6, is called which of the following? Cell Address Cell Identification Cell Column Cell Row

cell address

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

cover letter resume research paper

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

data

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

data indexing

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

data summarization tool

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

data visualization

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

exponents

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

According to the GCF Video over Cell Basics, when you cut and paste a cell range the cells disappear when you cut them and reappear when you paste them. True False

false

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

false

Formulas begin with a plus sign (+).

false

Information and data are synonymous. 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 arguments to a function are all mandatory - each function has a specific set of arguments that are required for the function to work. True False

false

The average of a set of numbers is the sum of the values divided by the least of the values. The more samples there are, the more reliable the average. True False

false

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

female

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

filtering

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

formula bar

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

it is a key paper in the area of research

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? Select from Hover Bar Select from Text pulldown Left click Right click

right click

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

sorting

uWho does Goldreich identify as the target of presenting the author's key ideas to? The author's peers The author's students The general public The relevant community

the relevant community

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 communicate an idea To sell papers To get published

to communicate an idea

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

true

A stacked column chart shows the relationship of individual items to the whole by comparing the contribution of each value to a total across categories. true false

true

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 False

true

According to the GCF Video over Formatting Cells, when selecting changes to the font, you will get a preview of the possible selection as you scroll over the selection. True False

true

According to the GCF videos on Creating and Opening Documents, you can pin commonly used documents to the back stage view. 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

As students, you have access to bibliographic and subject matter databases through the library. true false

true

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

true

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

Standard deviation is used to identify the variance in the set of data points. True False

true

The Date type in Excel is an internal way for Excel to store dates. It allows everything to be stored in a common way and allows follow-on functions to handle the date. True False

true

The Page Layout tab can help you modify your page orientation, margins, and theme. True False

true

The median is a numerical value separating the higher half of a sample, a population, or a probability distribution, from the lower half. True False

true

The median is a numerical value separating the higher half of a sample, a population, or a probability distribution, from the lower half. True False

true

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

true

To create a PivotTable, click either one cells (if your data is already in a table) or the cell range (if you data is not a table) and then click the Pivot Table option. True False

true

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

true

You can preview the font style if you use the dropdown menu. true false

true