CCE Midterm 1
Row 5, Column 1
A5 is the cell address for
equals sign
Formulas should always begin with a(n)
Voltron
Which of the these is NOT a programming language?
If-Then
Which of these programming constructs do we use for taking action based on checking the value of a variable?
To scroll through the spreadsheet while continuing to see the frozen rows
Why would you want to freeze rows in your spreadsheet?
(any of the above)- list of distinct values, range of decimal numbers, range of whole numbers, set of allowable dates
Data validation can be used to limit the values entered in a cell based on...
The associated row or column is an absolute reference
A "$" in a cell reference means
cell range
A group of cells is called a ________.
12-3
According to the order of operations, which calculation comes first in the following formula? =3^2/5+(12-3)
can come from any column in the table
After a matching value is found using the VLOOKUP function, the return value...
10
Assume that cell A1 has the value 10 and A2 as the value 20. What is the result of the following spreadsheet IF statement?
Yes
Assume that cell A1 has the value 10 and A2 as the value 20. What is the result of the following spreadsheet IF statement?
30
Assume that cell A1 has the value 10 and A2 as the value 20. What is the result of the following spreadsheet IF statement? =IF(A1 * 2 > A2, A2 - A1, A1 + A2)
Yes
Assume that cell A1 has the value 10 and A2 as the value 20. What is the result of the following spreadsheet IF statement? =IF(A1 * 2 >= A2, "Yes", "No")
Purple Elephants May Destroy A School
Clever acronym for PEMDAS
False
Every Google Sheet is visible to everyone on the Internet. Therefore you can not use Google Sheets for sensitive data like budget information, etc.
True
Goal Seek can give you different answers for the same inputs based on the starting value of the target cell
True
Google Sheets is a "software as a service" provided freely by Google for anyone with a Google account.
False. You can use vlookup on numeric or text data in any part of the search table.
If the lookup value argument to VLOOKUP is not a number, the range argument (the cells you are searching) should be a number.
absolute
In general, when you use a cell name in a formula, it is a(n) reference
Yes
Is it possible to put more than one time series on a single spreadsheet time series chart?
arguments
Most functions contain one or more ________ in parentheses.
True
Properly organizing your data will greatly simplify making graphs and charts in a spreadsheet.
The name already has another use or meaning to the program
Sometimes you will try naming a cell and Google Sheets will choke on it and not allow that name. What is the most likely reason for this?
False
The Data Source for a chart cannot be changed after the chart is created
XY Scatter
The chart type best suited for plotting functional relationships (i.e., y=f(x)) is...
F4
The shortcut to toggle a cell reference between absolute and relative is:
Either of the above will work
To copy a formula from a selected cell to other cells directly below it, do the following:
Type "=" and then enter the formula
To enter a formula in a cell, do the following:
True
True or False: Google Sheets saves your changes automatically.
Pie
Use this chart to show proportions of a whole. Use it when the total of your numbers is 100%
Line
Use this chart to show trends over time (years, months, and days) or categories
Column
Use this chart to visually compare values across a few categories
Scatter (X,Y)
Use this chart type to show the relationship between sets of values
Searchable Log of All Conversation and Knowledge
What does the name "Slack" stand for?
A simplified programming language.
What is Git?
The dollar signs indicate this is an absolute reference (not relative).
What is the meaning of the dollar signs in this cell reference:$B$32
13
What is the output of this spreadsheet statement? =3^2+8/4*2
To provide human readable information about the code.
What is the purpose of a "comment" in code?
To determine if there is a statistical trend in the data
What is the purpose of the "Trendline" option in the Google Sheets - Customize - Series tab?
Yes
What is the result of the following spreadsheet IF statement? =IF (1000=500*2, "Yes", "No")
Yes
What is the result of the following spreadsheet IF statement? =IF(PI()>=0, "Yes", "No")
None of the above. You can graph anything.
What kind of data should you NEVER put in a spreadsheet graph?
SUM
Which function would you use to add the values of several cells?
= sum(A1:E1)
Which is the correct formula to sum all the values in the cells A1, B1, C1, D1, and E1?
<>
Which of of the following operators represents "not equal to" in a spreadsheet conditional expression?
Chart angle or rotation
Which of the following are NOT customizable features of a Google Sheets chart?
Filters
Which of the following features allows you to narrow down the data in your worksheet?
Freestyle chart
Which of the following is NOT a chart/ graph type in Google Sheets?
IF(A2=100, "A2 is 100", A2 is not 100)
Which of the following is NOT a legitimate spreadsheet IF statement?
boolean_option
Which of the following is NOT an argument to the IF function?
$A$2
Which of the following is an absolute cell reference?
/,*,^,+
Which of the following symbols are recognized as mathematical operators in a spreadsheet? Select all that apply.
My_Variable_3
Which of these is a legal name for a variable?
<html>
Which of these lines of code are used in every web page?
Loop
Which of these programming constructs do we use for iterating over a list or array of items?
