Mock Examination ACCA ADCA ACCA0% 12345678910111213141516171819202122232425 ACCA Mock TestFinal Semester ExaminationTotal Questions: 50Full Marks: 100 (50 x 2)Time: 60 Minutes 1 / 25 Category: Computer Fundamentals 1) Which of the following is an application of AI? Self-driving cars Word processing software Spreadsheet management Internet browsing 2 / 25 Category: Computer Fundamentals 2) The hexadecimal number system has a base of: 8 2 10 16 3 / 25 Category: Computer Fundamentals 3) What is Artificial Intelligence (AI)? Creating biological intelligence in machines The study of natural intelligence in humans and animals Programming computers to solve problems without human intervention The simulation of human intelligence in machines 4 / 25 Category: Computer Fundamentals 4) Who is the father of Computers? Dennis Ritchie James Gosling Bill Gate Charles Babbage 5 / 25 Category: Computer Fundamentals 5) Identify this computer component Computer Cabinate Black Box CPU 6 / 25 Category: MS Word 6) In Microsoft Word, how do you insert a table? Insert > Table Page Layout > Table Design > Table Home > Table 7 / 25 Category: MS Word 7) Which of the following is used to change the look of the text, including font type, size, and color? Formatting Themes Formatting Painter Styles 8 / 25 Category: MS Word 8) How do you remove all formatting from selected text in Word? Press Ctrl + Z Click the Eraser button Use the Clear Formatting button in the Home tab Press Ctrl + A 9 / 25 Category: MS Word 9) What is the default page margin in Microsoft Word? 1.5 inch on all sides 1 inch on all sides 1.25 inch on all sides 0.5 inch on all sides 10 / 25 Category: MS Word 10) Which view displays the document as it will appear on the printed page? Outline Draft Print Layout Web Layout 11 / 25 Category: MS Excel 11) What is the default file extension for an Excel workbook? .xlsm .csv .xls .xlsx 12 / 25 Category: MS Excel 12) Which Excel feature allows you to visually analyze data? Filtering Conditional Formatting Data Validation Sorting 13 / 25 Category: MS Excel 13) Which of the following is NOT a valid chart type in Excel? Histogram Gantt Chart Radar Chart Bubble Chart 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) Which function returns the current date? TODAY() NOW() TIMESTAMP() DATE() 16 / 25 Category: MS Excel 16) Which of the following cannot be used as a cell reference? A1 C B$2 1A 17 / 25 Category: MS Excel 17) What type of chart is best for showing parts of a whole? Pie Chart Bar Chart Scatter Plot Line Chart 18 / 25 Category: MS Excel 18) Which function would you use to find the highest value in a range? MAX LARGE TOP HIGH 19 / 25 Category: MS Excel 19) Which of the following allows you to create a drop-down list in a cell? AutoFilter Data Validation Cell Formatting Conditional Formatting 20 / 25 Category: MS Excel 20) Which shortcut key is used to open the Format Cells dialog? Ctrl + 1 Alt + F1 Ctrl + Shift + F Ctrl + F 21 / 25 Category: MS PowerPoint 21) How do you remove a background from a picture in PowerPoint? Insert > Remove Background Format > Background Click the image, then click Picture Tools > Remove Background Design > Background Removal 22 / 25 Category: MS PowerPoint 22) What is the function of the ‘Format Painter’ in PowerPoint? It adds text boxes. It changes the slide layout. It resizes images. It copies formatting from one object to another. 23 / 25 Category: MS PowerPoint 23) Which option is used to create hyperlinks between slides in PowerPoint? Slide Show > Action Settings Insert > Hyperlink Home > Link View > Link 24 / 25 Category: MS PowerPoint 24) How do you add a comment in PowerPoint? Review > New Comment View > Comments Home > Add Comment Insert > Comment 25 / 25 Category: MS PowerPoint 25) Which of the following options in PowerPoint allows you to embed videos? Design > Multimedia Insert > Audio Home > Video Insert > Video Your score isThe average score is 0% 0% Restart quiz Anonymous feedback Send feedback ADCA0% Mock Test ADCAFinal Semester ExaminationTotal Questions: 50Full Marks: 100 (50 x 2)Time: 60 Minutes 1 / 50 Category: Computer Fundamentals 1) Identify input device of computer in this picture. Scanner Mouse Keyboard Web CamCheck 2 / 50 Category: Computer Fundamentals 2) Which generation of computers introduced the use of microprocessors? Third generation Fourth generation First generation Second generation 3 / 50 Category: Computer Fundamentals 3) Identify the component of computer Hard Disk RAM ROM CPU 4 / 50 Category: Computer Fundamentals 4) Which of the following is considered the first generation of computers? Integrated Circuits Vacuum Tubes Microprocessors Transistors 5 / 50 Category: Computer Fundamentals 5) Which of the following is the brain of the computer? Storage devices Central Processing Unit (CPU) Memory Input devices 6 / 50 Category: MS Word 6) Which view displays the document as it will appear on the printed page? Draft Web Layout Print Layout Outline 7 / 50 Category: MS Word 7) In Word, what is the purpose of ‘Track Changes’? To track hyperlinks To track document edits and revisions To keep track of document versions To track the word count 8 / 50 Category: MS Word 8) What is the default page margin in Microsoft Word? 0.5 inch on all sides 1 inch on all sides 1.5 inch on all sides 1.25 inch on all sides 9 / 50 Category: MS Word 9) Which of the following is used to change the look of the text, including font type, size, and color? Themes Styles Formatting Formatting Painter 10 / 50 Category: MS Word 10) Which menu tab allows you to add a table to a document? Review Insert Home View 11 / 50 Category: MS Word 11) What is the default font used in Microsoft Word 2016 and later versions? Verdana Calibri Arial Times New Roman 12 / 50 Category: MS Word 12) Which function key opens the ‘Help’ menu in Word? F3 F2 F1 F4 13 / 50 Category: MS Word 13) Which of the following views is best for editing a document? Draft View Reading View Web Layout View Print Layout View 14 / 50 Category: MS Word 14) What is the shortcut key for italicizing text in Word? Ctrl + E Ctrl + U Ctrl + I Ctrl + B 15 / 50 Category: MS Word 15) Which command would you use to insert page numbers into a document? File > Page Numbers View > Page Numbers Insert > Page Break Insert > Page Numbers 16 / 50 Category: MS Excel 16) What type of chart is best for showing parts of a whole? Scatter Plot Bar Chart Line Chart Pie Chart 17 / 50 Category: MS Excel 17) What is the shortcut for inserting a new worksheet? Ctrl + W Ctrl + N Shift + F11 Alt + N 18 / 50 Category: MS Excel 18) What is the main purpose of the Data Validation feature? To restrict the type of data entered in a cell To summarize data To format cells To create charts 19 / 50 Category: MS Excel 19) Which of the following cannot be used as a cell reference? A1 B$2 1A C 20 / 50 Category: MS Excel 20) What does the SUMIF function do? Finds the minimum value in a range Adds all values in a range Adds values based on a specific condition Counts all values in a range 21 / 50 Category: MS Excel 21) Which function would you use to count non-empty cells? COUNTBLANK COUNTA COUNTIF COUNT 22 / 50 Category: MS Excel 22) Which function would you use to find the highest value in a range? MAX LARGE TOP HIGH 23 / 50 Category: MS Excel 23) How do you create a hyperlink in Excel? Insert > Hyperlink Format > Hyperlink Right-click > Insert Link Data > Link 24 / 50 Category: MS Excel 24) Which shortcut key is used to open the Format Cells dialog? Alt + F1 Ctrl + Shift + F Ctrl + 1 Ctrl + F 25 / 50 Category: MS Excel 25) Which function returns the current date? DATE() TODAY() TIMESTAMP() NOW() 26 / 50 Category: MS PowerPoint 26) Which of the following is a method to add a transition effect in PowerPoint? Design > Transitions Animations > Transitions Slide Show > Transitions Home > Transitions 27 / 50 Category: MS PowerPoint 27) Which feature helps you add effects like fade, fly-in, or zoom to objects? Action Settings Slide Transitions Custom Shows Animations 28 / 50 Category: MS PowerPoint 28) Which of the following tools allows you to draw freehand on a slide during a presentation? Drawing Tool Free Draw Pen Tool Markup Tool 29 / 50 Category: MS PowerPoint 29) Which PowerPoint feature helps you visually organize text and data into shapes? Text Boxes Tables SmartArt Charts 30 / 50 Category: MS PowerPoint 30) 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 31 / 50 Category: MS PowerPoint 31) What is the maximum number of slides you can add to a PowerPoint presentation? 999 There is no limit 90 1250 32 / 50 Category: MS PowerPoint 32) Which of the following is the correct way to add a video from your computer to a slide? Slide Show > Insert Video Home > Insert Video View > Media Insert > Video > Video from File 33 / 50 Category: MS PowerPoint 33) How do you apply a PowerPoint theme to an existing presentation? View > Themes Design > Apply Theme File > New Slide Show > Theme 34 / 50 Category: MS PowerPoint 34) What is a Microsoft PowerPoint? Spreadsheet Program Presentation Program Database Program Designing Program 35 / 50 Category: MS PowerPoint 35) How do you create a table in PowerPoint? Insert > Table View > Table Home > Table Design > Table 36 / 50 Category: Advance Excel 36) What does the function NOW() return? Current date only Current year Current date and time Current time only 37 / 50 Category: Advance Excel 37) What does the VLOOKUP function do? Looks up a value in a vertical list Looks up a value in a horizontal list Validates a list of values Counts the number of vertical cells 38 / 50 Category: Advance Excel 38) Which function calculates the number of cells that meet a specific condition? COUNTIF COUNTBLANK COUNT COUNTA 39 / 50 Category: Advance Excel 39) Which of the following can be used to create a pivot table Insert > PivotTable Data > Filter View > PivotTable Data > Sort 40 / 50 Category: Advance Excel 40) Which function finds the position of a substring within a string? SEARCH FIND POSITION LOCATE 41 / 50 Category: Advance Excel 41) Which Excel feature can you use to group data? Data Validation Sort Filter PivotTable 42 / 50 Category: Advance Excel 42) What is the purpose of the Slicers in Excel? To sort data To filter data visually To create charts To format cells 43 / 50 Category: Advance Excel 43) Which Excel feature helps to manage and analyze large datasets? Comments Charts Tables Conditional Formatting 44 / 50 Category: Advance Excel 44) What does the PMT function calculate? Present Value Payment for a loan Future Value Interest Rate 45 / 50 Category: Advance Excel 45) What does the AVERAGEIF function do? Finds the maximum value Counts cells that meet a condition Calculates the average of all cells Averages cells that meet a certain condition 46 / 50 Category: AI Applications 46) What does AI stand for? Automated Intelligence Automated Integration Artificial Intelligence Artificial Integration 47 / 50 Category: AI Applications 47) Which tool is used for creating AI-based chatbots? Hadoop ableau MongoDB BotPress 48 / 50 Category: AI Applications 48) Which AI technology is used in healthcare for predicting patient diagnoses based on medical data? Virtual Reality Speech Recognition Deep Learning Robotic Process Automation Explanation: Deep learning algorithms are commonly used in healthcare applications to analyze medical data, such as imaging or patient records, and help predict diagnoses.49 / 50 Category: AI Applications 49) Which of the following AI tools is used for data visualization and analysis? Flask Power BI TensorFlow Apache Kafka 50 / 50 Category: AI Applications 50) Which AI system is frequently used by websites like YouTube to recommend videos to users? Collaborative Filtering Predictive Analytics Generative Adversarial Networks Content Filtering Explanation: Collaborative filtering is the algorithm behind the recommendation systems used by platforms like YouTube to suggest videos based on user preferences and past behavior.Your score is 0% Restart quiz Anonymous feedback Send feedback