Edit Page Last Edit: 4 years ago. Abyssal Ruins is an underwater ruin in North Eastern Unova. It can only be reached by using HM06 - Dive in Undella Bay. The entire ruin is like an underwater maze. Swim around and pick up Relic Items that can be sold to a maniac in Undella Town for a high price. You can also find Plates for Arceus hidden around here.
The GT score is calculated by adding your Word knowledge, Arithmetic Reasoning, and paragraph comprehension subscores. edit: if you still have a sheet that they gave you when you took the ASVAB it should have those scores.
In order to drop the lowest score, you will need to use the MIN function. This function locates the minimum value in a range of scores. EXAMPLE: MIN(D2:H2) will return the smallest value in cells D2 through H2. Use the SUM function to total all the scores in a selected range.Subtract the lowest score using the MIN function. EXAMPLE: =SUM(D2:H2)-MIN(D2:H2). NOTE: This formula calculates the total of scores in cells D2 through H2, subtracts the lowest value in the range, and displays the result in the cell.XAMPLE: SMALL(D2:H2,2) will return the 2nd smallest value in the range. In the row you want to calculate scores for, use the SUM function to total all the scores in the row. EXAMPLE: =SUM(D2:H2). NOTE: This formula calculates the total of all scores in cells D2 through H2 and displays this result in the cell.