MS Excel B7:B9 indicates: Cells B7 and cell B9 only Cell B8 only Cells B7 through B9 None of these Cells B7 and cell B9 only Cell B8 only Cells B7 through B9 None of these ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because It can contain many sheets including worksheets and chart sheets It can be modified It can contain text and data You have to work hard to create it It can contain many sheets including worksheets and chart sheets It can be modified It can contain text and data You have to work hard to create it ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button Click the Delete button on the Standard toolbar Delete the column from the worksheet 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 Click the Delete button on the Standard toolbar Delete the column from the worksheet Select Data > Delete Record from the menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you insert a row? Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar Select the row heading where you want to insert the new row and select Edit >Row from the menu All of the listed here Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu ANSWER DOWNLOAD EXAMIANS APP
MS Excel Paste special allows some operation while you paste to new cell. Which of the following operation is valid ? Percentage Goal seek Divide Square Percentage Goal seek Divide Square ANSWER DOWNLOAD EXAMIANS APP
MS Excel The auto calculate feature Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet Provides a quick way to view the result of an arithmetic operation on a range of cells Can only add values in a range of cells A and C Automatically creates formulas and adds them to a worksheet ANSWER DOWNLOAD EXAMIANS APP