MS Excel Getting data from a cell located in a different sheet is called ___ Updating Accessing Referencing Functioning Updating Accessing Referencing Functioning ANSWER DOWNLOAD EXAMIANS APP
MS Excel To remove the content of selected cells you must issue ___ command Delete Clear All Clear Delete Clear Contents Delete Clear All Clear Delete Clear Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which language is used to create macros in Excel? C Java Visual C++ Visual Basic C Java Visual C++ Visual Basic 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? From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box Click on Merge and Center tool on formatting toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value The resulting values of a formula instead of the actual formula Formatting options Cell comments Multiply the selection by a copied value ANSWER DOWNLOAD EXAMIANS APP
MS Excel What does COUNTA () function do? Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number Counts cells having alphabets Counts non-empty cells Counts empty cells Counts cells having number ANSWER DOWNLOAD EXAMIANS APP