Download SIMnet Group 9 Ultimate Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which Excel function returns the future value of an investment based on periodic, constant payments and a constant interest rate? A) PMT B) FV C) NPER D) PV Answer: B Explanation: The FV function calculates the future value of an investment given periodic payments, interest rate, and number of periods. Question 2. In Excel, which function would you use to test multiple conditions and return different results without nesting several IF statements? A) VLOOKUP B) IFS C) CHOOSE D) SWITCH Answer: B Explanation: IFS evaluates multiple conditions sequentially and returns the corresponding value for the first TRUE condition, simplifying complex IF logic. Question 3. What does the INDEX function return when used with MATCH? A) The position of a value in a range B) The value at a specific row and column in a range C) The sum of a column D) A Boolean result Answer: B Explanation: INDEX retrieves a value from a table based on row and column numbers; combined with MATCH, it can perform flexible lookups. Question 4. Which of the following is NOT a valid argument for the COUNTIFS function?
A) Criteria_range B) Criteria C) Sum_range D) Criteria_range Answer: C Explanation: COUNTIFS counts cells meeting multiple criteria; it does not accept a sum_range argument—that belongs to SUMIFS. Question 5. When creating an Excel Table, which feature automatically expands the table when new data is added directly below it? A) Structured References B) AutoFill C) Table AutoExpansion D) Data Validation Answer: C Explanation: Excel Tables have an AutoExpansion feature that automatically includes adjacent rows added below the table. Question 6. Which of the following sorting options lets you sort data based on more than one column at the same time? A) Simple Sort B) Custom Sort C) Filter Sort D) Quick Sort Answer: B Explanation: Custom Sort allows you to define multiple levels (e.g., first by Region, then by Sales) for hierarchical sorting. Question 7. In Data Validation, which setting creates a drop‑down list that restricts entries to predefined items? A) Whole number
D) Solver Answer: B Explanation: Goal Seek iteratively changes a single input cell to reach a target result in another cell. Question 11. In Excel’s Scenario Manager, what does a “changing cell” refer to? A) The cell that displays the result of the scenario B) The cell that holds the scenario name C) The cell whose values are altered for each scenario D) The cell containing a formula Answer: C Explanation: Changing cells are those that you modify for each scenario, allowing comparison of different outcomes. Question 12. Which function would you use to calculate the number of periods required to pay off a loan, given payment amount, interest rate, and loan amount? A) NPER B) PMT C) RATE D) PV Answer: A Explanation: NPER returns the number of periods for an investment or loan based on periodic payment, rate, and present value. Question 13. When you apply a conditional format that highlights cells greater than the average, which type of rule is being used? A) Data Bar B) Color Scale C) Icon Set D) Formula‑based rule Answer: D
Explanation: A formula‑based conditional format can compare each cell to the AVERAGE of the range and apply formatting when true. Question 14. Which of the following statements about VLOOKUP is FALSE? A) VLOOKUP can search horizontally if you use the fourth argument FALSE. B) VLOOKUP requires the lookup column to be the leftmost column of the table array. C) VLOOKUP can return a value from a column to the left of the lookup column using a negative column index. D) VLOOKUP can perform an exact match when the range_lookup argument is FALSE. Answer: C Explanation: VLOOKUP cannot retrieve data from a column left of the lookup column; you would need INDEX/MATCH for that. Question 15. Which Excel feature allows you to create a dynamic range that automatically expands as new data is added? A) Named Range with OFFSET B) Table C) Data Validation List D) Freeze Panes Answer: B Explanation: Converting a range to an Excel Table creates a dynamic named range that expands with added rows. Question 16. In a pivot chart, which element represents the underlying pivot table data? A) Chart Area B) Plot Area C) Data Series D) Axis Labels Answer: C Explanation: Data series in a pivot chart are directly linked to the pivot table’s summarized data.
Question 20. When you use the SUMIFS function, why must the criteria_range arguments be the same size as the sum_range? A) To ensure correct calculation of averages. B) To avoid circular references. C) Because Excel matches each cell position across ranges. D) It is not required; they can differ. Answer: C Explanation: SUMIFS adds values from sum_range where corresponding cells in each criteria_range meet the condition; mismatched sizes would misalign the criteria. Question 21. Which Excel feature allows you to quickly generate a list of unique values from a column? A) Remove Duplicates B) Advanced Filter – Unique records only C) Conditional Formatting – Duplicate Values D) Data Validation – List Answer: B Explanation: The Advanced Filter with “Unique records only” extracts distinct entries without altering the original data. Question 22. In Excel, which function would you use to calculate the internal rate of return for a series of cash flows? A) XIRR B) IRR C) RATE D) NPV Answer: B Explanation: IRR computes the rate that makes the net present value of cash flows equal to zero. Question 23. What does the “Refresh All” command do in a workbook containing multiple data connections?
A) Saves the workbook. B) Updates all linked external data sources. C) Recalculates all formulas only. D) Clears all filters. Answer: B Explanation: Refresh All updates all external data connections, PivotTables, and queries to bring in the latest data. Question 24. Which of the following best describes a “structured reference” in an Excel Table? A) A reference to a cell using its absolute address. B) A reference that uses table and column names instead of cell addresses. C) A reference that automatically creates a chart. D) A reference that locks the cell during editing. Answer: B Explanation: Structured references use the table name and column headers, making formulas easier to read and maintain. Question 25. What is the result of the formula =AND(TRUE,FALSE,TRUE)? A) TRUE B) FALSE C) #VALUE! D) #NAME? Answer: B Explanation: AND returns TRUE only if all arguments are TRUE; because one argument is FALSE, the result is FALSE. Question 26. Which Excel feature allows you to lock specific cells while permitting editing of others? A) Protect Sheet with unlocked cells B) Hide Columns
D) No filter; slicers cannot be used with dates. Answer: C Explanation: Excel automatically creates a date hierarchy for slicers on date fields, allowing selection by years, quarters, months, etc. Question 30. Which of the following is NOT a valid use of the IFERROR function? A) Suppressing #DIV/0! errors. B) Replacing errors with a custom message. C) Detecting circular references. D) Providing an alternate calculation when a formula errors. Answer: C Explanation: IFERROR cannot detect circular references; those produce a #REF! error that cannot be trapped by IFERROR. Question 31. In Excel, which chart type is most appropriate for showing the distribution of a single continuous variable? A) Column Chart B) Pie Chart C) Histogram D) Scatter Plot Answer: C Explanation: A histogram groups continuous data into bins, displaying frequency distribution. Question 32. Which function would you use to return the position of a specific text string within another text string? A) SEARCH B) FIND C) MATCH D) INDEX Answer: A
Explanation: SEARCH returns the starting position of a substring, ignoring case; FIND does the same but is case‑sensitive. Question 33. What does the “Allow editing directly in cells” option control in a protected worksheet? A) Whether users can edit any cell at all. B) Whether users can edit only unlocked cells. C) Whether users can edit cells without double‑clicking. D) Whether users can edit cells that contain formulas. Answer: B Explanation: When a sheet is protected, only cells that are unlocked can be edited; this option toggles that behavior. Question 34. Which of the following is the correct way to write a VLOOKUP that performs an approximate match? A) VLOOKUP(lookup_value, table_array, col_index_num, FALSE) B) VLOOKUP(lookup_value, table_array, col_index_num, TRUE) C) VLOOKUP(lookup_value, table_array, col_index_num) D) VLOOKUP(lookup_value, table_array, col_index_num, 0) Answer: B Explanation: Setting the range_lookup argument to TRUE (or omitting it) tells VLOOKUP to use an approximate match. Question 35. Which Excel feature can you use to automatically split a column of full names into first and last names? A) Text to Columns B) Flash Fill C) CONCATENATE D) Data Validation Answer: B
Question 39. When you create a Data Table (two‑variable) for sensitivity analysis, which of the following is required? A) A single input cell only. B) Two input cells – one for row input and one for column input. C) No input cells; the table works independently. D) A macro to generate the table. Answer: B Explanation: Two‑variable data tables need a row input cell and a column input cell to vary two parameters simultaneously. Question 40. Which of the following best describes the purpose of the “Goal Seek” feature? A) To calculate the future value of an investment. B) To find the input that produces a desired result in a formula. C) To generate multiple scenarios automatically. D) To protect a worksheet from changes. Answer: B Explanation: Goal Seek iteratively changes a single input to achieve a target value in another cell. Question 41. In Microsoft Word, which style hierarchy is automatically used to generate a Table of Contents? A) All styles that start with “Heading”. B) Only the Normal style. C) Custom styles marked as TOC entries. D) Any style with the “List” attribute. Answer: A Explanation: Word’s default TOC pulls entries from styles named Heading 1, Heading 2, etc., unless customized. Question 42. Which command inserts a non‑breaking space in a Word document?
A) Ctrl + Space B) Ctrl + Shift + Space C) Alt + 0160 D) Alt + Enter Answer: B Explanation: Ctrl + Shift + Space inserts a non‑breaking space, preventing line breaks at that point. Question 43. When you apply a “Mirror Margins” setting in Word, what effect does it have? A) It flips the page orientation from portrait to landscape. B) It creates symmetrical inner and outer margins for double‑sided printing. C) It reverses the text direction from left‑to‑right to right‑to‑left. D) It adds a gutter on the left side only. Answer: B Explanation: Mirror margins set wider inside margins (gutter) for binding and equal outer margins, ideal for book layouts. Question 44. Which of the following Word features allows you to automatically update a field that displays the current page number? A) Bookmark B) Cross‑Reference C) Page Number field (Insert > Page Number) D) Caption Answer: C Explanation: Inserting a Page Number field automatically updates as pages are added or removed. Question 45. In Word, what is the purpose of the “Restrict Editing” pane? A) To lock the entire document from opening. B) To allow only specific types of changes (e.g., filling in forms) by other users. C) To apply a password that encrypts the file.
Answer: B Explanation: Mail merge requires a main document containing merge fields that will be populated with data from the data source. Question 49. Which of the following is the correct sequence to compare two Word documents? A) Review > Compare > Combine Documents B) Review > Combine > Compare Documents C) Review > Compare > Compare Documents D) File > Info > Version History Answer: C Explanation: The Compare feature is accessed via Review > Compare > Compare Documents, allowing side‑by‑side differences. Question 50. In Word, what does the “SmartArt” feature primarily provide? A) Automated table of contents generation. B) Visual diagrams such as process flows, hierarchies, and lists. C) Advanced mail merge capabilities. D) Real‑time collaboration with multiple authors. Answer: B Explanation: SmartArt inserts pre‑designed graphics for illustrating concepts like processes, cycles, and hierarchies. Question 51. Which Word option lets you wrap text tightly around an inserted picture? A) In Line with Text B) Square C) Behind Text D) Top and Bottom Answer: B Explanation: The Square wrap style makes text flow around the rectangular bounds of the picture, creating a tight layout.
Question 52. When you add a digital signature to a Word document, what does it primarily ensure? A) The document cannot be printed. B) The document’s content has not been altered since signing. C) The document is automatically saved to OneDrive. D) The document’s font changes to a protected style. Answer: B Explanation: A digital signature creates a cryptographic hash of the document, detecting any modifications after signing. Question 53. Which of the following is NOT a valid way to insert a caption for a figure in Word? A) References > Insert Caption B) Right‑click the picture > Insert Caption C) Home > Paragraph > Caption D) Using the “Insert Caption” dialog box Answer: C Explanation: The Home tab’s Paragraph group does not contain a Caption command; captions are added via the References tab or context menu. Question 54. In Word, which view allows you to see how your document will appear when printed, including margins and page breaks? A) Draft View B) Web Layout C) Print Layout D) Outline View Answer: C Explanation: Print Layout visualizes the final printed page, showing margins, headers/footers, and page breaks. Question 55. What is the effect of applying a “Section Break (Next Page)” in a Word document?
B) Theme C) Animation Pane D) Slide Sorter Answer: B Explanation: A Theme defines a unified visual style (colors, fonts, effects) applied to all slides. Question 59. What does the “Morph” transition do between two slides? A) It fades one slide into another. B) It animates objects from their position on the first slide to their new position on the second slide. C) It flips the slide horizontally. D) It adds a 3‑D rotation effect. Answer: B Explanation: Morph creates a smooth animation by matching objects across slides and moving them accordingly. Question 60. Which of the following actions will embed an Excel chart into a PowerPoint slide rather than linking it? A) Copy > Paste > Use Destination Styles B) Copy > Paste > Link & Keep Source Formatting C) Copy > Paste > Keep Source Formatting D) Copy > Paste > Picture (Enhanced Metafile) Answer: C Explanation: Pasting with “Keep Source Formatting” embeds the chart; linking would use “Link & Keep Source Formatting”. Question 61. In PowerPoint, what is the purpose of a “Custom Slide Show”? A) To create a separate file with selected slides. B) To define a sequence of slides that differs from the main presentation order. C) To export slides as a video. D) To lock the slide order for collaboration.
Answer: B Explanation: Custom Slide Shows let you choose a subset and order of slides for a specific audience without altering the main deck. Question 62. Which animation trigger option makes an object animate only when another specific object is clicked? A) On Click B) With Previous C) After Previous D) On Click of (specific object) Answer: D Explanation: The “On Click of” trigger ties the animation to a different object’s click event. Question 63. Which of the following file formats preserves all PowerPoint animations and transitions when sharing with others? A) PDF B) PPTX C) PPSX D) MP Answer: B Explanation: PPTX retains all editable content, including animations and transitions; PDF and MP4 flatten the presentation. Question 64. When you insert a video clip into a slide, which playback option ensures the video starts automatically when the slide appears? A) On Click B) Automatically C) Play Across Slides D) Loop Until Stopped Answer: B
