MS Excel The Chart wizard term data categories refers to; A chart plot area The data range that supply chart data A horizontal axis The organization of individual values with a chart’s data series A chart plot area The data range that supply chart data A horizontal axis The organization of individual values with a chart’s data series ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification All of the listed here Contents Scenarios Objects All of the listed here Contents Scenarios Objects ANSWER DOWNLOAD EXAMIANS APP
MS Excel How can you show or hide the gridlines in Excel Worksheet Both None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline Both None Click Gridline tool on Forms toolbar Go to Tools > Options > View tab and mark or remove the check box named Gridline ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which of the following is an absolute cell reference? A1 !A!1 $A$1 #a#1 A1 !A!1 $A$1 #a#1 ANSWER DOWNLOAD EXAMIANS APP
MS Excel Long text can be broken down into many lines within a cell. You can do this through Text Wrapping in Format > Cells All of above Wrap Text in Format > Cells Justify in Edit > Cells Text Wrapping in Format > Cells All of above Wrap Text in Format > Cells Justify in Edit > Cells ANSWER DOWNLOAD EXAMIANS APP
MS Excel How do you rearrange the data in ascending or descending order? Data Subtotals Data, Table Data, Form Data, Sort Data Subtotals Data, Table Data, Form Data, Sort ANSWER DOWNLOAD EXAMIANS APP