MS Excel A circular reference is A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous A formula that either directly or indirectly depends on itself Geometric modeling tool A cell that points to a drawing object Always erroneous ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you insert an excel file into a word document. The data are Linked Embedded Hyperlinked placed in a word table Use the word menu bar and toolbars Linked Embedded Hyperlinked placed in a word table Use the word menu bar and toolbars ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The cells selected are marked for cutting The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
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