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) Basic architecture of computer was developed by Steve Jobes John Von Neumann Thomas Adison Charls Babbage 2 / 25 Category: Computer Fundamentals 2) Which of the following is the brain of the computer? Central Processing Unit (CPU) Storage devices Memory Input devices 3 / 25 Category: Computer Fundamentals 3) Which of the following is considered the first generation of computers? Vacuum Tubes Microprocessors Integrated Circuits Transistors 4 / 25 Category: Computer Fundamentals 4) The basic operations performed by a computer are: Input, Processing, Output, and Storage Data entry, Data analysis, Data output Input, Output, and Storage Data entry, Data process, Data output 5 / 25 Category: Computer Fundamentals 5) Which of the following is not a characteristic of a computer? Versatility Diligence IQ Accuracy 6 / 25 Category: MS Word 6) How can you apply a bullet list in Word? Layout > Bullets Home > Bullets Review > Bullets Insert > Bullets 7 / 25 Category: MS Word 7) Which menu tab allows you to add a table to a document? Insert View Review Home 8 / 25 Category: MS Word 8) What does the Ctrl + B shortcut key do? Copy text Make text bold Paste text Make text italic 9 / 25 Category: MS Word 9) What is the default file extension for a Microsoft Word document? .pdf .txt .xls .docx 10 / 25 Category: MS Word 10) How can you quickly move the cursor to the beginning of a document? Ctrl + End Ctrl + A Ctrl + C Ctrl + Home 11 / 25 Category: MS Excel 11) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Saves the workbook Undoes the last action Closes the workbook 12 / 25 Category: MS Excel 12) Which function would you use to count non-empty cells? COUNTIF COUNT COUNTA COUNTBLANK 13 / 25 Category: MS Excel 13) Which Excel feature allows you to visually analyze data? Filtering Data Validation Sorting Conditional Formatting 14 / 25 Category: MS Excel 14) What does the SUMIF function do? Counts all values in a range Adds all values in a range Finds the minimum value in a range Adds values based on a specific condition 15 / 25 Category: MS Excel 15) How do you create a hyperlink in Excel? Format > Hyperlink Right-click > Insert Link Data > Link Insert > Hyperlink 16 / 25 Category: MS Excel 16) Which of the following is NOT a valid chart type in Excel? Bubble Chart Radar Chart Gantt Chart Histogram 17 / 25 Category: MS Excel 17) Which function calculates the average of a range of cells? AVERAGE COUNT MEDIAN SUM 18 / 25 Category: MS Excel 18) Which function would you use to find the highest value in a range? LARGE TOP HIGH MAX 19 / 25 Category: MS Excel 19) Which of the following allows you to create a drop-down list in a cell? AutoFilter Conditional Formatting Data Validation Cell Formatting 20 / 25 Category: MS Excel 20) What type of chart is best for showing parts of a whole? Line Chart Bar Chart Scatter Plot Pie Chart 21 / 25 Category: MS PowerPoint 21) What is the function of the ‘Slide Show’ tab in PowerPoint? To edit objects and shapes To apply animations To create new slides To start and control the slide show 22 / 25 Category: MS PowerPoint 22) How can you change the order of slides in PowerPoint? Slide Show > Rearrange Insert > Slide Order Home > Move Slide Slide Sorter View > Drag the slide 23 / 25 Category: MS PowerPoint 23) Which of the following allows you to change the layout of a slide? Design tab Home tab View tab Slide Show tab 24 / 25 Category: MS PowerPoint 24) Which option is used to create hyperlinks between slides in PowerPoint? Slide Show > Action Settings Insert > Hyperlink View > Link Home > Link 25 / 25 Category: MS PowerPoint 25) Which PowerPoint feature helps you visually organize text and data into shapes? Tables SmartArt Charts Text Boxes 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 is the name of this computer component? Hard Disk CPU SSD RAM 2 / 50 Category: Computer Fundamentals 2) Identify the component of computer Hard Disk CPU RAM ROM 3 / 50 Category: Computer Fundamentals 3) What does RAM stand for? Rapid Access Memory Run Access Memory Random Access Memory Read Access Memory 4 / 50 Category: Computer Fundamentals 4) Which device is used to point and select objects on the screen? Mouse Keyboard Printer Scanner 5 / 50 Category: Computer Fundamentals 5) A kilobyte equals how many bytes? 1000 8 1024 2048 6 / 50 Category: MS Word 6) Which tab would you use to add pictures to your document? View Layout Insert Design 7 / 50 Category: MS Word 7) What is the shortcut key for italicizing text in Word? Ctrl + E Ctrl + B Ctrl + U Ctrl + I 8 / 50 Category: MS Word 8) Which function key opens the ‘Help’ menu in Word? F1 F2 F4 F3 9 / 50 Category: MS Word 9) What does the Ctrl + B shortcut key do? Copy text Make text bold Paste text Make text italic 10 / 50 Category: MS Word 10) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Formatting Painter Text Box Table of Contents Paragraph Styles 11 / 50 Category: MS Word 11) How do you remove all formatting from selected text in Word? Press Ctrl + A Press Ctrl + Z Use the Clear Formatting button in the Home tab Click the Eraser button 12 / 50 Category: MS Word 12) Which key combination is used to create a new document in Word? Ctrl + O Ctrl + N Ctrl + S Ctrl + P 13 / 50 Category: MS Word 13) In Word, how can you change the document orientation? Layout > Orientation Insert > Orientation View > Orientation Design > Page Setup 14 / 50 Category: MS Word 14) How can you add a comment to a document in Word? Insert > Comment Home > New Comment View > Comment Review > New Comment 15 / 50 Category: MS Word 15) Which of the following is NOT a text formatting option in Word? Highlight Bold Italic Strikethrough 16 / 50 Category: MS Excel 16) What happens when you double-click a cell’s right border? The cell is formatted The cell is deleted The cell is copied The column width adjusts to fit the content 17 / 50 Category: MS Excel 17) Which function would you use to find the highest value in a range? HIGH LARGE MAX TOP 18 / 50 Category: MS Excel 18) How do you create a hyperlink in Excel? Right-click > Insert Link Insert > Hyperlink Data > Link Format > Hyperlink 19 / 50 Category: MS Excel 19) Which of the following cannot be used as a cell reference? 1A B$2 A1 C 20 / 50 Category: MS Excel 20) What is the shortcut key for saving a workbook? Ctrl + O Ctrl + S Ctrl + N Ctrl + P 21 / 50 Category: MS Excel 21) What is the main purpose of the Data Validation feature? To summarize data To create charts To format cells To restrict the type of data entered in a cell 22 / 50 Category: MS Excel 22) What does the ‘Ctrl + Z’ shortcut do in Excel? Redoes the last action Closes the workbook Undoes the last action Saves the workbook 23 / 50 Category: MS Excel 23) Which function calculates the average of a range of cells? AVERAGE COUNT MEDIAN SUM 24 / 50 Category: MS Excel 24) What feature allows you to repeat column titles on every printed page? Print Titles Page Layout Header/Footer Print Area 25 / 50 Category: MS Excel 25) What will the COUNTIF function return? Total of numeric cells Count of cells meeting a specific criterion Count of blank cells Count of all cells 26 / 50 Category: MS PowerPoint 26) Which option is used to create hyperlinks between slides in PowerPoint? View > Link Home > Link Insert > Hyperlink Slide Show > Action Settings 27 / 50 Category: MS PowerPoint 27) How do you add a new slide in PowerPoint? Press Ctrl + M Click File > New Press Ctrl + N Right-click in the slide sorter pane 28 / 50 Category: MS PowerPoint 28) Which view allows you to edit the slide while seeing the slide sorter in PowerPoint? Normal View Slide Show View Reading View Slide Sorter View 29 / 50 Category: MS PowerPoint 29) Which tab would you use to insert a table in PowerPoint? Slide Show Insert Design Home 30 / 50 Category: MS PowerPoint 30) How can you create a new custom theme in PowerPoint? Design > Custom Layout Design > Themes > Save As Theme Home > Save Theme View > Master Slide 31 / 50 Category: MS PowerPoint 31) What is the default font size for text in a new PowerPoint slide? 12 pt 18 pt 14 pt 10 pt 32 / 50 Category: MS PowerPoint 32) How can you change the order of slides in PowerPoint? Slide Sorter View > Drag the slide Insert > Slide Order Home > Move Slide Slide Show > Rearrange 33 / 50 Category: MS PowerPoint 33) How can you apply a design template to an existing presentation? File > Save As Design > Themes View > Slide Master Home > Layout 34 / 50 Category: MS PowerPoint 34) How can you add a new slide to a presentation in PowerPoint? Home > New Slide Design > Add Slide View > Slide Insert > Slide 35 / 50 Category: MS PowerPoint 35) Which of the following is used to print slides in PowerPoint? Insert > Print Home > Print View > Print File > Print 36 / 50 Category: Advance Excel 36) Which feature can be used to visualize trends in data over time? Pie Chart Bar Chart Column Chart Line Chart 37 / 50 Category: Advance Excel 37) Which function can be used to join text from multiple cells? CONCATENATE MERGE JOIN COMBINE 38 / 50 Category: Advance Excel 38) What does the PMT function calculate? Payment for a loan Present Value Interest Rate Future Value 39 / 50 Category: Advance Excel 39) Which of the following can be used to create a pivot table Insert > PivotTable Data > Filter Data > Sort View > PivotTable 40 / 50 Category: Advance Excel 40) Which function finds the position of a substring within a string? SEARCH POSITION LOCATE FIND 41 / 50 Category: Advance Excel 41) What does the IF function do? Finds the sum of a range Calculates an average Tests a condition and returns one value for TRUE and another for FALSE Checks for duplicates 42 / 50 Category: Advance Excel 42) What is the purpose of the Fill Handle? To copy formulas and data to adjacent cells To format cells To fill cells with color To delete rows and columns 43 / 50 Category: Advance Excel 43) What does the function TRIM() do? Concatenates strings Removes spaces from a string Changes text to uppercase Finds a substring 44 / 50 Category: Advance Excel 44) What does the REPLACE function do? Finds a substring Joins two strings Changes the case of a string Replaces part of a string with another string 45 / 50 Category: Advance Excel 45) What does the LOOKUP function do? Validates a range Sorts a range Filters a range Finds a value in a range 46 / 50 Category: AI Applications 46) Which version of GPT does ChatGPT currently use (as of December 2024)? GPT-2 GPT-5 GPT-4 GPT-3 47 / 50 Category: AI Applications 47) What is the primary AI application used in autonomous vehicles to navigate roads? Computer Vision Data Mining Facial Recognition Sentiment Analysis Explanation: Autonomous vehicles rely on computer vision to interpret their surroundings, recognize obstacles, traffic signs, and pedestrians, helping them navigate safely. 48 / 50 Category: AI Applications 48) Which AI framework is developed by Facebook for deep learning? PyTorch TensorFlow Keras Theano 49 / 50 Category: AI Applications 49) Which programming language is commonly used for AI development? Java C++ PHP Python 50 / 50 Category: AI Applications 50) Which of the following AI tools is used for data visualization and analysis? Apache Kafka TensorFlow Flask Power BI Your score is 0% Restart quiz Anonymous feedback Send feedback
