IDS Unit 1 MCQ PDF

UNIT 1 1. MS Excel is a? A) Spreadsheet B) Presentation C) OS D) Compiler Ans A 2. The intersection of a column and a row in a worksheet is called? A) Column...

UNIT 1 1. MS Excel is a? A) Spreadsheet B) Presentation C) OS D) Compiler Ans A 2. The intersection of a column and a row in a worksheet is called? A) Column B) Address C) Cell D) Row Ans C 3. Named Ranges cannot be created using? A) Name box B) Create from selection in the Defined Names C) Name Manager from Defined Names D) AVERAGE Ans D 4. By default, a cell reference in excel is ___________? A) Absolute B) Relative C) Mixed D) Null Ans B 5. If you want to maintain the original cell reference when you copy it, you "lock" it by putting a dollar sign ($) before the cell and column references. This process is known as? A) Absolute reference B) Value error C) Relative reference D) Mixed mode Ans A 6. Assume currently you are in sheet1, the value in cell B2 on Sheet2 can be referenced using? A) =B2 B) =Sheet2.B2 C) =Sheet2!B2 D) =Sheet1.Sheet2.B2 Ans C 7. The ______ function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. A) IF B) COUNTIF C) COUNT D) IFS Ans D 8. If the range contains a formula that returns an empty string, the _______ function counts that value. A) COUNT B) COUNTA C) COUNTBLANK D) COUNTALL Ans B 9. The range for Column A, Row 2 and Column B, Row 5 can be represented as? A) A2:B5 B) A:B C) B5:A2 D) “A2:B5” Ans A 10. In _____________, data from the entire population or a sample is summarized with numerical descriptors. A) Inferential statistics B) Text mining C) Descriptive statistics D) Sentimental analysis Ans C 11. The ribbon in excel is made up of four basic components namely tabs, groups, dialog launchers, and _______________. A) formulas B) workbooks C) cells D) command buttons Ans D 12. Excel assumes that everything is __________ that is, relocated and copied formulas will reference information according to the number of columns and rows they have moved. A) absolute B) zero C) relative D) null Ans C 13. ________ is an Excel feature that allows you to keep row or column titles on the screen while you scroll through long lists on a worksheet. A) Scroll Panes B) Freeze Panes C) Slicers D) AutoFill Ans B 14. Assume cell A1 contains value 50, formula =IFS(A1>40,"A”, A1>50,"B") on any cell returns? A) A B) B C) 0 D) 1 Ans A 15. Assume cell A1 contains value 50, formula =AND(A1>40, A1>50) on any cell returns? A) TRUE B) 40 C) FALSE D) 50 Ans C 16. Assume cell A1 contains value Reggie Miller, text function formula =MID(A1,2,3) on any cell returns? A) Reg B) Mil C) Eggie D) egg Ans D 17. ___________ serial number represents noon on December 31, 2022 in excel. A) 44926.25 B) 44926.5 C) 44926 D) 44856.05 Ans B 18. Assume B41 cell contains text value james and C41 contains jones. The formula =CONCATENATE(LOWER(B41)&"."&LOWER(C41)&"@"&"microsoft.com") in any cell displays? A) [email protected] B) james&[email protected] C) james.jones&microsoft.com D) [email protected] Ans A 19. By default, Microsoft Excel for Windows uses the __________ date system. A) 1560 B) 2000 C) 1900 D) 1990 Ans C 20. To get a time serial number, excel expresses time as a decimal fraction of the ________ day to get a number between 0 and 1. A) 1-hour B) 12-hour C) 48-hour D) 24-hour Ans D TIME(HOUR(NOW()) + 12, MINUTE(NOW()), SECOND(NOW())) this expression returns the time 21. 2 __________ hours from now. A) 1 B) 12 C) 48 D) 24 Ans B  The powerful _________ features available in excel enable you to highlight cells, create top 22. and bottom rules, and apply three types of formatting namely data bars, color scales, and icon sets. A) sorting B) autofill C) conditional formatting D) Date and time Ans C 23. What function would you use to find the nth largest number in a range of cells? A) MAX B) BIGGEST C) HIGHEST D) LARGE Ans D 24. What does 'Filtering' data do in excel? A) Changes the data formatting B) Deletes unwanted data C) Temporarily hides rows or columns that do D) Permanently removes data that doesn't meet not meet the specified criteria a criterion Ans C 25. _________ function returns the current date and time each time the worksheet is recalculated. A) TODAY() B) NOW() C) DATE() D) TIME() Ans B 26. Excel 2019 supports up to ____________ rows per worksheet. A) 1,048,576 B) 65,535 C) No limit D) 2,50,000 Ans A Assume cell A1 contains text: MS, cell B1 contains text: Excel and cell C1 contains text: 27. Software. Predict output of formula = A1 & " " & B1 & " " & C1. A) MS B) Software C) MS Excel Software D) ValueError Ans C The _______ function in Excel is a formula designed to compute the count of days between 28. two given dates. A) DAY B) WEEK C) NOW D) DAYS Ans D 29. The formula = REPLACE("Python Excel",1,6,"MS") produces output as? A) MS B) MS Excel C) Excel D) Python MS Ans B 30. The formula = ROUNDUP(3.5558,2) produces output as? A) 3.56 B) 3.556 C) 3 D) 4 Ans A 31. In excel when sorting multiple columns, it will always sort by the ________ column. A) last B) second C) first (leftmost) D) second last Ans C In conditional formatting, ___________ are rules based on specified numerical values, 32. matching text, calendar dates, or duplicated and unique values. A) filter B) sort C) autofill D) conditions Ans D 33. Select the formula which add 6 hours from now. A) =NOW()+6 B) =NOW()+6*(1/24) C) =TODAY()*6*(1/24) D) =NOW()+6*24 Ans B 34. SUBTOTAL automatically ________ existing subtotal formulas to avoid double counting. A) ignores B) utilizes C) considers D) replaces Ans A 35. Normal formatting is _______, while conditional formatting is _______. A) static and static B) dynamic and dynamic C) static and dynamic D) dynamic and static Ans C Assume data in the range M9:M16 as {-2, 56, 0, 0, 11, 1, -10, 100}. Apply formula as 36. =M9=MIN(IF($M$9:$M$160,$M$9:$M$16)) in conditional formatting feature of excel to the range M9:M16. Predict the highlighted cell value after applying conditional formatting. A) 0 B) -2 C) 100 D) -10 Ans D Analyze the conditional formatting formula for the highlighted cells in the following data range G9:G15. 12 120 37. 5 6 15 19 14 A) =AND(MAX($G$9:$G$15)=$G9, B) =OR(MAX($G$9:$G$15)=$G9, MIN($G$9:$G$15)=$G9) MIN($G$9:$G$15)=$G9) C) =OR(MAX($G$9:$G$15)=$G$9, D) =OR(MAX($G$9:$G$15)=$G$9, MIN($G$9:$G$15)=$G$9) MIN($G$9:$G$15)=$G$9) Ans B If you have a list of data that you want to group and summarize, you can use excel _____ and 38. Outline to display summary rows or columns. A) Subtotal B) Autosum C) Total D) Autofill Ans A The filter feature applies a ________ menu to each column heading, allowing you to select 39. specific choices to narrow a table. A) Combo box B) Checklist C) Drop down D) Radiobutton Ans C 40. Which one is not predictive analytics tools? A) KNIME B) IBM SPSS Modeler C) R D) Bar Charts Ans D 41. What is the primary purpose of Business Intelligence (BI)? A) To clean and preprocess data B) To present historical data to aid decision- making C) To perform data mining D) To transform data Ans B 42. Which of the following excel functions is used to clean and format text data? A) TRIM() B) CONCATENATE() C) SUM() D) FILL() Ans A 43. What is data mining primarily concerned with? A) Collecting raw data B) Cleaning and processing data C) Identifying patterns and relationships in D) Reporting and visualization data Ans C 44. What is the first step in the data analysis process? A) Data Collection B) Data Cleaning C) Data Conversion D) Data Requirements Specification Ans D 45. In the context of data cleaning, what does the excel function CLEAN() do? A) Removes all non-printable characters from B) Removes all spaces from text text C) Converts text to lowercase D) Finds and replaces text Ans A Which of the following techniques is commonly used in data mining for grouping similar data 46. points together? A) Classification B) Clustering C) Regression D) Association Ans B Which excel function is used to count the number of times a particular city appears in a 47. customer list. A) COUNT B) SUM C) COUNTIF D) COUNTA Ans C 48. Which excel function can you use to convert a text string representing a date into an excel? A) DATE() B) NOW() C) VALUE() D) DATEVALUE() Ans D 49. In the context of business intelligence, what does OLAP stand for? A) Online Analytical Processing B) Online Arithmetic Processing C) Offline Analytical Processing D) Offline Arithmetic Processing Ans A 50. Which of the following is a key benefit of using predictive analytics? A) Understanding past data B) Predicting future outcomes C) Cleaning raw data D) Visualizing data Ans B The ________ function in excel calculates the last day of a month by adding a specified number 51. of months to a given date. A) DAY B) DAYS C) EOMONTH D) WEEKS Ans C Which function finds the date 90 workdays from 1/1/2012, counting only sundays as a weekend 52. day. A) =WORKDAY.INTL(DATE(2012,1,1),90) B) =WORKDAY.INTL(DATE(2012,1,1),90,0) C) =DAY(DATE(2012,1,1),90,11) D) =WORKDAY.INTL(DATE(2012,1,1),90,11) Ans D 53. The _________ function is designed for columns of data, or vertical ranges. A) SUBTOTAL B) TOTAL C) RANGE D) COLUMN Ans A It is generally easier to create a list with subtotals by using the Subtotal command in the _____ 54. group on the Data tab in the Excel desktop application. A) Font B) Outline C) Clipboard D) Styles Ans B Assume data in a cell A1 as 10+300+400. How do you find second occurrence of ‘+’ symbol in 55. cell A1? A) =FIND("+", A1,(FIND("+",A1,1))) B) =FIND("+", A1,1) C) =FIND("+", A1,(FIND("+",A1,1))+1) D) =FIND(A1,(FIND("+",A1,1))) Ans C Predict the output of the given function =SUBSTITUTE("Python Excel Python Excel Python 56. Excel","Python","MS",3). A) MS Excel B) MS MS MS Excel C) Python Excel MS Excel D) Python Excel Python Excel MS Excel Ans D 57. In a __________ reference, either the column letter or the row number is fixed, but not both. A) mixed B) absolute C) relative D) immediate Ans A 58. Among the following which mixed reference will make only row constant? A) $A$1 B) A$1 C) A1 D) $A1 Ans B 59. Referencing the cell of other worksheets is known as _______ referencing. A) Remote B) Mixed C) External D) Relative Ans C The _______ feature in Excel allows you to quickly fill cells with repetitive or sequential data 60. by dragging the fill handle A) AutoSum B) DragFill C) QuickFill D) AutoFill Ans D