Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It is widely used and has become the industry standard for spreadsheets.
A common task in Microsoft Excel is data manipulation across large tables of data. Here is an example of that task. Process the two EXCEL formulas below the table to find the final coordinates for this cache.
|
A |
B |
C |
D |
| 1 |
HBN |
CRL |
BWT |
JUV |
| 2 |
6559 |
64 |
93 |
18 |
| 3 |
117 |
81 |
30 |
603 |
| 4 |
376 |
332 |
175 |
4138 |
| 5 |
7439 |
4 |
657 |
872 |
CONCATENATE(MID(A1,3,1),LEFT(A4,2)," ",RIGHT(D3,2),".",B4)
CONCATENATE(MID(C1,2,1),C2," ",MID(D4,2,2),".",RIGHT(A2,3))
You can validate your puzzle solution with certitude.