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) Who is the father of Computers? Charles Babbage Bill Gate Dennis Ritchie James Gosling 2 / 25 Category: Computer Fundamentals 2) Which of the following is considered the first generation of computers? Transistors Microprocessors Integrated Circuits Vacuum Tubes 3 / 25 Category: Computer Fundamentals 3) Which of the following is an output device? Mouse Mouse Printer Keyboard 4 / 25 Category: Computer Fundamentals 4) What is the key feature of third-generation computers? Use of transistors Use of Integrated Circuits (ICs) Use of vacuum tubes Use of microprocessors 5 / 25 Category: Computer Fundamentals 5) Which of the following is the brain of the computer? Input devices Storage devices Central Processing Unit (CPU) Memory 6 / 25 Category: MS Word 6) In Word, how can you change the document orientation? Layout > Orientation View > Orientation Insert > Orientation Design > Page Setup 7 / 25 Category: MS Word 7) In Microsoft Word, what is the ‘Ribbon’? The toolbar at the top of the document A graphical tool for editing text The help section of Word A predefined list of text styles 8 / 25 Category: MS Word 8) Which of the following is used to change the look of the text, including font type, size, and color? Themes Styles Formatting Painter Formatting 9 / 25 Category: MS Word 9) How can you quickly move the cursor to the beginning of a document? Ctrl + Home Ctrl + A Ctrl + C Ctrl + End 10 / 25 Category: MS Word 10) What is the function of “Ctrl + A” in Word? Saves the document Selects all content Select Page option Opens a new document 11 / 25 Category: MS Excel 11) What will the COUNTIF function return? Count of all cells Total of numeric cells Count of blank cells Count of cells meeting a specific criterion 12 / 25 Category: MS Excel 12) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Saves the workbook Undoes the last action Closes the workbook 13 / 25 Category: MS Excel 13) What is the shortcut key for saving a workbook? Ctrl + N Ctrl + O Ctrl + S Ctrl + P 14 / 25 Category: MS Excel 14) Which function would you use to find the highest value in a range? TOP LARGE MAX HIGH 15 / 25 Category: MS Excel 15) Which option allows you to protect a worksheet? Review > Protect Sheet Home > Format View > Protection Data > Protect 16 / 25 Category: MS Excel 16) What is the maximum number of rows in an Excel worksheet? 2,048 100,000 1,048,576 65,536 17 / 25 Category: MS Excel 17) Which function would you use to count non-empty cells? COUNTIF COUNTA COUNTBLANK COUNT 18 / 25 Category: MS Excel 18) What happens when you double-click a cell’s right border? The cell is copied The cell is deleted The column width adjusts to fit the content The cell is formatted 19 / 25 Category: MS Excel 19) What is the default file extension for an Excel workbook? .xlsm .xls .xlsx .csv 20 / 25 Category: MS Excel 20) Which of the following cannot be used as a cell reference? B$2 1A A1 C 21 / 25 Category: MS PowerPoint 21) Which of the following allows you to change the layout of a slide? Slide Show tab Home tab View tab Design tab 22 / 25 Category: MS PowerPoint 22) Which of the following shortcuts will you use to undo an action in PowerPoint? Ctrl + Z Ctrl + A Ctrl + Y Ctrl + X 23 / 25 Category: MS PowerPoint 23) Which of the following options can you use to apply animations to text in PowerPoint? Home tab Slide Master View tab Animations tab 24 / 25 Category: MS PowerPoint 24) Which of the following is used to print slides in PowerPoint? Insert > Print File > Print View > Print Home > Print 25 / 25 Category: MS PowerPoint 25) Which file extension does a PowerPoint 2019 presentation use? .pptx .ppt .ppxt .ppsx 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) What does the acronym ‘LAN’ stand for? Local Access Network Large Access Network Local Area Network Long Area Network 2 / 50 Category: Computer Fundamentals 2) What does RAM stand for? Read Access Memory Random Access Memory Rapid Access Memory Run Access Memory 3 / 50 Category: Computer Fundamentals 3) A kilobyte equals how many bytes? 8 2048 1024 1000 4 / 50 Category: Computer Fundamentals 4) The hexadecimal number system has a base of: 16 10 2 8 5 / 50 Category: Computer Fundamentals 5) Which language does a computer understand directly? Machine Language High-Level Language English Assembly Language 6 / 50 Category: MS Word 6) How can you quickly move the cursor to the beginning of a document? Ctrl + A Ctrl + Home Ctrl + C Ctrl + End 7 / 50 Category: MS Word 7) Which function key opens the ‘Help’ menu in Word? F2 F4 F3 F1 8 / 50 Category: MS Word 8) In Word, how do you turn on or off the ‘Ruler’? View > Show/Hide Ruler Layout > Ruler View > Ruler Insert > Ruler 9 / 50 Category: MS Word 9) Which of the following views is best for editing a document? Reading View Print Layout View Web Layout View Draft View 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) What does the ‘Undo’ button do in Microsoft Word? Save the document Redo the last action Open the document Cancel the last action 12 / 50 Category: MS Word 12) What is the shortcut key for italicizing text in Word? Ctrl + E Ctrl + U Ctrl + B Ctrl + I 13 / 50 Category: MS Word 13) In Microsoft Word, how do you insert a table? Page Layout > Table Design > Table Home > Table Insert > Table 14 / 50 Category: MS Word 14) In Microsoft Word, what is the ‘Ribbon’? The help section of Word A predefined list of text styles The toolbar at the top of the document A graphical tool for editing text 15 / 50 Category: MS Word 15) 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 16 / 50 Category: MS Excel 16) Which symbol is used to denote an absolute reference in a formula? & # @ $ 17 / 50 Category: MS Excel 17) Which option allows you to protect a worksheet? View > Protection Data > Protect Home > Format Review > Protect Sheet 18 / 50 Category: MS Excel 18) What feature allows you to repeat column titles on every printed page? Page Layout Header/Footer Print Titles Print Area 19 / 50 Category: MS Excel 19) Which of the following cannot be used as a cell reference? B$2 A1 1A C 20 / 50 Category: MS Excel 20) What is the default file extension for an Excel workbook? .xls .csv .xlsx .xlsm 21 / 50 Category: MS Excel 21) Which Excel feature allows you to visually analyze data? Sorting Conditional Formatting Filtering Data Validation 22 / 50 Category: MS Excel 22) Which function would you use to count non-empty cells? COUNTIF COUNT COUNTBLANK COUNTA 23 / 50 Category: MS Excel 23) Which of the following allows you to create a drop-down list in a cell? Cell Formatting AutoFilter Data Validation Conditional Formatting 24 / 50 Category: MS Excel 24) What happens when you double-click a cell’s right border? The column width adjusts to fit the content The cell is copied The cell is deleted The cell is formatted 25 / 50 Category: MS Excel 25) What will the result of the formula =5^2 be? 5 2 10 25 26 / 50 Category: MS PowerPoint 26) Which of the following is not a type of transition in PowerPoint? Zoom In Fly In Fade Wipe 27 / 50 Category: MS PowerPoint 27) Which tab would you use to insert a table in PowerPoint? Insert Home Slide Show Design 28 / 50 Category: MS PowerPoint 28) Which of the following is used to insert a picture into a slide? Design > Picture Insert > Picture Home > Image View > Image 29 / 50 Category: MS PowerPoint 29) What is the maximum number of slides you can add to a PowerPoint presentation? There is no limit 999 1250 90 30 / 50 Category: MS PowerPoint 30) Which PowerPoint feature helps you visually organize text and data into shapes? Text Boxes SmartArt Tables Charts 31 / 50 Category: MS PowerPoint 31) How can you create a new custom theme in PowerPoint? View > Master Slide Design > Themes > Save As Theme Design > Custom Layout Home > Save Theme 32 / 50 Category: MS PowerPoint 32) What is a Microsoft PowerPoint? Database Program Designing Program Presentation Program Spreadsheet Program 33 / 50 Category: MS PowerPoint 33) Which of the following is NOT a valid PowerPoint slide layout? Blank Title Slide Title and Content Text Effects 34 / 50 Category: MS PowerPoint 34) Which feature helps you add effects like fade, fly-in, or zoom to objects? Slide Transitions Action Settings Custom Shows Animations 35 / 50 Category: MS PowerPoint 35) What is the function of the ‘Format Painter’ in PowerPoint? It resizes images. It changes the slide layout. It copies formatting from one object to another. It adds text boxes. 36 / 50 Category: Advance Excel 36) Which function calculates the number of cells that meet a specific condition? COUNTA COUNT COUNTIF COUNTBLANK 37 / 50 Category: Advance Excel 37) Which feature can be used to visualize trends in data over time? Line Chart Pie Chart Column Chart Bar Chart 38 / 50 Category: Advance Excel 38) What does the function NOW() return? Current time only Current date only Current year Current date and time 39 / 50 Category: Advance Excel 39) Which of the following is a logical function? SUM COUNT AVERAGE IF 40 / 50 Category: Advance Excel 40) What does the IF function do? Tests a condition and returns one value for TRUE and another for FALSE Calculates an average Checks for duplicates Finds the sum of a range 41 / 50 Category: Advance Excel 41) What is a macro in Excel? A shortcut for frequently used commands A set of instructions to automate tasks A large formula A tool for data analysis 42 / 50 Category: Advance Excel 42) What does the AVERAGEIF function do? Finds the maximum value Averages cells that meet a certain condition Calculates the average of all cells Counts cells that meet a condition 43 / 50 Category: Advance Excel 43) What is the purpose of the Fill Handle? To fill cells with color To format cells To copy formulas and data to adjacent cells To delete rows and columns 44 / 50 Category: Advance Excel 44) What is the purpose of the Slicers in Excel? To filter data visually To sort data To create charts To format cells 45 / 50 Category: Advance Excel 45) What does the VLOOKUP function do? Counts the number of vertical cells Looks up a value in a vertical list Validates a list of values Looks up a value in a horizontal list 46 / 50 Category: AI Applications 46) Which AI tool is primarily used for speech recognition? R Studio Apache Hadoop Google Speech-to-Text IBM Watson 47 / 50 Category: AI Applications 47) Which AI application powers voice assistants like Siri, Alexa, and Google Assistant? Convolutional Neural Networks Natural Language Processing Reinforcement Learning Machine Translation Explanation: NLP is used by voice assistants to understand and process user speech, allowing them to respond in a meaningful way. 48 / 50 Category: AI Applications 48) Which AI application is commonly used for personalized recommendations on e-commerce Collaborative Filtering Natural Language Processing Self-driving algorithms Image Recognition 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. 49 / 50 Category: AI Applications 49) What is the main advantage of ChatGPT over rule-based chatbots? Ability to generate human-like responses Faster response times No need for data to function Easy integration with all platforms 50 / 50 Category: AI Applications 50) What is the primary AI application used in autonomous vehicles to navigate roads? Facial Recognition Data Mining Computer Vision Sentiment Analysis Explanation: Autonomous vehicles rely on computer vision to interpret their surroundings, recognize obstacles, traffic signs, and pedestrians, helping them navigate safely. Your score is 0% Restart quiz Anonymous feedback Send feedback
