Which sign or symbol will you use to lock cells for absolute cell reference? A.
ampersand
B.
asterisk
C.
dollar sign
D.
exclamation mark

Option C. dollar sign is the correct answer

Explanation:

There are two types of referencing styles used in MS excel.

Relative and absolute.

Out of these two, absolute referencing is used where we don't want the cell addresses to change when the formula with cell reference is copied. Dollar sign is with the row and column number to write an absolute cell reference.

An absolute cell reference for cell C5 is written as:

$C$5

Hence,

Option C. dollar sign is the correct answer

i would first let him be aware that a cover letter is official and confidential and it requires a proper formatting so that the employer doesn't have hard time when going through it. he should write it in paragraphs of about two to four sentences and use proper grammar a , spelling and proper punctuation. i will also advice him not to be emotional and not also to use images.then base his attention to the details of the job described and not other things. that is he be specific to the responsibilities and to the employers requirements. on this he should make sure that the letter reflects how good he is for the requirements detailed by the employer

the letter should not be too long nor too short.