Computer Methods 170- spreadsheets unit
A5 is the cell address for A. Row 5, Column 1 B. Row 1, Column 5
A. Row 5, Column 1
A "$" in a cell reference means A. The associated row or column is an absolute reference B. The cell is locked for editing C. The cell is formatted for currency
A. The associated row or column is an absolute reference
A group of cells is called a ________. A. chart B. cell range C. multicell D. cell cluster
B. cell range
Data validation can be used to limit the values entered in a cell based on... A. a list of distinct values B. a range of decimal numbers C. a range of whole numbers D. a set of allowable dates E. (any of the above)
E. (any of the above)
Google Sheets is a "software as a service" provided freely by Google for anyone with a Google account. True False
True
Properly organizing your data will greatly simplify making graphs and charts in a spreadsheet. True False
True
True or False: Google Sheets saves your changes automatically. True False
True
A file made up of related worksheets
Workbook
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
Which of the following is an absolute cell reference? A. #A2 B. $A$2 C. A2 D. A:2
B. $A$2
Which of these programming constructs do we use for taking action based on checking the value of a variable? A. Loop B. Function C. Subroutine D. If - Then E. Variable F. GoTo
D. If - Then
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) A. 10 B. 20 C. Yes D. No E. 30
E. 30
How would a spreadsheet evaluate this formula? = (3 * 5 ^ 2 / 15) - (5 - 2 ^ 2)
4
Which of the following symbols are recognized as mathematical operators in a spreadsheet? Select all that apply. A. / B. @ C. * D. ^ E. x F. +
A. / C. * D. ^ F. +
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, A1, A2) A. 10 B. 20 C. Yes D. No E. 30
A. 10
According to the order of operations, which calculation comes first in the following formula? = 3 ^ 2 / 5 + (12 - 3) A. 12 - 3 B. 2 / 5 C. 5 + 12 D. 3 ^ 2
A. 12 - 3
Which of these lines of code are used in every web page? A. <html> B. Print Line C. OpenFile() D. # Load Preview E. array() F. for (i=0,i++, i<99) {}
A. <html>
The shortcut to toggle a cell reference between absolute and relative is: A. F4 B. Ctrl-R C. Alt-A D. Ctrl-Shift-Q
A. F4
What is the purpose of the "Trendline" option in the Google Sheets - Customize - Series tab? A. To determine if there is a statistical trend in the data B. To determine which trends in clothing are coming next year C. To highlight the original data through changing line style trends D. To note trending topics in Twitter
A. To determine if there is a statistical trend in the data
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") A. Yes B. No
A. Yes
Is it possible to put more than one time series on a single spreadsheet time series chart? A. Yes B. No
A. Yes
What is the result of the following spreadsheet IF statement? =IF(1000=500*2, "Yes", "No") A. Yes B. No
A. Yes
What is the result of the following spreadsheet IF statement? =IF(PI()>=0, "Yes", "No") A. Yes B. No
A. Yes
Which of the following is NOT an argument to the IF function? A. boolean_option B. value_if_true C. value_if_false D. logical_test
A. boolean_option
Formulas should always begin with a(n) ________. A. equals sign B. dollar sign C. header D. hashtag
A. equals sign
What does the name "Slack" stand for? A. System for the Loose Arrangement of Computer Knowledge B. Searchable Log of All Conversation and Knowledge C. Special Library for Advanced Communication Keeping D. Stable Language for Corporate Know-how
B. Searchable Log of All Conversation and Knowledge
What is the purpose of a "comment" in code? A. To force the code to stop running. B. To provide human readable information about the code. C. To pop up a message box to the user. D. To tell the user when the program is done running (or when an error has occurred).
B. To provide human readable information about the code.
In general, when you use a cell name in a formula, it is a(n) ____ reference A. relative B. absolute
B. absolute
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, A1, IF(A2 = 20, "Yes", "No")) A. 10 B. 20 C. Yes D. No E. 30
C. Yes
Which of of the following operators represents "not equal to" in a spreadsheet conditional expression? A. NE B. != C. <> D. ≠
C. <>
Which is the correct formula to sum all the values in the cells A1, B1, C1, D1, and E1? A. = sum(A1 + B1 + C1 + D1 + E1) B. = A1:E1(summed) C. = sum(A1:E1) D. = sum:A1 + sum:E1 E. = sum(A1...E1)
C. = sum(A1:E1)
To copy a formula from a selected cell to other cells directly below it, do the following: A. Ctrl C (copy) + Ctrl V (paste) B. Click and drag the small square in the corner of the cell C. Either of the above will work
C. Either of the above will work
Which of the following features allows you to narrow down the data in your worksheet? A. Merge cells B. Sorting C. Filters D. Relative cell references
C. Filters
The chart type best suited for plotting functional relationships (i.e., y=f(x)) is... A. Column B. Bar C. Line D. XY Scatter E. Pie
C. Line (I guess I don't really know) D. XY Scatter
Which function would you use to add the values of several cells? A. VERAGE B. MAX C. SUM D. TOTAL
C. SUM
Why would you want to freeze rows in your spreadsheet? A. To modify only the frozen rows B. To limit the data that can be entered in the frozen row C. To scroll through the spreadsheet while continuing to see the frozen rows D. To prevent the rows from being edited by collaborators
C. To scroll through the spreadsheet while continuing to see the frozen rows
To enter a formula in a cell, do the following: A. Hit Ctrl-F and type in the formula box B. Right-click on the cell and select "Enter Formula" from the pop-up menu C. Type "=" and then enter the formula D. All (any) of the above will work
C. Type "=" and then enter the formula
After a matching value is found using the VLOOKUP function, the return value... A. always comes from the first column in the table B. always comes from the second column in the table C. can come from any column in the table
C. can come from any column in the table
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
Use this chart to visually compare values across a few categories. A. Line D. Scatter (X,Y) C. Column D. Pie
Column
What is Git? A. A simplified programming language. B. A mispronunciation of "Get". C. Something to shout at stray cats. D. Code versioning software. E. The command your computer uses for retrieving web pages.
D. Code versioning software.
Which of these programming constructs do we use for iterating over a list or array of items? A. GoTo B. Open C. If - Then D. Loop E. Choose F. Redirect G. Function
D. Loop
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? A. The name is too short B. The name is too long C. You can't use proper names like names of people or places, for a cell name D. The name already has another use or meaning to the program E. The name is too controversial to be used F. You can't use swear words for names in publicly facing spreadsheets
D. The name already has another use or meaning to the program
Most functions contain one or more ________ in parentheses. A. plus signs B. sentences C. sub-functions D. arguments
D. arguments
Which of these is a legal name for a cell name in spreadsheets or a variable name in programming? A. My Variable 3 B. MyVariable 3 C. 3MyVariable D. My_Variable_3
D.) My_Variable_3
What is the meaning of the dollar signs in this cell reference:$B$32 A. Nothing. This is the same as writing B32. B. $B$32 is a cell address formatted for currency. C. $B$32 indicates that the cell is on the second tab. D. The dollar signs indicate greater importance of this cell. E. The dollar signs indicate this is an absolute reference (not relative).
E. The dollar signs indicate this is an absolute reference (not relative).
Which of the following is NOT a legitimate spreadsheet IF statement? A. IF(A2 = "foo","A2 is foo") B. IF(A2,"A2 was true","A2 was false") C. IF(TRUE,4,5) D. IF(TRUE, TRUE, TRUE) E. IF(A2<=1000, 1000, 0) F. IF(A2=100, "A2 is 100", A2 is not 100)
F. IF(A2=100, "A2 is 100", A2 is not 100)
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 False
False
If the lookup value argument to VLOOKUP is not a number, the range argument (the cells you are searching) should be a number. True False
False
The Data Source for a chart cannot be changed after the chart is created True False
False
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
Keeps row or column titles on the screen no matter where you scroll in the worksheet
Freeze
Pre-defined formula that performs calculations using specific values in a particular order.
Function
Which of the following are NOT customizable features of a Google Sheets chart? A. Chart & axis titles B. Legend position C. Series color and style D. Gridlines and tick marks E. Font styles and colors F. Chart size and position on the sheet G. Chart angle or rotation H. Vertical axis data range I. Horizontal axis data range
G. Chart angle or rotation
What kind of data should you NEVER put in a spreadsheet graph? A. Water data B. Financial data C. Population data D. Library data E. Business data F. Student grade data G. None of the above
G. None of the above
Which of the following is NOT a chart/graph type in Google Sheets? A. Line chart B. Column chart C. Area chart D. Bar chart E. Pie chart F. Scatter chart G. Gauge chart H. Freestyle chart I. Candlestick chart J. Radar chart
H. Freestyle chart
Which of these is NOT a programming language? A. JavaScript B. Python C. Visual Basic D. C++ E. Fortran F. Perl G. C# H. Voltron I. PHP
H. Voltron
Use this chart to show trends over time (years, months, and days) or categories. A. Line D. Scatter (X,Y) C. Column D. Pie
Line
This allows you to combine a cell with adjacent, empty cells to create one large cell.
Merge Cells
Use this chart to show proportions of a whole. Use it when the total of your numbers is 100%. A. Line D. Scatter (X,Y) C. Column D. Pie
Pie
A group of cells that run horizontally side to side
Row
Use this chart type to show the relationship between sets of values. A. Line D. Scatter (X,Y) C. Column D. Pie
Scatter (X,Y)
Goal Seek can give you different answers for the same inputs based on the starting value of the target cell True False
True
The workspace made up of columns and rows where you enter date to create and electronic spreadsheet
Worksheet
This will automatically modify a cell's row height, allowing the cell contents to be displayed on multiple lines.
Wrap Text
A group of cells that run vertically from top to bottom.Identified by letters.
column
