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 Exam Review

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. Is/are used to place worksheet, column, and row titles on a worksheet.Text
2. Is a series of two or more adjacent cells in a column or row or a rectangular group of cells.Range
3. How many chart types does Excel offer?10
4. The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.Autofill Options
5. The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.Autocorrect
6. The ____ is the small black square located in the lower-right corner of the heavy border around the active cell.Fill Handle
7. The person or persons requesting the worksheet should supply their requirements in a ____ document.Requirement Document
8. Key that toggles between Insert mode and Overtype mode?Insert
9. To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery.Print Selection
10. You can open the Format Cells dialog box by pressing the ____ keys.Ctrl+1
11. You can use the ____ to check which cells are referenced in the formula assigned to the active cell.Range Finder
12. When designing a worksheet, which steps should be taken to ensure that functional considerations supersede visual aesthetics? A. Identification of how to format various elements of the worksheet or B. Avoiding the temptation to use flashy or confusing visual elements within the worksheetA
13. One of the reasons Excel is such a valuable tool is that you can assign a(n) ____________________ to a cell, and Excel will calculate the result.Formula
14. The function, or ____________________, of a worksheet is to provide a user with direct ways to accomplish tasks.Purpose
15. True or False, As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.False
16. True or False, The arithmetic operator, , directs Excel to perform the division operation.False
17. After shrinking entries to fit in cells, consider using the ____ slider on the status bar to make the entries more readable.Zoom
18. Cell references in a formula are called ____.Assumptions
19. If you enter 90 in the Degrees box in the ____ area of the Format Cells dialog box, the text will appear vertically and read from bottom to top in the cell.Orientation
20. The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.Fill Formatting Only
21. When assigned to a cell, the ____ function returns a number that corresponds to the system date and timeNOW
22. What is the path to the Insert Cells arrow?Home tab & cells group
23. True or False, When Excel cannot calculate a formula, it displays an error message in a cell.True

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=Is/are_used_to_place_worksheet,_column,_and_row_titles_on_a_worksheet.

Question 1 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 2 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 3 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 4 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=The______feature_works_behind_the_scenes,_fixing_common_typing_or_spelling_mistakes_when_you_complete_a_text_entry.

Question 5 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=The______is_the_small_black_square_located_in_the_lower-right_corner_of_the_heavy_border_around_the_active_cell.

Question 6 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 7 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 8 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=To_print_a_range_of_cells_in_the_active_worksheet,_click______in_the_Settings_area_in_the_Print_gallery.

Question 9 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 10 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 11 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=When_designing_a_worksheet,_which_steps_should_be_taken_to_ensure_that_functional_considerations_supersede_visual_aesthetics?_A._Identification_of_how_to_format_various_elements_of_the_worksheet_or_B._Avoiding_the_temptation_to_use_flashy_or_confusing_visual_elements_within_the_worksheet

Question 12 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=One_of_the_reasons_Excel_is_such_a_valuable_tool_is_that_you_can_assign_a(n)______________________to_a_cell,_and_Excel_will_calculate_the_result.

Question 13 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=The_function,_or_____________________,_of_a_worksheet_is_to_provide_a_user_with_direct_ways_to_accomplish_tasks.

Question 14 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=True_or_False,_As_in_algebra,_you_can_use_brackets_to_override_the_order_of_operations_Excel_follows_to_perform_formula_calculations.

Question 15 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=True_or_False,_The_arithmetic_operator,_,_directs_Excel_to_perform_the_division_operation.

Question 16 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=After_shrinking_entries_to_fit_in_cells,_consider_using_the______slider_on_the_status_bar_to_make_the_entries_more_readable.

Question 17 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 18 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=If_you_enter_90_in_the_Degrees_box_in_the______area_of_the_Format_Cells_dialog_box,_the_text_will_appear_vertically_and_read_from_bottom_to_top_in_the_cell.

Question 19 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=The______Auto_Fill_Option_that_fills_the_destination_area_using_the_format_of_the_source_area;_no_content_is_filled.

Question 20 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=When_assigned_to_a_cell,_the______function_returns_a_number_that_corresponds_to_the_system_date_and_time

Question 21 (of 23)

 



Excel Exam Review: QR Challenge

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

Question 22 (of 23)

 



Excel Exam Review: QR Challenge

https://www.classtools.net/QR/decode.php?text=True_or_False,_When_Excel_cannot_calculate_a_formula,_it_displays_an_error_message_in_a_cell.

Question 23 (of 23)