MS Excel What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address An absolute cell address is created The sheet tab is changed Cell address will change when it is copied to another cell The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Tab scrolling button Allow you to view additional worksheet rows down Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs Allow you to view a different worksheet Allow you to view additional worksheet rows down Allow you to view additional worksheet columns to the right Allow you to view additional sheets tabs Allow you to view a different worksheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you find specific information in a list? Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar Select Insert > Find from the menu Select Tools > Finder from the menu Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button Click the Find button on the standard toolbar ANSWER DOWNLOAD EXAMIANS APP
MS Excel Excel uniquely identifies cells within a worksheet with a cell name Column latters and row numbers Cell locator coordinates Cell names Column numbers and row letters Column latters and row numbers Cell locator coordinates Cell names Column numbers and row letters ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, a Data Series is defined as what? A cell reference A division of results A collection of related data A type of chart A cell reference A division of results A collection of related data A type of chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Position tabs Reference tabs Sheet tabs Location tabs Position tabs Reference tabs Sheet tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS