MS Excel Which of the following is not a basic step in creating a worksheet? Modifiy the worksheet Copy the worksheet Save workbook Enter text and data Modifiy the worksheet Copy the worksheet Save workbook Enter text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a way to complete a cell entry? Pressing spacebar Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard Pressing spacebar Pressing enter Clicking the Enter button on the Formula bar Pressing any arrow key on the keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Values and formulas but not labels Labels and values but not formulas Labels, values, and formulas Formulas only Values and formulas but not labels Labels and values but not formulas Labels, values, and formulas Formulas only ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which key do you press to check spelling? F3 F5 F7 F9 F3 F5 F7 F9 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
MS Excel The active cell: Receives the data the user enters Only A and B It is the formula bar Is defined by a bold border around the cell Receives the data the user enters Only A and B It is the formula bar Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP