Computer Fundamentals PDF

UNIQUE ONLINE GURU 1. In MS Excel, in which bar have the 6. Excel is a collection of workbook currency option …………. A) Formatting Toolbar A) Workbooks B) Standard Toolbar B) Worksheets C) Status Bar...

UNIQUE ONLINE GURU 1. In MS Excel, in which bar have the 6. Excel is a collection of workbook currency option …………. A) Formatting Toolbar A) Workbooks B) Standard Toolbar B) Worksheets C) Status Bar C) Charts and Slides D) Formula bar D) Data Correct answer : A Correct answer : B 2. Which menu contains macro options in 7. Which of these data types is not in MS Excel MS.excel? A) Insert A) Number B) Format B) Currency C) Tools C) Label D) Data D) Date/Time Correct answer : C Correct answer : C 3. Which function is used to input the 8. In MS Excel, which menu does have date only in MS Excel? Sort option A) Today A) Edit B) Now B) Format C) Time C) Tool D) Calendar D) Data Correct answer : A Correct answer : D 4. Which Function is used to calculate 9. Which of these charts does not exist in Remainder in MS Excel? MS Excel A) INT ( ) A) Scatter B) FACT ( ) B) Line C) MOD ( ) C) Doughnut D) DIV ( ) D) Graph Correct answer : C Correct answer : D 5. Which menu have the Fill option in MS 10. Which of these options is not available Excel? in the Chart Options in MS Excel A) View “CHART WIZARD”? B) Format A) Axes C) Tools B) Data Label D) Edit C) Data Series Correct answer : D D) Data Table Correct answer : C BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU 11. MS EXCEL Based on _______ 16. Which option is not in the Data Menu Software in MS Excel ? A) WINDOWS A) Validation B) DOS B) Filter C) UNIX C) Freeze Pane D) LINUX D) Sort Correct answer : A Correct answer : C 12. A spreadsheet is a collection of pages 17. When using the Function, which is called a _______ reference operator is used to give the A) Workbook range? B) Art book A) ; C) Worksheet B) & D) Documents C): Correct answer : A D) = 13. What is the Extension of Excel Correct answer : C Workbook in MS Excel 2007? 18. What is the feature of inserting cells A).xlx by dragging numbers in MS Excel ? B).xlsx A) Auto Correct C).xlcx B) Auto Text D).xlxx C) Auto Fill Correct answer : B D) Auto Cell 14. Which option of Chart Wizard Correct answer : C contains the option of Series Name, 19. Which of the options is in the Tool Category and Value in Data? Menu in MS.Excel ? A) Legend A) Formula Auditing B) Chart area B) Goal Seek C) Data label C) Scenarios D) Data Titles D) All of these Correct answer : C Correct answer : D 15. Which sign display when Formula 20. Which function is used to calculate Error in MS Excel Rate of Return, Loan, Amount and A) $ Future Value ? B) * A) Statistical function C) \ B) Financial function D) # C) Logical function Correct answer : D BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU D) Mathematical function B) 39 Correct answer : B C) 21 21. What is the shortcut key to insert D) 20 current date in cell ? Correct answer : B A) Ctrl +; 26. Which chart would be useful to B) Ctrl + T compare the sales price of two different C) Ctrl + D branches of a distributor? D) Ctrl + / A) Scatter Chart Correct answer : A B) Bar Chart 22. In M.S. Excel if Day Formula is C) Doughnut Chart imposed, answer to 5/3/2017 will be D) Area Chart printed ______ Correct answer : C A) 5 27. Which of these statements is correct? B) 3 A) = POWER(2*3) C) 2017 B) = POWER(2^3) D) 5 mar C) = POWER(2,3) Correct answer : B D) = POWER(2:3) 23. Which symbol do you use to start Correct answer : C formula in MS Excel? 28. Which of these is not an operator A) % in MS Excel? B) = A) Text Concatenation Operator C) + B) Reference Operator D) C) Arithmetic Operator Correct answer : B D) Logical Operator 24. Which of these functions is used to Correct answer : D remove more than one space? 29. Where does the active cell’s contents A) Trim display in Excel? B) Char A) Name Box C) Len B) Row Headings D) Int C) Formula Bar Correct answer : A D) Task Pane 25. In MS Excel cell, values 29, 19, 27, 39 Correct answer : C and 20 are written from A6 to A11. Then 30. How many steps are there to create what will be the value of = MAX (A6: charts in MS Excel? A11)? A) 2 A) 29 B) 3 BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU C) 4 C) Freeze Pane D) 5 D) Sort Correct answer : C Correct answer : C 31. A function does have inside the 36. “Comment” option is found in the function is called______ ………… menu. A) Nested Function A) insert B) Round Function B) Data C) Sum Function C) review D) Text Function D) View Correct answer : A Correct answer : A 32. The cell address in the Microsoft 37. What is the shortcut key to insert a Office Excel document is _________ new sheet in the current workbook? A) Column Name A) F11 B) Row Name B) Ctrl + F11 C) First Row then Column Name C) Shift + F11 D) First Column then Row Name D) Alt + F11 Correct answer : D Correct answer : C 33. If you want a blank line after the 38. How can you show or hide the title in the worksheet, which of these Grid lines in Excel sheet? methods will be the best? A) Go to Tools – Options – View tab A) Re-Format the spreadsheet then Mark or unmarked the Grid line box B) Insert the Row B) Click on the Grid Line tool in the Forms C) Increase the column Width Toolbar D) Use the Space bar C) A and B Both Correct answer : B D) None of these 34. How is the data organize in the Correct answer : A spreadsheet? 39. The address of the current cell in A) Line and Spacing Excel is displayed in _______ B) Rows and Columns A) Formula bar C) Layers and Pallets B) Status bar D) Height and Width C) Name Box Correct answer : B D) Title bar 35. In MS Excel, which of the following Correct answer : C option is not available in the Data menu? 40. The shortcut key to add Hyperlink in A) Validation Worksheet is _______ B) Filter A) Alt + K BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU B) Ctrl + H D) None of these C) Ctrl + K Correct answer : B D) Shift + Ctrl + K 46. The programming language in which Correct answer : C Excel keeps the macro code record. 41. Which of these statements is not A) Java correct? B) Visual Basic A) You can create graph in Excel sheet. C) Basic B) Excel sheet has an extension.doc D) Video Basic C) The new workbook is called book 1. Correct answer : B D) None of these 47. What is the shortcut key to replace in Correct answer : B MS-Excel? 42. The common point of row and column A) Ctrl+R is called B) Ctrl+E A) pixel C) Ctrl+H B) cell D) Ctrl+L C) 0 Correct answer : C D) Track 48. Which of the following menu is used Correct answer : B for Cut, Copy, Paste, Delete text in 43. Who can use a Spreadsheet? Excel? A) Finance Professionals A) Edit menu B) Engineers B) File menu C) Stoke Brokers C) Tool menu D) All of these D) Format menu Correct answer : D Correct answer : A 44. To show the range of cells, we use 49. The default extension of the Excel file …………. in excel is______ A) Semicolon A).XLS B) Comma B).XLW C) Colon C).WK1 D) Dot D).123 Correct answer : C Correct answer : A 45. What is the shortcut to open the 50. A worksheet has a header by default- dialog box of Format cell? A) User Name A) Alt + 1 B) Date and time B) Ctrl + 1 C) Sheet tab name C) Ctrl + Shift + 1 BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU D) None D) Ctrl Correct answer : D Correct answer : B 51. The maximum row in a work sheet is- 56. Which column will you select to insert A) 256 a new column between Column D and E. B) 1024 A) select column E C) 65536 B) select column D D) 32000 C) select column E , F , G Correct answer : C D) select column D, E , F 52. Cell reference will be from range G2 Correct answer : A to M12. 57. Which of the following is not the A) G2=M12 Zoom percentage in excel? B) G2;M12 A) 10 C) G2:M12 B) 100 D) G2,M12 C) 300 Correct answer : C D) 500 53. Which menu is used to show and hide Correct answer : D the Status Bar in Excel 58. What is the feature of inserting by A) Edit menu dragging number in cells in MS Excel B) File menu ? C) View menu A) Auto Correct D) Format menu B) Auto Text Correct answer : C C) Auto Fill 54. The keyboard shortcut is used to D) Auto Cell create charts in the selected range. Correct answer : C A) F2 59. How many columns are there in B) F4 Excel? C) F8 A) 256 D) F11 B) 65536 Correct answer : D C) 216 55. ________ key is used to drag data of D) 220 range from selected worksheet to another Correct answer : A worksheet. 60. In which menu have Freeze Pane A) Tab option? B) Alt A) Tools C) Shift B) Data C) Window BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU D) View A.Cannot be modified Correct Answer : C B. Only appears on summary worksheets 61. In MS-Excel which functions will C.Both (a) & (b) calculate the number of workdays D.Spans worksheets between 6/9/2013 and 8/12/2013 B. Date A.Workday C.Networkday B. Date D.Weekday C.Networkday Option: D D.Weekday 65. In MS-Excel to protect a worksheet, Option: D you can choose Protection and the Protect 62. In MS-Excel data marker on a chart Sheet from the........... menu are linked to data points in a worksheet, A.Edit therefore B. Format A.You can automatically apply C.Tools formatting to a data series D.All of the abov B. You can change the position of a Option: C data marker and that automatically 66. In MS-Excel you can open the changes the data point value in the Highlight Changes dialog box by worksheet choosing Track Changes from the.... Menu. C.You can change a data point value A.Edit and automatically that is drawn in B. Insert the chart C.Tools D.Both (b) & (c) D.None of these Option: D Option: C 63. MS-Excel uses the.... Function when 67. What MS-Excel feature can you use if creating a data table you want to work with one record at a A.Average time? B. Count A.Auto Complete C.Both (a) & (b) B. Auto Filter D.Table C.Data Form Option: D D.All of the above 64. In MS-Excel which functions will Option: C calculate the number of workdays 68. In MS-Excel what chart object is between 6/9/2013 and 8/12/2013 horizontal or vertical line that extends A.Workday BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU across the plot area to make it easier to button read and follow the values? C.Select Data > Delete Record from A.Category axis the menu B. Data marker D.None of these C.Both (a) & (b) Option: B D.Gridline 73. In MS-Excel which of the following is Option: D an absolute cell reference? 69. In MS-Excel value used in a formula A.!A!1 that does not change is called a B. $A$1 A.Cell address C.#a#1 B. Constant D.None of these C.Function Option: B D.None of these 74. In MS-Excel Documentation should Option: B include 70. In MS-Excel which elements of A.Destination and users of the output worksheet can be protected from data accidental modification? B. Source of input data A.Contents B. Objects C.Scenarios D.All of above C.Information on the purpose of the Option: D workbook 71. In MS-Excel comments can be added D.All of the above to cells using Option: D A.Edit > Comments 75. In MS-Excel chart wizard term data B. Insert > Comments series refers to C.File > Comments A.A chart legend D.None of these B. A collection of chart data markers Option: B C.A set of values you plot in a chart 72. In MS-Excel how can you delete a D.None of these record? Option: B A.Delete the column from the 76. In MS-Excel Chart wizard term data worksheet categories refers to B. Select Data > Form from the menu A.A chart plot area to open the Data Form dialog box, B. A horizontal axis find the record and Click the Delete C.The organization of individual BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU values with a chart's data series 81. In MS-Excel which is used to perform D.All of these what if analysis? Option: B A.Solver 77. In MS-Excel two common wildcard B. Goal seek characters that MS-Excel recognizes are C.Scenario Manager A.* and ? D.All of above B. < and > Option: C C.^ and / 82. In MS-Excel Book1 is an example of D.None of these how... are numbered and named during Option: A each work session 78. In MS-Excel how can you find A.Active cell specific information in a list? B. Formula bar A.Select Tools > Finder from the menu C.Menu bar B. Click the Find button on the standard D.Name box toolbar Option: D C.Select lnsert > Find from the menu 83. In MS-Excel Graphics objects on a D.Select Data > Form from the menu chart are used to to open the Data Form dialog box A.Add emphasis to chart data and click the Criteria button B. Add interest to a chart Option: D C.Help explain the chart data 79. In MS-Excel when integrating MS- D.All the above Word and MS-Excel, MS-Word is usually Option: D the 84. In MS-Excel constant is another A.Server name for this type of data B. Destination A.number C.Client B. equation D.Both (A) and (C) C.formula Option: D D.None of these 80. In MS-Excel Comments put in cells Option: A are called 85. In MS-Excel the view that puts a blue A.Smart tip a blue line around each page that would B. Cell tip be printed is the C.Web tip A.Print Preview D.None of these B. Normal View Option: B C.Page Break Preview D.None of thes BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU Option: C C.date 86. In MS-Excel to select an individual D.None of these data marker or data label, you must Option: D A.Double click the data series 91. In MS-Excel which of the following is B. Right click selected marker not an option in the spelling dialog box C.Both (a) & (b) A.Edit D.Double click the marker or label B. Ignore Option: D C.Ignore all 87. In MS-Excel what does SUMIF D.None of these function do? Option: A A.Adds up cell values based on a 92. In MS-Excel you can copy cell condition formats from one cell to another by using B. Adds all the numbers in a range of the cells A.Bsckspace key C.Returns a subtotal in a list or B. Default font database C.Format painter D.Both (a) & (b) D.None of these Option: A Option: C 88. In MS-Excel you can insert labels 93. In MS-Excel when you group for worksheets A.All the data markers on a chart A.You can enter variable data on B. A data series multiple worksheets at one time C.A selected data marker B. You can print more than one D.All of the above worksheet at a time Option: D C.You can enter common data, 89. In Excel 3-D reference in a formula formats, and formulas on multiple A.Cannot be modified worksheets at one time B. Only appears on summary of D.(B) and (C) Worksheet Option: D C. Limits the formatting options 94. In MS-Excel accounting style shows D. spans worksheet negative numbers in Option: D A.Bold 90. In MS-Excel default header for a B. Brackets worksheet is C.Parentheses A.Your name D.None of these B. The date and time Option: C BY RATNAKAR SIR 8009012815, 9455443048  UNIQUE ONLINE GURU 95. In MS-Excel you can zoom a 99. In MS-Excel the auto calculate worksheet feature A.With the mouse pointer in Print A.Can add values in a range of cells Preview B. Provides a quick way to view the B. With the zoom button on the Print results of an arithmetic operation on Preview toolbar a range of cells C.With the Zoom command on the C.Automatically creates formula and view menu adds them to a worksheet D.All of the above D.All of thes Option: D Option: D 96. You can link MS-Excel worksheet 100. In MS-Excel you can use the format data to a Word document painter multiple times before you turn it A.With the right drag method off by B. With a hyperlink A.You can use the format painter button C.With the copy and paste buttons on only one time when you click it the standard toolbar B. Double clicking the format painter D.None of these button Option: B 97. In MS-Excel the chart wizard A.Can place a chart on a new chart sheet or on any sheet in the C.Pressing the Ctrl key and clicking the workbook format painter button B. Can only place a chart on new D.None of these chart sheet Option: B C.Can only place a chart on a new blank worksheet D.None of these Option: A 98. MS-Excel is similar to which of the following accounting worksheets A.Word processing B. Database C.Spreadsheets D.Both (b) & (c) Option: C BY RATNAKAR SIR 8009012815, 9455443048