MS Excel A typical worksheet has ___ number of columns. 1024 128 256 16384 1024 128 256 16384 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Each excel file is called a workbook because 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 It can contain many sheets including worksheets and chart sheets ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which function is not available in the Consolidate dialog box ? Sum Average Max Pmt Sum Average Max Pmt ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you select an entire column? Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column Hold down the Ctrl key as you click anywhere in the column Select Edit > Select > Column from the menu Click the column heading letter Hold down the shift key as you click anywhere in the column ANSWER DOWNLOAD EXAMIANS APP
MS Excel When a row of data is to be converted into columns Copy the cells in row, select the same number of cells in row and paste Copy the cells then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and 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 then go to Cells then on Alignment tab click Transpose check box and click OK Copy the cells in column then choose Paste Special, then click Transpose and OK Select the cells then place the cell pointer on new cell and choose Paste Special, mark Transpose check box and click OK ANSWER DOWNLOAD EXAMIANS APP
MS Excel What is the short cut key to highlight the entire column? Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter Ctrl + Space Bar Ctrl + C Ctrl + Page Up Ctrl + Enter ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS