True or False HLookup is similar to VLookup – only it allows you to search for data horizontally.
3. Question 3 True or False HLookup is similar to VLookup – only it allows you to search for data horizontally. 1 point True False
-
-
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 does not exist. Which function should Jerry use to get around the message?
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…
-
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 the project.
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…
-
True or False The subtotal function has the ability to perform mathematical functions such as: sum, average, count, product, min, max and more
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 …
-
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 assign an alias to each group of data?
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…
-
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 use to do this?
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…
-
The formula A$1 does which of the following?
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…
-
What button allows you to insert a formula step-by-step through the Excel user interface?
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 Go to the cell and click Formulas > Trace Precedents Go to the cell and click Formulas > Evaluate Formula Go to the cell and click Formulas > Show Formula Go to the cell and click Formulas > Remove Arrows Correct Correct. You would go to the cell, click Formulas and then click Trace Precedents to find out where the contents of that cell came from.
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…
-
The Excel screen is designed to allow for easy access to the key features of the program. You can click through the ribbon or use what key on your keyboard to toggle between different tabs on the ribbon and different buttons on each tab?
2. Question 2 The Excel screen is designed to allow for easy access to the key features of the program. You can click through the ribbon or use what key…