MS Excel In the formula, which symbol specifies the fixed columns or rows ? * $ & % * $ & % ANSWER DOWNLOAD EXAMIANS APP
MS Excel Concatenation of text can be done using Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') Ampersand (&) Hash (#) Exclamation (!) Apostrophe (') ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following option is not available in paste Special dialog box ? SQRT Divide Add Subtract SQRT Divide Add Subtract ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a label is too long to fit within a worksheet cell, you typically must Adjust the row height Increase the column width Shorten the label Decrease the column width Adjust the row height Increase the column width Shorten the label Decrease the column width ANSWER DOWNLOAD EXAMIANS APP
MS Excel Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above Double CAL indicator on status bar None of above Go to File > Options > Formulas > Calculation Option - and mark the corresponding radio button Both of above ANSWER DOWNLOAD EXAMIANS APP