MICROSOFT EXCEL (Q&A)

 AJAKAI ICT- COMPUTER QUESTIONS AND ANSWERS

1. With which of the following all formulas in excel starts ? / * $ =   2. On an excel sheet the active cell in indicated by ? A dotted border A dark wide border A blinking border By italic text   3. What term describes explanatory text attached to a cell ? Context Callout Comment Dialog 4. How we can view a cell comment ? position the mouse pointer over the cell click the comment command on the view menu click the edit comment commands on the Insert menu click the Display comment command on the window menu   5. Which of these will not select all the cells in a document ? Using the Edit – Select All menu Pressing Ctrl + A on the keyboard Clicking three times with the right mouse button in the spreadsheet   6. The default style for new data keyed in a new workbook is ? Comma Normal Currency Percent   7. If you press __, the cell accepts your typing as its contents ? Tab Ctrl+Enter Enter Alt+Enter   8. Which of the following keyboard shortcut can be used for creating a chart from the selected cells ? F11 F10 F4 F2 9. Formula palette is used to ? format cells containing numbers create and edit formulas containing functions entered assumptions data copy all cells   10. A value used in a formula that does not change is called a ? Constant Cell address Varaible Static 11. A Spreadsheet contains ? columns rows rows and columns None of above   12. To open an existing workbook, click the Open button on the ___ toolbar ? Form Standard Drawing Formatting   13. Which among following is not associated with spelling dialogue box ? Edit Ignore Ignore All Change   14. what term describes a background that appears as a grainy, non smooth surface ? Pattern Gradient Texture Velvet   15. Which among following is associated with excel ? Graphic program Word Processor Presentation Spreadsheet   16. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ? C1:10H C1:H10 C1:H-10 C1:H:10   17. You can convert existing Excel worksheet data and charts to HTML document by using the ? Internet Assistant Wizard Intranet Wizard Import Wizard Export Wizard   18. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called ? HTML Pivot Table Field List Pivot Table Report Pivot Table List   19. What function displays row data in a column or column data in a row ? Transpose Index Rows Hyperlinks   20. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ? NOT OR IF AND  21. Macros can be executed from the which of the following menu ? Format Home Insert Tools   22. Protection and the Protect Sheet options can be selected from ? Data Tools Edit Format   23. Which of the following is not a valid Zoom percentage in Excel ? 10 100 300 500   24. You can check the conditions against ____ when applying conditional formatting ? Cell Value Formula Both of above None of above

25. How can we set Page Border in Excel ? From Edit menu From Home You can not set page border in Excel From Tools menu   26. Which function calculates your monthly mortage payment ? PV NPER PMT All of above   27. Which types of charts can excel produce ? Line graphs and pie charts only Bar charts, line graphs and pie charts Bar charts and line graphs only Only line graphs   28. How is data organized in a spreadsheet ? Rows and columns Layers and planes Lines and spaces Height and width   29. VLOOKUP function used to ? Finds related records Looks up text that contain "v" Check if two cells are identical None of above   30. Gridlines may be turned off for display but turned on for printing. True False   31. How do you change column width to fit the contents ? Single-click the boundary to the left to the column heading Double click the boundary to the right of the column heading Press Alt and single click anywhere in the column All of above   32. To insert three columns between columns A and B you would Select column A Select A and B Select B All of above   33. To drag a selected range of data to another worksheet in the same workbook, use the ? Ctrl key Shift key Alt key Tab key   34. You can activate a cell by ? Pressing the Tab key Clicking the cell Pressing an arrow key All of above   35. A function inside another function is known as ? Round function Sandwich function Switch function Nested function   36. What excel feature can you use if you want to work with one record at a time ? Auto Complete Data Form Set Form Auto Text 37. Which function is used for creating a data table ? Sum Table Add Count   38. The accounting style shows negative numbers in ? Bold Italics Parentheses Quotes   39. 3-D reference in a formula ? Spans worksheets Can not be modified Only appears on summary worksheets Limits the formatting options   40. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells. True False   41. Which among following wildcard characters are recognized by excel ? + and - ! and ^ * and ? < and > 42. Which among following is divide symbol in excel ? / D Div \   43. Which function in excel counts the numbers of characters in a cell ? LENGHT LGT LT LEN   44. Which function converts miles to kilometers ? Change Covnert Shift Conv   45. What is shortcut to enter current date in cell in excel ? Ctrl + ; Alt + ; Shift + & Ctrl + $   46. Shortcut to edit the selected cell ? F3 F8 F4 F2   47. Each excel can contain many sheets including worksheets and chart sheets. True False 48. Which shortcut can be used to Switch between open workbooks ? Ctrl + F2 Ctrl + F6 Ctrl + F8 Ctrl + F10   49. Shortcut to delete the selected column ? Ctrl + - Alt + - Shift + - Insert + -   50. Shortcut to enter current date ? Home + ; Shift + ; Alt + ; Ctrl + ;   51. When the formula bar is activated, you can see The Edit Formula button The Cancel button The Enter button All of above   52. Style sheet formats can be applied from ? Table >> Autoformat Format >> Autoformat Table >> Cells Fromat >> Cells

53. Which function will you use to enter current time in a woksheet cell ? =time() =nowtime() =now() =currentTime() 54. Merge cells option can be applied from ? Formatting toolbar Format Cells dialog box Alignment Tab Both of above None of above   55. How many recent files you can display on File menu at maximum ? 3 7 9 15   56. The name box appears at the ? left of the formula bar right of the formula bar below the status bar below the menu bar   57. Entire worksheet can not be selected in one time. True False   58. Where are the status indicators located ? Horizontal Scroll Vertical Scroll Formula bar Address bar   59. Insert picture option is in which of the following toolbars ? Standard Formatting Drawing Picture   60. What term refers to a specific set of values saved with the workbook ? Range File set Data set Scenario 61. We can cancel marquee by pressing ? Ctrl + Esc Alt + Esc Shift + Esc Esc   62. Which of the following methods cannot be used to edit the content of cell ? Pressing F2 Clicking the formula bar Pressing the Alt key Double clicking the cell   63. When you use multiplication, division or exponentiation in a formula then there is chance of occurring rounding errors. True False   64. Which among following can't be considered as worksheet criterion ? Efficiency Auditability Clarity Description 65. When creating a vertical page break ? The active cell must be in row 1 The active cell must be A1 The active cell must be in row 10 The active cell must be in column A 66. The intersection of row and column is called a ? dataset cell data set   67. You will use which feature in excel, if you want to work with one record at a time ? Auto Complete Auto Filter Sub Totals Data Form 68. Which dialogue box we can use to name a constant ? Create Name Define Name Get Name Create Constant   69. One cell format can be copied to another cell by using ? Format Painter Format Setting Format Showing Format Checking 70. Which among following is types of excel data types ? Numbers, Formulas, Labels Data, Words, Numbers Words, Number, Labels Equations, Data, Numbers   71. To join some cells and place the content at the middle of joined cell, which tool you will use? From Format Cells dialog box choose Merge and Center check box Click on Merge and Center tool on formatting toolbar From Format Cells dialog box select the Centered alignment From Format Cells dialog box click on Merge Cells check box   72. On Excel screen, Tab scroll buttons are towards the top left corner towards the top right corner towards the bottom right corner towards the bottom left corner   73. Choose from the following, which is not the correct method of editing the cell content ? Press the Alt key Press the F2 key Double click the cell Click the formula bar   74. In Excel Worksheet how can you show or hide the gridlines ? Click Gridline tool on Forms toolbar Go to Tools -> Options -> View tab and mark or remove the check box named Gridline Both of above None of above   75. When you press Ctrl + X after selecting some cells in Excel, what will happen then The cell content of selected cells disappear from cell and stored in clipboard The selected cells are deleted and cells are shifted up The selected cells are deleted and the cells are shifted left The cells selected are marked for cutting   76. In Paste Special dialog box, which of the following option is not available ? Divide Add Subtract Square root 77. To convert a column of data into row, which command will you choose Edit -> Paste Special -> Transpose Cut and Paste Both of above None of above 78. Using Paste Special command which of the following you can paste selectively Formulas Validation Formats All of above