
L&L Excel
Quiz
•
Computers
•
Professional Development
•
Practice Problem
•
Hard
Adam Alam
FREE Resource
Enhance your content in a minute
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
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Excel Basic 2019
Quiz
•
Professional Development
15 questions
Google Sheets Quiz: From Importing to Analysis
Quiz
•
Professional Development
15 questions
Microsoft Excel Functions & Formulas
Quiz
•
3rd Grade - Professio...
10 questions
Excel day 1
Quiz
•
Professional Development
15 questions
Pretest Latihan Soal Excel
Quiz
•
Professional Development
10 questions
Excel 365
Quiz
•
Professional Development
10 questions
Excel Test for Beginners
Quiz
•
Professional Development
10 questions
Training Microsoft Excel 2024
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
How to Email your Teacher
Quiz
•
Professional Development
6 questions
3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET
Quiz
•
Professional Development
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
22 questions
Multiplying Exponents with the Same Base
Quiz
•
9th Grade - Professio...
40 questions
Flags of the World
Quiz
•
KG - Professional Dev...
