MS Excel Text formulas: Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value Concatenate and manipulate text Replace cell references Return ASCII values of characters Show formula error value ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Insert > Find from the menu Select Tools > Finder 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 Insert > Find from the menu Select Tools > Finder from the menu Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel A worksheet can have a maximum of ________ number of rows. 256 65535 1024 1048576 256 65535 1024 1048576 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 Sheet1!A10 Sheet3!A10 A10 Sheet3.A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you update the values of formula cells if Auto Calculate mode of Excel is disabled ? F8 F11 F9 F10 F8 F11 F9 F10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel The shortcut key Ctrl + R is used in Excel to None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell None of above Fill the selection with active cells to the right Remove the cell contents of selected cells Right align the content of cell ANSWER DOWNLOAD EXAMIANS APP