MS Excel Which of the following action removes a sheet from workbook? None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above None of above Select the sheet, then choose Edit > Delete Sheet Select the sheet then choose Format > Sheet > Hide Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Decrease the column width Adjust the row height Shorten the label Increase the column width Decrease the column width Adjust the row height Shorten the label Increase the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Square Divide Goal seek Percentage Square Divide Goal seek Percentage ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is a correct order of precedence in formula calculation? Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction Addition and subtraction, positive and negative values, exponentiation Multiplication and division exponentiation positive and negative values None of the listed here Multiplication and division, positive and negative values, addition and subtraction ANSWER DOWNLOAD EXAMIANS APP
MS Excel If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats From Edit menu choose Delete Double click the Format Painter and then press Esc key in keyboard Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats From Edit menu choose Delete Double click the Format Painter and then press Esc key in keyboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP