L&L Excel

L&L Excel

Professional Development

13 Qs

quiz-placeholder

Similar activities

Java SE: Programming I

Java SE: Programming I

Professional Development

10 Qs

MS Excel Revision Quiz (2nd phase ICT training)

MS Excel Revision Quiz (2nd phase ICT training)

Professional Development

10 Qs

Soal TIK Exel kelas VI MI

Soal TIK Exel kelas VI MI

Professional Development

10 Qs

MS Excel Basics Quiz

MS Excel Basics Quiz

Professional Development

10 Qs

Kaun banega excel champ?

Kaun banega excel champ?

Professional Development

10 Qs

Basics of Excel

Basics of Excel

Professional Development

11 Qs

Advanced Excel End of Workshop Assessment

Advanced Excel End of Workshop Assessment

Professional Development

10 Qs

Introduction to Pivots

Introduction to Pivots

Professional Development

11 Qs

L&L Excel

L&L Excel

Assessment

Quiz

Computers

Professional Development

Practice Problem

Hard

Created by

Adam Alam

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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()

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

sheet['A1']

sheet['A1'].value

sheet['A1'].getValue()

sheet['A1'].value()

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

What is an Excel Spreadsheet document called

Cell

Workbook

Worksheet

File

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image

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

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Using openpyxl, how do you open a workbook?

openpyxl.open()

openpyxl.Workbook()

openpyxl.load_workbook()

openpyxl.new_workbook()

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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()

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?