MS Excel A numeric value can be treated as a label value if it precedes with Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Select Insert > Find from the menu Click the Find button on the standard toolbar Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you remove borders applied in cells ? Both None Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) Both None Choose None on Border tab of Format cells Open the list on Border tool in Format Cell toolbar then choose first tool (none)) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scroll buttons are place on Excel screen Towards the top left corner Towards the bottom right corner Towards the bottom left corner Towards the top right corner Towards the top left corner Towards the bottom right corner Towards the bottom left corner Towards the top right corner ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 1024 128 16384 256 1024 128 16384 256 ANSWER DOWNLOAD EXAMIANS APP