Excel Engineering Function Quiz

Question 1

In technical modeling, why does =BIN2DEC('1111111111') return -1 instead of 1023?

Question 2

Which function identifies the 'Logical Intersection' by matching bit-positions across two integers?

Question 3

To shift a bit-flag 3 positions to the left (effectively multiplying by 2^3), which function is used?

Question 4

When converting Octal '755' (Unix permission) to binary, why is the result '111101101'?

Question 5

Which function act as the 'Coefficient Splitter' to recover ONLY the real (resistive) part of an impedance vector?

Question 6

Calculate the result of =BITXOR(5, 3). (Hint: 101 XOR 011)

Question 7

What happens if you use =HEX2BIN('200') in a technical configuration log?

Question 8

Which complex function correctly identifies the 'Vector Superposition' of multiple series-connected loads?

Question 9

If a maintenance transponder reports Octal 7777777770, what decimal 'Numeric Intercept' does OCT2DEC return?

Question 10

To calculate the 'Residual Error' (Delta) between a sensor reading and a reference vector, use:

Question 11

Excel's Engineering base-converters (like DEC2HEX) are locked to what internal architectural bit-width?

Question 12

Which suffix is the industry standard for electrical engineering impedance strings in Excel?

Question 13

What is the return value of =BITRSHIFT(8, 2)?

Question 14

Which function would you use to assemble a complex phasor from a purely real voltage and an imaginary reactive current?

Question 15

In complex vector math, what is the 'Reactance Isolation' ($X$) coefficient in the string '50+30j'?