MS Excel By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one? Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above Click on Sheet 3 and from Edit menu choose Delete None of above Right click on Sheet Tab of third sheet and choose Delete from the context menu Both of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which menu option can be used to split windows into two ? Review > window View > split View > window > split Window > split Review > window View > split View > window > split Window > split 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 Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete Click on Remove Formatting tool on Standard Toolbar From Edit menu choose Clear and then Formats Double click the Format Painter and then press Esc key in keyboard From Edit menu choose Delete ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Both 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 ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you copy a formula Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references Excel erases the original copy of the formula Excel adjusts absolute cell references Excel edits cell references in the newly copied formula Excel doesn’t adjust relative cell references ANSWER DOWNLOAD EXAMIANS APP
MS Excel To create a formula, you can use: Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time Values but not cell references Value and cell references Cell references but not values Values or cell references although not both at the same time ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS