Data Manipulation

Question 1

First thing to look for in a data?

Answer 1

How is a data structured
Are there any missing data
Are there errors in the dataset
is the data numeric, text, or both

Question 2

OFFSET(reference,rows,cols,[height],[width])

Answer 2

reference = starting cell
rows = number of rows to count up or down
cols = number of cells to count from left or right
[height] = number of rows to return
[width] = number of columns to return