MS Excel What is the correct way to refer the cell A10 on sheet3 from sheet1? Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 Sheet3.A10 Sheet3!A10 Sheet1!A10 A10 ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is represented by the small, black square in the lower-right corner of an active cell or range? Border Insert handle Copy handle Fill handle Border Insert handle Copy handle Fill handle ANSWER DOWNLOAD EXAMIANS APP
MS Excel Right clicking something in Excel: Nothing the right mouse button is there for left handed people Deletes the object Selects the object Opens a shortcut menu listing everything you can do to the object Nothing the right mouse button is there for left handed people Deletes the object Selects the object Opens a shortcut menu listing everything you can do to the object ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not true regarding Conditional Formatting? You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them You can delete any condition from Conditional Formatting dialog box if it is not requried You can apply Font, border and pattern formats that meets the specified conditions You can add more than one condition to check You can set condition to look for Bold and apply Italics on them ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet Click the Delete button on the Standard toolbar Select Data > Delete Record from the menu Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Delete the column from the worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell The sheet tab is changed The status bar does not display the cell address An absolute cell address is created Cell address will change when it is copied to another cell ANSWER DOWNLOAD EXAMIANS APP