PREMIUM LOGIN

ClassTools Premium membership gives access to all templates, no advertisements, personal branding and other benefits!

Username:    
Password:    
Submit Cancel

 
Not a member? JOIN NOW!  

QR Challenge: Excel Vocabulary Part 2

Created using the ClassTools QR Treasure Hunt Generator

Print

Create a New QuizEdit this quiz View a Sample Quiz
Detailed Case Study Search the Archive Feedback

Teacher Notes

A. Prior to the lesson:

1. Arrange students into groups. Each group needs at least ONE person who has a mobile device.

2. If their phone camera doesn't automatically detect and decode QR codes, ask students to

3. Print out the QR codes.

4. Cut them out and place them around your class / school.

B. The lesson:

1. Give each group a clipboard and a piece of paper so they can write down the decoded questions and their answers to them.

2. Explain to the students that the codes are hidden around the school. Each team will get ONE point for each question they correctly decode and copy down onto their sheet, and a further TWO points if they can then provide the correct answer and write this down underneath the question.

3. Away they go! The winner is the first team to return with the most correct answers in the time available. This could be within a lesson, or during a lunchbreak, or even over several days!

C. TIPS / OTHER IDEAS

4. A detailed case study in how to set up a successful QR Scavenger Hunt using this tool can be found here.

Questions / Answers (teacher reference)

Question

Answer

1. Absolute cell reference - A cell reference that does not change when copied or moved to a new cell
2. Argument - The value the function uses to perform a calculation, including a number, text, a cell reference, or even a formula that acts as an operand
3. Automatic page break - Excel inserts this whenever it runs out of room on what would be a printed page
4. Chart - A graphical representation of data
5. Conditional formatting - Highlights worksheet data by changing the look of cells that meet a specified condition you create
6. Fill (2nd Meaning) - Copies a cells contents (any numbers, text, or formulas) and formatting into an adjacent cell or range
7. Fill handle - The little box that appears in the lower-right corner of the active cell or range, and is used to fill cells
8. Freeze pane - Rows and/or columns you select to remain visible on the screen as the rest of the worksheet scrolls in the window
9. Function - Shorthand way to write an equation that performs a calculation. For example the SUM function is used to make adding a range easier
10. Manual calculation - Lets you determine when Excel calculates the formulas
11. Manual page break - A page break you insert manually to start a new page
12. Mixed cell reference - Cell references that contain both relative and absolute column or row references
13. Operand - A constant (text or number) or cell reference used in a formula. For example in 8 + 2, the 8 and 2 are the operands
14. Operator - A symbol that indicates the type of calculation to perform on operands. For example, in 8 + 2, the + is the operator
15. Order of evaluation - The sequence used to calculate the value of a formula – exactly the same as order of operation in math
16. Page Break Preview - View that shows where the page breaks are in a worksheet, which is helpful when you prepare a worksheet for printing
17. Point-and-click method - Allows you to point and click (or touch) each cell in a formula rather than typing out cell references
18. Print area - Consists of the cells and ranges you can designate for printing and does not have to be the entire spreadsheet
19. Print title - Rows and/or columns in a worksheet that you assign to print on each page
20. Relative cell reference - A cell reference that changes by adjusting to its new location when copied or moved
21. Scale - Enables you to resize a worksheet to print on a specific number of pages
22. Sort - Rearranging the data in a spreadsheet in a more meaningful order. For example, putting a range in alphabetical order
23. Split - Divides the worksheet window into two or four panes that you can scroll and work in independently from one another
24. Sum button - The button at the top right of the Home tab that makes using functions to write formulas much easier to do

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Absolute_cell_reference_-_A_cell_reference_that_does_not_change_when_copied_or_moved_to_a_new_cell

Question 1 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Argument_-_The_value_the_function_uses_to_perform_a_calculation,_including_a_number,_text,_a_cell_reference,_or_even_a_formula_that_acts_as_an_operand

Question 2 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Automatic_page_break_-_Excel_inserts_this_whenever_it_runs_out_of_room_on_what_would_be_a_printed_page

Question 3 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Chart_-_A_graphical_representation_of_data

Question 4 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Conditional_formatting_-_Highlights_worksheet_data_by_changing_the_look_of_cells_that_meet_a_specified_condition_you_create

Question 5 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Fill_(2nd_Meaning)_-_Copies_a_cells_contents_(any_numbers,_text,_or_formulas)_and_formatting_into_an_adjacent_cell_or_range

Question 6 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Fill_handle_-_The_little_box_that_appears_in_the_lower-right_corner_of_the_active_cell_or_range,_and_is_used_to_fill_cells

Question 7 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Freeze_pane_-_Rows_and/or_columns_you_select_to_remain_visible_on_the_screen_as_the_rest_of_the_worksheet_scrolls_in_the_window

Question 8 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Function_-_Shorthand_way_to_write_an_equation_that_performs_a_calculation._For_example_the_SUM_function_is_used_to_make_adding_a_range_easier

Question 9 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Manual_calculation_-_Lets_you_determine_when_Excel_calculates_the_formulas

Question 10 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Manual_page_break_-_A_page_break_you_insert_manually_to_start_a_new_page

Question 11 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Mixed_cell_reference_-_Cell_references_that_contain_both_relative_and_absolute_column_or_row_references

Question 12 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Operand_-_A_constant_(text_or_number)_or_cell_reference_used_in_a_formula._For_example_in_8_+_2,_the_8_and_2_are_the_operands

Question 13 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Operator_-_A_symbol_that_indicates_the_type_of_calculation_to_perform_on_operands._For_example,_in_8_+_2,_the_+_is_the_operator

Question 14 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Order_of_evaluation_-_The_sequence_used_to_calculate_the_value_of_a_formula_–_exactly_the_same_as_order_of_operation_in_math

Question 15 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Page_Break_Preview_-_View_that_shows_where_the_page_breaks_are_in_a_worksheet,_which_is_helpful_when_you_prepare_a_worksheet_for_printing

Question 16 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Point-and-click_method_-_Allows_you_to_point_and_click_(or_touch)_each_cell_in_a_formula_rather_than_typing_out_cell_references

Question 17 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Print_area_-_Consists_of_the_cells_and_ranges_you_can_designate_for_printing_and_does_not_have_to_be_the_entire_spreadsheet

Question 18 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Print_title_-_Rows_and/or_columns_in_a_worksheet_that_you_assign_to_print_on_each_page

Question 19 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Relative_cell_reference_-_A_cell_reference_that_changes_by_adjusting_to_its_new_location_when_copied_or_moved

Question 20 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Scale_-_Enables_you_to_resize_a_worksheet_to_print_on_a_specific_number_of_pages

Question 21 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sort_-_Rearranging_the_data_in_a_spreadsheet_in_a_more_meaningful_order._For_example,_putting_a_range_in_alphabetical_order

Question 22 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Split_-_Divides_the_worksheet_window_into_two_or_four_panes_that_you_can_scroll_and_work_in_independently_from_one_another

Question 23 (of 24)

 


Excel Vocabulary Part 2: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sum_button_-_The_button_at_the_top_right_of_the_Home_tab_that_makes_using_functions_to_write_formulas_much_easier_to_do

Question 24 (of 24)