MS Excel Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook? Work sheet Data sheet Chart sheet Macro sheet Work sheet Data sheet Chart sheet Macro sheet ANSWER DOWNLOAD EXAMIANS APP
MS Excel What are the tabs that appear at the bottom of each workbook called? Sheet tabs Reference tabs Position tabs Location tabs Sheet tabs Reference tabs Position tabs Location tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel Comments can be added to cells using File > Comments Edit > Comments Insert > Comments View > Comments File > Comments Edit > Comments Insert > Comments View > Comments ANSWER DOWNLOAD EXAMIANS APP
MS Excel The Paste Special command lets you copy and paste: Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value Cell comments The resulting values of a formula instead of the actual formula Formatting options Multiply the selection by a copied value 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 Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address The sheet tab is changed Cell address will change when it is copied to another cell An absolute cell address is created The status bar does not display the cell address ANSWER DOWNLOAD EXAMIANS APP
MS Excel Documentation should include All of these Destination and users of the output data Source of input data Information on the purpose of the workbook All of these Destination and users of the output data Source of input data Information on the purpose of the workbook ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS