MS Excel Which of the following is not a valid data type in Excel ? Number Date/Time Character Label Number Date/Time Character Label ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu All of the listed here Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Standard Tool Bar Title Bar Menu Bar Formula Bar Standard Tool Bar Title Bar Menu Bar Formula Bar 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 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 in row, select the same number of cells in row and paste 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 column then choose Paste Special, then click Transpose and OK Copy the cells in row, select the same number of cells in row and paste ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Average Pmt Max Sum Average Pmt Max Sum ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell Only A and B It is the formula bar Receives the data the user enters Is defined by a bold border around the cell ANSWER DOWNLOAD EXAMIANS APP