ACCT Analytics Final

Number

-1234.00

The result of =FIND(ʺisʺ, ʺMississippiʺ,3) is ________.

5

AND, OR, and NOT are examples of Excel ________ functions

Conjunction

A ________ chart is very common as a statistical tool depicting the correlation between the two variables.

Scatter

What is the error message when you attempt to use a cell that has been deleted as a function argument?

#REF!

Currency

($1,234.00)

Comma

(1,234.00)

Exploratory data visualization

- Allows the audience to explore data for further analyses - Is conducted for a problem that has not been clearly defined Exploratory visualization is what we do to understand the data, e.g., to develop and assess a hypothesis or question or find a pattern in the data

General

-1234

Accounting

$(1,234.00)

The _____ function returns the current system date

Date

References that address data across multiple worksheets are called ________ references.

3-D

The correct syntax for the SUMIF function is ________.

=SUMIF(range, criteria, [sum_range])

What is alteryx

A graphical, workflow-based tool designed to empower business users in the evolving world of data everywhere. A tool that allows users to: - blend, manipulate and report on data quickly and easily - in a repeatable drag-and-drop workflow - without needing any special tools or programming skills

Data visualization

A visualization is a means of communicating data, primarily through imagery, that is both readable and recognizable.

Data Automation

Alteryx Trifacta ClearStory Data Dataiku Datameer Informatica And many more

The inputs used by an Excel function to calculate a result are called ________.

Arguments

qualitative (categorical) data

Arizona, New York, Texas Sarah, John, Maria Coors, Bud Light, Stella Artois

Robotics

Automation Anywhere Blue Prism Openspan UiPath

Returns a mean from a specified range of cells

Average

FV

Balance amount after last payment

A(n) ________ chart is similar to a column chart except the data is horizontal instead of vertical.

Bar

Data Visualizations

Business Objects (SAP) Tableau Qlik Power BI (Microsoft) SPSS (IBM) Oracle Data Visualization

If you want to see how many cells in a specified range contain numbers, you would use the ________ function

COUNT

The ________ function allows for multiple criteria in multiple ranges to be evaluated and counted

COUNTIFS

The intersection of a row and column is called a ________.

Cell

A(n) ________ chart displays two different types of data by using multiple chart types in a single chart object

Combination

Returns the number of cells in a range of cells that contain numeric data

Count

The ________ command produces multiple named ranges at one time from the headings in rows, columns, or both from the data set.

Create from Selection

If you want to find the time between two dates, you would use the ________ function.

DATEDIF

Why visualize?

Data visualization is not a personal preference, to be done "just in case some people are more visual." It is a necessity! The first step in understanding your data should always be to examine it visually. Visualization can play a critical role in helping you figure out what the interesting questions are. Remember the picture superiority effect: pictures are retained at much higher rates than words. A good visualization reduces the time to insight

To modify a named range, you select its name in the Name Box, then click Name Manager in the ________ tab.

Defined Names group on the Formulas

A character such as a tab or comma that separates fields

Delimiter

Pie charts

Don't use!! tempting because everyone understands what they are meant to convey (the various parts of a whole), but it is much harder to compare slices of a pie than it is to compare length or height (especially when slices become very thin)

Which of the following is NOT an Excel function category?

Educational

Tufte's principles

Edward Tufte is an American statistician and professor emeritus of political science, statistics and computer science at Yale University. He is known as a pioneer in the field of data visualization and has written four books about information design. Tufte's principles highlight that "excellence in statistical graphics consists of complex ideas communicated with clarity, precision and efficiency.

Explanatory data visualization

Explains what the audience needs to know Shows specific relationships in data, such as link between causes and results

Instead of typing the $ symbol in a cell reference, you can use the ________ keyboard shortcut

F4

Using color in visualizations

FACT: approximately 8% of men worldwide are color blind. Avoid red/green palettes! Blue/orange is a good alternative. For continuous data, color ramps are effective. For discrete data, always try to limit colors (under 5 is ideal).

An attribute

Field

Indicates the maximum length of an attribute

Field size

_____ is/are used to verify the correct value is entered in a field and prevents the user from leaving the current field until the problem is fixed.

Field validation rules

An example of a ________ is SUM(A1:A10).

Function

By using the _____ clause, you can combine records with identical values in a specified field list into a single record.

GROUP BY

Qualitative (ordinal) data

Gold, silver, bronze Excellent health, good health, poor health Love it, like it, hate it

The ________ function is used when the lookup_value argument checks the top row of the table_array.

HLOOKUP

Defines a consistent template

Input mask

A(n) ________ appears when a user makes a validated cell active and prompts a user before data is entered with information about data constraints.

Input message

Rate

Interest rate

A ________ chart is used to communicate trends over time.

Line

Which of the following is NOT an area in the Fields areas?

List

PV

Loan amount

The ________ function looks for a value within a range and returns the position of that value within the range.

MATCH

If you want to see which employee had the highest sale, you could use the ________ function.

MAX

Which of the following functions returns the number in the middle of a set of numbers?

MEDIAN

Examines all numeric values in a specified range and returns the highest value

Max

Examines all numeric values in a specified range and returns the lowest value

Min

The ________ function can be used to identify the principal portion for a mortgage payment

PPMT

A unique identifier

Primary key

In a database, a(n) _____ is a field that uniquely identifies a record.

Primary key

A(n) _____ is a link between tables.

Relationship

Which of the following is NOT an example of a statistical function?

SUMIF

Access adds _____ around field names to denote that the data will come from an existing field.

Square brackets

Calculated fields can be used in other expressions within your query by enclosing the calculated field name in _____.

Square brackets

Adds of all numeric information in a specified range, list of numbers, list of cells, or any combination

Sum

In a database, data is stored in a _____.

Table

An input mask sets specific _____ and provides punctuation, so it does not have to typed manually

Template

If you enter a date or time that is not recognized, Excel treats the information as ________ and left-aligns it in the cell.

Text

Altyrx environment - canvas

The Canvas is an infinite workspace where you can use any combination of tools to achieve your data cleansing and blending goals. Use Comments and Tool Containers to help keep your Canvas organized.

Altyrx environment - configuration

The Configuration panel, activated after selecting a tool, will allow you to set all parameters related to a tool.

Altyrx environment - results

The Results panel, activated after running a workflow, will show data flowing into a control and out of a control. It will also show messages related to the control or the entire workflow.

Altyrx environment - tool bar

The Tool Bar contains all of the Alteryx Tools and Macros available to use to build a workflow. Tools are organized by category, common tools found in the Favorites category. Drag & Drop a tool onto the Canvas to begin.

Type

This argument is optional

Which of the following is NOT true about working with formulas?

To copy a formula and not change relative references, select the formula in the formula bar, click Shift + Esc, select the destination cell, and then click Insert.

Nper

Total number of payments

Tufte's principle: data-to-ink ratio

Tufte believes you should show the data and essentially maximize the data-to-ink ratio. This essentially means you should remove all non-data ink and redundant data ink, often referred to as chart junk. The idea here is that less can be more.

Data ________ increases the probability of correct data entry on an Excel worksheet.

Validation

The _____ clause allows you to limit the results of your query by specifying criteria that field values must meet without using the field to group the data mathematically

WHERE

Quantitative

Weight (10 lbs, 20 lbs, 5000 lbs) Cost ($0, $100, $.05) Discount (5%, 10%, 12.8%)

Review Capabilities

ability to break-down and review advanced processes and data manipulation

Diagnostics & Variance

ability to run complex diagnostics against data sources and highlight variances

Standardization

all professional are relying on same model vs disparate workbooks that are difficult to maintain

Systematic Processing

benefits performance of advanced data management and calculation routines without manual intervention

The third argument of the VLOOKUP function is ________.

col_index_number

Analytics

combines data from variety of disparate sources and stages for advanced analytics

connections

controls the flow of data from one tool to the next

Types of data visualization

exploratory and explanatory

anchors

input and/or output of a tool

To select noncontiguous rows, click the header of the first row, ________ the header of each additional row

press and hold Ctrl, and click

Types of data

quantitative data & qualitative data

tool

step in the process

Workflow components

tool, anchors, connections