Download TOSA Desktop Practice Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which ribbon tab in Microsoft Word contains the “Track Changes” command? A) Home B) Review C) Insert D) Layout Answer: B Explanation: The “Track Changes” feature is located on the Review tab, which groups editing and proofing tools. Question 2. In Excel, which keyboard shortcut inserts the current date without the time? A) Ctrl + ; B) Ctrl + Shift + ; C) Alt + D D) Ctrl + Alt + D Answer: A Explanation: Pressing Ctrl + ; inserts the system’s current date; Ctrl + Shift + ; inserts the current time. Question 3. What view in PowerPoint shows a thumbnail of each slide in a vertical pane? A) Slide Sorter B) Reading View C) Normal View D) Outline View Answer: C Explanation: Normal view displays the slide pane on the left and the current slide in the main area.
Question 4. Which file format preserves all formatting and allows editing in Microsoft Word but prevents macro execution? A) .docx B) .docm C) .pdf D) .rtf Answer: A Explanation: .docx files store all Word formatting and content but do not support macros; .docm does. Question 5. In Excel, what does the dollar sign ($) before a column letter indicate? A) Relative reference B) Absolute column reference C) Mixed reference D) Named range Answer: B Explanation: $ before a column letter locks the column when copying formulas, creating an absolute column reference. Question 6. Which function returns the number of cells that contain numbers in a range? A) COUNT B) COUNTA C) COUNTIF D) COUNTBLANK Answer: A Explanation: COUNT counts only numeric entries; COUNTA counts all non‑empty cells.
Explanation: VLOOKUP searches vertically in the first column and returns a value from a specified column. Question 10. Which shortcut opens the “Find and Replace” dialog in Word? A) Ctrl + F B) Ctrl + H C) Ctrl + Shift + F D) Alt + Ctrl + F Answer: B Explanation: Ctrl + H opens the Find and Replace window, while Ctrl + F only opens Find. Question 11. In PowerPoint, what does the “Slide Master” allow you to control? A) Slide transitions only B) Individual slide animations C) Global layout, fonts, and placeholders for all slides D) Slide sorter order Answer: C Explanation: The Slide Master defines common elements (fonts, colors, placeholders) applied to all slides using that master. Question 12. Which Excel feature creates a summary table that can automatically group, filter, and calculate data? A) Table B) PivotTable C) Subtotal D) Data Validation Answer: B
Explanation: PivotTables provide dynamic aggregation, grouping, and filtering of large data sets. Question 13. In Word, what does the “Read Mode” view prioritize? A) Editing tools B) Page layout accuracy C) Screen‑friendly reading with minimal distractions D) Print preview Answer: C Explanation: Read Mode reformats the document for comfortable on‑screen reading and hides most editing commands. Question 14. Which function returns the position of a value within a one‑dimensional array? A) VLOOKUP B) MATCH C) INDEX D) OFFSET Answer: B Explanation: MATCH returns the relative position of a lookup value in a range. Question 15. To protect an Excel workbook with a password that prevents opening the file, you should use which command? A) Review → Protect Sheet B) File → Info → Protect Workbook → Encrypt with Password C) Review → Protect Workbook D) File → Save As → Tools → General Options Answer: B
D) Styles Answer: B Explanation: Multilevel List creates numbered or bulleted outlines with indent‑based hierarchy. Question 19. In Excel, what does the “Goal Seek” tool do? A) Finds the maximum value in a range B) Changes a single input value to achieve a desired result in a formula C) Generates random numbers D) Creates a scenario manager Answer: B Explanation: Goal Seek iteratively adjusts a specified cell to reach a target value for another formula cell. Question 20. Which shortcut inserts a new slide in PowerPoint using the default layout? A) Ctrl + M B) Ctrl + N C) Shift + Enter D) Alt + I, S Answer: A Explanation: Ctrl + M adds a new slide with the current default layout. Question 21. In Outlook, which feature lets you automatically move incoming messages that meet certain criteria to a specific folder? A) Quick Steps B) Rules C) Categories D) Flags
Answer: B Explanation: Rules can be defined to filter, move, or perform actions on incoming mail based on conditions. Question 22. Which Excel function returns the largest value in a range that meets a given condition? A) MAX B) LARGE C) MAXIF (not native) D) MAXIFS Answer: D Explanation: MAXIFS (available in newer Excel versions) returns the maximum value that satisfies one or more criteria. Question 23. In Word, what does the “Format Painter” tool do? A) Copies text formatting from one selection and applies it to another B) Paints background colors on a page C) Converts text to a graphic D) Highlights spelling errors Answer: A Explanation: Format Painter copies the formatting (font, style, etc.) of selected text and applies it elsewhere. Question 24. Which view in Excel displays the workbook’s structure as a hierarchy of sheets? A) Page Layout view B) Normal view
B) Browse headings, pages, and search results C) Change page margins D) Apply themes Answer: B Explanation: The Navigation Pane provides quick access to document headings, pages, and search results. Question 28. Which file extension indicates a PowerPoint presentation that can contain macros? A) .pptx B) .pptm C) .ppt D) .ppsx Answer: B Explanation: .pptm files are macro‑enabled PowerPoint presentations; .pptx does not allow macros. Question 29. In Excel, which tool helps you identify duplicate values in a column? A) Conditional Formatting → Highlight Cells Rules → Duplicate Values B) Data Validation → List C) Sort → Descending D) Filter → Advanced Answer: A Explanation: Conditional Formatting can highlight duplicate entries automatically. Question 30. Which Outlook feature lets you schedule an email to be sent at a later time? A) Delay Delivery (Options)
B) Recall Message C) Mark as Unread D) Flag for Follow‑up Answer: A Explanation: The Delay Delivery option (or “Send Later” in newer versions) postpones sending until the specified time. Question 31. In Word, what does the “Replace with” field do in the Find and Replace dialog? A) Deletes the found text B) Inserts the specified text in place of the found text C) Highlights the found text D) Moves the cursor to the next occurrence Answer: B Explanation: “Replace with” defines the new text to substitute for each occurrence of the searched string. Question 32. Which Excel function counts the number of cells that meet a single condition? A) COUNTIF B) COUNTIFS C) SUMIF D) AVERAGEIF Answer: A Explanation: COUNTIF applies a single criterion to count matching cells. Question 33. In PowerPoint, which view lets you reorder slides by dragging them? A) Slide Sorter
C) To‑Do Bar D) Ribbon Answer: B Explanation: The Navigation Pane (left side) contains shortcuts to Mail, Calendar, People, Tasks, etc. Question 37. Which Word style is typically used for the main document title? A) Heading 1 B) Title C) Normal D) Heading 2 Answer: B Explanation: The “Title” style is designed for the primary document title, distinct from heading levels. Question 38. In Excel, what does the “Subtotal” feature do? A) Adds a total row at the bottom of the sheet automatically B) Inserts subtotal rows for each group based on a chosen column C) Calculates the sum of visible cells only D) Generates a pivot table automatically Answer: B Explanation: Subtotal groups data by a field and inserts subtotal rows for each group. Question 39. Which PowerPoint animation option allows you to trigger an effect “On Click” of a specific object? A) Start → With Previous B) Start → After Previous
C) Start → On Click D) Start → Auto Answer: C Explanation: “On Click” starts the animation when the user clicks the selected object. Question 40. In Google Docs, which menu contains the option to “Suggest” edits rather than directly editing? A) File B: Edit C) View D) Tools Answer: B Explanation: The “Suggesting” mode is toggled from the Edit menu (or toolbar) to propose changes. Question 41. Which Excel function returns the number of characters in a text string? A) LEN B) LEFT C) MID D) TEXTLEN (not native) Answer: A Explanation: LEN calculates the length of a string, counting all characters including spaces. Question 42. In Word, what does the “Insert Caption” command do? A) Adds a footnote B) Inserts a label and number for figures, tables, or equations C) Creates a text box
D) Reading View Answer: C Explanation: Presenter View shows the current slide, speaker notes, and a preview of the next slide. Question 46. In Word, which option inserts a non‑breaking space that prevents line breaks at that position? A) Ctrl + Space B) Ctrl + Shift + Space C) Alt + Space D) Shift + Space Answer: B Explanation: Ctrl + Shift + Space inserts a non‑breaking space (Unicode U+00A0). Question 47. Which Excel feature allows you to limit entries in a cell to a predefined list? A) Conditional Formatting B) Data Validation → List C) Filter → List D) Protect Sheet → Allow List Answer: B Explanation: Data Validation with the List option restricts input to the items you specify. Question 48. In Outlook, which icon indicates that a message has been marked for follow‑up? A) Flag B) Star C) Envelope
D) Exclamation point Answer: A Explanation: A flag symbol denotes a message flagged for follow‑up. Question 49. Which Word command creates a table of contents automatically from heading styles? A) Insert → Table of Contents B) References → Table of Contents C) Layout → Table of Contents D) Review → Table of Contents Answer: B Explanation: The Table of Contents feature resides under the References tab and builds the list from heading styles. Question 50. In Excel, which function returns the average of a range, ignoring hidden rows? A) AVERAGE B) SUBTOTAL with function_num = 101 C) AGGREGATE with option = 3 D) AVERAGEIF Answer: B Explanation: SUBTOTAL with 101 calculates the average while ignoring manually hidden rows. Question 51. Which PowerPoint shortcut starts a slideshow from the current slide? A) F B) Shift + F C) Alt + S D) Ctrl + F
Explanation: Recall tries to remove an unread message from the recipient’s mailbox, but success depends on settings. Question 55. Which Word feature automatically updates the page numbers in a Table of Contents after changes? A) Refresh Field (F9) B) Update Document C) Recalculate Index D) Sync Table Answer: A Explanation: Pressing F9 on the TOC field refreshes it, updating page numbers. Question 56. In Excel, which function can be used to extract the year from a date value? A) YEAR B) DATEPART C) MONTH D) DAY Answer: A Explanation: YEAR(serial_number) returns the year portion of a date. Question 57. Which PowerPoint feature lets you apply a consistent set of colors, fonts, and effects to a presentation? A) Design Themes B) Slide Layouts C) Master Slides D) Animation Pane Answer: A
Explanation: Design Themes define a cohesive visual style across the entire deck. Question 58. In Word, which command inserts a cross‑reference to a numbered item such as a figure or heading? A) Insert → Reference → Cross‑Reference B) References → Table of Contents → Cross‑Reference C) Layout → Cross‑Reference D) Review → Cross‑Reference Answer: A Explanation: The Cross‑Reference dialog allows linking to headings, figures, tables, etc. Question 59. In Excel, what does the “#REF!” error indicate? A) Division by zero B) Invalid cell reference, often after deleting referenced cells C) Text in a numeric formula D) Circular reference Answer: B Explanation: #REF! appears when a formula refers to a cell that no longer exists. Question 60. Which Outlook view displays email messages grouped by conversation threads? A) Compact B) Single C) Conversation D) List Answer: C Explanation: Conversation view groups related messages into a single expandable thread.
