I assume you mean phenotypically? If so, it would be a silent point mutation. In this, a single nucleotide is replaced by another but, the sequence will still code for the same amino acid, and as such the protein will not change.
Genotypically, it could be one of several types of mutations. It could be a missense point mutation, or a nonsense point mutation. In addition, it could be a deletion or insertion. Any of these can cause the cells to develop into oncogenes, in which the cells ability to know when to stop dividing ceases; which is in itself, cancer.
All cancer mutations are visible at some point, though it can take many years for it to become visible, so I would assume that not all cancer mutations are visible initially but, will become visible eventually.
As for cancer screening, there are many tests out there to test for many different types of cancer. If this is something concerning you, you'd best see your doctor or a specialist.