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: Spreadsheet Management Vocab Quiz 1

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. 1. This button allows you to apply formatting once, or you can continue to apply formatting if you click it twice. It looks like a paint bucketFormat Painter
2. 2. Takes the place of a number in a formula. Happens when you click on a cell instead of entering a numberCell Reference
3. 3. Automatically resizes your spreadsheets before printingScale To Fit
4. 4. What is this an example of: B2Cell
5. 5. This will not show up on the worksheet but you can tell it is there because there will be a dark line, and the column or row numbers or letters will not be in order anymoreHidden Row or Column
6. 6. This is part of a workbook, it is shown usually as a tab at the bottom with its own nameWorksheet
7. 7. The location of the cell remains relative to the cell that contains the formulaRelative Cell Reference
8. 8. The location of the cell does not change when you move or copy the formula. Formed by using F4Absolute cell reference
9. 9. It is an absolute reference cell. It is made by defining a name for itNamed cell
10. 10. This chart compares parts of a wholePie Chart
11. 11. This chart shows trends in data over timeLine Chart
12. 12. These tabs are activated only when a chart is selectedChart Contextual Tabs
13. 13. This axis runs up and down on a chartVertical Axis
14. 14. This axis runs across the bottom of a chartHorizontal Axis
15. 15. This means if data is changed in the spreadsheet then the chart will change alsoLinked data
16. 16. This formatting calls attention to a set of data and applies a rule or rules and modifies the formatting of the cell to match the rule. It can be a change of color, text, etc. to highlight the cellConditional Formatting
17. 17. This stands for Comma Separated ValueCSV
18. 18. Pre-existing workbooks that you can use in Excel to save the time of creating new workbooksTemplates
19. 19. This allows you to scroll through a workbook with the headings of the columns or the rows still showing and not disappearingFreeze Panes
20. 20. This allows you to choose what data to include and what data to filter out. The data is still there, it is just not showingFilter
21. 21. This can put things in alphabetical or numerical order or other optionsSort
22. 22.It allows you to determine the value of a cell based on the outcome of a logical testThe IF Function
23. 23.Use this to create criteria for cells that limit the possible entries into those cells Data Validation
24. 24. This can be added to the top of your worksheet and can be used for a title, company name, your name, etc.Header
25. 25.These can be added to the bottom of your document. Used for page numbers, file names, etc.Footer

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=1._This_button_allows_you_to_apply_formatting_once,_or_you_can_continue_to_apply_formatting_if_you_click_it_twice._It_looks_like_a_paint_bucket

Question 1 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=2._Takes_the_place_of_a_number_in_a_formula.__Happens_when_you_click_on_a_cell_instead_of_entering_a_number

Question 2 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 3 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=4._What_is_this_an_example_of:_B2

Question 4 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=5._This_will_not_show_up_on_the_worksheet_but_you_can_tell_it_is_there_because_there_will_be_a_dark_line,_and_the_column_or_row_numbers_or_letters_will_not_be_in_order_anymore

Question 5 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=6._This_is_part_of_a_workbook,_it_is_shown_usually_as_a_tab_at_the_bottom_with_its_own_name

Question 6 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 7 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=8._The_location_of_the_cell_does_not_change_when_you_move_or_copy_the_formula._Formed_by_using_F4

Question 8 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=9._It_is_an_absolute_reference_cell._It_is_made_by_defining_a_name_for_it

Question 9 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 10 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 11 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 12 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 13 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 14 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 15 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=16._This_formatting_calls_attention_to_a_set_of_data_and_applies_a_rule_or_rules_and_modifies_the_formatting_of_the_cell_to_match_the_rule._It_can_be_a_change_of_color,_text,_etc._to_highlight_the_cell

Question 16 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 17 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=18._Pre-existing_workbooks_that_you_can_use_in_Excel_to_save_the_time_of_creating_new_workbooks

Question 18 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 19 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=20._This_allows_you_to_choose_what_data_to_include_and_what_data_to_filter_out._The_data_is_still_there,_it_is_just_not_showing

Question 20 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 21 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 22 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

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

Question 23 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=24._This_can_be_added_to_the_top_of_your_worksheet_and_can_be_used_for_a_title,_company_name,_your_name,_etc.

Question 24 (of 25)

 


Spreadsheet Management Vocab Quiz 1: QR Challenge

https://www.classtools.net/QR/decode.php?text=25.These_can_be_added_to_the_bottom_of_your_document._Used_for_page_numbers,_file_names,_etc.

Question 25 (of 25)