L&L Excel

What is the code for getting a list of the name of all sheets in workbook (wb)?

• wb.getSheets()

• wb.sheetnames

• wb.sheets

• wb.getSheetNames()

How do you get the value of cell "A1" in a sheet?

• sheet['A1']

• sheet['A1'].value

• sheet['A1'].getValue()

• sheet['A1'].value()

What is an Excel Spreadsheet document called

• Cell

• Workbook

• Worksheet

• File

What is this code doing?

• Printing the value of every 3rd column in row 2 starting at column 2

• Printing the value of every 3rd row in column 3 starting at row 2

• Printing the value of every other column in row 3 starting at column 2

• Printing the value of every other row in in column 2 starting at row 2

Using openpyxl, how do you open a workbook?

• openpyxl.open()

• openpyxl.Workbook()

• openpyxl.load_workbook()

• openpyxl.new_workbook()

To convert column letters to numbers using openpyxl, which function do you use?

• column_to_number()

• get_column_number()

• column_index_from_string()

• convert_column()

Which of the following is a correct way to access rows in a Worksheet object using openpyxl

• sheet.rows[1]

• sheet.get_rows(1)

• list(sheet.rows)[1]

• sheet[1].rows

What method in openpyxl is used to add a new sheet to a workbook?

• workbook.add_sheet()

• workbook.create_sheet()

• workbook.new_sheet()

• workbook.insert_sheet()

How could you set the value of a cell in a Worksheet using openpyxl?

• sheet.set('A1', 'Hello')

• sheet['A1'] = 'Hello'

• sheet.write('A1', 'Hello')

• sheet.value('A1', 'Hello'

In openpyxl, how do you access a range of cells

• sheet.get_cells('A1:C3')

• sheet['A1:C3']

• sheet.range('A1:C3')

• sheet.cells('A1:C3')