MS Excel Which of the following options is not located in the page setup dialog box ? Page Break Preview Margins Headers and Footers Page Orientation Page Break Preview Margins Headers and Footers Page Orientation ANSWER DOWNLOAD EXAMIANS APP
MS Excel What happens when you press Ctrl + X after selecting some cells in Excel? The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following methods can not be used to edit the contents of a cell? Double clicking the cell Pressing the F2 key Press the Alt key Clicking the formula bar Double clicking the cell Pressing the F2 key Press the Alt key Clicking the formula bar ANSWER DOWNLOAD EXAMIANS APP
MS Excel What do you call the chart that shows the proportions of how one or more data elements relate to another data element? Pie Chart XY Chart Line Chart Column Chart Pie Chart XY Chart Line Chart Column Chart 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 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 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 Excel probably considers the cell entry January 1, 2020 to be a Formula Label Value Text string Formula Label Value Text string ANSWER DOWNLOAD EXAMIANS APP