compilation of Moodle quizzes and tests
Given the following formula: =IF(A2>500,IF(A2>750,"Very High","High"),IF(A2>250,"Low","Very Low")) What would it return if the value in cell A2 is 250?
Very Low
Click here to toggle between seeing the values or editing the table/query.
View
VBA
Visual Basic for Applications; programming language that can be used within various software packages to enhance and automate functionality
BaseRate of 53
Well Paid
The functions which end in S, such as IFS(), SUMIFS(), COUNTIFS() ...
When you need multiple criteria matched. For example the number of all Females who received an A in the class.
According to Qoheleth, is wisdom better than folly? Why?
Wisdom is better than folly just like light is better than darkness because folly can lead us astray
Given this spreadsheet example, what is the best formula in order to create a running balance in column E?
=E2-C3+D3
Returns the number of characters in a text string
=LEN()
* (asterisk)
A Wildcard - used in pattern searching
Which type of chart is best for comparing values between named categories or items (e.g. population levels between cities)?
Bar Chart
A Customer Relationship Management system, such as Salesforce, allows for keeping track of clients, reaching out to them with targeted communications, recording of interactions between your company and them, and many other features.
CRM
, (comma)
Often used as a file delimiter in a CSV flat file
BaseRate of 20
Okay
BaseRate of 30
Okay
Key field uniquely identifies the rest of the data in that record.
The value in a primary
These type of "mini" charts occupy a single cell.
Spark Lines
This extension reflects a file with "flat text" and usually has lines for each row with commas separating the fields.
.csv
What decimal number is represented by the binary number 10000001?
129
Adding a slicer for education, how many technicians with a tertiary education level prefer to be contacted by cellular?
163
How many loans are to people who are retired?
230
Filtering the Jobs to compare entrepreneur, self-employed, and student, how many loans are represented?
435
If you need a quick total of some numbers
=5+8+2+4+10
Assume a formula in cell C2 uses cells A2 and B2. When copied to cell C3 it should produce similar results like the illustration below. What would the formula in cell C2 look like?
=B2 & " " & A2
If the formula reflected for cell B2 were copied to cell C6, what would the copied formula be in C6?
=B6 * F$2
When you need to add cells that are not all side by side.
=C2+F2+H2
This can be a combination of literal values, arithmetic operators and database values
A Calculated field or an expression
Which statement is true
A foreign key points to the key in another table
Array Formula
A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.
In general, this is best for "what-if" analysis.
A spreadsheet
What best describes a table.
A structure where rows can have varying columns to fit all situations
=257*$G$1
Absolute
In what-if analysis, you can use this type to change a value in order to see how if affects the rest of the calculations. For example, if my profit margin increases from 10% to 20% what would my net profit be for this quarter?
Absolute
Review the formula view of the example above. What will be the value of cell C1 when switched to the view that displays the values?
An Error like #VALUE!
The key to doing this is using Ctrl+Shift+Enter.
Array Formula
The range of the highlighted section
B2:F4
Click here to find the option of defining relationships between tables
Database Tools
Box and Whisker (Boxplot)
Distribution
Histogram
Distribution
Used to store a GPA
Double
An Enterprise Resource Planning system allows for the integration of many resources and processes to work together in order to efficiently run a business.
ERP
According to Ecclesiastes, "There is nothing better for a person than that they should ..."
Eat, drink and find enjoyment in their toil
Type the words which fill out the DIKW Pyramid in the space below
data information knowledge wisdom
How many students want to be contacted via a cell phone?
62
Given the snippet of the spreadsheet above, what will be the value in cell C2?
885
Scatter Plot
Relationship
A worksheet is
- a spreadsheet that contains formulas, values, text, and/or visual aids - opened by clicking the tab at the bottom of the Excel screen
Sometimes data fields contain numeric digits but they are really meant to identify something not quantify it (wouldn't want to do arithmetic operations on it). Select the example(s) below which are used to identify
- Calvin student number (e.g. 0505050) - Phone number (e.g. 1-616-526-6000) - Zip code (e.g. 49546)
According to the article, "7 Irresistible Reasons to Convert Your Data into an Excel Data Table", which of the following are some of those reasons?
- Drop-Down Filters - Automatic Totals. - Even When You Filter! - Column Headings are Always Visible - Banded Rows - to Make your Data Easier to Read
Select the best match below that complete this verse from Ecclesiastes 11:9: "_________, O young man, in your youth, and let your heart cheer you in the days of your youth. Walk in the ways of your heart and the sight of your eyes. But know that for all these things God will bring you into ____________."
Rejoice, judgment
Treemap
Relationship
The ____________ window in Access 2016 allows you to lay out your Tables and specify relationships between them visually.
Relationships
=B4+C4
Relative
Used in a formula when you want to keep the pattern the similar to the row above. For example, totaling a student's quiz scores.
Relative
" (double quotes)
To specify that a number should be treated as text
Line Chart
Trend
$A$1 is an example of an absolute reference in Excel.
True
A cell in Excel is the intersection of a column and row.
True
A network is used to communication between 2 or more computers.
True
A workbook is a file containing related worksheets
True
Iteration
repeated interactions with the same partners
[] (square brackets)
Allows the value of a Field to be used in a query criteria
& (ampersand)
Used to Concatenate strings together
This function allows you to find a value based on another (e.g. a product code to find a product name)
VLOOKUP()
In the process of creating a new table in Access, you are creating
NOT Data values that can be used in decision making (idk the right answer..)
The value of B3
Nancy
Which of the following describes good file management practices
- After learning some basic principles in class, create a file management systems that works best for you. - Create a folder for each class and store assignments and resources accordingly
Select the answer(s) which best indicates what are Databases good for?
- Answer questions about who, what, when, and where - Enforce structure on data
In the book of Ecclesiastes, we talked about several different phrases/concepts that are repeated throughout the book. Select the appropriate response(s).
- ...under the sun - Vanity of vanities
One of the repetitive phrases in the book of Ecclesiastes is "vanity of vanities." What are some other words which could be used instead?
- A vapor, mist, or mere breathe. - Meaningless
It is a good idea to:
- In writing queries, make a change and then run the query to see if it worked the way you wanted it to - Check your results to see if it makes sense
In class we used Access to establish a connection to another computer and linked to tables from a database on that computer so that you could work with that table as if it were actually on your machine. What do you think are some of the benefits to this type of client-server technology?
- Opens up opportunities to access a variety of data from a multitude of sources - Facilitates the sharing of data with multiple people. For example multiple researchers can access the same database even if they lived in different countries. - Opens up access to Big Data
Select the answer(s) which describes what Spreadsheets are really good at?
- Strong at providing what-if analysis - Variety of charting options to visualize data
Given the formula select all that apply: =IF(B2>90,"A",IF(B2>80,"B",IF(B2>70,"C",IF(B2>60,"D","F"))))
- This is a valid formula because you are allowed to have multiple IF statements nested together - Given that B2 contains a 61, the results of this formula will return a 'D'
In class we talked about several key concepts found in Ecclesiastes 3. From the below list, choose one (only one), indicate which one you are writing about, and write several sentences unpacking its meaning. 2. "...everything God does will endure forever..." (Ecc 3:14)
2. Everything that God does and has done is completely perfect in itself. There is no way for humans to complete with what He has done. There is no body with greater power to undo what He has done. Therefore, His actions can withstand time
On a scale of 1-5 with 5 being most difficult, how would you rate Project #1 difficulty level? (Your grade is not based upon what level you give, but only on if you answer this question or not.)
4
Returns the number of cells which match multiple criteria. For example, how many students turned their assignments in on time and received extra credit.
=COUNTIFS()
Returns the current date/time
=NOW()
Calculates a loan payment amount
=PMT()
Calculate the total of contiguous cells
=SUM(C2:G2)
Add up all the numbers which match a given criteria in the range.
=SUMIF()
Used to look up a specified value in a range of values while returning related information. For example looking up a part number and returning the part description.
=VLOOKUP()
Used in a formula where the cell's location must never change. You always want to point to that cell.
Absolute
Which contact method seems to be the most prevalent?
Cellular
ASCII and UTF 8 are standards for
Character encoding
=[StudentAge]
Checks against field/column "StudentAge"
Symbols such as >, >=, <, <=, etc are examples of
Comparison operators used on a criteria line
Pareto
Composition
To dynamically change the fill color of cells based upon cells contents. For example, to you might use Green, Yellow, Red colors to indicate cell values which are good, not so good, and not good at all.
Conditional Formatting
What does the green triangle in the upper left of a cell indicate?
Excel has determine that something may be wrong in the cell. It is a warning indicator and you should double check to make sure the value in the cell is what you want it to be.
This is a value based on a constant literal, a formula, a function or a combination.
Expression
Given that the PMT() functions requires the inputs of interest rate, payment periods and the value of the loan in that order (This is true and not part of the question). Does the following use of the PMT() function adequately represents the calculation for a loan of $200,000 for monthly payments spread across six years at an annual interest rate of 3 percent: =PMT(3%/12, 6 * 12, 200,000)
False
The cell C10, refers to Row C and Column 10.
False
The cell containing the text Quiz 2 is in the range of B3:F3.
False
When entering data into an autonumber field, Access allows you to type any number you wish.
False
According to the book of Proverbs, what is the beginning of wisdom?
Fear of the Lord
If you don't set this value, text will be 255 characters in length by default:
Field Size
For a quick ad-hoc inquiry for records with a certain value in a column, generally most people using Access will use which of the following if they don't want to save the search conditions:
Filter
FileZilla
Free ftp transfering software
If a query produces the following query result using this Employee table, what is the Calculated Field? (FULL NAME)
Full Name: [lname] & ", " & [Fname]
This is a great tool for finding out how much you need to change a single input value to generate a specific result from a formula.
Goal Seek
Small Problem Given the following table/data and the query design that follows, which product(s) would be returned in the query.
Hammer
This function is useful for conditionally determining an output value when comparing two values.
IF()
This function is useful in the event a formula includes references to cells that could result in a division by zero.
IFERROR()
To display a user friendly message when a VLOOKUP() cannot find a match, you could use this function.
IFNA()
Which can be used to select only rows where the value of a column is unknown?
IS NULL
When using Access, "1234" is an example of
Literal text value similar to a name or a zip code
Used to store the population of Michigan
Long Integer
Used to store an Essay question
Long Text
How is meta-data different than data?
Meta-data describes the data such as its type, format and validation rules
BaseRate of 40
Not Bad
Bar Chart
Ordering and Ranking
=[Enter the minimum age]
Prompt the User
Qoheleth writes in Ecclesiastes 7:2, "It is better to go to a house of mourning than to go to a house of feasting, for death is the destiny of every man; the living should take this to heart." (NIV). What do we learn from this?
Qoheleth takes death seriously and reflects upon only having so much time to live, therefore he is encouraging us to live life well.
As you reflect back on Project #1, what stands out to you, impacted you, or was reinforced through it?
Reflecting back on Project #1, I was reinforced with the knowledge of how useful a database is. When having to record data, it was interesting, and frustrating at times, to see how all the data was connected. I would try to enter or change data but I couldn't until I changed it in a specific table first. All of it was worth it in the end when making forms and queries. The forms and queries were able to simply and create readably data quickly and nicely which is amazing.
A Student Information System allows storing data for each student including a student's demographics, course work, financial aid, bills, etc.
SIS
This function is useful for adding up values that are associated with a specific label.
SUMIF()
Used to demonstrate the results of multiple situations. For example to help understand the impact of Down payment and Interest Rate combinations on the resulting Monthly payment.
Scenario Manager
Used to store Last Name
Short Text
Used to store a Zip code
Short Text
What does a Histogram reflect?
Shows the occurrences/distribution of measurements that occur within a given range.
This tool will calculate the values of multiple variables and constraints to generate a desired outcome of a formula. It can also be thought of a as a tool to optimize a scenario.
Solver
When you need to make a decision in Access and/or Excel, using "if" logic is a great option.
True
When you save a file, you should always know where you are putting it.
True
A1 is an example of a relative reference in Excel.
True
A1:B5 is an example of a range in Excel
True
According to the book, a database is simply an ordered collection of records.
True
An IP address identifies a computer across a network, so in other words if you want to communicate with your friends computer, your computer needs to know/find the IP address of your friends computer.
True
Ctrl+' (accent grave) will toggle between formula view and value view
True
Everything is stored in a computer as 1's and 0's
True
If you create a chart based on an Excel Table, you can add new records and the chart will automatically update to show the new data
True
In Banded Rows, every other row in the table is shaded
True
In Excel, you can give a specific cell address a particular name which you can then use in formulas. For example, if cell G2 contains Sales Tax information, you could name cell G2 to be SalesTax and then use it in the formula =B2*SalesTax
True
In working with Excel formulas, it is a good idea to make sure that their results are correct. Validating them can prevent costly mistakes and embarrassments.
True
It is good meeting etiquette to mute your microphone when you are not talking.
True
Microsoft Access provides multiple ways to get data into your database, such as data entry, bringing in data from a flat text file, bringing in data from an Excel file, etc.
True
TCP/IP is a protocol used to exchange information across the internet.
True
The file index.html is the default page that is displayed when accessing a web page.
True
The function key, F4, is used to change between addressing types. For example, changing a relative address to an absolute address.
True
Turning off your video can help when you have a slow internet connection.
True
When determining if numerical data should be classified as a "Number" or as "Text", a good rule to use is "Will I do arithmetic operations on it?" For example, will I want to get a total of these data items or maybe an average of them?
True
Macros
an action or a set of actions that you can run as many times as you want
According to this data, if you preferred to be contacted by telephone as opposed to cell phone or some other method, what job would you likely be in?
blue-collar
