OA reviewer PROG.

OA reviewer PROG. - Quiz

1. 1.
How do you access the active worksheet?

A) wb.current
B) wb.active <
C) wb.main
D) None of These
E) wb.sheet

2. 2. What does the geometry("300x200") method do?

A) Sets the window size
B) Sets the widget size <
C) None of These
D) Sets padding
E) Sets the font size

3. 3. Which function is often used to trigger saving Excel data in a Tkinter app?

A) Button command <
B) Label text()
C) Menu bind()
D) Entry get()
E) None of These

4. 4. How do you create a new sheet?

A) wb.create_sheet("NewSheet") <
B) None of These
C) wb.add("NewSheet")
D) wb.new_sheet("NewSheet")
E) wb.insert("NewSheet")

5. 5. Which widget is best to show Excel data in Tkinter?

A) Treeview() <
B) Label()
C) Listbox()
D) Text()
E) None of These

6. 6. Which parameter controls text color?

A) color
B) fg <
C) None of These
D) front
E) text_color

7. 7. What method saves the workbook to a file?

A) write("file.xlsx")
B) None of These
C) close("file.xlsx")
D) save("file.xlsx") <
E) export("file.xlsx")

8. 8. How do you iterate over all rows?

A) for row in ws.iter_rows(): <
B) None of These
C) for row in ws.loop_rows():
D) for row in ws.rows():
E) for row in ws.allrows():

9. 9. Which object represents a single sheet in OpenPyXL?

A) Row
B) Worksheet <
C) None of These
D) Workbook
E) Cell

10. 10. What function creates the main application window?

A) None of These
B) Root()
C) Main()
D) Window()
E) Tk() <

11. 11. What does root.mainloop() do?

A) Runs only once
B) Keeps the window open and listens for events <
C) Closes the window
D) Loads external files
E) None of These

12. 12. What function is used to open an existing Excel workbook?

A) load_workbook() <
B) read_file()
C) excel_load()
D) None of These
E) open_excel()

13. 13. How do you read data from a cell?

A) ws["A1"].value <
B) ws.fetch("A1")
C) ws.read("A1")
D) None of These
E) ws.get("A1")

14. 14. Which attribute gives the maximum number of rows used?

A) ws.length
B) ws.max row <
C) ws.rowcount
D) None of These
E) ws.rows

15. 15. What is OpenPyXL used for?

A) Working with Excel files in Python <
B) Creating PDFs
C) Web scraping
D) Connecting to databases
E) None of These

16. 16. How do you make a column heading bold in OpenPyXL?

A) Use Style(bold=True)
B) None of These
C) Use Text(bold=True)
D) Use Header(bold=True)
E) Use Font(bold=True) <

17. 17. Which OpenPyXL function reads all cells in a row?

A) loop_rows()
B) None of These
C) rows()
D) get_row()
E) iter_rows() <

18. 18. Which attribute gives the maximum number of columns used?

A) ws.colcount
B) None of These
C) ws.cols
D) ws.width
E) ws.max_column <

19. 19. What do you call the top-level window in Tkinter?

A) Tk() <
B) Shell()
C) None of These
D) Frame()
E) Main()

20. 21. What file type does OpenPyXL NOT support?

A) .CSV
B) .xlsm
C) .xls <
D) .xltx
E) None of These

21. 22. Which widget allows single-line text input?

A) None of These
B) Text()
C) Entry() <
D) Label()
E) Button()

22. 23. What method is used to place widgets using absolute positioning?

A) place() <
B) align()
C) None of These
D) pack()
E) grid()

23. 25. What function is used to clear all contents of a Text widget?

A) clear()
B) delete("1.0", END) <
C) reset()
D) remove()
E) None of These

24. 27. What function opens a file dialog to select a file?

A) askfile()
B) browse()
C) selectfile()
D) filedialog.askopenfilename() <
E) None of These

25. 28. Which widget is used to display images?

A) None of These
B) Text()
C) Canvas()
D) Label() with Photolmage <
E) Button()

26. 29. How do you write data to a cell?

A) ws.cell("A1").write("Hello")
B) None of These
C) ws.set("A1", "Hello")
D) ws["A1"] = "Hello" <
E) ws.put("A1", "Hello")

27. 30. How do you change the window title?

A) None of These
B) root.text("My App")
C) root.name("My App")
D) root.caption("My App")
E) root.title("My App") <

28. 31. Which Tkinter widget can be used to make a scrollable text box?

A) Canvas()
B) None of These
C) Entry()
D) Text() with Scrollbar() <
E) Label()

29. 32. What is the file extension for Excel workbooks used in OpenPyXL?

A) None of These
B) .xlsx <
C) .xls
D) .CSV
E) .txt

30. 33. Which method arranges widgets in rows and columns?

A) layout()
B) place()
C) None of These
D) pack()
E) grid() <

31. 34. What parameter in Button() defines the action when clicked?

A) onClick
B) event
C) None of These
D) command <
E) function

32. 35. Which method merges cells?

A) ws.join("A1:B1")
B) ws.merge("A1:B1")
C) None of These
D) ws.merge_cells("A1:B1") <
E) ws.combine("A1:B1")

33. 36. Which method creates a new Excel workbook?

A) None of These
B) CreateBook()
C) Workbook() <
D) NewExcel()
E) Excel()

34. 37. How do you insert a new row at the top?

A) ws.add_row(1)
B) ws.top_row()
C) None of These
D) ws.new_row(1)
E) ws.insert_rows(1) <

35. 38. What event triggers when a Tkinter button is clicked?

A) onPress()
B) event()
C) command <
D) click()
E) None of These

36. 39. To automatically update Excel when a button is pressed, which command is used?

A) None of These
B) Button command=function_name <
C) Menu run-function_name
D) Label text=function_name
E) Entry onChange=function_name

37. 40. What library must be imported for Treeview?

A) from tkinter import ttk <
B) import view
C) from tkinter import tree
D) None of These
E) import tree

38. 41. How do you get all sheet names?

A) wb.sheetnames <
B) wb.list()
C) wb.names
D) None of These
E) wb.sheets()

39. 42. Which command imports the OpenPyXL module?

A) import pyexcel
B) from excel import *
C) import openpyxi <
D) None of These
E) from openxi import *

40. 43. Which Tkinter widget is ideal for entering Excel filenames?

A) Entry() <
B) Frame()
C) Text()
D) None of These
E) Label()

41. 44. What parameter in Label() sets the displayed text?

A) caption
B) label
C) value
D) text <
E) None of These

42. 46. How do you show a success message after saving a file?

A) messagebox.showinfo() <
B) alert()
C) print("Saved")
D) label.set()
E) None of These

43. 48. What widget is used to display text or labels?

A) None of These
B) Entry()
C) Text()
D) Canvas()
E) Label() <

44. 49. How do you get a specific sheet by name?

A) wb.sheet("Sheet1")
B) wb.active("Sheet1")
C) None of These
D) wb["Sheet1"] <
E) wb.get("Sheet1")

45. 50. Which module provides styling tools in OpenPyXL?

A) openpyxl.format
B) openpyxl.design
C) None of These
D) openpyxl.styles <
E) openpyxl.color

46. 52. Which widget allows users to select from a list of options?

A) Menu()
B) Choice()
C) Combo()
D) None of These
E) Listbox() <

47. 53. Which function closes a workbook?

A) wb.close() <
B) wb.stop()
C) wb.end()
D) None of These
E) wb.finish()

48. 54. How can you disable an Entry widget after saving data?

A) None of These
B) entry.freeze()
C) entry.config(state="disabled") <
D) entry.off()
E) entry.hide()

49. 55. How do you reopen a workbook after saving in OpenPyXL?

A) read_workbook("file.xlsx")
B) wb.open("file.xlsx")
C) None of These
D) load_workbook("file.xlsx") <
E) get_book("file.xlsx")

50. 21. What file type does OpenPyXL NOT support?

A) .xls <
B) .xltx
C) .xlsm
D) .CSV
E) None of These

Created with That Quiz — where a math practice test is always one click away.