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 select the Centered alignment 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 choose Merge and Center check box From Format Cells dialog box select the Centered alignment 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 choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink The word document contains a copy of the actual data The word document cannot be edit The word document contains a reference to the original source application The word document must contain a hyperlink ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options Cell comments The resulting values of a formula instead of the actual formula Multiply the selection by a copied value Formatting options ANSWER DOWNLOAD EXAMIANS APP
MS Excel The chart wizard term data series refers to A data label A collection of chart data markers A chart legend A set of values you plot in a chart A data label A collection of chart data markers A chart legend A set of values you plot in a chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can delete any condition from Conditional Formatting dialog box if it is not requried You can add more than one condition to check You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Both of above Double CAL indicator on status bar Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS