MS Excel MS Excel provides the default value for step in fill Series dialog box O 1 10 5 O 1 10 5 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel edits cell references in the newly copied formula Excel adjusts absolute cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods cannot be used to enter data in a cell Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key Pressing the Tab key Pressing an arrow key Clicking on the formula bar Pressing the Esc key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Cell names Column numbers and row letters Column latters and row numbers Cell locator coordinates Cell names Column numbers and row letters Column latters and row numbers Cell locator coordinates ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet You can set the column width automatically fit the amount of text Sheet tabs can be colored The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet 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 From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Clear and then Formats ANSWER DOWNLOAD EXAMIANS APP