Mock Examination ACCA ADCA ACCA 0% 12345678910111213141516171819202122232425 ACCA Mock Test Final Semester Examination Total Questions: 50 Full Marks: 100 (50 x 2) Time: 60 Minutes 1 / 25 Category: Computer Fundamentals 1) Which of the following is an application of AI? Internet browsing Word processing software Spreadsheet management Self-driving cars 2 / 25 Category: Computer Fundamentals 2) Basic architecture of computer was developed by Charls Babbage Steve Jobes Thomas Adison John Von Neumann 3 / 25 Category: Computer Fundamentals 3) The basic operations performed by a computer are: Input, Output, and Storage Data entry, Data process, Data output Input, Processing, Output, and Storage Data entry, Data analysis, Data output 4 / 25 Category: Computer Fundamentals 4) Which of the following is an output device? Keyboard Printer Mouse Mouse 5 / 25 Category: Computer Fundamentals 5) What is the name of this component? RAM CPU SSD ROM 6 / 25 Category: MS Word 6) In Word, how can you change the document orientation? Design > Page Setup Layout > Orientation View > Orientation Insert > Orientation 7 / 25 Category: MS Word 7) How do you close a Word document without exiting the Word application? CTRL + N Click File > Close Click the 'X' in the top-right corner Press Ctrl + W 8 / 25 Category: MS Word 8) What is the default page margin in Microsoft Word? 1.25 inch on all sides 0.5 inch on all sides 1 inch on all sides 1.5 inch on all sides 9 / 25 Category: MS Word 9) In Word, what is the purpose of ‘Track Changes’? To keep track of document versions To track the word count To track document edits and revisions To track hyperlinks 10 / 25 Category: MS Word 10) In Word, which view displays the document as it would appear when printed? Print Layout Outline Draft Web Layout 11 / 25 Category: MS Excel 11) Which option allows you to protect a worksheet? Home > Format Review > Protect Sheet View > Protection Data > Protect 12 / 25 Category: MS Excel 12) What will the COUNTIF function return? Count of blank cells Count of all cells Count of cells meeting a specific criterion Total of numeric cells 13 / 25 Category: MS Excel 13) Which function returns the current date? NOW() DATE() TIMESTAMP() TODAY() 14 / 25 Category: MS Excel 14) Which Excel feature allows you to visually analyze data? Conditional Formatting Data Validation Filtering Sorting 15 / 25 Category: MS Excel 15) Which function would you use to find the highest value in a range? TOP LARGE HIGH MAX 16 / 25 Category: MS Excel 16) What does the SUMIF function do? Adds all values in a range Adds values based on a specific condition Finds the minimum value in a range Counts all values in a range 17 / 25 Category: MS Excel 17) What feature allows you to repeat column titles on every printed page? Print Titles Page Layout Print Area Header/Footer 18 / 25 Category: MS Excel 18) What is the shortcut for inserting a new worksheet? Shift + F11 Alt + N Ctrl + N Ctrl + W 19 / 25 Category: MS Excel 19) What does the ‘Ctrl + Z’ shortcut do in Excel? Undoes the last action Saves the workbook Closes the workbook Redoes the last action 20 / 25 Category: MS Excel 20) Which function calculates the average of a range of cells? MEDIAN COUNT AVERAGE SUM 21 / 25 Category: MS PowerPoint 21) How do you start a slide show from the current slide? Click Slide Show > From Beginning Press Shift + F5 Click Slide Show > Start Press F5 22 / 25 Category: MS PowerPoint 22) Which of the following is not a type of transition in PowerPoint? Fly In Fade Zoom In Wipe 23 / 25 Category: MS PowerPoint 23) Which of the following is a method to add a transition effect in PowerPoint? Slide Show > Transitions Animations > Transitions Home > Transitions Design > Transitions 24 / 25 Category: MS PowerPoint 24) What is the default slide layout in PowerPoint? Blank Title and Content Title Slide Section Header 25 / 25 Category: MS PowerPoint 25) Which option allows you to change the orientation of your slides in PowerPoint? Design > Slide Orientation Home > Slide Orientation View > Orientation File > Page Setup Your score isThe average score is 0% 0% Restart quiz Anonymous feedback Send feedback ADCA 0% Mock Test ADCA Final Semester Examination Total Questions: 50 Full Marks: 100 (50 x 2) Time: 60 Minutes 1 / 50 Category: Computer Fundamentals 1) The basic operations performed by a computer are: Data entry, Data process, Data output Input, Processing, Output, and Storage Data entry, Data analysis, Data output Input, Output, and Storage 2 / 50 Category: Computer Fundamentals 2) Which of the following is not a characteristic of a computer? Diligence Versatility IQ Accuracy 3 / 50 Category: Computer Fundamentals 3) Identify this computer component Cabinate CPU Black Box Computer 4 / 50 Category: Computer Fundamentals 4) What does the acronym ‘LAN’ stand for? Long Area Network Large Access Network Local Access Network Local Area Network 5 / 50 Category: Computer Fundamentals 5) Microsoft windows 11 is an example of computer application software. True False 6 / 50 Category: MS Word 6) Which tab would you use to add pictures to your document? View Layout Design Insert 7 / 50 Category: MS Word 7) What does the ‘Undo’ button do in Microsoft Word? Redo the last action Save the document Cancel the last action Open the document 8 / 50 Category: MS Word 8) What does the ‘Find and Replace’ feature do? Finds and deletes text Finds and formats text Finds and replaces text in the document Finds all hyperlinks 9 / 50 Category: MS Word 9) Which of the following is a font style in Microsoft Word? Italics Bold Underline All are correct 10 / 50 Category: MS Word 10) What does the ‘Spelling & Grammar’ feature in Word do? Checks and suggests corrections for errors Provides suggestions for punctuation Checks for typing errors only Highlights grammatical mistakes only 11 / 50 Category: MS Word 11) Which of the following is NOT a text formatting option in Word? Highlight Italic Bold Strikethrough 12 / 50 Category: MS Word 12) How do you remove all formatting from selected text in Word? Press Ctrl + A Click the Eraser button Press Ctrl + Z Use the Clear Formatting button in the Home tab 13 / 50 Category: MS Word 13) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Table of Contents Text Box Paragraph Styles Formatting Painter 14 / 50 Category: MS Word 14) What is the shortcut key for printing a document? Ctrl + P Ctrl + T Ctrl + R Ctrl + V 15 / 50 Category: MS Word 15) Which tab in Microsoft Word contains the ‘Font’ and ‘Paragraph’ groups? Insert Home View Review 16 / 50 Category: MS Excel 16) What will the COUNTIF function return? Count of all cells Total of numeric cells Count of cells meeting a specific criterion Count of blank cells 17 / 50 Category: MS Excel 17) What will the result of the formula =5^2 be? 25 5 2 10 18 / 50 Category: MS Excel 18) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Saves the workbook Closes the workbook Undoes the last action 19 / 50 Category: MS Excel 19) Which function would you use to count non-empty cells? COUNTIF COUNT COUNTA COUNTBLANK 20 / 50 Category: MS Excel 20) Which shortcut key is used to open the Format Cells dialog? Ctrl + 1 Ctrl + Shift + F Ctrl + F Alt + F1 21 / 50 Category: MS Excel 21) Which of the following cannot be used as a cell reference? A1 1A B$2 C 22 / 50 Category: MS Excel 22) Which function would you use to find the highest value in a range? HIGH MAX TOP LARGE 23 / 50 Category: MS Excel 23) Which Excel feature allows you to visually analyze data? Conditional Formatting Sorting Filtering Data Validation 24 / 50 Category: MS Excel 24) What is the shortcut key for saving a workbook? Ctrl + P Ctrl + S Ctrl + O Ctrl + N 25 / 50 Category: MS Excel 25) Which of the following is NOT a valid chart type in Excel? Radar Chart Gantt Chart Histogram Bubble Chart 26 / 50 Category: MS PowerPoint 26) What is the default slide layout in PowerPoint? Blank Title Slide Title and Content Section Header 27 / 50 Category: MS PowerPoint 27) Which option allows you to change the orientation of your slides in PowerPoint? File > Page Setup Design > Slide Orientation View > Orientation Home > Slide Orientation 28 / 50 Category: MS PowerPoint 28) Which of the following is NOT a valid animation effect in PowerPoint? Fold Bounce Fade Spin 29 / 50 Category: MS PowerPoint 29) Which view allows you to edit the slide while seeing the slide sorter in PowerPoint? Slide Sorter View Reading View Slide Show View Normal View 30 / 50 Category: MS PowerPoint 30) How can you apply a design template to an existing presentation? Home > Layout Design > Themes View > Slide Master File > Save As 31 / 50 Category: MS PowerPoint 31) Is it possible to add this kind of image in a PowerPoint slide? Yes No 32 / 50 Category: MS PowerPoint 32) Which of the following is the correct way to insert a hyperlink in PowerPoint? View > Hyperlink Home > Insert > Link Slide Show > Link Insert > Hyperlink 33 / 50 Category: MS PowerPoint 33) In PowerPoint, which option can be used to add a voiceover or narration to a presentation? Home > Voice Narration View > Voiceover Slide Show > Record Narration Insert > Audio 34 / 50 Category: MS PowerPoint 34) Which of the following tools allows you to draw freehand on a slide during a presentation? Pen Tool Markup Tool Free Draw Drawing Tool 35 / 50 Category: MS PowerPoint 35) What is the primary purpose of the ‘Slide Master’ feature? To apply consistent formatting and layout across slides To manage animations and transitions To add animations to charts To create a new slide layout 36 / 50 Category: Advance Excel 36) What does the function TRIM() do? Removes spaces from a string Finds a substring Changes text to uppercase Concatenates strings 37 / 50 Category: Advance Excel 37) What does the function LEN() do? Converts text to lowercase Joins two strings Returns the length of a string Trims spaces from a string 38 / 50 Category: Advance Excel 38) Which of the following is a logical function? COUNT IF AVERAGE SUM 39 / 50 Category: Advance Excel 39) What does the IF function do? Finds the sum of a range Calculates an average Tests a condition and returns one value for TRUE and another for FALSE Checks for duplicates 40 / 50 Category: Advance Excel 40) What does the PMT function calculate? Future Value Present Value Interest Rate Payment for a loan 41 / 50 Category: Advance Excel 41) Which function finds the position of a substring within a string? POSITION SEARCH FIND LOCATE 42 / 50 Category: Advance Excel 42) Which Excel feature can you use to group data? Data Validation Filter PivotTable Sort 43 / 50 Category: Advance Excel 43) Which Excel feature helps to manage and analyze large datasets? Comments Tables Charts Conditional Formatting 44 / 50 Category: Advance Excel 44) What does the REPLACE function do? Replaces part of a string with another string Joins two strings Changes the case of a string Finds a substring 45 / 50 Category: Advance Excel 45) Which feature can be used to visualize trends in data over time? Column Chart Line Chart Bar Chart Pie Chart 46 / 50 Category: AI Applications 46) What is the primary function of ChatGPT? Code debugging Conversational AI for generating human-like text Image generation Data analysis 47 / 50 Category: AI Applications 47) Which AI application helps in providing personalized news or content recommendations on digital platforms? Computer Vision Recommender Systems Autonomous Robotics Predictive Text Explanation: Recommender systems use algorithms to suggest articles, news, or videos based on the user’s browsing history and preferences. 48 / 50 Category: AI Applications 48) What is OpenCV used for? Natural language processing Database management Image processing Data analysis 49 / 50 Category: AI Applications 49) What AI technology is most commonly used for fraud detection in online banking and finance applications? Natural Language Processing Neural Networks Machine Learning Predictive Analytics Explanation: Machine learning algorithms are used to analyze transaction patterns and identify fraudulent activities in real-time in banking and finance applications. 50 / 50 Category: AI Applications 50) Which AI tool is best for natural language processing? Unity Keras NLTK (Natural Language Toolkit) OpenCV Your score is 0% Restart quiz Anonymous feedback Send feedback
