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 considered the first generation of computers? Vacuum Tubes Microprocessors Integrated Circuits Transistors 2 / 25 Category: Computer Fundamentals 2) What is the name of this component? ROM RAM CPU SSD 3 / 25 Category: Computer Fundamentals 3) What does RAM stand for? Rapid Access Memory Random Access Memory Read Access Memory Run Access Memory 4 / 25 Category: Computer Fundamentals 4) Identify input device of computer in this picture. Web Cam Scanner Mouse Keyboard 5 / 25 Category: Computer Fundamentals 5) Who is the father of Computers? James Gosling Dennis Ritchie Bill Gate Charles Babbage 6 / 25 Category: MS Word 6) In Microsoft Word, how do you insert a table? Insert > Table Home > Table Design > Table Page Layout > Table 7 / 25 Category: MS Word 7) What is the shortcut for opening a new document in Word? Ctrl + N Ctrl + O Ctrl + P Ctrl + S 8 / 25 Category: MS Word 8) In Word, how can you change the document orientation? Insert > Orientation Layout > Orientation View > Orientation Design > Page Setup 9 / 25 Category: MS Word 9) Which of the following is a font style in Microsoft Word? Underline All are correct Italics Bold 10 / 25 Category: MS Word 10) How do you insert a page border in Word? View > Borders Layout > Borders Design > Page Borders Insert > Shapes > Border 11 / 25 Category: MS Excel 11) What is the purpose of the Freeze Panes feature? To hide rows and columns To lock the worksheet To prevent editing of cells To keep rows or columns visible while scrolling 12 / 25 Category: MS Excel 12) 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 deleted The cell is copied 13 / 25 Category: MS Excel 13) What is the shortcut for inserting a new worksheet? Ctrl + N Ctrl + W Shift + F11 Alt + N 14 / 25 Category: MS Excel 14) What is the default file extension for an Excel workbook? .xlsx .xlsm .csv .xls 15 / 25 Category: MS Excel 15) Which shortcut key is used to open the Format Cells dialog? Alt + F1 Ctrl + Shift + F Ctrl + 1 Ctrl + F 16 / 25 Category: MS Excel 16) Which function calculates the average of a range of cells? AVERAGE COUNT MEDIAN SUM 17 / 25 Category: MS Excel 17) How do you create a hyperlink in Excel? Data > Link Format > Hyperlink Right-click > Insert Link Insert > Hyperlink 18 / 25 Category: MS Excel 18) What does the SUMIF function do? Counts all values in a range Adds values based on a specific condition Finds the minimum value in a range Adds all values in a range 19 / 25 Category: MS Excel 19) How can you quickly sum a column of numbers? Use the SUM function manually Select the column and press Ctrl + S Right-click and choose Sum Click the AutoSum button 20 / 25 Category: MS Excel 20) Which Excel feature allows you to visually analyze data? Sorting Conditional Formatting Data Validation Filtering 21 / 25 Category: MS PowerPoint 21) What is the shortcut key to start a slideshow in PowerPoint? Alt + F5 Ctrl + F5 Shift + F5 F5 22 / 25 Category: MS PowerPoint 22) What is the ‘Slide Show’ tab used for? To add charts and graphics To create new layouts To run the presentation in full screen To insert new slides 23 / 25 Category: MS PowerPoint 23) Which of the following shortcuts will you use to undo an action in PowerPoint? Ctrl + Z Ctrl + X Ctrl + A Ctrl + Y 24 / 25 Category: MS PowerPoint 24) What is the function of the ‘Format Painter’ in PowerPoint? It changes the slide layout. It copies formatting from one object to another. It resizes images. It adds text boxes. 25 / 25 Category: MS PowerPoint 25) How do you add a comment in PowerPoint? Review > New Comment Home > Add Comment Insert > Comment View > Comments 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 smallest unit of data in a computer is: Megabyte Kilobyte Bit Byte 2 / 50 Category: Computer Fundamentals 2) What is the key feature of third-generation computers? Use of vacuum tubes Use of Integrated Circuits (ICs) Use of transistors Use of microprocessors 3 / 50 Category: Computer Fundamentals 3) Which of the following is an example of system software? Operating System Google Chrome Microsoft Office Adobe Photoshop 4 / 50 Category: Computer Fundamentals 4) Which of the following is not a characteristic of a computer? IQ Accuracy Diligence Versatility 5 / 50 Category: Computer Fundamentals 5) Which of the following is considered the first generation of computers? Vacuum Tubes Microprocessors Integrated Circuits Transistors 6 / 50 Category: MS Word 6) How do you remove all formatting from selected text in Word? Use the Clear Formatting button in the Home tab Press Ctrl + Z Press Ctrl + A Click the Eraser button 7 / 50 Category: MS Word 7) In Word, how can you change the document orientation? Insert > Orientation Design > Page Setup View > Orientation Layout > Orientation 8 / 50 Category: MS Word 8) In Microsoft Word, what is the ‘Ribbon’? A graphical tool for editing text The toolbar at the top of the document A predefined list of text styles The help section of Word 9 / 50 Category: MS Word 9) What does the ‘Spelling & Grammar’ feature in Word do? Provides suggestions for punctuation Highlights grammatical mistakes only Checks and suggests corrections for errors Checks for typing errors only 10 / 50 Category: MS Word 10) Which of the following is used to change the look of the text, including font type, size, and color? Formatting Painter Formatting Themes Styles 11 / 50 Category: MS Word 11) What is the default file extension for a Microsoft Word document? .txt .pdf .docx .xls 12 / 50 Category: MS Word 12) Which menu tab allows you to add a table to a document? Review Home View Insert 13 / 50 Category: MS Word 13) What is the shortcut for opening a new document in Word? Ctrl + P Ctrl + N Ctrl + S Ctrl + O 14 / 50 Category: MS Word 14) How can you quickly move the cursor to the beginning of a document? Ctrl + C Ctrl + End Ctrl + A Ctrl + Home 15 / 50 Category: MS Word 15) In Word, how do you turn on or off the ‘Ruler’? View > Ruler View > Show/Hide Ruler Insert > Ruler Layout > Ruler 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) How can you quickly sum a column of numbers? Right-click and choose Sum Use the SUM function manually Click the AutoSum button Select the column and press Ctrl + S 18 / 50 Category: MS Excel 18) What is the shortcut for inserting a new worksheet? Alt + N Ctrl + N Ctrl + W Shift + F11 19 / 50 Category: MS Excel 19) Which function calculates the average of a range of cells? MEDIAN SUM COUNT AVERAGE 20 / 50 Category: MS Excel 20) Which shortcut key is used to open the Format Cells dialog? Ctrl + 1 Alt + F1 Ctrl + F Ctrl + Shift + F 21 / 50 Category: MS Excel 21) Which option allows you to protect a worksheet? View > Protection Review > Protect Sheet Data > Protect Home > Format 22 / 50 Category: MS Excel 22) What is the maximum number of rows in an Excel worksheet? 1,048,576 65,536 100,000 2,048 23 / 50 Category: MS Excel 23) What feature allows you to repeat column titles on every printed page? Header/Footer Page Layout Print Titles Print Area 24 / 50 Category: MS Excel 24) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Saves the workbook Closes the workbook Undoes the last action 25 / 50 Category: MS Excel 25) What will the COUNTIF function return? Total of numeric cells Count of blank cells Count of cells meeting a specific criterion Count of all cells 26 / 50 Category: MS PowerPoint 26) Which tab would you use to add transitions between slides? Animations tab Design tab Insert tab Transition tab 27 / 50 Category: MS PowerPoint 27) Which tab would you use to insert a table in PowerPoint? Design Slide Show Home Insert 28 / 50 Category: MS PowerPoint 28) How do you start a slide show from the current slide? Click Slide Show > Start Press Shift + F5 Press F5 Click Slide Show > From Beginning 29 / 50 Category: MS PowerPoint 29) How do you adjust the slide orientation from portrait to landscape? File > Page Setup View > Slide Orientation Home > Slide Orientation Design > Slide Orientation 30 / 50 Category: MS PowerPoint 30) What is the default font size for text in a new PowerPoint slide? 12 pt 14 pt 10 pt 18 pt 31 / 50 Category: MS PowerPoint 31) Which feature helps you add effects like fade, fly-in, or zoom to objects? Animations Action Settings Slide Transitions Custom Shows 32 / 50 Category: MS PowerPoint 32) Which of the following is used to print slides in PowerPoint? Insert > Print Home > Print File > Print View > Print 33 / 50 Category: MS PowerPoint 33) Which of the following is not a type of transition in PowerPoint? Fly In Zoom In Wipe Fade 34 / 50 Category: MS PowerPoint 34) What is the shortcut key to start a slideshow in PowerPoint? Ctrl + F5 Shift + F5 F5 Alt + F5 35 / 50 Category: MS PowerPoint 35) Which of the following options in PowerPoint allows you to embed videos? Home > Video Insert > Video Insert > Audio Design > Multimedia 36 / 50 Category: Advance Excel 36) What does the REPLACE function do? Finds a substring Changes the case of a string Replaces part of a string with another string Joins two strings 37 / 50 Category: Advance Excel 37) Which function can be used to join text from multiple cells? CONCATENATE JOIN MERGE COMBINE 38 / 50 Category: Advance Excel 38) What does the IF function do? Calculates an average Finds the sum of a range Tests a condition and returns one value for TRUE and another for FALSE Checks for duplicates 39 / 50 Category: Advance Excel 39) What is a macro in Excel? A set of instructions to automate tasks A large formula A tool for data analysis A shortcut for frequently used commands 40 / 50 Category: Advance Excel 40) Which Excel feature can you use to group data? Data Validation Sort PivotTable Filter 41 / 50 Category: Advance Excel 41) What does the VLOOKUP function do? Counts the number of vertical cells Looks up a value in a vertical list Looks up a value in a horizontal list Validates a list of values 42 / 50 Category: Advance Excel 42) Which of the following can be used to create a pivot table View > PivotTable Data > Sort Insert > PivotTable Data > Filter 43 / 50 Category: Advance Excel 43) Which function calculates the number of cells that meet a specific condition? COUNT COUNTBLANK COUNTIF COUNTA 44 / 50 Category: Advance Excel 44) Which function finds the position of a substring within a string? SEARCH LOCATE FIND POSITION 45 / 50 Category: Advance Excel 45) What does the function LEN() do? Joins two strings Converts text to lowercase Trims spaces from a string Returns the length of a string 46 / 50 Category: AI Applications 46) Which AI framework is developed by Facebook for deep learning? Keras Theano PyTorch TensorFlow 47 / 50 Category: AI Applications 47) Which AI tool is primarily used for speech recognition? Apache Hadoop Google Speech-to-Text R Studio IBM Watson 48 / 50 Category: AI Applications 48) Which AI application helps in providing personalized news or content recommendations on digital platforms? Computer Vision Autonomous Robotics Predictive Text Recommender Systems Explanation: Recommender systems use algorithms to suggest articles, news, or videos based on the user’s browsing history and preferences. 49 / 50 Category: AI Applications 49) Which AI technology is used in healthcare for predicting patient diagnoses based on medical data? Speech Recognition Deep Learning Virtual Reality 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. 50 / 50 Category: AI Applications 50) What is the main advantage of ChatGPT over rule-based chatbots? No need for data to function Faster response times Easy integration with all platforms Ability to generate human-like responses Your score is 0% Restart quiz Anonymous feedback Send feedback
