MS Excel How many worksheets can a workbook have? 8 none of above 3 255 8 none of above 3 255 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Rounding errors can occur When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation When you show the results of formulas with different decimal places that the calculated results When you use addition and subtraction in a formula When you use multiplication, division, or exponentiation in a formula Because excel uses hidden decimal places in computation ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Max Pmt Average Sum Max Pmt Average ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Click the Delete button on the Standard toolbar Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Select Data > Delete Record from the menu Click the Delete button on the Standard toolbar Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Select Data > Delete Record from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a valid data type in Excel ? Number Date/Time Label Character Number Date/Time Label Character 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