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) What is Artificial Intelligence (AI)? The study of natural intelligence in humans and animals Programming computers to solve problems without human intervention Creating biological intelligence in machines The simulation of human intelligence in machines 2 / 25 Category: Computer Fundamentals 2) Identify the component of computer CPU Hard Disk ROM RAM 3 / 25 Category: Computer Fundamentals 3) The smallest unit of data in a computer is: Bit Kilobyte Megabyte Byte 4 / 25 Category: Computer Fundamentals 4) Microsoft windows 11 is an example of computer application software. False True 5 / 25 Category: Computer Fundamentals 5) A kilobyte equals how many bytes? 1024 1000 8 2048 6 / 25 Category: MS Word 6) How do you remove all formatting from selected text in Word? Click the Eraser button Press Ctrl + Z Press Ctrl + A Use the Clear Formatting button in the Home tab 7 / 25 Category: MS Word 7) Which tab would you use to add pictures to your document? Insert View Design Layout 8 / 25 Category: MS Word 8) How do you save a document for the first time? Click File > Save Press Ctrl + S Click File > Save As Can you all 9 / 25 Category: MS Word 9) Which menu tab allows you to add a table to a document? Home View Insert Review 10 / 25 Category: MS Word 10) What is the default font used in Microsoft Word 2016 and later versions? Verdana Arial Calibri Times New Roman 11 / 25 Category: MS Excel 11) What feature allows you to repeat column titles on every printed page? Print Area Print Titles Header/Footer Page Layout 12 / 25 Category: MS Excel 12) What is the shortcut key for saving a workbook? Ctrl + P Ctrl + N Ctrl + O Ctrl + S 13 / 25 Category: MS Excel 13) Which of the following is NOT a valid chart type in Excel? Gantt Chart Histogram Radar Chart Bubble Chart 14 / 25 Category: MS Excel 14) Which function returns the current date? TIMESTAMP() DATE() NOW() TODAY() 15 / 25 Category: MS Excel 15) What is the default file extension for an Excel workbook? .xls .csv .xlsm .xlsx 16 / 25 Category: MS Excel 16) What will the result of the formula =5^2 be? 10 2 25 5 17 / 25 Category: MS Excel 17) How can you quickly sum a column of numbers? Use the SUM function manually Click the AutoSum button Right-click and choose Sum Select the column and press Ctrl + S 18 / 25 Category: MS Excel 18) Which Excel feature allows you to visually analyze data? Data Validation Filtering Sorting Conditional Formatting 19 / 25 Category: MS Excel 19) What happens when you double-click a cell’s right border? The cell is formatted The column width adjusts to fit the content The cell is copied The cell is deleted 20 / 25 Category: MS Excel 20) How do you create a hyperlink in Excel? Right-click > Insert Link Format > Hyperlink Data > Link Insert > Hyperlink 21 / 25 Category: MS PowerPoint 21) Which of the following is used to insert a picture into a slide? Design > Picture Insert > Picture Home > Image View > Image 22 / 25 Category: MS PowerPoint 22) Which of the following options in PowerPoint allows you to embed videos? Design > Multimedia Insert > Video Insert > Audio Home > Video 23 / 25 Category: MS PowerPoint 23) Which of the following is used to change the color scheme of your PowerPoint slides? Design > Colors Design > Color Schemes Format > Colors Home > Color 24 / 25 Category: MS PowerPoint 24) Which of the following is a method to add a transition effect in PowerPoint? Slide Show > Transitions Home > Transitions Design > Transitions Animations > Transitions 25 / 25 Category: MS PowerPoint 25) What is a Microsoft PowerPoint? Spreadsheet Program Database Program Presentation Program Designing Program 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) Identify input device of computer in this picture. Web Cam Scanner Keyboard Mouse Check 2 / 50 Category: Computer Fundamentals 2) Which device is used to point and select objects on the screen? Scanner Mouse Printer Keyboard 3 / 50 Category: Computer Fundamentals 3) Basic architecture of computer was developed by Charls Babbage Steve Jobes Thomas Adison John Von Neumann 4 / 50 Category: Computer Fundamentals 4) What does RAM stand for? Rapid Access Memory Random Access Memory Run Access Memory Read Access Memory 5 / 50 Category: Computer Fundamentals 5) Which of the following is considered the first generation of computers? Transistors Vacuum Tubes Integrated Circuits Microprocessors 6 / 50 Category: MS Word 6) What is the shortcut for opening a new document in Word? Ctrl + S Ctrl + O Ctrl + N Ctrl + P 7 / 50 Category: MS Word 7) Which of the following is used to change the look of the text, including font type, size, and color? Themes Styles Formatting Formatting Painter 8 / 50 Category: MS Word 8) In Word, how can you change the document orientation? Design > Page Setup Insert > Orientation View > Orientation Layout > Orientation 9 / 50 Category: MS Word 9) In Word, what is the purpose of ‘Track Changes’? To keep track of document versions To track hyperlinks To track the word count To track document edits and revisions 10 / 50 Category: MS Word 10) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Table of Contents Text Box Formatting Painter Paragraph Styles 11 / 50 Category: MS Word 11) What is the default file extension for a Microsoft Word document? .pdf .txt .docx .xls 12 / 50 Category: MS Word 12) What is the shortcut key for printing a document? Ctrl + T Ctrl + P Ctrl + R Ctrl + V 13 / 50 Category: MS Word 13) What is the function of “Ctrl + A” in Word? Select Page option Saves the document Opens a new document Selects all content 14 / 50 Category: MS Word 14) Which of the following is NOT a text formatting option in Word? Bold Italic Highlight Strikethrough 15 / 50 Category: MS Word 15) Which function key opens the ‘Help’ menu in Word? F3 F2 F1 F4 16 / 50 Category: MS Excel 16) What is the purpose of the Freeze Panes feature? To hide rows and columns To prevent editing of cells To keep rows or columns visible while scrolling To lock the worksheet 17 / 50 Category: MS Excel 17) Which function would you use to find the highest value in a range? HIGH TOP LARGE MAX 18 / 50 Category: MS Excel 18) What does the CONCATENATE function do? Combines multiple strings into one Splits a string into multiple parts Finds a substring in a string Changes the case of a string 19 / 50 Category: MS Excel 19) What will the COUNTIF function return? Total of numeric cells Count of all cells Count of blank cells Count of cells meeting a specific criterion 20 / 50 Category: MS Excel 20) What happens when you double-click a cell’s right border? The cell is formatted The cell is copied The cell is deleted The column width adjusts to fit the content 21 / 50 Category: MS Excel 21) Which symbol is used to denote an absolute reference in a formula? $ # @ & 22 / 50 Category: MS Excel 22) What feature allows you to repeat column titles on every printed page? Print Area Header/Footer Page Layout Print Titles 23 / 50 Category: MS Excel 23) Which function calculates the average of a range of cells? MEDIAN COUNT SUM AVERAGE 24 / 50 Category: MS Excel 24) Which of the following is NOT a valid chart type in Excel? Histogram Gantt Chart Radar Chart Bubble Chart 25 / 50 Category: MS Excel 25) How can you quickly sum a column of numbers? Click the AutoSum button Select the column and press Ctrl + S Right-click and choose Sum Use the SUM function manually 26 / 50 Category: MS PowerPoint 26) Which of the following options in PowerPoint allows you to embed videos? Insert > Video Home > Video Design > Multimedia Insert > Audio 27 / 50 Category: MS PowerPoint 27) Which of the following tools allows you to draw freehand on a slide during a presentation? Drawing Tool Free Draw Pen Tool Markup Tool 28 / 50 Category: MS PowerPoint 28) What is the default font size for text in a new PowerPoint slide? 14 pt 10 pt 12 pt 18 pt 29 / 50 Category: MS PowerPoint 29) Which of the following is the default view when you open a PowerPoint presentation? Slide Sorter View Outline View Slide Show View Normal View 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 Home > Voice Narration View > Voiceover Insert > Audio 31 / 50 Category: MS PowerPoint 31) Which of the following tools allows you to align objects in PowerPoint? View > Align Format > Align Home > Align Insert > Align 32 / 50 Category: MS PowerPoint 32) Which of the following shortcuts will you use to undo an action in PowerPoint? Ctrl + A Ctrl + X Ctrl + Y Ctrl + Z 33 / 50 Category: MS PowerPoint 33) How can you apply a design template to an existing presentation? View > Slide Master File > Save As Design > Themes Home > Layout 34 / 50 Category: MS PowerPoint 34) Which of the following is a predefined design that controls the look of the slides? Slide theme Transition Slide layout Animation 35 / 50 Category: MS PowerPoint 35) Which of the following is the correct way to add a hyperlink to a slide? Slide Show > Link Home > Insert > Hyperlink Insert > Link > Hyperlink View > Hyperlink 36 / 50 Category: Advance Excel 36) What does the function TRIM() do? Concatenates strings Changes text to uppercase Removes spaces from a string Finds a substring 37 / 50 Category: Advance Excel 37) Which function can be used to join text from multiple cells? JOIN CONCATENATE MERGE COMBINE 38 / 50 Category: Advance Excel 38) What is the purpose of the Slicers in Excel? To filter data visually To sort data To create charts To format cells 39 / 50 Category: Advance Excel 39) What does the LOOKUP function do? Finds a value in a range Filters a range Sorts a range Validates a range 40 / 50 Category: Advance Excel 40) Which of the following is a logical function? COUNT IF AVERAGE SUM 41 / 50 Category: Advance Excel 41) What does the function NOW() return? Current time only Current date only Current date and time Current year 42 / 50 Category: Advance Excel 42) Which of the following can be used to create a pivot table Data > Sort View > PivotTable Data > Filter Insert > PivotTable 43 / 50 Category: Advance Excel 43) What does the REPLACE function do? Finds a substring Replaces part of a string with another string Joins two strings Changes the case of a string 44 / 50 Category: Advance Excel 44) Which Excel feature can you use to group data? PivotTable Sort Data Validation Filter 45 / 50 Category: Advance Excel 45) Which feature can be used to visualize trends in data over time? Line Chart Bar Chart Pie Chart Column Chart 46 / 50 Category: AI Applications 46) Which of the following AI tools is commonly used to assist customer service on websites? Image Recognition Speech Recognition Neural Networks Chatbots 47 / 50 Category: AI Applications 47) What does AI stand for? Artificial Integration Artificial Intelligence Automated Intelligence Automated Integration 48 / 50 Category: AI Applications 48) What type of AI is used for making predictions or classifications based on data? Expert systems Machine learning Deep learning Reinforcement learning 49 / 50 Category: AI Applications 49) Which version of GPT does ChatGPT currently use (as of December 2024)? GPT-5 GPT-3 GPT-4 GPT-2 50 / 50 Category: AI Applications 50) Which AI framework is developed by Facebook for deep learning? TensorFlow PyTorch Keras Theano Your score is 0% Restart quiz Anonymous feedback Send feedback
