# Why Professional Certification Might Be Good

# Why Professional Certification Might Be Good

Join the DZone community and get the full member experience.

Join For FreeThe Future of Enterprise Integration: Learn how organizations are re-architecting their integration strategy with data-driven app integration for true digital transformation.

**Strike 1. Counting From Zero**

I then ponited out that the Microsoft doco is weird because the highestnumber allowed by ulong is 18,446,744,073,709,551,615 which ends in an oddsnumber

I remineded him that 2**64 = 18,446,744,073,709,551,616

Apparently, this was the first time anyone realized how counting from zero works. If they had actually thought about this, they could have tried a smaller example. For example three bits. 2**3 = 8. When you enumerate the values you get 0, 1, 2, 3, 4, 5, 6, 7. The highest value is 2**3-1. It's not "weird". It's a trivially obvious mathematical fact.

*n*values have numbers from 0 to

*n*-1. Didn't know that? Consider your certification revoked. Even hobbyists know this.

**Strike 2. Wrong Tools and Wrong Approach**

Then he wanted a spreadsheet of 2 raised to nth power.

I put it together and the numbers just looked weird. I then realized thatwhen you type a number that contains more than 15 digits in a cell,Microsoft Excel changes any digits past the fifteenth place to zeroes

What I felt like saying is that Python has built in this concept of "longintegers" which has unlimited precision and it automatically switches tothem

One of the clods knew Python. Instead of writing a trivial loop in Python, apparently, clod #1 proceeded to type numbers into a spreadsheet. The clod didn't

*compute*them -- with formulas or software -- the clod

*typed*the numbers.

*Typed*. Have Python. Elected to type. How did they do the calculations? On a pocket calculator? Oh the shame.

**Strike 3. Floating Point**

contains more than 15 digits in a cell,Microsoft Excel changes any digits past the fifteenth place to zeroes

This is not "news". The link provided in the email (" Last digits are changed to zeroes when you type long numbers in cells of Excel") indicates a profound lack of understanding.

Make your mark on the industry’s leading annual report. Fill out the State of API Integration 2019 Survey and receive $25 to the Cloud Elements store.

Opinions expressed by DZone contributors are their own.

## {{ parent.title || parent.header.title}}

## {{ parent.tldr }}

## {{ parent.linkDescription }}

{{ parent.urlSource.name }}