MS Excel How can you show or hide the gridlines in Excel Worksheet None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar Both 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
MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction None of the listed here Multiplication and division exponentiation positive and negative values Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel A numeric value can be treated as a label value if it precedes with Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') Hash (#) Ampersand (&) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Max Average Sum Pmt Max Average Sum Pmt ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS