When a range is formatted as a table it automatically has

nested functions that do not display the formulas

un$-$nested functions that display the $!$ symbol

all blank entries set to $1$

nested functions that display the formulas

filters

all text entries displayed with subtotal

predefined column and row names

all text becomes wrapped text

un$-$nested function that don't display formulas

all entries set to $0$