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 an application of AI? Word processing software Internet browsing Spreadsheet management Self-driving cars 2 / 25 Category: Computer Fundamentals 2) The basic operations performed by a computer are: Input, Processing, Output, and Storage Data entry, Data process, Data output Data entry, Data analysis, Data output Input, Output, and Storage 3 / 25 Category: Computer Fundamentals 3) Identify input device of computer in this picture. Scanner Keyboard Web Cam Mouse 4 / 25 Category: Computer Fundamentals 4) Which of the following is considered the first generation of computers? Integrated Circuits Vacuum Tubes Transistors Microprocessors 5 / 25 Category: Computer Fundamentals 5) What is the key feature of third-generation computers? Use of transistors Use of Integrated Circuits (ICs) Use of microprocessors Use of vacuum tubes 6 / 25 Category: MS Word 6) How can you quickly move the cursor to the beginning of a document? Ctrl + End Ctrl + Home Ctrl + A Ctrl + C 7 / 25 Category: MS Word 7) How do you remove all formatting from selected text in Word? Click the Eraser button Press Ctrl + A Press Ctrl + Z Use the Clear Formatting button in the Home tab 8 / 25 Category: MS Word 8) What is the shortcut key for italicizing text in Word? Ctrl + B Ctrl + U Ctrl + I Ctrl + E 9 / 25 Category: MS Word 9) How do you close a Word document without exiting the Word application? Click File > Close Click the 'X' in the top-right corner CTRL + N Press Ctrl + W 10 / 25 Category: MS Word 10) How do you save a document for the first time? Can you all Click File > Save As Press Ctrl + S Click File > Save 11 / 25 Category: MS Excel 11) Which of the following cannot be used as a cell reference? A1 1A B$2 C 12 / 25 Category: MS Excel 12) What is the maximum number of rows in an Excel worksheet? 65,536 2,048 100,000 1,048,576 13 / 25 Category: MS Excel 13) What type of chart is best for showing parts of a whole? Scatter Plot Line Chart Pie Chart Bar Chart 14 / 25 Category: MS Excel 14) How can you quickly sum a column of numbers? Click the AutoSum button Select the column and press Ctrl + S Use the SUM function manually Right-click and choose Sum 15 / 25 Category: MS Excel 15) What feature allows you to repeat column titles on every printed page? Page Layout Print Area Print Titles Header/Footer 16 / 25 Category: MS Excel 16) What will the result of the formula =5^2 be? 25 10 2 5 17 / 25 Category: MS Excel 17) Which function returns the current date? NOW() TODAY() DATE() TIMESTAMP() 18 / 25 Category: MS Excel 18) Which option allows you to protect a worksheet? Review > Protect Sheet Data > Protect Home > Format View > Protection 19 / 25 Category: MS Excel 19) How do you create a chart in Excel? Insert > Chart Data > Chart View > Chart Format > Chart 20 / 25 Category: MS Excel 20) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Closes the workbook Saves the workbook Undoes the last action 21 / 25 Category: MS PowerPoint 21) Which of the following is NOT a valid PowerPoint slide layout? Title and Content Text Effects Blank Title Slide 22 / 25 Category: MS PowerPoint 22) What is the purpose of the Slide Master in PowerPoint? To apply different animations to slides To manage audio and video settings To insert and edit charts To create and edit themes and layouts for the slides 23 / 25 Category: MS PowerPoint 23) Which feature helps you add effects like fade, fly-in, or zoom to objects? Action Settings Slide Transitions Animations Custom Shows 24 / 25 Category: MS PowerPoint 24) What is the function of the ‘Slide Show’ tab in PowerPoint? To apply animations To start and control the slide show To edit objects and shapes To create new slides 25 / 25 Category: MS PowerPoint 25) In PowerPoint, which of the following options helps you add a background color or image to your slides? View > Backgrounds Home > Background Design > Background Styles Insert > Background 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: Bit Byte Kilobyte Megabyte 2 / 50 Category: Computer Fundamentals 2) Which of the following is the brain of the computer? Central Processing Unit (CPU) Storage devices Input devices Memory 3 / 50 Category: Computer Fundamentals 3) What does RAM stand for? Rapid Access Memory Run Access Memory Read Access Memory Random Access Memory 4 / 50 Category: Computer Fundamentals 4) The main function of the ALU is to: Perform arithmetic and logic operations Perform logical calculation Control the input and output Store data 5 / 50 Category: Computer Fundamentals 5) What is the name of this computer component? Hard Disk SSD RAM CPU 6 / 50 Category: MS Word 6) What is the default file extension for a Microsoft Word document? .txt .pdf .docx .xls 7 / 50 Category: MS Word 7) Which function key opens the ‘Help’ menu in Word? F4 F3 F2 F1 8 / 50 Category: MS Word 8) What is the shortcut for opening a new document in Word? Ctrl + S Ctrl + N Ctrl + O Ctrl + P 9 / 50 Category: MS Word 9) What does the ‘Undo’ button do in Microsoft Word? Redo the last action Open the document Save the document Cancel the last action 10 / 50 Category: MS Word 10) What is the function of “Ctrl + A” in Word? Opens a new document Select Page option Saves the document Selects all content 11 / 50 Category: MS Word 11) What is the default font used in Microsoft Word 2016 and later versions? Calibri Times New Roman Verdana Arial 12 / 50 Category: MS Word 12) In Word, which view displays the document as it would appear when printed? Web Layout Outline Draft Print Layout 13 / 50 Category: MS Word 13) Which key combination is used to create a new document in Word? Ctrl + N Ctrl + P Ctrl + S Ctrl + O 14 / 50 Category: MS Word 14) Which of the following is a font style in Microsoft Word? Underline All are correct Italics Bold 15 / 50 Category: MS Word 15) What is the shortcut key for printing a document? Ctrl + T Ctrl + P Ctrl + R Ctrl + V 16 / 50 Category: MS Excel 16) How can you quickly sum a column of numbers? Click the AutoSum button Use the SUM function manually Right-click and choose Sum Select the column and press Ctrl + S 17 / 50 Category: MS Excel 17) What is the maximum number of rows in an Excel worksheet? 65,536 2,048 1,048,576 100,000 18 / 50 Category: MS Excel 18) What will the result of the formula =5^2 be? 5 10 25 2 19 / 50 Category: MS Excel 19) What will the COUNTIF function return? Count of blank cells Total of numeric cells Count of all cells Count of cells meeting a specific criterion 20 / 50 Category: MS Excel 20) Which of the following is NOT a valid chart type in Excel? Histogram Radar Chart Gantt Chart Bubble Chart 21 / 50 Category: MS Excel 21) Which option allows you to protect a worksheet? View > Protection Review > Protect Sheet Home > Format Data > Protect 22 / 50 Category: MS Excel 22) Which function calculates the average of a range of cells? MEDIAN COUNT AVERAGE SUM 23 / 50 Category: MS Excel 23) Which symbol is used to denote an absolute reference in a formula? @ # $ & 24 / 50 Category: MS Excel 24) What is the main purpose of the Data Validation feature? To summarize data To format cells To restrict the type of data entered in a cell To create charts 25 / 50 Category: MS Excel 25) What feature allows you to repeat column titles on every printed page? Page Layout Print Area Print Titles Header/Footer 26 / 50 Category: MS PowerPoint 26) Which of the following is a valid chart type that can be created in PowerPoint? Bubble Chart Bar Chart All Types Pie Chart 27 / 50 Category: MS PowerPoint 27) What is the ‘Slide Show’ tab used for? To create new layouts To add charts and graphics To run the presentation in full screen To insert new slides 28 / 50 Category: MS PowerPoint 28) In PowerPoint, which option can be used to add a voiceover or narration to a presentation? Slide Show > Record Narration Home > Voice Narration Insert > Audio View > Voiceover 29 / 50 Category: MS PowerPoint 29) Which of the following is NOT a valid animation effect in PowerPoint? Spin Bounce Fold Fade 30 / 50 Category: MS PowerPoint 30) How do you add a comment in PowerPoint? Home > Add Comment Review > New Comment Insert > Comment View > Comments 31 / 50 Category: MS PowerPoint 31) Which of the following is not a type of transition in PowerPoint? Zoom In Fly In Wipe Fade 32 / 50 Category: MS PowerPoint 32) Which of the following is a method to add a transition effect in PowerPoint? Slide Show > Transitions Home > Transitions Animations > Transitions Design > Transitions 33 / 50 Category: MS PowerPoint 33) What is the shortcut key to start a slideshow in PowerPoint? Alt + F5 Ctrl + F5 Shift + F5 F5 34 / 50 Category: MS PowerPoint 34) How do you create a table in PowerPoint? Home > Table View > Table Design > Table Insert > Table 35 / 50 Category: MS PowerPoint 35) Which option allows you to change the orientation of your slides in PowerPoint? Design > Slide Orientation File > Page Setup Home > Slide Orientation View > Orientation 36 / 50 Category: Advance Excel 36) What does the LOOKUP function do? Validates a range Finds a value in a range Sorts a range Filters a range 37 / 50 Category: Advance Excel 37) Which Excel feature can you use to group data? Filter Data Validation PivotTable Sort 38 / 50 Category: Advance Excel 38) What does the PMT function calculate? Present Value Payment for a loan Future Value Interest Rate 39 / 50 Category: Advance Excel 39) Which function calculates the number of cells that meet a specific condition? COUNTIF COUNT COUNTA COUNTBLANK 40 / 50 Category: Advance Excel 40) Which function finds the position of a substring within a string? FIND LOCATE POSITION SEARCH 41 / 50 Category: Advance Excel 41) What does the function NOW() return? Current time only Current year Current date only Current date and time 42 / 50 Category: Advance Excel 42) Which feature can be used to visualize trends in data over time? Pie Chart Bar Chart Line Chart Column Chart 43 / 50 Category: Advance Excel 43) Which of the following can be used to create a pivot table Data > Sort View > PivotTable Insert > PivotTable Data > Filter 44 / 50 Category: Advance Excel 44) What is the purpose of the Slicers in Excel? To filter data visually To format cells To create charts To sort data 45 / 50 Category: Advance Excel 45) What is the purpose of the Fill Handle? To format cells To copy formulas and data to adjacent cells To delete rows and columns To fill cells with color 46 / 50 Category: AI Applications 46) Which AI tool is best for natural language processing? OpenCV Keras NLTK (Natural Language Toolkit) Unity 47 / 50 Category: AI Applications 47) Which AI application is primarily used in online content moderation to detect inappropriate language or images? Machine Learning Speech Recognition Natural Language Processing Image Recognition Explanation: NLP is used to analyze text in social media posts or comments to detect offensive language or hate speech. 48 / 50 Category: AI Applications 48) Which AI framework is developed by Facebook for deep learning? TensorFlow PyTorch Keras Theano 49 / 50 Category: AI Applications 49) What is the main advantage of ChatGPT over rule-based chatbots? No need for data to function Faster response times Ability to generate human-like responses Easy integration with all platforms 50 / 50 Category: AI Applications 50) Which company developed ChatGPT? OpenAI Microsoft IBM Google Your score is 0% Restart quiz Anonymous feedback Send feedback
