Mock Examination ACCA ADCA ACCA0% 12345678910111213141516171819202122232425 ACCA Mock TestFinal Semester ExaminationTotal Questions: 50Full Marks: 100 (50 x 2)Time: 60 Minutes 1 / 25 Category: Computer Fundamentals 1) Identify this computer component Computer Cabinate Black Box CPU 2 / 25 Category: Computer Fundamentals 2) The hexadecimal number system has a base of: 8 2 16 10 3 / 25 Category: Computer Fundamentals 3) Which of the following is an example of system software? Operating System Google Chrome Microsoft Office Adobe Photoshop 4 / 25 Category: Computer Fundamentals 4) Which of the following is the brain of the computer? Memory Input devices Storage devices Central Processing Unit (CPU) 5 / 25 Category: Computer Fundamentals 5) Microsoft windows 11 is an example of computer application software. True False 6 / 25 Category: MS Word 6) How can you apply a bullet list in Word? Review > Bullets Home > Bullets Layout > Bullets Insert > Bullets 7 / 25 Category: MS Word 7) How do you access the ‘Print’ menu in Word? View > Print Insert > Print File > Print Home > Print 8 / 25 Category: MS Word 8) What does the Ctrl + B shortcut key do? Make text italic Paste text Copy text Make text bold 9 / 25 Category: MS Word 9) What is the default page margin in Microsoft Word? 1.5 inch on all sides 0.5 inch on all sides 1.25 inch on all sides 1 inch on all sides 10 / 25 Category: MS Word 10) In Word, what is the ‘Thesaurus’ used for? To check for spelling errors To translate words To insert a dictionary To find synonyms and antonyms for words 11 / 25 Category: MS Excel 11) How can you quickly sum a column of numbers? Click the AutoSum button Right-click and choose Sum Use the SUM function manually Select the column and press Ctrl + S 12 / 25 Category: MS Excel 12) What does the ‘Ctrl + Z’ shortcut do in Excel? Undoes the last action Saves the workbook Closes the workbook Redoes the last action 13 / 25 Category: MS Excel 13) How do you create a hyperlink in Excel? Format > Hyperlink Right-click > Insert Link Insert > Hyperlink Data > Link 14 / 25 Category: MS Excel 14) Which shortcut key is used to open the Format Cells dialog? Ctrl + F Ctrl + Shift + F Ctrl + 1 Alt + F1 15 / 25 Category: MS Excel 15) What will the COUNTIF function return? Count of cells meeting a specific criterion Count of blank cells Total of numeric cells Count of all cells 16 / 25 Category: MS Excel 16) Which option allows you to protect a worksheet? View > Protection Review > Protect Sheet Data > Protect Home > Format 17 / 25 Category: MS Excel 17) Which function would you use to count non-empty cells? COUNTBLANK COUNT COUNTA COUNTIF 18 / 25 Category: MS Excel 18) What is the shortcut key for saving a workbook? Ctrl + O Ctrl + P Ctrl + S Ctrl + N 19 / 25 Category: MS Excel 19) What does the SUMIF function do? Adds values based on a specific condition Counts all values in a range Adds all values in a range Finds the minimum value in a range 20 / 25 Category: MS Excel 20) What is the purpose of the Freeze Panes feature? To keep rows or columns visible while scrolling To hide rows and columns To prevent editing of cells To lock the worksheet 21 / 25 Category: MS PowerPoint 21) Which tab would you use to insert a table in PowerPoint? Insert Home Design Slide Show 22 / 25 Category: MS PowerPoint 22) Which option is used to create hyperlinks between slides in PowerPoint? Slide Show > Action Settings Home > Link View > Link Insert > Hyperlink 23 / 25 Category: MS PowerPoint 23) What is a Microsoft PowerPoint? Presentation Program Designing Program Database Program Spreadsheet Program 24 / 25 Category: MS PowerPoint 24) What is the function of the ‘Format Painter’ in PowerPoint? It adds text boxes. It changes the slide layout. It copies formatting from one object to another. It resizes images. 25 / 25 Category: MS PowerPoint 25) Which of the following is NOT a valid animation effect in PowerPoint? Fade Spin Fold Bounce Your score isThe average score is 0% 0% Restart quiz Anonymous feedback Send feedback ADCA0% Mock Test ADCAFinal Semester ExaminationTotal Questions: 50Full Marks: 100 (50 x 2)Time: 60 Minutes 1 / 50 Category: Computer Fundamentals 1) A kilobyte equals how many bytes? 1000 1024 8 2048 2 / 50 Category: Computer Fundamentals 2) What is Artificial Intelligence (AI)? The simulation of human intelligence in machines Programming computers to solve problems without human intervention The study of natural intelligence in humans and animals Creating biological intelligence in machines 3 / 50 Category: Computer Fundamentals 3) The hexadecimal number system has a base of: 16 8 10 2 4 / 50 Category: Computer Fundamentals 4) Microsoft windows 11 is an example of computer application software. True False 5 / 50 Category: Computer Fundamentals 5) Which device is used to point and select objects on the screen? Printer Scanner Keyboard Mouse 6 / 50 Category: MS Word 6) Which tab would you use to add pictures to your document? Layout Design Insert View 7 / 50 Category: MS Word 7) What is the default page margin in Microsoft Word? 1.5 inch on all sides 1 inch on all sides 1.25 inch on all sides 0.5 inch on all sides 8 / 50 Category: MS Word 8) 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 9 / 50 Category: MS Word 9) How can you apply a bullet list in Word? Insert > Bullets Review > Bullets Home > Bullets Layout > Bullets 10 / 50 Category: MS Word 10) How do you close a Word document without exiting the Word application? Press Ctrl + W CTRL + N Click the 'X' in the top-right corner Click File > CloseCheck 11 / 50 Category: MS Word 11) Which of the following is used to change the look of the text, including font type, size, and color? Themes Formatting Formatting Painter Styles 12 / 50 Category: MS Word 12) Which function key opens the ‘Help’ menu in Word? F4 F2 F3 F1 13 / 50 Category: MS Word 13) What is the shortcut for opening a new document in Word? Ctrl + O Ctrl + S Ctrl + N Ctrl + P 14 / 50 Category: MS Word 14) What is the default font used in Microsoft Word 2016 and later versions? Verdana Calibri Times New Roman Arial 15 / 50 Category: MS Word 15) How can you add a comment to a document in Word? Review > New Comment Insert > Comment View > Comment Home > New Comment 16 / 50 Category: MS Excel 16) What does the ‘Ctrl + Z’ shortcut do in Excel? Closes the workbook Redoes the last action Saves the workbook Undoes the last action 17 / 50 Category: MS Excel 17) Which function would you use to find the highest value in a range? LARGE HIGH TOP MAX 18 / 50 Category: MS Excel 18) Which of the following cannot be used as a cell reference? C A1 B$2 1A 19 / 50 Category: MS Excel 19) What is the maximum number of rows in an Excel worksheet? 100,000 2,048 65,536 1,048,576 20 / 50 Category: MS Excel 20) What does the CONCATENATE function do? Splits a string into multiple parts Changes the case of a string Combines multiple strings into one Finds a substring in a string 21 / 50 Category: MS Excel 21) Which function returns the current date? TIMESTAMP() TODAY() NOW() DATE() 22 / 50 Category: MS Excel 22) What is the shortcut key for saving a workbook? Ctrl + O Ctrl + S Ctrl + N Ctrl + P 23 / 50 Category: MS Excel 23) What is the purpose of the Freeze Panes feature? To lock the worksheet To hide rows and columns To prevent editing of cells To keep rows or columns visible while scrolling 24 / 50 Category: MS Excel 24) How do you create a hyperlink in Excel? Data > Link Right-click > Insert Link Format > Hyperlink Insert > Hyperlink 25 / 50 Category: MS Excel 25) How do you create a chart in Excel? Insert > Chart View > Chart Format > Chart Data > Chart 26 / 50 Category: MS PowerPoint 26) Which of the following is used to resize an image in PowerPoint? Format Picture Tool Design > Rescale Text Box Format Insert > Image Resizer 27 / 50 Category: MS PowerPoint 27) Which option allows you to change the orientation of your slides in PowerPoint? Home > Slide Orientation File > Page Setup View > Orientation Design > Slide Orientation 28 / 50 Category: MS PowerPoint 28) Which view allows you to edit the slide while seeing the slide sorter in PowerPoint? Slide Show View Reading View Slide Sorter View Normal View 29 / 50 Category: MS PowerPoint 29) How do you add a new slide in PowerPoint? Press Ctrl + N Click File > New Right-click in the slide sorter pane Press Ctrl + M 30 / 50 Category: MS PowerPoint 30) How can you change the order of slides in PowerPoint? Slide Show > Rearrange Slide Sorter View > Drag the slide Insert > Slide Order Home > Move Slide 31 / 50 Category: MS PowerPoint 31) Which of the following is a predefined design that controls the look of the slides? Animation Slide theme Transition Slide layout 32 / 50 Category: MS PowerPoint 32) Which of the following allows you to change the layout of a slide? Design tab Slide Show tab Home tab View tab 33 / 50 Category: MS PowerPoint 33) How can you add a new slide to a presentation in PowerPoint? View > Slide Design > Add Slide Home > New Slide Insert > Slide 34 / 50 Category: MS PowerPoint 34) What is the default slide layout in PowerPoint? Title and Content Section Header Blank Title Slide 35 / 50 Category: MS PowerPoint 35) Which of the following tools allows you to draw freehand on a slide during a presentation? Drawing Tool Pen Tool Free Draw Markup Tool 36 / 50 Category: Advance Excel 36) What does the function LEN() do? Joins two strings Trims spaces from a string Returns the length of a string Converts text to lowercase 37 / 50 Category: Advance Excel 37) What does the function TRIM() do? Changes text to uppercase Concatenates strings Removes spaces from a string Finds a substring 38 / 50 Category: Advance Excel 38) What does the LOOKUP function do? Filters a range Finds a value in a range Validates a range Sorts a range 39 / 50 Category: Advance Excel 39) What does the IF function do? Checks for duplicates Finds the sum of a range Calculates an average Tests a condition and returns one value for TRUE and another for FALSE 40 / 50 Category: Advance Excel 40) What is a macro in Excel? A set of instructions to automate tasks A tool for data analysis A shortcut for frequently used commands A large formula 41 / 50 Category: Advance Excel 41) What is the purpose of the Slicers in Excel? To sort data To create charts To format cells To filter data visually 42 / 50 Category: Advance Excel 42) Which function finds the position of a substring within a string? FIND LOCATE POSITION SEARCH 43 / 50 Category: Advance Excel 43) What does the REPLACE function do? Replaces part of a string with another string Changes the case of a string Joins two strings Finds a substring 44 / 50 Category: Advance Excel 44) Which of the following is a logical function? AVERAGE IF SUM COUNT 45 / 50 Category: Advance Excel 45) Which of the following can be used to create a pivot table View > PivotTable Data > Sort Insert > PivotTable Data > Filter 46 / 50 Category: AI Applications 46) Which AI application helps in providing personalized news or content recommendations on digital platforms? Computer Vision Recommender Systems Predictive Text Autonomous Robotics Explanation: Recommender systems use algorithms to suggest articles, news, or videos based on the user’s browsing history and preferences.47 / 50 Category: AI Applications 47) Which version of GPT does ChatGPT currently use (as of December 2024)? GPT-5 GPT-2 GPT-3 GPT-4 48 / 50 Category: AI Applications 48) What AI technology is most commonly used for fraud detection in online banking and finance applications? Predictive Analytics Machine Learning Natural Language Processing Neural Networks Explanation: Machine learning algorithms are used to analyze transaction patterns and identify fraudulent activities in real-time in banking and finance applications.49 / 50 Category: AI Applications 49) What AI application is used in social media platforms to automatically tag people in photos? Natural Language Processing Predictive Analytics Text Summarization Face Recognition Explanation: Face recognition is used by social media platforms like Facebook to detect and tag people in photos automatically.50 / 50 Category: AI Applications 50) 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.Your score is 0% Restart quiz Anonymous feedback Send feedback