MS Excel Which of the following is an absolute cell reference? $A$1 #a#1 !A!1 A1 $A$1 #a#1 !A!1 A1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Insert handle Border Fill handle Copy handle Insert handle Border Fill handle Copy handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as label value if ___ precedes it. Tilde (~) Hash (#) Exclamation (!) Apostrophe (') Tilde (~) Hash (#) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 5430 ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: Press the Erase key Press the Edit Formula button Press the Enter button Press Esc Press the Erase key Press the Edit Formula button Press the Enter button Press Esc ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS