INDIA MCQ

Which of the following Excel screen components can NOT be turned on or off?a. Formula Barb. Status Barc. Tool Bard. None of aboveWhat happens when you press Ctrl + X after selecting some cells in Excel?a. The cell content of selected cells disappear from cell and stored in clipboardb. The cells selected are marked for cuttingc. The selected cells are deleted and the cells are … [Read more...]

Which tool you will use to join some cells and place the content at the middle of joined cell?a. From Format Cells dialog box click on Merge Cells check boxb. From Format Cells dialog box select the Centered alignmentc. From Format Cells dialog box choose Merge and Center check boxd. Click on Merge and Center tool on formatting toolbarTab scroll buttons are place on Excel … [Read more...]

Which of the following format you can decide to apply or not in AutoFormat dialog box?a. Number formatb. Border formatc. Font formatd. All of aboveHow can you remove borders applied in cells?a. Choose None on Border tab of Format cellsb. Open the list on Border tool in Formatting toolbar then choosefirst tool (no border)c. Both of aboved. None of aboveWhere can you set the … [Read more...]

If you need a text to show vertically in a cell. How will you achieve this?a. Choose Vertical on Text alignment in Format Cells dialog boxb. Choose 90 Degrees in Orientation of Format Cells dialog boxc. Choose Distributed from the Vertical drop down list of FormatCells dialog boxd. Choose Center Across Selection from Horizontal combo box inFormat Cells dialog boxCan you set 0.5 … [Read more...]

To protect a worksheet, you can choose Protection and theProtect Sheet from the ….. menua. Editb. Formatc. Toolsd. DataYou can open the Highlight Changes dialog box by choosingTrack Changes from the …. Menu.a. Editb. Insertc. Formatd. ToolsWhich of the following is not a worksheet design criterion?a. Efficiencyb. Auditabilityc. Descriptiond. ClarityTo copy cell contents using … [Read more...]