MS Excel To create a formula, you first: Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Select the cell you want to place the formula into Choose the new command from the file menu Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Name box on to the left of formula bar None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on None of the listed here Shows the name of worksheet currently working on Shows the name of workbook currently working on Shows the name of cell or range currently working on ANSWER DOWNLOAD EXAMIANS APP
MS Excel Ctrl+ D shortcut key in Excel will None of the listed here Apply double underline for the active cell Open the font dialog box Fill down in the selection None of the listed here Apply double underline for the active cell Open the font dialog box Fill down in the selection ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? Visual C++ C Java Visual Basic Visual C++ C Java Visual Basic ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the cell pointer indicates you that you can make selection? Mouse Pointer with anchor at the tip None of above Doctor’s symbol (Big Plus) Small thin plus icon Mouse Pointer with anchor at the tip None of above Doctor’s symbol (Big Plus) Small thin plus icon ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS