4. Question 4 What is the correct formula structure for completing a vLookup? 1 point =VLOOKUP (table_array,lookup_value,col_index_num, [range_lookup]) =VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) =VLOOKUP (table_array, col_index_num, table_array,…
3. Question 3 True or False HLookup is similar to VLookup – only it allows you to search for data horizontally. 1 point True False
2. Question 2 Jerry is working with a set of data using the VLookup function. He continues to receive an error message because the data he is trying to look-up…
1. Question 1 After you have completed the Week 1 project, select the formula that displays in cell M33 in the sheet “Question.” This will verify that you successfully completed…
1. Question 1 True or False The subtotal function has the ability to perform mathematical functions such as: sum, average, count, product, min, max and more 1 / 1 point True …
3. Question 3 You receive a set of data from a client which contains a lists of names, sales amounts, locations and other information. What function will you use to…
1. Question 1 You have an Excel workbook that contains many different formulas. You want to copy the values, but not the formulas into another tab. What functionality would you…
2. Question 2 The formula A$1 does which of the following? 1 / 1 point Anchors the formula to the selected cell Anchors the formula to the selected row Anchors…
3. Question 3 What button allows you to insert a formula step-by-step through the Excel user interface? 1 / 1 point Correct. The fx allows you to insert a formula…
4. Question 4 You have received an Excel spreadsheet from a client and you are unsure of where the contents of a cell came from. What should you do? 1 / 1 point…
