MIDTERM 170
Which of the following symbols are recognized as mathematical operators in a spreadsheet? Select all that apply.
/ * ^ +
A file made up of related worksheets
Workbook
The workspace made up of columns and rows where you enter date to create and electronic spreadsheet
Worksheet
Formulas should always begin with a(n) ________.
equals sign
Is it possible to put more than one time series on a single spreadsheet time series chart?
yes
Which of the following is an absolute cell reference?
$A$2
According to the order of operations, which calculation comes first in the following formula? = 3 ^ 2 / 5 + (12 - 3)
12 - 3
What is the output of this spreadsheet statement? =3^2+8/4*2
13
How would a spreadsheet evaluate this formula?= 6 * 4 / 12 + 72 / 8 - 9
2
How would a spreadsheet evaluate this formula?= (17 - 6 / 2) + 4 * 3
26
Pre-defined formula that performs calculations using specific values in a particular order.
Function
= (3 * 5 ^ 2 / 15) - (5 - 2 ^ 2)
4
Which of of the following operators represents "not equal to" in a spreadsheet conditional expression?
<>
Which of these lines of code are used in every web page?
<html>
Which is the correct formula to sum all the values in the cells A1, B1, C1, D1, and E1?
= sum(A1:E1)
Which of the following answers correctly describes how this Google Sheet is shared?
Anyone on the web can view the sheet, but only Dan, Anna, Jim, and Norm can edit it.
This is each rectangle in a spreadsheet. It is an intersection of a row and a column.
Cell
A group or block of cells in a worksheet that have been selected or highlighted.
Cell Range
Which of the following are NOT customizable features of a Google Sheets chart?
Chart angle or rotation
What is Git?
Code versioning software.
A group of cells that run vertically from top to bottom.Identified by letters.
Column
Every Google Sheet is visible to everyone on the Internet. Therefore you can not use Google Sheets for sensitive data like budget information, etc.
FALSE
Which of the following features allows you to narrow down the data in your worksheet?
Filters
An equation that calculates a new value from values currently in a worksheet.
Formula
Use this to enter and edit data, functions and formulas for a specific cell.
Formula Bar
Which of the following is NOT a chart/graph type in Google Sheets?
Freestyle chart
Keeps row or column titles on the screen no matter where you scroll in the worksheet
Freeze
Which of the following is NOT a legitimate spreadsheet IF statement?
IF(A2=100, "A2 is 100", A2 is not 100)
Which of these programming constructs do we use for taking action based on checking the value of a variable?
If - Then
Which of these is NOT a programming language?
JavaScript Python Visual Basic C++ Fortran Perl C# VOLTRON***** PHP
Which of these programming constructs do we use for iterating over a list or array of items?
LOOP
This allows you to combine a cell with adjacent, empty cells to create one large cell.
Merge Cells
Which of these is a legal name for a cell name in spreadsheets or a variable name in programming?
My_Variable_3
A group of cells that run horizontally side to side
Row
Which function would you use to add the values of several cells?
SUM
What does the name "Slack" stand for?
Searchable Log of All Conversation and Knowledge
Google Sheets is a "software as a service" provided freely by Google for anyone with a Google account.
TRUE
True or False: Google Sheets saves your changes automatically.
TRUE
What is the meaning of the dollar signs in this cell reference:
The dollar signs indicate this is an absolute reference (not relative).
What is the purpose of the "Trendline" option in the Google Sheets - Customize - Series tab?
To determine if there is a statistical trend in the data
What is the purpose of a "comment" in code?
To provide human readable information about the code.
Why would you want to freeze rows in your spreadsheet?
To scroll through the spreadsheet while continuing to see the frozen rows
This will automatically modify a cell's row height, allowing the cell contents to be displayed on multiple lines.
Wrap Text
Data validation can be used to limit the values entered in a cell based on...
a list of distinct values a range of decimal numbers a range of whole numbers a set of allowable dates
Most functions contain one or more ________ in parentheses.
arguments
Which of the following is NOT an argument to the IF function?
boolean_option
A group of cells is called a ________.
cell range
What kind of data should you NEVER put in a spreadsheet graph?
graph everything
Goal Seek can give you different answers for the same inputs based on the starting value of the target cell
true
Properly organizing your data will greatly simplify making graphs and charts in a spreadsheet.
true
