MS Excel Which of the following is not a valid data type in Excel ? Number Character Label Date/Time Number Character Label Date/Time ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can enter which types of data into worksheet cells? Formulas only Labels, values, and formulas Values and formulas but not labels Labels and values but not formulas Formulas only Labels, values, and formulas Values and formulas but not labels Labels and values but not formulas ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste Special allows some operation while you paste to new cell. Which of the following operation is valid? Goal seek Percentage Square Divide Goal seek Percentage Square Divide ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; The organization of individual values with a chart’s data series The data range that supply chart data A horizontal axis A chart plot area The organization of individual values with a chart’s data series The data range that supply chart data A horizontal axis A chart plot area ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above Double CAL indicator on status bar Both of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button None of above ANSWER DOWNLOAD EXAMIANS APP