CS Week 14 & 15
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