MS Excel A ________ is a grid with labeled columns and rows. Worksheet Dialog box Toolbar Clipboard Worksheet Dialog box Toolbar Clipboard 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 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 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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click 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 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 Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel To copy cell contents using drag and drop press the Shift key Esc key End key Ctrl key Shift key Esc key End key Ctrl key ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can use the formula palette to Format cells containing numbers Enter assumptions data Copy a range of cells Create and edit formula containing functions Format cells containing numbers Enter assumptions data Copy a range of cells Create and edit formula containing functions ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS