MS Excel Which of the following is an absolute cell reference? A1 #a#1 !A!1 $A$1 A1 #a#1 !A!1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Shorten the label Increase the column width Decrease the column width Adjust the row height Shorten the label Increase the column width Decrease the column width Adjust the row height ANSWER DOWNLOAD EXAMIANS APP
MS Excel To return the remainder after a number is divided by a divisor in EXCEL we use the function? Div ( ) ROUND ( ) MOD ( ) FACT ( ) Div ( ) ROUND ( ) MOD ( ) FACT ( ) ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) Hash (#) Apostrophe (') Exclamation (!) Ampersand (&) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F8 F10 F11 F9 F8 F10 F11 F9 ANSWER DOWNLOAD EXAMIANS APP
MS Excel We can save and protect the workbook by Write Reservation Password Any of the above Protection Password Read-only Recommended Write Reservation Password Any of the above Protection Password Read-only Recommended ANSWER DOWNLOAD EXAMIANS APP