MS Excel Status indicators are located on the Horizontal scroll bar Formula bar Vertical scroll bar Standard toolbar Horizontal scroll bar Formula bar Vertical scroll bar Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 Sheet3!A10 Sheet1!A10 Sheet3.A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula Type the equals sign (=) to tell Excel that you’re about to enter a formula Select the cell you want to place the formula into Choose the new command from the file menu Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas is not entered correctly? =10+50 =B7*B1 10+50 =B7+14 =10+50 =B7*B1 10+50 =B7+14 ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Shift key End key Ctrl key Esc key Shift key End key Ctrl key Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK 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 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 Copy the cells in column then choose Paste Special, then click Transpose and OK ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS