Which function gives me the correlation between two arrays of data?

		Covariance.s
		Correlation.s
		Correl.s
		Correl

Assume you have the loop in VBA below, When i = 3, what does x =?

X = 1

For i = 1 to 3

X = x + i

Next i

		1
		2
		7
		4

Imagine you have the following table: Values Characters 1 - 1 A 2 2 - 1 B 3 0 4 1 D 5 2 E 6 2 F 7 5 G If I do a custom sort like shown below, what will be the character in the 2nd row? Sort 1 Add Level Delete Level E Copy Level Options... My data has headers Sort On Order Column Sort by Values Then by characters Values Smallest to Largest Values Z to A OK Cancel B D OOO A In the following income statement worksheet, which cell has an error? A B 1 2016 2 Sales 3,850.00 3 Cost of Goods Sold 3,250.00 4 Gross Profit =B2-B3 5 Selling and G&A Expenses 330.30 6 Fixed Expenses 100.00 7 Depreciation Expense 20.00 8 EBIT =B4-SUM(B4:B7) 9 Interest Expense 76.00 10 Earnings Before Taxes =B8-B9 11 Taxes 29.48 12 Net Income =B10-B11 B4 B8 B10 B12 None Imagine you have the following table: Values Characters 1 - 1 A 2 2 - 1 B 3 0 4 1 D 5 2 E 6 2 F 7 5 G If I do a custom sort like shown below, what will be the character in the 2nd row? Sort 1 Add Level Delete Level E Copy Level Options... My data has headers Sort On Order Column Sort by Values Then by characters Values Smallest to Largest Values Z to A OK Cancel B D OOO A In the following income statement worksheet, which cell has an error? A B 1 2016 2 Sales 3,850.00 3 Cost of Goods Sold 3,250.00 4 Gross Profit =B2-B3 5 Selling and G&A Expenses 330.30 6 Fixed Expenses 100.00 7 Depreciation Expense 20.00 8 EBIT =B4-SUM(B4:B7) 9 Interest Expense 76.00 10 Earnings Before Taxes =B8-B9 11 Taxes 29.48 12 Net Income =B10-B11 B4 B8 B10 B12 None