Transform Trivia

Excel

100

How does an XLOOKUP work?

It searches a category base on the premise given.  Similar to Vlookup, but with greater flexibility

200

What is a Macro?

A VBA based automation which performs a repeatable process by recording your clicks.

300

Name an advantage of using Tables

Formula names

Auto-spilling

Data grouping

Table Names

Special formatting

400

Where can you change your Pivot Table defaults?

Excel Options: Data

500

What is a #SPILL error?

When a formula answer occupies >1 cell but is blocked by data outside of the spill range.

Alteryx

100

What is the purpose of Alteryx?

A powerful data analytics platform that allows users to quickly and easily analyze, visualize, and transform data. It's designed to be a drag-and-drop interface, making it accessible to both technical and non-technical users.

200

What is a workflow?

A series of steps that guide the data through a specific analytical process.

300

What is the difference between an input and an output anchor?

Input = Source data

Output = 

400

What tool is used to join two data sets?

Join (Merge in Power Query)

500

Name at least 4 file formats that are compatible with Alteryx

.XLSX

.CSV

.TXT

.JSON

.XML

SmartView

100

What is SmartView?

It allows us to integrate data directly from a data source (Oracle) directly into Microsoft products (Excel).

200

What button allows you to update the source data in Excel?

Refresh

300

What is the purpose of a Bottom Level function?

Retrieves data for the lowest level of members in a dimension

400

True or False: In SmartView, you may have multiple shared connections?

False

500

What does POV stand for in SmartView?

Point of View.  The POV represents members from each of the applications;  the retrieve is generated for POV members.

Shortcuts

100

CTRL + X

Cut

200

CTRL + SHIFT + V

Paste Special

300

F4

Lock cell reference

400

CTRL + SPACEBAR

Selects column

500

CTRL + [

Snap to cell reference

Data Decoder

100

Madison needs to flip one of his criteria columns into a header row for a summary report?  How could this be done?

Pivot Table

200

Eissah is trying to refresh data from Oracle in his Excel workbook.  Which tool is best for Eissah to use on a monthly basis?

SmartView

300

Every month Kurtis gets a data report that he manually updates for the team.  What tool can be used to automate this?

Alteryx/PowerQuery

400

In the below formula, what does the 'Sales' stand for?

=TriviaQs[@Sales]

Column Header in table name 'TRIVAQS'

500

Arden is making a list of all the squirrels she's encountered each month.  Which function can be used to combine this into a single list for the year?

Power Query: Append

Alteryx: Join