Back to Subject
View Notes

Unit 3 - Practice Quiz

INT346

1 In the context of Robotic Process Automation (RPA), what is the primary function of a Package?

A. To compress files into a ZIP format for storage.
B. To bundle a specific set of actions or commands needed to perform tasks in a bot.
C. To create a graphical user interface for the end-user.
D. To encrypt data during transmission between the bot and the control room.

2 When integrating package actions into a bot, why is version control of the package important?

A. It increases the execution speed of the bot by .
B. It ensures the bot utilizes the correct set of features and bug fixes compatible with the existing code.
C. It is required to change the programming language of the bot.
D. It automatically converts Excel files to PDF.

3 Which of the following acts as the primary difference between 'Excel Basic' and 'Excel Advanced' packages in many RPA tools?

A. Excel Basic can only read CSV files, while Advanced reads XLSX.
B. Excel Basic requires Microsoft Excel to be installed, while Advanced does not.
C. Excel Advanced requires Microsoft Excel to be installed, while Basic does not.
D. Excel Basic supports macros, while Advanced does not.

4 When using an Excel action to read data, what does the 'Contains Header' option usually signify?

A. The first row of the data contains formatting styles.
B. The first row of the data contains column names and should not be processed as data.
C. The file is password protected.
D. The bot should add a header row to the output file.

5 Which action is required to initiate any read or write operation in an Excel Advanced session?

A. Activate Sheet
B. Open/Connect
C. Get All Cells
D. Run Macro

6 In Excel Automation, what is a 'Session Name' used for?

A. To name the output PDF file.
B. To serve as a unique identifier linking multiple actions to a specific open workbook.
C. To define the user credentials for logging into Windows.
D. To calculate formulas within the spreadsheet.

7 Which file extension is NOT typically supported by standard Excel Basic file operations?

A. .xlsx
B. .xls
C. .csv
D. .exe

8 To read a specific data point from the intersection of the 3rd column and 5th row, which cell reference is used?

A. C5
B. 5C
C. E3
D. Row3Col5

9 What is the result of the 'Get Single Cell' action in an RPA Excel package?

A. It deletes the content of the cell.
B. It retrieves the value from a specified cell and stores it in a variable.
C. It changes the background color of the cell.
D. It merges the cell with the one next to it.

10 Which technique is most efficient for processing a large dataset (e.g., rows) in Excel Automation?

A. Looping through each row and reading cells one by one.
B. Using the 'Get All Cells' action to load data into a DataTable variable and processing in memory.
C. Taking a screenshot of every page.
D. Opening and closing the file for every single row.

11 What does the 'Save As' action allow a bot to do?

A. Only save the changes in the current file.
B. Save the current workbook with a new name or different file format.
C. Save the workbook to the cloud without a local copy.
D. Delete the original file automatically.

12 In Excel Advanced, how can a bot execute complex pre-written VBA code?

A. By using the 'Run Macro' action.
B. By typing the code into cell A1.
C. By using the 'Calculate Formula' action.
D. By converting the file to a text file.

13 When generating a QR Code using RPA, what is the primary input required?

A. The color of the QR code.
B. The text, URL, or data to be encoded.
C. The printer name.
D. The scanning camera resolution.

14 Which action is used to interpret the information contained within a QR code image file?

A. Generate QR Code
B. Scan/Read QR Code
C. OCR to Text
D. Image Resize

15 Which of the following is a valid output format when using a 'Generate QR Code' action?

A. A text file (.txt)
B. An image file (e.g., .png or .jpg)
C. An audio file (.mp3)
D. A spreadsheet (.xlsx)

16 In File Operations, which action is used to combine multiple files into a compressed archive?

A. Merge Files
B. Zip/Compress Files
C. Concat Text
D. Encrypt Files

17 Why is the 'If File Exists' condition critical in file automation workflows?

A. It checks if the file has a virus.
B. It prevents errors by ensuring a file is present before attempting to read or move it.
C. It automatically creates the file if it is missing.
D. It renames the file to avoid duplicates.

18 Which Excel action allows you to filter rows based on specific criteria (e.g., Age )?

A. Sort Data
B. Filter/AutoFilter
C. Find and Replace
D. Merge Cells

19 To iterate through every file within a specific folder, which loop construct is used?

A. Loop n times
B. Loop for each row in CSV
C. Loop for each file in folder
D. While loop

20 When writing data to a text file, what does the 'Append' option do?

A. Overwrites the existing content of the file.
B. Adds the new data to the end of the existing content without deleting it.
C. Creates a new file with a timestamp.
D. Deletes the file before writing.

21 What happens if a bot attempts to 'Create Folder' using a path that already exists?

A. The bot usually ignores the command or returns an error depending on configuration.
B. The existing folder is deleted.
C. The computer restarts.
D. All files inside the folder are duplicated.

22 In Excel Advanced, what is the purpose of the 'Set Cell' action?

A. To lock the cell format.
B. To write a value or formula into a specific cell.
C. To read the value of a cell.
D. To delete the cell row.

23 Which of the following creates a robust file path reference that works across different users' machines?

A. Hardcoding C:\Users\JohnDoe\Documents\file.txt
B. Using system variables like \Documents\file.txt
C. Assuming the file is always on the Desktop.
D. Using only the filename without a path.

24 When deleting files, what is the primary risk of using the 'Delete File' action in RPA?

A. The file might be too large to delete.
B. Permanent data loss if the wrong path pattern is provided.
C. It requires internet access.
D. It converts the file to a shortcut.

25 Which Excel action is used to remove a specific worksheet from a workbook?

A. Delete Row
B. Clear Cells
C. Delete Worksheet
D. Remove Column

26 In the context of QR codes, what determines the amount of data that can be stored?

A. The color of the ink used.
B. The version (size of the grid) and error correction level.
C. The file name of the image.
D. The speed of the processor.

27 What is the function of 'Copy File' action?

A. Moves a file from Source to Destination, removing it from Source.
B. Duplicates a file from Source to Destination, keeping the Source intact.
C. Renames a file.
D. Opens the file for editing.

28 Which variable type is most appropriate to store the data retrieved from an 'Excel: Get All Cells' action?

A. Boolean
B. String
C. DataTable / Table
D. Number

29 How can a bot identify the extension of a file during a file loop?

A. By opening the file and checking the header.
B. By using the dictionary key associated with the file extension (e.g., ).
C. By guessing based on file size.
D. It is not possible to check extensions.

30 What does the 'Close' action in Excel Automation allow the user to define?

A. Whether to save changes or discard them.
B. Which font to use for the next session.
C. The password for the computer.
D. The color of the closed window.

31 Which of the following is a File Management operation?

A. Summing column A.
B. Renaming a folder.
C. Scanning a QR code.
D. Sending an email.

32 If you need to perform a VLOOKUP operation without opening the Excel UI, which approach is best?

A. Use Excel Advanced 'VLOOKUP' formula.
B. Use Database actions to treat the Excel file as a database and run a SQL query.
C. Use keystrokes to type VLOOKUP.
D. Manually search with Ctrl+F.

33 What is a CSV file?

A. Compiled Source Value
B. Computer System Video
C. Comma Separated Values
D. Complex Sheet View

34 When generating a QR code, what happens if the input text exceeds the capacity of the selected QR version?

A. The bot automatically compresses the text.
B. The action typically fails or throws an error.
C. It generates multiple QR codes automatically.
D. It prints the text below the QR code.

35 Which package action would you use to change the location of a file from Folder A to Folder B?

A. Copy File
B. Move File
C. Create File
D. Rename File

36 In Excel Advanced, what is the effect of 'Find and Replace'?

A. It finds a file on the hard drive and replaces it.
B. It searches for specific content within the spreadsheet and replaces it with new content.
C. It finds the sum of a column.
D. It locates the Excel application.

37 To read a QR code, the input file typically must be:

A. A PDF document with text.
B. An image file format (PNG, JPG, BMP).
C. A Word document.
D. An Excel spreadsheet.

38 Which File Operation is used to organize multiple files into a new hierarchical structure?

A. Create Folder
B. Zip Files
C. Print Files
D. Read Files

39 What is the purpose of the 'Get Active Cell' action?

A. To retrieve the value from the currently selected or highlighted cell in the Excel UI.
B. To activate a specific cell.
C. To find the last used row.
D. To format the cell.

40 When working with date values in Excel via RPA, why is it important to handle format correctly?

A. Dates usually take up too much memory.
B. Excel may store dates as serial numbers (e.g., 44195), requiring conversion to be human-readable.
C. RPA bots cannot read numbers.
D. Dates are automatically deleted after 24 hours.

41 Which action allows a bot to iterate through data in an Excel sheet row by row?

A. Loop: For n times
B. Loop: For each row in worksheet/dataset
C. Loop: While x < y
D. If/Else statement

42 What is the primary benefit of using System Variables (like ) in File Operations?

A. They make the bot code shorter.
B. They allow the bot to be portable across different environments without changing hardcoded paths.
C. They encrypt the file names.
D. They increase the file size.

43 In Excel, what does the 'Go to Cell' action do?

A. It reads the value of the cell.
B. It moves the active cursor focus to a specific cell address.
C. It deletes the cell.
D. It changes the cell color.

44 Which of the following is considered a Data Manipulation technique in Excel automation?

A. Opening the application.
B. Trimming whitespace from text in a column.
C. Saving the file.
D. Closing the session.

45 When using 'Rename File', what must remain unique in the destination folder?

A. The file size.
B. The file creation date.
C. The file name.
D. The file content.

46 What is the result of using a formula like =A1*B1 in the 'Set Cell' action?

A. The bot writes the text '=A1*B1' as a string literal.
B. Excel calculates the product of values in A1 and B1 and displays the result.
C. The bot crashes.
D. The cells A1 and B1 are deleted.

47 Which action checks the size of a file before emailing it?

A. Get File Info / Properties
B. Read File
C. Open File
D. Resize File

48 To convert an Excel file to PDF using RPA, which command is commonly used?

A. Rename File to .pdf
B. Excel: Save As (type PDF) or Export to PDF
C. Zip File
D. Move File

49 What is the main advantage of using 'Close All Excel Windows' at the end of a bot run?

A. It saves the data twice.
B. It acts as a cleanup step to ensure no orphaned Excel processes consume memory.
C. It deletes the Excel application.
D. It speeds up the internet connection.

50 When scanning a QR code containing a URL, the output is typically:

A. The website opens automatically.
B. A string variable containing the URL address.
C. An image of the website.
D. A Boolean value (True/False).