MS Excel What is the shortcut key to replace a data with another in sheet ? Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R Ctrl + F Ctrl + H Ctrl + R Ctrl + Shift + R ANSWER DOWNLOAD EXAMIANS APP
MS Excel How many worksheets can a workbook have? 255 8 3 none of above 255 8 3 none of above ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which elements of worksheet can be protected from accidental modification Contents All of the listed here Objects Scenarios Contents All of the listed here Objects Scenarios 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 Line Chart Column Chart XY Chart Pie Chart Line Chart Column Chart XY Chart ANSWER DOWNLOAD EXAMIANS APP
MS Excel In Excel, the Fill Color button on the Formatting toolbar is used for what? To select a distribution of figures To add borders To add shading or color to a cell range To insert a background To select a distribution of figures To add borders To add shading or color to a cell range To insert a background ANSWER DOWNLOAD EXAMIANS APP
MS Excel Which tool you will use to join some cells and place the content at the middle of joined cell? From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box From Format Cells dialog box select the Centered alignment Click on Merge and Center tool on formatting toolbar From Format Cells dialog box click on Merge Cells check box From Format Cells dialog box choose Merge and Center check box ANSWER DOWNLOAD EXAMIANS APP