Thanks for replying.

When I try to remove the /sqrt(size), it gives an actual answer of .805.

I also tried to compute the test statistic first and use the norm.s.dist (z,cumulative) and the answer excel gives is also 1.
I'm not sure if there's something with excel or what