MS Excel Which elements of a worksheet can be protected from accidental modification? Contents All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios ANSWER DOWNLOAD EXAMIANS APP
MS Excel The name box Appears below the status bar Shows the location of the previously active cell Appears below the menu bar Appears to the left of the formula bar Appears below the status bar Shows the location of the previously active cell Appears below the menu bar Appears to the left of the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red Apply Conditional Formatting command on Format menu All of above Select the cells that contain number between 0 and 100 then click Red color on Text Color tool Use =if() function to format the required numbers red ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Sound Recorder Calculator Media player Macro Recorder Sound Recorder Calculator Media player Macro Recorder 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 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Hold down the shift key as you click anywhere in the column Select Edit > Select > Column from the menu Hold down the Ctrl key as you click anywhere in the column Click the column heading letter Hold down the shift key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP