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…
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…
1. Question 1 In the image below, which number is next to the arrow that points to the formula bar? 1 / 1 point 1 2 3 …
