This demo test explains how Excel tests work. On the right, you see a spreadsheet that contains a column of 20 integers. You need to answer two sub-questions based on it. Your answers will be evaluated automatically.
You can see that the cell where you must write the formula is highlighted. On all Excel tests on Equip, you'll:
- Look for blue cells. There may be multiple cells across sheets
- Use a formula to write the answer. DO NOT write the answer directly
- Track the countdown timer at the bottom
Click on the "How it works" link above to see these instructions in detail.
Sub-questions
1. In A22, calculate the sum of all the numbers in the column above it.
10 Points
2. In B4, find the largest number in column A up to row number 21.
10 Points