MS Excel Which of the following is a correct order of precedence in formula calculation? Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation Multiplication and division, positive and negative values, addition and subtraction Multiplication and division exponentiation positive and negative values None of the listed here Addition and subtraction, positive and negative values, exponentiation ANSWER DOWNLOAD EXAMIANS APP
MS Excel When you link data maintained in an excel workbook to a word document The word document must contain a hyperlink The word document contains a reference to the original source application The word document cannot be edit The word document contains a copy of the actual data The word document must contain a hyperlink The word document contains a reference to the original source application The word document cannot be edit The word document contains a copy of the actual data ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar Both None Go to Tools > Options > View tab and mark or remove the check box named Gridline Click Gridline tool on Forms toolbar 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? Line Chart XY Chart Pie Chart Column Chart Line Chart XY Chart Pie Chart Column Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is not the correct method of editing the cell content? Press the Alt key Double click the cell Click the formula bar Press the F2 key Press the Alt key Double click the cell Click the formula bar Press the F2 key 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
EXAMIANS