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