Download SimNet Program Ultimate Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which Excel function returns the value in the same row as the lookup value but from a column to its left? A) VLOOKUP B) HLOOKUP C) XLOOKUP D) INDEX-MATCH Answer: D Explanation: INDEX‑MATCH can retrieve values from any column, including those left of the lookup column, unlike VLOOKUP which only searches to the right. Question 2. In Excel, which of the following formulas correctly counts the number of cells in range A2:A100 that contain values greater than 50 and are not blank? A) =COUNTIFS(A2:A100,">50") B) =COUNTIF(A2:A100,">50") C) =COUNTIFS(A2:A100,">50",A2:A100,"<>") D) =SUMPRODUCT(--(A2:A100>50)) Answer: C Explanation: COUNTIFS can apply multiple criteria; the second criterion excludes blanks. Question 3. When creating a data validation list, which setting prevents users from typing values not present in the list? A) Input Message B) Error Alert – Stop C) Ignore Blank D) In‑cell dropdown only Answer: B Explanation: Setting the Error Alert to “Stop” blocks any entry that is not in the list.
Question 4. Which named range reference is absolute and will not change when copied to another cell? A) =Sheet1!A B) =Sheet1!$A$ C) =Sheet1!A$ D) =Sheet1!$A Answer: B Explanation: $ signs before both column and row make the reference fully absolute. Question 5. In Scenario Manager, what does the “Changing cells” box define? A) Cells that display the scenario results B) Cells that hold the scenario names C) Cells whose values will be altered for each scenario D) Cells that are locked during scenario analysis Answer: C Explanation: “Changing cells” are the inputs that Scenario Manager varies to generate different outcomes. Question 6. Which of the following is NOT a valid use of a two‑variable data table? A) Calculating loan payment based on interest rate and term B) Finding break‑even point for price and quantity C) Producing a list of unique values from a single column D) Sensitivity analysis for profit margin and sales volume Answer: C
Explanation: Selection actions are usually recorded, but they do not affect the macro’s functional outcome; however, the macro records formatting, sheet insertion, and formula entry. Question 10. In Word, what is the purpose of a continuous section break? A) To start a new page automatically B) To apply different headers/footers without a page break C) To insert a column break D) To end the document Answer: B Explanation: Continuous section breaks let you change formatting (e.g., columns, headers) within the same page. Question 11. Which style in Word controls the appearance of headings used by the automatic Table of Contents? A) Normal B) Title C) Heading 1, Heading 2, … D) Caption Answer: C Explanation: The built‑in Heading styles are the source levels for the generated Table of Contents. Question 12. To create a bibliography in APA style, which Word feature must you use? A) SmartArt B) References → Insert Bibliography C) Mail Merge D) Track Changes
Answer: B Explanation: The References tab provides tools for citations and bibliographies, including APA formatting. Question 13. In a mail merge, which file type is commonly used as the data source for recipient information? A) .docx B) .pdf C) .xlsx or .csv D) .pptx Answer: C Explanation: Excel workbooks or CSV files supply the list of fields (e.g., names, addresses) for a mail merge. Question 14. In Access, which field property ensures that each record has a unique identifier automatically generated? A) Validation Rule B) Input Mask C) AutoNumber (Primary Key) D) Lookup Wizard Answer: C Explanation: An AutoNumber field set as the primary key guarantees uniqueness for each record. Question 15. What does enforcing referential integrity between two tables prevent? A) Duplicate records in the child table
Answer: A Explanation: Nested IFs require each FALSE result to be another IF function; option A follows this syntax. Question 19. In Word, which view best displays the document’s page layout, including margins and columns? A) Draft View B) Print Layout View C) Outline View D) Web Layout View Answer: B Explanation: Print Layout shows the document exactly as it will appear when printed, with all layout elements. Question 20. When defining a relationship in Access, what does “Cascade Delete” do? A) Prevents deletion of related records B) Deletes child records automatically when a parent is deleted C) Locks related tables from editing D) Copies parent records to child tables Answer: B Explanation: Cascade Delete propagates the delete action from the primary (parent) to related foreign (child) records. Question 21. Which Excel function can be used to calculate the average of values that meet multiple criteria? A) AVERAGEIF B) AVERAGEIFS C) SUMIF
D) COUNTIFS
Answer: B Explanation: AVERAGEIFS allows averaging with more than one condition, analogous to SUMIFS and COUNTIFS. Question 22. What is the effect of applying a “Group By” operation in a PivotTable? A) It creates a new calculated field B) It sorts the data alphabetically C) It aggregates data at a higher level (e.g., months) D) It filters out duplicate rows Answer: C Explanation: Grouping combines items (e.g., dates into months) so the PivotTable summarizes at that level. Question 23. In Word, which field code inserts the current page number? A) { DATE } B) { PAGE } C) { NUMPAGES } D) { TIME } Answer: B Explanation: { PAGE } displays the number of the page on which it appears. Question 24. Which Access data type is best for storing monetary values with currency symbols? A) Number B) Currency C) Text
C) Keeps the selected paragraph on the same page as the following paragraph D) Adds a page break after the paragraph Answer: C Explanation: “Keep with next” ensures the current paragraph stays together with the one that follows, avoiding unwanted page breaks. Question 28. Which Access object stores the layout of a form, including controls and their properties? A) Table B) Query C) Report D) Form module Answer: D Explanation: The form object includes design elements; the module holds VBA code, while the form itself defines layout. Question 29. In Excel, which function returns the number of working days between two dates, excluding weekends and specified holidays? A) NETWORKDAYS B) WORKDAY C) DAYS D) WEEKNUM Answer: A Explanation: NETWORKDAYS calculates business days between dates, optionally excluding a list of holidays.
Question 30. When creating a macro that records formatting changes, which setting should you adjust to ensure the macro works on any workbook? A) Use relative references B) Use absolute references only C) Record in the Personal Macro Workbook only D) Enable “Use VBA Project” option Answer: A Explanation: Relative references make the macro act on the active cell or selection regardless of the workbook. Question 31. Which Word feature allows you to automatically number headings and preserve hierarchy (e.g., 1., 1.1, 1.1.1)? A) Bullets and Numbering B) Multilevel List C) Table of Contents D) Caption Answer: B Explanation: Multilevel lists provide hierarchical numbering that updates as headings change. Question 32. In Access, which join type returns all records from the left table and matching records from the right table? A) Inner Join B) Left Outer Join C) Right Outer Join D) Full Outer Join Answer: B
Answer: B Explanation: Input masks define the required format for data entry (e.g., (999) 000‑0000 for phone numbers). Question 36. In Excel, which option under “File → Options → Formulas” enables iterative calculations? A) Enable multi‑threaded calculation B) Enable iterative calculation C) Use table names in formulas D) Enable automatic calculation Answer: B Explanation: Turning on iterative calculation allows formulas that refer to themselves to converge. Question 37. Which Word field code inserts the total number of pages in the document? A) { PAGE } B) { SECTIONPAGES } C) { NUMPAGES } D) { DOCVARIABLE } Answer: C Explanation: { NUMPAGES } displays the total page count. Question 38. In Access, which data type should be used for storing large blocks of text (e.g., product descriptions) that may exceed 255 characters? A) Text B) Memo (Long Text) C) Char
D) Byte Answer: B Explanation: The Memo/Long Text type allows storage of up to 65,535 characters, unlike Text which is limited to 255. Question 39. Which Excel function can be used to return the nth largest value in a range? A) LARGE B) MAX C) SMALL D) RANK Answer: A Explanation: LARGE(range, n) returns the nth largest numeric value. Question 40. When applying a slicer to a PivotTable, which of the following is true? A) Slicers can only be used with OLAP data sources B) Slicers automatically create a chart C) Multiple slicers can be linked to the same PivotTable for different fields D) Slicers replace the need for row labels Answer: C Explanation: You can add several slicers, each filtering a different field of the same PivotTable. Question 41. In Word, which command inserts a cross‑reference to a figure number that updates automatically when the figure is renumbered? A) Insert → Bookmark B) Insert → Cross‑Reference C) References → Table of Figures
D) No spacing before/after Answer: A Explanation: “Keep lines together” stops a single line of a paragraph from being left alone at the top or bottom of a page. Question 45. In Access, which property of a relationship defines what happens when a related primary‑key record is deleted? A) Cascade Delete B) Referential Integrity C) Join Type D) Indexed Answer: A Explanation: The Cascade Delete option propagates deletions from parent to child tables. Question 46. Which Excel function can be used to return the column number of a specified cell reference? A) ROW B) COLUMNS C) COLUMN D) ADDRESS Answer: C Explanation: COLUMN(reference) returns the column index number. Question 47. In Word, which view is most suitable for editing long documents structured by headings? A) Draft View B) Print Layout View
C) Outline View D) Web Layout View Answer: C Explanation: Outline View displays the document hierarchy, making it easy to rearrange sections. Question 48. Which Access feature lets you automatically fill a form field with the current date when a new record is created? A) Default Value property set to Date() B) Validation Rule set to Today() C) Input Mask of ##/##/#### D) Lookup Wizard to a Date table Answer: A Explanation: Setting the Default Value to the Date() function inserts today’s date for each new record. Question 49. In Excel, which function returns the rank of a number within a list, with ties assigned the same rank? A) RANK.EQ B) RANK.AVG C) LARGE D) SMALL Answer: A Explanation: RANK.EQ provides the rank, giving the same rank to identical numbers. Question 50. Which Word feature allows you to automatically insert a bibliography entry for a source you have cited? A) Insert → Footnote
A) Adding page numbers B) Creating a table of contents C) Numbering figures, tables, or equations for cross‑reference D) Setting document margins Answer: C Explanation: Captions provide numbered labels that can be referenced elsewhere. Question 54. Which Access property determines whether a text field can store up to 255 characters? A) Field Size set to “Text” B) Data Type set to “Short Text” with a length of 255 C) Validation Rule set to Len([Field])≤ D) Input Mask set to 255 characters Answer: B Explanation: Short Text (formerly Text) allows up to 255 characters; the length is defined in the field property. Question 55. In Excel, what is the result of the formula =IFERROR(VLOOKUP(5,A1:B10,2,FALSE),"Not found") when the lookup fails? A) #N/A error B) 0 C) "Not found" D) Blank cell Answer: C Explanation: IFERROR catches any error (including #N/A) and returns the specified alternative text.
Question 56. Which Word option controls the default spacing after a paragraph style? A) Indentation B) Line spacing C) Space After (in the Paragraph dialog) D) Tab stops Answer: C Explanation: “Space After” defines the vertical distance following a paragraph. Question 57. In Access, which macro action is used to open a form in dialog mode? A) OpenForm with WindowMode = Dialog B) RunCommand = acCmdOpenForm C) DoCmd.OpenReport D) DoCmd.OpenTable Answer: A Explanation: The OpenForm action includes the WindowMode argument; setting it to Dialog opens the form as a modal dialog. Question 58. Which Excel function can be used to return the number of characters in cell D5, excluding leading and trailing spaces? A) LEN(D5) B) TRIM(D5) C) LEN(TRIM(D5)) D) CLEAN(D5) Answer: C Explanation: TRIM removes extra spaces; wrapping LEN around it gives the character count without those spaces.
