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) Which device is used to point and select objects on the screen? Printer Mouse Keyboard Scanner 2 / 25 Category: Computer Fundamentals 2) What does RAM stand for? Rapid Access Memory Read Access Memory Run Access Memory Random Access Memory 3 / 25 Category: Computer Fundamentals 3) A kilobyte equals how many bytes? 1000 8 2048 1024 4 / 25 Category: Computer Fundamentals 4) Which of the following is an example of system software? Microsoft Office Operating System Adobe Photoshop Google Chrome 5 / 25 Category: Computer Fundamentals 5) Which of the following is an application of AI? Self-driving cars Spreadsheet management Internet browsing Word processing software 6 / 25 Category: MS Word 6) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Table of Contents Formatting Painter Text Box Paragraph Styles 7 / 25 Category: MS Word 7) What is the default font used in Microsoft Word 2016 and later versions? Times New Roman Verdana Arial Calibri 8 / 25 Category: MS Word 8) What is the shortcut for opening a new document in Word? Ctrl + P Ctrl + S Ctrl + N Ctrl + O 9 / 25 Category: MS Word 9) What is the shortcut key for italicizing text in Word? Ctrl + U Ctrl + B Ctrl + E Ctrl + I 10 / 25 Category: MS Word 10) In Microsoft Word, how do you insert a table? Page Layout > Table Design > Table Home > Table Insert > Table 11 / 25 Category: MS Excel 11) What does the SUMIF function do? Finds the minimum value in a range Counts all values in a range Adds values based on a specific condition Adds all values in a range 12 / 25 Category: MS Excel 12) What is the shortcut key for saving a workbook? Ctrl + O Ctrl + N Ctrl + P Ctrl + S 13 / 25 Category: MS Excel 13) Which function calculates the average of a range of cells? COUNT SUM MEDIAN AVERAGE 14 / 25 Category: MS Excel 14) What is the default file extension for an Excel workbook? .xls .xlsx .csv .xlsm 15 / 25 Category: MS Excel 15) Which Excel feature allows you to visually analyze data? Filtering Sorting Data Validation Conditional Formatting 16 / 25 Category: MS Excel 16) Which of the following cannot be used as a cell reference? C B$2 1A A1 17 / 25 Category: MS Excel 17) Which option allows you to protect a worksheet? View > Protection Review > Protect Sheet Data > Protect Home > Format 18 / 25 Category: MS Excel 18) What feature allows you to repeat column titles on every printed page? Print Titles Header/Footer Page Layout Print Area 19 / 25 Category: MS Excel 19) What is the main purpose of the Data Validation feature? To format cells To restrict the type of data entered in a cell To create charts To summarize data 20 / 25 Category: MS Excel 20) Which of the following is NOT a valid chart type in Excel? Radar Chart Histogram Gantt Chart Bubble Chart 21 / 25 Category: MS PowerPoint 21) Which of the following is the correct way to insert a hyperlink in PowerPoint? Home > Insert > Link View > Hyperlink Slide Show > Link Insert > Hyperlink 22 / 25 Category: MS PowerPoint 22) Which option allows you to change the orientation of your slides in PowerPoint? Home > Slide Orientation File > Page Setup Design > Slide Orientation View > Orientation 23 / 25 Category: MS PowerPoint 23) What is the function of the ‘Format Painter’ in PowerPoint? It adds text boxes. It copies formatting from one object to another. It resizes images. It changes the slide layout. 24 / 25 Category: MS PowerPoint 24) Which of the following is not a type of transition in PowerPoint? Fly In Wipe Fade Zoom In 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 Design > Background Styles Home > Background Insert > Background 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) The smallest unit of data in a computer is: Kilobyte Bit Megabyte Byte 2 / 50 Category: Computer Fundamentals 2) The hexadecimal number system has a base of: 2 8 16 10 3 / 50 Category: Computer Fundamentals 3) Which of the following is an application of AI? Self-driving cars Spreadsheet management Word processing software Internet browsing 4 / 50 Category: Computer Fundamentals 4) Identify this computer component Black Box CPU Computer Cabinate 5 / 50 Category: Computer Fundamentals 5) The main function of the ALU is to: Control the input and output Store data Perform arithmetic and logic operations Perform logical calculation 6 / 50 Category: MS Word 6) Which tab in Microsoft Word contains the ‘Font’ and ‘Paragraph’ groups? Insert Home View Review 7 / 50 Category: MS Word 7) In Word, what is the purpose of ‘Track Changes’? To track the word count To track document edits and revisions To keep track of document versions To track hyperlinks 8 / 50 Category: MS Word 8) What is the default file extension for a Microsoft Word document? .docx .txt .pdf .xls 9 / 50 Category: MS Word 9) Which command would you use to insert page numbers into a document? Insert > Page Numbers File > Page Numbers Insert > Page Break View > Page Numbers 10 / 50 Category: MS Word 10) How do you close a Word document without exiting the Word application? Click File > Close Click the 'X' in the top-right corner Press Ctrl + W CTRL + NCheck 11 / 50 Category: MS Word 11) What is the shortcut for opening a new document in Word? Ctrl + N Ctrl + P Ctrl + O Ctrl + S 12 / 50 Category: MS Word 12) Which of the following views is best for editing a document? Reading View Web Layout View Draft View Print Layout View 13 / 50 Category: MS Word 13) Which key combination is used to create a new document in Word? Ctrl + O Ctrl + P Ctrl + N Ctrl + S 14 / 50 Category: MS Word 14) Which feature in Microsoft Word helps you format multiple sections of the document simultaneously? Table of Contents Paragraph Styles Formatting Painter Text Box 15 / 50 Category: MS Word 15) Which function key opens the ‘Help’ menu in Word? F4 F2 F1 F3 16 / 50 Category: MS Excel 16) How can you quickly sum a column of numbers? Select the column and press Ctrl + S Click the AutoSum button Right-click and choose Sum Use the SUM function manually 17 / 50 Category: MS Excel 17) What does the CONCATENATE function do? Changes the case of a string Combines multiple strings into one Finds a substring in a string Splits a string into multiple parts 18 / 50 Category: MS Excel 18) What does the SUMIF function do? Counts all values in a range Finds the minimum value in a range Adds all values in a range Adds values based on a specific condition 19 / 50 Category: MS Excel 19) Which function returns the current date? TIMESTAMP() DATE() NOW() TODAY() 20 / 50 Category: MS Excel 20) What happens when you double-click a cell’s right border? The cell is copied The cell is formatted The column width adjusts to fit the content The cell is deleted 21 / 50 Category: MS Excel 21) How do you create a hyperlink in Excel? Right-click > Insert Link Insert > Hyperlink Data > Link Format > Hyperlink 22 / 50 Category: MS Excel 22) Which Excel feature allows you to visually analyze data? Filtering Data Validation Sorting Conditional Formatting 23 / 50 Category: MS Excel 23) Which function would you use to find the highest value in a range? HIGH MAX LARGE TOP 24 / 50 Category: MS Excel 24) Which symbol is used to denote an absolute reference in a formula? $ & # @ 25 / 50 Category: MS Excel 25) What will the result of the formula =5^2 be? 10 25 2 5 26 / 50 Category: MS PowerPoint 26) What feature in PowerPoint lets you insert charts and graphs? Insert > Chart Insert > SmartArt Insert > Tables Insert > Picture 27 / 50 Category: MS PowerPoint 27) Which option is used to create hyperlinks between slides in PowerPoint? Slide Show > Action Settings Home > Link View > Link Insert > Hyperlink 28 / 50 Category: MS PowerPoint 28) Which of the following is the default view when you open a PowerPoint presentation? Normal View Slide Show View Slide Sorter View Outline View 29 / 50 Category: MS PowerPoint 29) What is the primary purpose of the ‘Slide Master’ feature? To manage animations and transitions To apply consistent formatting and layout across slides To create a new slide layout To add animations to charts 30 / 50 Category: MS PowerPoint 30) What is the purpose of the Slide Master in PowerPoint? To insert and edit charts To manage audio and video settings To apply different animations to slides To create and edit themes and layouts for the slides 31 / 50 Category: MS PowerPoint 31) Which of the following tools allows you to align objects in PowerPoint? Insert > Align Home > Align View > Align Format > Align 32 / 50 Category: MS PowerPoint 32) Which of the following shortcuts will you use to undo an action in PowerPoint? Ctrl + Y Ctrl + X Ctrl + Z Ctrl + A 33 / 50 Category: MS PowerPoint 33) How can you add a new slide to a presentation in PowerPoint? View > Slide Home > New Slide Insert > Slide Design > Add Slide 34 / 50 Category: MS PowerPoint 34) Which file extension does a PowerPoint 2019 presentation use? .ppt .ppxt .pptx .ppsx 35 / 50 Category: MS PowerPoint 35) Which of the following is a predefined design that controls the look of the slides? Slide theme Transition Slide layout Animation 36 / 50 Category: Advance Excel 36) Which function finds the position of a substring within a string? POSITION LOCATE SEARCH FIND 37 / 50 Category: Advance Excel 37) What does the function TRIM() do? Finds a substring Concatenates strings Removes spaces from a string Changes text to uppercase 38 / 50 Category: Advance Excel 38) What does the REPLACE function do? Joins two strings Finds a substring Changes the case of a string Replaces part of a string with another string 39 / 50 Category: Advance Excel 39) Which of the following is a logical function? AVERAGE IF COUNT SUM 40 / 50 Category: Advance Excel 40) What is the purpose of the Fill Handle? To fill cells with color To format cells To delete rows and columns To copy formulas and data to adjacent cells 41 / 50 Category: Advance Excel 41) What does the IF function do? Calculates an average Finds the sum of a range Checks for duplicates Tests a condition and returns one value for TRUE and another for FALSE 42 / 50 Category: Advance Excel 42) Which Excel feature can you use to group data? Sort PivotTable Data Validation Filter 43 / 50 Category: Advance Excel 43) What does the AVERAGEIF function do? Calculates the average of all cells Averages cells that meet a certain condition Counts cells that meet a condition Finds the maximum value 44 / 50 Category: Advance Excel 44) What does the PMT function calculate? Interest Rate Future Value Present Value Payment for a loan 45 / 50 Category: Advance Excel 45) What does the function LEN() do? Converts text to lowercase Joins two strings Trims spaces from a string Returns the length of a string 46 / 50 Category: AI Applications 46) Which AI tool is primarily used for speech recognition? Apache Hadoop IBM Watson R Studio Google Speech-to-Text 47 / 50 Category: AI Applications 47) What AI application is used in social media platforms to automatically tag people in photos? Text Summarization Face Recognition Predictive Analytics Natural Language Processing Explanation: Face recognition is used by social media platforms like Facebook to detect and tag people in photos automatically.48 / 50 Category: AI Applications 48) What is OpenCV used for? Data analysis Image processing Natural language processing Database management 49 / 50 Category: AI Applications 49) Which AI system is frequently used by websites like YouTube to recommend videos to users? Collaborative Filtering Predictive Analytics Generative Adversarial Networks Content Filtering Explanation: Collaborative filtering is the algorithm behind the recommendation systems used by platforms like YouTube to suggest videos based on user preferences and past behavior.50 / 50 Category: AI Applications 50) Which version of GPT does ChatGPT currently use (as of December 2024)? GPT-4 GPT-2 GPT-5 GPT-3 Your score is 0% Restart quiz Anonymous feedback Send feedback