MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? Sheet tabs can be colored You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically Sheet tabs can be colored You can set the column width automatically fit the amount of text Some picture can be applied as a background of a sheet The width of a row and be specified manually or fit automatically ANSWER DOWNLOAD EXAMIANS APP
MS Excel What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? 5436.80 5430 6.8 5436.8 5436.80 5430 6.8 5436.8 ANSWER DOWNLOAD EXAMIANS APP
MS Excel You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? Fill across worksheet Custom List Fill series Auto fill options Fill across worksheet Custom List Fill series Auto fill options 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 Delete Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Delete Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP
MS Excel The active cell: It is the formula bar Is defined by a bold border around the cell Only A and B Receives the data the user enters It is the formula bar Is defined by a bold border around the cell Only A and B Receives the data the user enters ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS