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...]

“Qtr 1, Qtr 2, Qtr 3” is an example of aa. Formulab. Functionc. Seriesd. SyntaxYou can edit existing Excel data by pressing thea. F1 keyb. F2 keyc. F3 keyd. F4 keyThe cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is ….a. G1-G10b. B1.G10c. B1;G10d. B1:G10A user wishes to remove a spreadsheet from a workbook. Which is the … [Read more...]