MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 5436.80 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Click the Delete button on the Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 =SUM(Sales)-A3 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(A1:A5)-10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can activate a cell by Pressing the Tab key Pressing an arrow key All of these Clicking the cell Pressing the Tab key Pressing an arrow key All of these Clicking the cell ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data Create and edit formula containing functions Copy a range of cells Format cells containing numbers Enter assumptions data ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS