MS Excel What are the tabs that appear at the bottom of each workbook called? Reference tabs Location tabs Position tabs Sheet tabs Reference tabs Location tabs Position tabs Sheet tabs ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK Copy the cells in row, select the same number of cells in row and paste Copy the cells in column then choose Paste Special, then click Transpose and OK Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel To record a sequence of keystrokes and mouse actions to play back later we use: Media player Macro Recorder Calculator Sound Recorder Media player Macro Recorder Calculator Sound Recorder ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which area in an Excel window allows entering values and formulas? Menu Bar Title Bar Standard Tool Bar Formula Bar Menu Bar Title Bar Standard Tool Bar Formula Bar 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 When a range is selected, how can you activate the previous cell ? Press the Alt key Press Tab None Press Enter Press the Alt key Press Tab None Press Enter ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS