Computer Methods
Formulas should always begin with a(n) ________.
A. equals sign
workbook
a file made up of related worksheets
pie chart
use it to show proportions of a whole (your total should = 100%)
scatter (x,y) chart
use it to show the relationship between sets of values
line chart
use it to show trends over time (years, months, days) or categories
column chart
use it to visually compare values across a few categories
List the google sheets tool names in the order they appear
1. Font 2. Font Size 3. Bold 4. Italic 5. Strikethrough 6. Text color 7. fill color 8. borders 9. merge cells 10. horizontal lines
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
sometimes you will try naming a cell and google sheets will choke on it and not allow the name. what is most likely the reason for this? A. the name is too short B. the name is too long C. You can't use proper names 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
D.The name already has another use or meaning to the program
Formula Bar
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
row
A group of cells that run horizontally from side-to-side.
Which of the following symbols are recognized as mathematical operators in spreadsheet. A. / B. @ C. * D. ^ E. x F. +
A. / C. * D. ^ F. +
Assume that cell A1 has the value 10 and A2 has the value 20. What is the result of the following spreadsheet IF statement: =IF(A1*2 >=, A1, A2) A. 10 B. 20 C. yes D. no E. 30
A. 10
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
A5 is the cell address for A. Row 5, Column 1 B. Row 1, Column 5
A. Row 5, Column 1
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
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
formula
An equation that calculates a new value from values currently in a worksheet.
which of the following is an absolute reference? A. #A2 B. $A$2 C. A2 D. A:2
B. $A$2
What does 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"? 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
B. To provide human readable information about the code
which of the following operators represents "not equal to" in a spreadsheet conditional expression? A. NE B. != C. <> D. =/
C. <>
What is the correct formula to sum all the values in the cells A1, B1, C1, D1, 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)
which function would you use to add the values of several cells? A. AVERAGE B. MAX C. SUM D. TOTAL
C. SUM
Assume that cell A1 has the value 10 and A2 as the value 20. What is 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
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
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 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
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
The chart best suited for plotting functional relationships (i.e. y=f(x)) is... A. column B. bar C. line D. XY scatter E. pie
D. XY scatter
most functions contain one or more ________ in parenthesis. A. plus signs B. sentences C. sub-functions D. arguments
D. arguments
What is git? A. A simplified programming language B. A mispronunciation of "get" C. something to say to stray cats D. coder versioning software E. the command your computer uses for retrieving web pages
D. code versioing 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
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
Which of the following is not a legit 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) why? the third argument has no quotations around it
T/F If the lookup value argument to VLOOKUP is not a number, the range argument (the cells you are searching for) should be a number
F. You can use VLOOKUP on numeric or text data
which of the following are not customizable features of a chart? A. chart and 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
Which 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
Which of the following is not a chart/graph type? 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
column
a group of cells that run vertically from top to bottom (letters)
cell range
a group or block of cells in a worksheet that have been selected or highlighted
When you use a cell name in a formula, it is a _______ reference
absolute
merge cells
allows you to combine a cell with adjacent, empty cells to create one large cell
wrap text
automatically modifies a cel's row height and allows the cell contents to be displayed on multiple lines
a group of cells is called a___________
cell range
cell
each rectangle in a spreadsheet. it is an intersection of a row and a column
T/F the data source for a chart cannot be changed after the chart is created
false
freeze
keeps row or column titles on the screen no matter where you scroll in the worksheet
worksheet
the workspace made up of columns and rows where you enter data to create an electronic spreadsheet
T/F goal seek can give you different answers for the same inputs based on the starting value of the target cell
true
T/F... google sheets saves your changes automatically
true
