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

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. an equation that calculates a new value using values currently on a worksheetFormula
2. a chart that shows the relationship of a part to a wholePie Chart
3. the space formed by the intersection of a row and a column; the basic unit of a worksheetCell
4. a horizontal group of cells in a worksheet identified by numbersRow
5. cell reference that does not adjust to the new cell location when copied or movedAbsolute cell reference
6. keeps selected rows or columns visible on the screen as the rest of the worksheet scrollsFreeze
7. to arrange a list of words or numbers in ascending or descending orderSort
8. a chart that uses bars of varying height to illustrate values in a worksheetColumn chart
9. the mathematical rules used for calculating the value of a formulaOrder of operation
10. a selected worksheet cell that is ready for data entryActive cell
11. a unique identifier for a cell which is formed by combining the cell's column letter and row numberCell reference
12. selected group of cells on a worksheet identified by the cell in the upper left corner and the cell in the lower right corner, separated by a colonRange
13. the position of data within a cellAlignment
14. a grid of rows and columns containing numbers, text, and formulas used to perform calculationsSpreadsheet
15. a prewritten formula that makes it easy to perform common calculationsFunction
16. a symbol that indicates what mathematical operation to perform on the operands: plus (+), minus (-), multiply, divide (/)Operator
17. returns the number of cells in a range that contains numbersCOUNT
18. adds all the numbers in a range of cellsSUM
19. returns the smallest value in a set of valuesMIN
20. value, cell reference, range, or text that acts as an operand i a function formulaArgument
21. sort order arranging text or numbers from Z to A, largest to smallest, or latest to earliestDescending
22. numeric characters that can be used in a calculationValue
23. a cell reference that contains both relative and absolute referencesMixed cell reference
24. process of changing values in cells to see how those changes affect the outcome of formulas in the worksheetWhat-if analysis
25. returns the largest value in a set of valuesMAX
26. sort order arranging text or numbers from A to Z, from smallest to larges, or from earliest to latestAscending
27. alphanumeric text that will not be used in calculationsLabel
28. a vertical group of cells in a worksheet identified by lettersColumn
29. a function that automatically adds the values in the cells directly above or to the left of the active cellAutosum
30. a collection of related worksheetsWorkbook
31. to copy a cell's contents and/or formatting into an adjacent cell or rangeFill
32. returns the average (arithmetic means) of its arguementsAVERAGE
33. a graphic representation of values and their relationships; pie, line, column, bar, scatteredChart/graph
34. the workspace made up of columns and rows where data is entered to create an electronic spreadsheetWorksheet
35. a chart that uses points connected by a line to illustrate values in a worksheetLine chart
36. arranging the shape, size, type, and general makeup of a cell or group of cellsFormat
37. a number or cell reference used in a formulaOperand
38. cell reference that adjusts to a new location when copied or movedRelative cell reference

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=an_equation_that_calculates_a_new_value_using_values_currently_on_a_worksheet

Question 1 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_chart_that_shows_the_relationship_of_a_part_to_a_whole

Question 2 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=the_space_formed_by_the_intersection_of_a_row_and_a_column;_the_basic_unit_of_a_worksheet

Question 3 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_horizontal_group_of_cells_in_a_worksheet_identified_by_numbers

Question 4 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=cell_reference_that_does_not_adjust_to_the_new_cell_location_when_copied_or_moved

Question 5 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=keeps_selected_rows_or_columns_visible_on_the_screen_as_the_rest_of_the_worksheet_scrolls

Question 6 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=to_arrange_a_list_of_words_or_numbers_in_ascending_or_descending_order

Question 7 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_chart_that_uses_bars_of_varying_height_to_illustrate_values_in_a_worksheet

Question 8 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=the_mathematical_rules_used_for_calculating_the_value_of_a_formula

Question 9 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_selected_worksheet_cell_that_is_ready_for_data_entry

Question 10 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_unique_identifier_for_a_cell_which_is_formed_by_combining_the_cell's_column_letter_and_row_number

Question 11 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=selected_group_of_cells_on_a_worksheet_identified_by_the_cell_in_the_upper_left_corner_and_the_cell_in_the_lower_right_corner,_separated_by_a_colon

Question 12 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=the_position_of_data_within_a_cell

Question 13 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_grid_of_rows_and_columns_containing_numbers,_text,_and_formulas_used_to_perform_calculations

Question 14 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_prewritten_formula_that_makes_it_easy_to_perform_common_calculations

Question 15 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_symbol_that_indicates_what_mathematical_operation_to_perform_on_the_operands:_plus_(+),_minus_(-),_multiply,_divide_(/)

Question 16 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=returns_the_number_of_cells_in_a_range_that_contains_numbers

Question 17 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=adds_all_the_numbers_in_a_range_of_cells

Question 18 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=returns_the_smallest_value_in_a_set_of_values

Question 19 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=value,_cell_reference,_range,_or_text_that_acts_as_an_operand_i_a_function_formula

Question 20 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=sort_order_arranging_text_or_numbers_from_Z_to_A,_largest_to_smallest,_or_latest_to_earliest

Question 21 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=numeric_characters_that_can_be_used_in_a_calculation

Question 22 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_cell_reference_that_contains_both_relative_and_absolute_references

Question 23 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=process_of_changing_values_in_cells_to_see_how_those_changes_affect_the_outcome_of_formulas_in_the_worksheet

Question 24 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=returns_the_largest_value_in_a_set_of_values

Question 25 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=sort_order_arranging_text_or_numbers_from_A_to_Z,_from_smallest_to_larges,_or_from_earliest_to_latest

Question 26 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=alphanumeric_text_that_will_not_be_used_in_calculations

Question 27 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_vertical_group_of_cells_in_a_worksheet_identified_by_letters

Question 28 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_function_that_automatically_adds_the_values_in_the_cells_directly_above_or_to_the_left_of_the_active_cell

Question 29 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_collection_of_related_worksheets

Question 30 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=to_copy_a_cell's_contents_and/or_formatting_into_an_adjacent_cell_or_range

Question 31 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=returns_the_average_(arithmetic_means)_of_its_arguements

Question 32 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_graphic_representation_of_values_and_their_relationships;_pie,_line,_column,_bar,_scattered

Question 33 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=the_workspace_made_up_of_columns_and_rows_where_data_is_entered_to_create_an_electronic_spreadsheet

Question 34 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_chart_that_uses_points_connected_by_a_line_to_illustrate_values_in_a_worksheet

Question 35 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=arranging_the_shape,_size,_type,_and_general_makeup_of_a_cell_or_group_of_cells

Question 36 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=a_number_or_cell_reference_used_in_a_formula

Question 37 (of 38)

 


Excel Vocabulary: QR Challenge

https://www.classtools.net/QR/decode.php?text=cell_reference_that_adjusts_to_a_new_location_when_copied_or_moved

Question 38 (of 38)