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 1

Created using the ClassTools QR Treasure Hunt Generator

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. Active cell - The cell in the worksheet in which you can type data
2. Active worksheet - The worksheet that is displayed in the work area
3. Alignment – where the text is in relation to the border of the cell
4. AutoFit - Determines the best width for a column or the best height for a row, based on its contents
5. Border - The line around a cell’s edges
6. Cell - The intersection of a row and a column
7. Cell reference - Identifies the cell, and is formed by combining the cell’s column letter and row number
8. Cell style - A collection of formatting characteristics you apply to a cell or range of data
9. Clear - Removes formatting applied to a cell or a range of cells
10. Column - Appears vertically and is identified by letters at the top of the worksheet window
11. Column heading - The column identification, identified by the letter above the column
12. Editing mode - When you double-click the cell, or press the F2 key, and place the insertion point within the cell contents, you enable this mode and are able to edit cell contents
13. Fill (1st Meaning) - Background color of a cell
14. Format Painter - Enables you to copy formatting from one worksheet cell to another without copying the cell’s contents
15. Formula - An equation that calculates a new value from values currently in a worksheet
16. Formula Bar - Appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
17. Indent - Cell contents are shifted to the right
18. Merge - Combines multiple cells into one cell
19. Name Box - Cell reference area located below the Ribbon, displays the cell reference of the active cell
20. Number format - The way numerical data looks in a cell
21. Orientation - The angle at which the data is displayed within a cell
22. Range - A group of selected cells
23. Range reference - How the range is identified; made up of the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon
24. Row - Appears horizontally and is identified by numbers on the left side of the worksheet window
25. Row heading - The row identification, identified by the number beside the column
26. Sheet tab - Tab at the bottom of the worksheet window that displays the name of the worksheet
27. Spreadsheet - A grid of rows and columns in which you enter text, numbers, and the results of calculations
28. Truncate - Hidden from view
29. Workbook - The file used to store worksheets; what an Excel file is called
30. Worksheet - A computerized spreadsheet, the words spreadsheet and worksheet are interchangeable
31. Wrap text - When the row height adjusts automatically to include additional lines until all the text is visible within the same cell

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Active_cell_-_The_cell_in_the_worksheet_in_which_you_can_type_data

Question 1 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Active_worksheet_-_The_worksheet_that_is_displayed_in_the_work_area

Question 2 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Alignment_–_where_the_text_is_in_relation_to_the_border_of_the_cell

Question 3 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=AutoFit_-_Determines_the_best_width_for_a_column_or_the_best_height_for_a_row,_based_on_its_contents

Question 4 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Border_-_The_line_around_a_cell’s_edges

Question 5 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_-_The_intersection_of_a_row_and_a_column

Question 6 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_reference_-_Identifies_the_cell,_and_is_formed_by_combining_the_cell’s_column_letter_and_row_number

Question 7 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Cell_style_-_A_collection_of_formatting_characteristics_you_apply_to_a_cell_or_range_of_data

Question 8 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Clear_-_Removes_formatting_applied_to_a_cell_or_a_range_of_cells

Question 9 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Column_-_Appears_vertically_and_is_identified_by_letters_at_the_top_of_the_worksheet_window

Question 10 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Column_heading_-_The_column_identification,_identified_by_the_letter_above_the_column

Question 11 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Editing_mode_-_When_you_double-click_the_cell,_or_press_the_F2_key,_and_place_the_insertion_point_within_the_cell_contents,_you_enable_this_mode_and_are_able_to_edit_cell_contents

Question 12 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Fill_(1st_Meaning)_-_Background_color_of_a_cell

Question 13 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Format_Painter_-_Enables_you_to_copy_formatting_from_one_worksheet_cell_to_another_without_copying_the_cell’s_contents

Question 14 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Formula_-_An_equation_that_calculates_a_new_value_from_values_currently_in_a_worksheet

Question 15 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Formula_Bar_-_Appears_to_the_right_of_the_Name_Box_and_displays_a_formula_when_the_cell_of_a_worksheet_contains_a_calculated_value

Question 16 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Indent_-_Cell_contents_are_shifted_to_the_right

Question 17 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Merge_-_Combines_multiple_cells_into_one_cell

Question 18 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Name_Box_-_Cell_reference_area_located_below_the_Ribbon,_displays_the_cell_reference_of_the_active_cell

Question 19 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Number_format_-_The_way_numerical_data_looks_in_a_cell

Question 20 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Orientation_-_The_angle_at_which_the_data_is_displayed_within_a_cell

Question 21 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Range_-_A_group_of_selected_cells

Question 22 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Range_reference_-_How_the_range_is_identified;_made_up_of_the_cell_in_its_upper-left_corner_and_the_cell_in_its_lower-right_corner,_separated_by_a_colon

Question 23 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Row_-_Appears_horizontally_and_is_identified_by_numbers_on_the_left_side_of_the_worksheet_window

Question 24 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Row_heading_-_The_row_identification,_identified_by_the_number_beside_the_column

Question 25 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Sheet_tab_-_Tab_at_the_bottom_of_the_worksheet_window_that_displays_the_name_of_the_worksheet

Question 26 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Spreadsheet_-_A_grid_of_rows_and_columns_in_which_you_enter_text,_numbers,_and_the_results_of_calculations

Question 27 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Truncate_-_Hidden_from_view

Question 28 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Workbook_-_The_file_used_to_store_worksheets;_what_an_Excel_file_is_called

Question 29 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Worksheet_-_A_computerized_spreadsheet,_the_words_spreadsheet_and_worksheet_are_interchangeable

Question 30 (of 31)

 



Excel Vocabulary Part 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=Wrap_text_-_When_the_row_height_adjusts_automatically_to_include_additional_lines_until_all_the_text_is_visible_within_the_same_cell

Question 31 (of 31)