MS Excel To copy cell contents using drag and drop press the Ctrl key Esc key Shift key End key Ctrl key Esc key Shift key End key ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is invalid statement? The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text The width of a row and be specified manually or fit automatically Some picture can be applied as a background of a sheet Sheet tabs can be colored You can set the column width automatically fit the amount of text ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Delete the column from the worksheet Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Select Data > Delete Record from the menu Click the Delete button on the Standard toolbar Delete the column from the worksheet Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Select Data > Delete Record from the menu Click the Delete button on the Standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of a worksheet can be protected from accidental modification? Scenarios Contents All of the listed here Objects Scenarios Contents All of the listed here Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)*0.5 =SUM(A1:A5)/(10-10) ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried You can set condition to look for Bold and apply Italics on them You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can delete any condition from Conditional Formatting dialog box if it is not requried ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS