MS Excel Which of the following is not a worksheet design criterion? Clarity Aditibility Efficiency Description Clarity Aditibility Efficiency Description ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you first: Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula Choose the new command from the file menu Select the cell you want to place the formula into Type the equals sign (=) to tell Excel that you’re about to enter a formula Enter the formula using any input values and the appropriate mathematical operators that make up your formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel edits cell references in the newly copied formula Excel erases the original copy of the formula ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Chart wizard term data categories refers to; A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data A chart plot area The organization of individual values with a chart’s data series A horizontal axis The data range that supply chart data 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 Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box 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 select the Centered alignment From Format Cells dialog box click on Merge Cells check box ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu Select the cells that contain number between 0 and 100 then click Red color on Text Color tool All of above ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS