Loi.docx7
You will be completing and uploading the Challenge! assignments from the following study material topics:
1. Modifying Cells: Download Practice File excel_modifyingcells_practice.xlsx file
2. Number Formats: Download Practice File excel_numberformats_practice.xlsx file
3. Multiple Sheets: Download Practice File excel_multiplesheets_practice.xlsx file
8
1. Intro to Formulas: Download Practice File excel_introformulas_practice.xlsx file
2. Complex Formulas: Download Practice File excel_complexformulas_practice.xlsx file
3. Cell References: Download Practice File excel_cellreferences_practice.xlsx file
9
Functions: Download Practice File excel_functions_practice.xlsx file
10
· Sorting: Download Practice File excel_sorting_practice.xlsx file
· Filtering: Download Practice File excel_filtering_practive.xlsx file
· Charts: Download Practice File excel_charts_practice.xlsx file
· Conditional Formatting: Download Practice File excel_conditionalformatting_practice.xlsx file
· Intro to PivotTables: Download Practice File excel_intropivottables_practice.xlsx file
· What-If Analysis: Download Practice File excel_whatifanalysis_practice.xlsx file
11
· You will be completing and uploading the Challenge! assignments from the following study material topics: (use access_sampledatabase.accdb file for all challenges in this module)
1. Getting Started in Access
2. Working with Tables
3. Modifying Tables
4. Sorting and Filtering Records
12
You will be completing and uploading the Challenge! assignments from the following study material topics: (use access_sampledatabase.accdb file for all challenges in this module)
1. Designing a Simple Query
2. Designing a Multi-Table Query
13
You will be completing and uploading the Challenge! assignments from the following study material topics: (use access_sampledatabase.accdb file for all challenges in this module)
1. More Query Design Options
14
You will be completing and uploading the Challenge! assignments from the following study material topics: (use access_sampledatabase.accdb file for all challenges in this module)
1. Working With Forms
2. Creating Forms
3. Formatting Forms
4. Creating Reports
5. Advanced Report Options
15.
1. Slide Basics: Download the file powerpoint_slidebasics_practice.pptx file
2. Text Basics: Download the file powerpoint_textbasics_practice.pptx file
3. Applying Themes : Download the file powerpoint_themes_practice.pptx file
4. Applying Transitions: Download the file powerpoint_transitions_practice.pptx file
5. Managing Slides : Download the file powerpoint_managingslides_practice.pptx file
16.
1. Lists: powerpoint_lists_practice.pptx file
2. Animating Texts and Objects: Download the practice file powerpoint_animations_practice.pptx file
3. Aligning, Ordering, and Grouping Objects: Download the practice file powerpoint_aligning_practice.pptx file
4. Tables: Download the practice file powerpoint_tables_practice.pptx file
17.
1. Modifying Themes: Download the practice file powerpoint_modifyingthemes_practice.pptx file
2. Slide Master View: Download the practice file powerpoint_slidemaster_practice.pptx file
3. Hyperlinks: Download the practice file powerpoint_hyperlinks_practice.pptx file
Answer 30-50 words each question
1. Using Google, or another internet search engine, explain the "7x7 rule for PowerPoint".
2. Given any topic you choose (make sure to list the topic), give an example of using the 7x7 rule. Do not upload a slide, simply create a title and bulleted list within the message body of your reply.
