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