MS Excel Which of the following is an absolute cell reference? !A!1 A1 #a#1 $A$1 !A!1 A1 #a#1 $A$1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following options is not located in the page setup dialog box ? Headers and Footers Page Orientation Margins Page Break Preview Headers and Footers Page Orientation Margins Page Break Preview ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? All of the listed here Scenarios Objects Contents All of the listed here Scenarios Objects Contents ANSWER DOWNLOAD EXAMIANS APP
MS Excel Documentation should include Source of input data Destination and users of the output data Information on the purpose of the workbook All of these Source of input data Destination and users of the output data Information on the purpose of the workbook All of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which command will you choose to convert a column of data into row? None of above Both of above Cut and Paste Paste Special > Transpose None of above Both of above Cut and Paste Paste Special > Transpose 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 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 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS