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) The basic operations performed by a computer are: Input, Processing, Output, and Storage Input, Output, and Storage Data entry, Data analysis, Data output Data entry, Data process, Data output 2 / 25 Category: Computer Fundamentals 2) What is the key feature of third-generation computers? Use of microprocessors Use of vacuum tubes Use of Integrated Circuits (ICs) Use of transistors 3 / 25 Category: Computer Fundamentals 3) Which of the following is not a characteristic of a computer? IQ Accuracy Versatility Diligence 4 / 25 Category: Computer Fundamentals 4) Which device is used to point and select objects on the screen? Keyboard Printer Scanner Mouse 5 / 25 Category: Computer Fundamentals 5) Microsoft windows 11 is an example of computer application software. True False 6 / 25 Category: MS Word 6) Which command would you use to insert page numbers into a document? Insert > Page Numbers File > Page Numbers View > Page Numbers Insert > Page Break 7 / 25 Category: MS Word 7) Which menu tab allows you to add a table to a document? View Review Home Insert 8 / 25 Category: MS Word 8) Which view displays the document as it will appear on the printed page? Outline Draft Web Layout Print Layout 9 / 25 Category: MS Word 9) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Table of Contents Paragraph Styles Text Box Formatting Painter 10 / 25 Category: MS Word 10) What is the default font used in Microsoft Word 2016 and later versions? Calibri Arial Verdana Times New Roman 11 / 25 Category: MS Excel 11) What is the maximum number of rows in an Excel worksheet? 2,048 100,000 65,536 1,048,576 12 / 25 Category: MS Excel 12) Which of the following cannot be used as a cell reference? C 1A A1 B$2 13 / 25 Category: MS Excel 13) Which function would you use to find the highest value in a range? MAX LARGE TOP HIGH 14 / 25 Category: MS Excel 14) What happens when you double-click a cell’s right border? The column width adjusts to fit the content The cell is deleted The cell is copied The cell is formatted 15 / 25 Category: MS Excel 15) What type of chart is best for showing parts of a whole? Line Chart Bar Chart Scatter Plot Pie Chart 16 / 25 Category: MS Excel 16) Which function returns the current date? DATE() TODAY() NOW() TIMESTAMP() 17 / 25 Category: MS Excel 17) Which shortcut key is used to open the Format Cells dialog? Ctrl + Shift + F Alt + F1 Ctrl + F Ctrl + 1 18 / 25 Category: MS Excel 18) What does the ‘Ctrl + Z’ shortcut do in Excel? Saves the workbook Redoes the last action Closes the workbook Undoes the last action 19 / 25 Category: MS Excel 19) What feature allows you to repeat column titles on every printed page? Print Area Header/Footer Print Titles Page Layout 20 / 25 Category: MS Excel 20) Which function calculates the average of a range of cells? COUNT AVERAGE SUM MEDIAN 21 / 25 Category: MS PowerPoint 21) Which file extension does a PowerPoint 2019 presentation use? .ppsx .ppt .pptx .ppxt 22 / 25 Category: MS PowerPoint 22) In PowerPoint, which option can be used to add a voiceover or narration to a presentation? Slide Show > Record Narration Insert > Audio Home > Voice Narration View > Voiceover 23 / 25 Category: MS PowerPoint 23) Which of the following tools allows you to draw freehand on a slide during a presentation? Free Draw Markup Tool Drawing Tool Pen Tool 24 / 25 Category: MS PowerPoint 24) Is it possible to add this kind of image in a PowerPoint slide? No Yes 25 / 25 Category: MS PowerPoint 25) Which of the following is a method to add a transition effect in PowerPoint? Home > Transitions Design > Transitions Slide Show > Transitions Animations > Transitions 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) Which device is used to point and select objects on the screen? Scanner Keyboard Printer Mouse 2 / 50 Category: Computer Fundamentals 2) Identify input device of computer in this picture. Mouse Keyboard Web Cam Scanner Check 3 / 50 Category: Computer Fundamentals 3) Which of the following is a type of non-volatile memory? Cache RAM GPU ROM 4 / 50 Category: Computer Fundamentals 4) Who is the father of Computers? James Gosling Charles Babbage Bill Gate Dennis Ritchie 5 / 50 Category: Computer Fundamentals 5) Which of the following is an output device? Mouse Keyboard Mouse Printer 6 / 50 Category: MS Word 6) Which tab would you use to add pictures to your document? View Design Layout Insert 7 / 50 Category: MS Word 7) What does the ‘Undo’ button do in Microsoft Word? Cancel the last action Redo the last action Save the document Open the document 8 / 50 Category: MS Word 8) Which command would you use to insert page numbers into a document? Insert > Page Numbers File > Page Numbers Insert > Page Break View > Page Numbers 9 / 50 Category: MS Word 9) Which of the following views is best for editing a document? Print Layout View Draft View Web Layout View Reading View 10 / 50 Category: MS Word 10) In Microsoft Word, what is the ‘Ribbon’? A predefined list of text styles The help section of Word A graphical tool for editing text The toolbar at the top of the document 11 / 50 Category: MS Word 11) What feature would you use to insert a pre-designed format of text and images? SmartArt Header Table Quick Parts 12 / 50 Category: MS Word 12) What does the Ctrl + B shortcut key do? Make text italic Paste text Make text bold Copy text 13 / 50 Category: MS Word 13) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Text Box Paragraph Styles Formatting Painter Table of Contents 14 / 50 Category: MS Word 14) How do you close a Word document without exiting the Word application? Click the 'X' in the top-right corner Click File > Close CTRL + N Press Ctrl + W Check 15 / 50 Category: MS Word 15) What does the ‘Find and Replace’ feature do? Finds and replaces text in the document Finds all hyperlinks Finds and deletes text Finds and formats text 16 / 50 Category: MS Excel 16) What will the result of the formula =5^2 be? 5 10 25 2 17 / 50 Category: MS Excel 17) Which shortcut key is used to open the Format Cells dialog? Ctrl + 1 Ctrl + F Ctrl + Shift + F Alt + F1 18 / 50 Category: MS Excel 18) Which function would you use to count non-empty cells? COUNTA COUNTIF COUNT COUNTBLANK 19 / 50 Category: MS Excel 19) How do you create a hyperlink in Excel? Right-click > Insert Link Data > Link Format > Hyperlink Insert > Hyperlink 20 / 50 Category: MS Excel 20) What type of chart is best for showing parts of a whole? Scatter Plot Line Chart Pie Chart Bar Chart 21 / 50 Category: MS Excel 21) Which function returns the current date? NOW() DATE() TIMESTAMP() TODAY() 22 / 50 Category: MS Excel 22) What is the shortcut for inserting a new worksheet? Ctrl + W Ctrl + N Alt + N Shift + F11 23 / 50 Category: MS Excel 23) How can you quickly sum a column of numbers? Click the AutoSum button Use the SUM function manually Select the column and press Ctrl + S Right-click and choose Sum 24 / 50 Category: MS Excel 24) What is the main purpose of the Data Validation feature? To restrict the type of data entered in a cell To format cells To summarize data To create charts 25 / 50 Category: MS Excel 25) How do you create a chart in Excel? Format > Chart View > Chart Data > Chart Insert > Chart 26 / 50 Category: MS PowerPoint 26) Which of the following is the correct way to add a hyperlink to a slide? Home > Insert > Hyperlink Slide Show > Link View > Hyperlink Insert > Link > Hyperlink 27 / 50 Category: MS PowerPoint 27) Which of the following is not a type of transition in PowerPoint? Fade Fly In Zoom In Wipe 28 / 50 Category: MS PowerPoint 28) Which of the following is a method to add a transition effect in PowerPoint? Animations > Transitions Home > Transitions Slide Show > Transitions Design > Transitions 29 / 50 Category: MS PowerPoint 29) Which of the following tools allows you to draw freehand on a slide during a presentation? Markup Tool Free Draw Drawing Tool Pen Tool 30 / 50 Category: MS PowerPoint 30) Which of the following options can you use to apply animations to text in PowerPoint? Slide Master Home tab View tab Animations tab 31 / 50 Category: MS PowerPoint 31) What is the shortcut key to start a slideshow in PowerPoint? Ctrl + F5 F5 Shift + F5 Alt + F5 32 / 50 Category: MS PowerPoint 32) Which feature helps you add effects like fade, fly-in, or zoom to objects? Animations Action Settings Slide Transitions Custom Shows 33 / 50 Category: MS PowerPoint 33) Which of the following is the correct way to insert a hyperlink in PowerPoint? View > Hyperlink Insert > Hyperlink Home > Insert > Link Slide Show > Link 34 / 50 Category: MS PowerPoint 34) Which option allows you to change the orientation of your slides in PowerPoint? View > Orientation Home > Slide Orientation Design > Slide Orientation File > Page Setup 35 / 50 Category: MS PowerPoint 35) What is the primary function of the ‘Animations’ tab in PowerPoint? To apply text and object transitions To manage hyperlinks To change slide layouts To add audio or video 36 / 50 Category: Advance Excel 36) Which function can be used to join text from multiple cells? MERGE COMBINE CONCATENATE JOIN 37 / 50 Category: Advance Excel 37) Which function calculates the number of cells that meet a specific condition? COUNT COUNTA COUNTBLANK COUNTIF 38 / 50 Category: Advance Excel 38) Which of the following is a logical function? IF AVERAGE COUNT SUM 39 / 50 Category: Advance Excel 39) What does the function TRIM() do? Finds a substring Concatenates strings Changes text to uppercase Removes spaces from a string 40 / 50 Category: Advance Excel 40) What does the function LEN() do? Converts text to lowercase Joins two strings Trims spaces from a string Returns the length of a string 41 / 50 Category: Advance Excel 41) Which Excel feature helps to manage and analyze large datasets? Conditional Formatting Tables Charts Comments 42 / 50 Category: Advance Excel 42) What does the IF function do? Checks for duplicates Finds the sum of a range Tests a condition and returns one value for TRUE and another for FALSE Calculates an average 43 / 50 Category: Advance Excel 43) Which feature can be used to visualize trends in data over time? Bar Chart Pie Chart Column Chart Line Chart 44 / 50 Category: Advance Excel 44) Which Excel feature can you use to group data? Data Validation PivotTable Sort Filter 45 / 50 Category: Advance Excel 45) Which function finds the position of a substring within a string? POSITION LOCATE SEARCH FIND 46 / 50 Category: AI Applications 46) Which AI technology is used in healthcare for predicting patient diagnoses based on medical data? Virtual Reality Robotic Process Automation Speech Recognition Deep Learning Explanation: Deep learning algorithms are commonly used in healthcare applications to analyze medical data, such as imaging or patient records, and help predict diagnoses. 47 / 50 Category: AI Applications 47) Which company developed ChatGPT? OpenAI Google IBM Microsoft 48 / 50 Category: AI Applications 48) Which of the following AI tools is used for data visualization and analysis? TensorFlow Power BI Apache Kafka Flask 49 / 50 Category: AI Applications 49) What is OpenCV used for? Image processing Data analysis Database management Natural language processing 50 / 50 Category: AI Applications 50) Which AI application is commonly used for personalized recommendations on e-commerce Image Recognition Self-driving algorithms Natural Language Processing Collaborative Filtering Explanation: Collaborative filtering is used by e-commerce sites like Amazon and Netflix to provide personalized product or content recommendations based on user behavior and preferences. Your score is 0% Restart quiz Anonymous feedback Send feedback
