About this document

MS Excel Interview Q&A Guide by Rinsha Aisha is a document available to read on EtoBox.

=WEEKDAY(DATE(2023,1,15)) Returns: 2 (Monday is the 2nd day of the week) 37) What is the difference between absolute and relative cell references? Absolute cell references ($A$1) will always refer to that cell even if the formula is copied to another cell. Relative references (A1) will change the cell reference as the formula is copied. 38) How can you insert a comment in a cell in Excel? To insert a comment in a cell, select the cell and go to the Review tab. Click on New Comment and type the comment.

Author

Rinsha Aisha

Language

EN