MS Excel The auto calculate feature Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet A and C ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates that you can fill series ? Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) Small thin plus icon None of the listed here Mouse pointer with anchor at the tip Doctor's symbol (Big Plus) Small thin plus icon None of the listed here ANSWER DOWNLOAD EXAMIANS APP
MS Excel A typical worksheet has ___ number of columns. 256 16384 1024 128 256 16384 1024 128 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 Tools > Finder from the menu Click the Find button on the standard toolbar Select Insert > Find from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Select Tools > Finder from the menu Click the Find button on the standard toolbar Select Insert > Find from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.8 6.8 5430 5436.80 5436.8 6.8 5430 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above ANSWER DOWNLOAD EXAMIANS APP