MS Excel A circular reference is A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object A formula that either directly or indirectly depends on itself Geometric modeling tool Always erroneous A cell that points to a drawing object ANSWER DOWNLOAD EXAMIANS APP
MS Excel The command Edit > Fill Across Worksheet is active only when When many sheets are selected When no sheet is selected None of the listed here One sheet is selected When many sheets are selected When no sheet is selected None of the listed here One sheet is selected ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not a basic step in creating a worksheet? Save workbook Modifiy the worksheet Copy the worksheet Enter text and data Save workbook Modifiy the worksheet Copy the worksheet Enter text and data ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste 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 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 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 then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet? Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home Press Alt + Home Press Home Press Shift + Home Press Ctrl + Home ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which chart can be created in Excel ? Pie All of the listed here Line Area Pie All of the listed here Line Area ANSWER DOWNLOAD EXAMIANS APP