CS Week 14 & 15

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

True

A group of cells is called a range. T/ F

the internet

According to the PC Magazine article, cloud computing is a metaphor for:

False

As long as an app is turned off, it cannot use your location services. T / F

False

Big data analytics are only useful to online businesses.

True

By default, a formula in a spreadsheet will automatically recalculate if the value contained in any of the formula's cell references change. T/ F

80s

By this decade, Computer Science professors could assume that their students came in with relevent computer experience.

an internet connection

Cloud computing requires:

more than one of the above

Conditional formatting can change the:

False

Data can be copied from one cell to another, but formulas cannot. T/ F

tab-delimited

Data imported into a spreadsheet should generally be _____.

Microsoft OneDrive Google Sheets Dropbox

Example(s) of cloud computing:

True

Geofencing involves using location services to define a geographic boundary T / F

Cloud Computing

Google Drive is an example of:

True

Having location services turned on is a risk to your personal security. T / F

Data

If the cell does not start with an equal sign then the cell contains ______.

False

Location services on your phone only work when you have cell coverage. T / F

True

Many businesses are accumulating new data faster than they can make use of the data. T / F

False

More and more women are entering the Computer Science field. T / F

True

My purchases are excluded from big data analytics as long as I don't shop online. T / F

False

Only your current location is tracked with location services. T / F

survey (form)

Results of a _______ in Google are put in a spreadsheet by default.

True

Spreadsheets can both organize textual data and make computations on numerical data. T/ F

False

Spreadsheets can only sort in ascending order. T/ F

Formulas

Spreadsheets perform calculations with:

statistics privacy security

The Data Science field involves:

True

The US workforce has a shortage of the skilled workforce to make the most of Big Data. T / F

personal computers

The author of the NPR article suggests the numbers of women in Computer Science changed when what became prevalent in homes:

$100,000+

The average Data Scientist salary in 2016 was:

cell

The basic unit of a spreadsheet is a:

SamSam hackers

The group that attacked the city of Atlanta systems is know as:

synchronization

The process providing copies of local files online:

the cell where the formula is entered

The results of a calculation in a spreadsheet cell are displayed in:

ransomware

The type of malware that infected the city of Atlanta systems is known as:

apply a filter

To narrow down the spreadsheet data in view:

Colon

To refer to a range of cells, specify the first cell, the last cell, and a ______ between.

True

Users must install cloud computing extensions for an application to use cloud services. T / F

True

Using big data analytics makes it possible for retailers to target their advertising. T / F

charts

We can see spreadsheet results graphically by creating:

dollar sign ($)

What symbol is used to denote absolute cell references?

Relative, Absolute

When copying formulas in a spreadsheet, _______ references change based on position and _______ references do not change.

=E5 * $A3

When copying the formula =D5 * $A3 from column D to column E (same row), the rusulting formula in column E is:

=B2+C2-6.2

Which is a valid formula in a spreadsheet?

SUM AVERAGE COUNTIF

Which of the following are functions built into spreadsheets?

targeted ads traffic routing phone tracking

Which of the following are the result of location services?

storing and accessing data and programs over the Internet

cloud computing involves:

sorting

customizes the order of spreadsheet data

functions like COUNTIF, SUM, AVERAGE, MAX, MIN

if I want to analyze data in a spreadsheet, I could use:

whenever a cell is changed

spreadsheets recalculate


Ensembles d'études connexes

CCJS 341 Week 8 - The Changing Nature of Crime And Criminal Investigations: Read pages 9-48

View Set

Crim Law Chapters 12-14 Review Exam

View Set

Exam 3 Biology Chapter 8 Cell Division

View Set

History of Rock: Chapter 7- The Growing Rock Monster (1970-'75)

View Set

Glencoe Science Earth Science Chapter 7 Weathering Erosion and Soil

View Set