Which MS Word option is used to automatically create a table of contents?InsertHomeReviewA) ReferencesThe References tab contains tools for generating a Table of Contents automatically.
Which Excel function counts all non-empty cells?) COUNTA()SUM()AVERAGE()B) COUNTA()COUNTA() counts all cells containing data, including text and numbers.
Which PowerPoint feature is used to move from one slide to another with visual effects?TransitionHyperlinkThemeB) TransitionTransitions create visual effects when changing slides during a presentation.
Which shortcut key is used to open the Find dialog box in MS Word?Ctrl + SCtrl + HCtrl + KA) Ctrl + FCtrl + F opens the Find feature for searching text in a document.
Which Excel function is used to join text from multiple cells?COUNT()MAX()IF()A) CONCAT()CONCAT() combines text from multiple cells into one string.
Which PowerPoint feature ensures a consistent design across all slides?Animation PaneNotes ViewZoomA) Slide MasterSlide Master controls the overall layout and formatting of slides.
Which MS Word feature is used to check spelling and grammar?Track ChangesEditorSmartArtC) EditorThe Editor tool helps identify spelling, grammar, and style issues.
Which Excel function is used to count numeric cells only?COUNTA()SUM()LEN()A) COUNT()COUNT() counts only cells containing numbers.
Which PowerPoint view displays all slides as thumbnails?Slide Sorter ViewNotes ViewOutline ViewB) Slide Sorter ViewSlide Sorter View shows all slides as thumbnails for easy rearrangement.
Which option in MS Word is used to change page orientation?LayoutInsertReviewB) LayoutThe Layout tab contains options for page orientation, margins, and size.
Which Excel function returns the smallest value in a range?SUM()MIN()AVG()C) MIN()MIN() identifies the lowest value from a selected range of cells.
Which PowerPoint feature controls the overall design of slides?ThemeZoomHeaderB) ThemeThemes apply coordinated colors, fonts, and effects across a presentation.
Which MS Word feature is used to create labels and envelopes?MailingsLayoutViewB) MailingsThe Mailings tab contains tools for creating labels, envelopes, and mail merge documents.
Which Excel function returns the largest value in a range?MIN()SUM()COUNT()A) MAX()MAX() identifies the highest value from selected cells.
Which PowerPoint feature allows a presentation to run continuously?Set Up Slide ShowSlide MasterZoomB) Set Up Slide ShowSet Up Slide Show includes options for continuous looping presentations.
Which shortcut key saves the current document?Which shortcut key saves the current document?Ctrl + OCtrl + SCtrl + PC) Ctrl + SCtrl + S is the standard shortcut for saving files.
Which Excel function calculates the average of selected numbers?SUM()AVERAGE()MAX()C) AVERAGE()The AVERAGE() function returns the arithmetic mean of selected values.
Which PowerPoint feature allows movement of objects on a slide?TransitionHeaderThemeA) AnimationAnimations apply motion and effects to objects within slides.
Which MS Word feature is used to create a table of contents automatically?Insert TabHome TabLayout TabA) References TabThe References tab provides tools for creating and updating a Table of Contents.
Which Excel function returns the current date?TODAY()NOWTEXT()YEAR()B) TODAY()The TODAY() function displays the current system date.
Which PowerPoint feature allows slides to appear one after another automatically?Slide TransitionWordArtSmartArtB) Slide TransitionSlide Transition settings control how slides move during presentations.
Which MS Word feature helps track changes made by different users?Track ChangesAutoCorrectSmartArtB) Track ChangesTrack Changes records edits and allows users to review modifications in a document.
Which Excel function counts non-empty cells?COUNTA()MAX()SUM()B) COUNTA()COUNTA() counts all non-empty cells regardless of data type.
Which PowerPoint option is used to duplicate a slide?Duplicate SlideSlide LayoutNew WindowB) Duplicate SlideDuplicate Slide creates an exact copy of the selected slide.
Which MS Word feature creates personalized letters for multiple recipients?AutoCorrectSmartArtWordArtA) Mail MergeMail Merge combines a document with a data source to create personalized letters.
Which Excel chart is best for showing percentages of a wholeLine ChartScatter ChartArea ChartA) Pie ChartA Pie Chart displays how individual parts contribute to a whole.
Which shortcut key starts a slideshow from the beginning in PowerPoint?F1) F7F9A) F5Pressing F5 starts the presentation from the first slide.
Which shortcut key makes selected text italic in MS Word?Ctrl + ICtrl + BCtrl + TB) Ctrl + ICtrl + I applies italic formatting to selected text.
Which Excel feature automatically fills a series of data?AutoCorrectMail MergeSortA) AutoFillAutoFill quickly extends patterns such as numbers, dates, and formulas.
Which PowerPoint feature allows automatic slide movement?Slide Transition TimingHeader & FooterNotes PageB) Slide Transition TimingSlide Transition Timing controls when slides automatically advance.
Which MS Excel function counts cells containing numbers?SUM()AVERAGE()CONCAT()A) COUNT()COUNT() returns the number of cells containing numeric values.
Which tab in MS Word contains the Spelling & Grammar option?InsertLayoutHomeA) ReviewThe Review tab contains proofing tools such as Spelling & Grammar.
What is the default file extension of PowerPoint presentations?.xlsx.docx.pdfA) .pptxPowerPoint presentations are saved with the .pptx extension by default.
Which MS Word feature automatically corrects common typing errors?AutoSaveMail MergeTrack ChangesA) AutoCorrectAutoCorrect automatically fixes predefined spelling and typing mistakes.
Which Excel function is used to find the highest value in a range?COUNT()MAX()SUM()C) MAX()MAX() returns the largest value from a selected range.
Which PowerPoint view is best for rearranging slides?Slide Sorter ViewNotes ViewOutline ViewB) Slide Sorter ViewSlide Sorter View displays all slides together for easy organization.
