Data

Question 1

Text to column

Answer 1

Under the data tab. You select 1. delimited: characters such as commas or tabs separate each field
Or
Fixed width: fields are aligned in columns with spaces between each field

2. Specify what the delimiter character is.
3. Formatting and destination

Question 2

Split a fixed width

Answer 2

Serial numbers with fixed width
Data: text to columns
Fixed
Specify the column break
3 format or destination

Question 3

Control e

Answer 3

Shortcut for flash fill

Question 4

How to clean up case and spaces quickly

Answer 4

Flash fill
It runs on iterations

Question 5

Goal seek

Answer 5

What if analysis tool
See how a hypothetical value change affects a formula.

Question 6

Rich data types

Answer 6

Locations with stored data and frickin stocks

Question 7

Pivot table

Answer 7

Table to easily compare and analyze. Pivot bc you can easily change columns.

Question 8

Plus signs

Answer 8

Shows hidden

Question 9

Prep for pivot

Answer 9

Ungroup (data)
Remove filters (data. Clear filter)
Consistent data types within each row or column
Clear meaningful columns
No blank rows or columns

Question 10

When does excels date code start

Answer 10

Jan 1st 1900 = 1
The new before Christ bc, ad

Question 11

How to find empty cells

Answer 11

Find and select. Special. Blanks

Question 12

What 2 tabs show up when you create a pivot table

Answer 12

Analyze and design

Question 13

How do you create relationships

Answer 13

After creating a table, select relationship under analyze

Question 14

What is the benefit of using tables

Answer 14

You can select data on different sheets…look into this more

Question 15

How do you change the field values

Answer 15

Right click cell in pivot table
Select value field settings
Show values as
Percentages runn8ng totals rankings

Question 16

Div error

Answer 16

Divide by 0 or an empty cell

Question 17

error

Answer 17

This is a parsing error. Formula can’t be interpreted as written

Question 18

na

Answer 18

Data can’t be found in the spreadsheet or data doesn’t exist. ( like in look up)

Question 19

name

Answer 19

Formula is not recognized

Question 20

num

Answer 20

Data doesn’t make sense for that calculation

Question 21

value

Answer 21

General error, like a name in the start date

Question 22

ref

Answer 22

Referenced cells have been deleted

Question 23

Countif()

Answer 23

Countif(range,”criterion”)

Question 24

Countif()

Answer 24

Countif(range,”criterion”)

Question 25

Convert syntax

Answer 25

Convert(values, current metric, return metric)

Question 26

Convert syntax

Answer 26

Convert(values, current metric, return metric)

Question 27

Reject invalid inputs

Answer 27

Highlights invalid entries so formulas still work.