Basically the compiler is a program that processes commands written in a specific programming language and "translates" it into the machine language or "code" that the processor uses, converting the source code into an executable program.
When executed, the compiler first parses all language instructions syntactically one after the other and then, in one or more successive steps or “passages”, constructs the exit code, making sure that the instructions refer to other instructions are referenced correctly in the final code. Traditionally, the output of the compilation has been called an object code or sometimes an object module. The object is machine code that the processor can execute, one instruction at a time.
In excel "autofill" is used to fill data in cells, which follows the pattern or logic applied in other cells. To apply same calculation of A20 in B20 to H20, we use autofill technique. Instead of copy pasting, or manually entering the complex formula this method is more suitable.