MS Excel In Excel, a Data Series is defined as what? A division of results A cell reference A collection of related data A type of chart A division of results A cell reference A collection of related data A type of chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you delete a record? Select Data > Delete Record from the menu Delete the column from the worksheet Click the Delete button on the Standard toolbar 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 Delete the column from the worksheet Click the Delete button on the Standard toolbar Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button ANSWER DOWNLOAD EXAMIANS APP
MS Excel You can edit a cell by None of these Double clicking the cell to edit it in place Selecting Edit > Edit cell from the menu Clicking the formula button None of these Double clicking the cell to edit it in place Selecting Edit > Edit cell from the menu Clicking the formula button ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following formulas will Excel not be able to calculate? =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 =SUM(A1:A5)-10 =SUM(A1:A5)/(10-10) =SUM(A1:A5)*0.5 =SUM(Sales)-A3 ANSWER DOWNLOAD EXAMIANS APP
MS Excel In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. Auto sum Auto format AutoFill Auto correct Auto sum Auto format AutoFill Auto correct 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 Cell address will change when it is copied to another cell An absolute cell address is created The sheet tab is changed The status bar does not display the cell address Cell address will change when it is copied to another cell An absolute cell address is created ANSWER DOWNLOAD EXAMIANS APP