Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Learning Objective Organize an Excel data file for professional presentation Apply various Excel functions for dynamic calculations Important concepts and actions within Excel Freeze Pane Absolute and relative cell address and cell ranges Cell address between sheet tabs Grouping by row and column Column width Column format Paste Options Sheet Tab Filter Functions Formulas Conditional formatting Tasks Download a copy of “Lab 2 - Excel Formulas.xlsx” (link) Organize data on “Example” tab Fill out Example tab columns J - Q with the appropriate Excel functions Complete 2 tabs (“More Examples”, “Example Charts”) with appropriate Excel functions Requirements Technical Freeze Panes (top row and 2 name columns) Make 1 Group Column from A1 - A5 Make 2 Row Groups rough even sections rows 1 - 45, and rows 47 - 91 Expand Columns J & K to make sure the names are not cut off Format A1 - A5 columns as numbers with .1 decimal places Format column O & P as percentage (optional, this part was a bit confusing. You don’t have to divide by 100) Format column O to the .01 decimal place (optional, alternatively, you can make this a whole number using =round(,0) Enable Filters for all columns Apply Conditional Formatting to Column A1-A5 (E-I) for light red background for score <70 Content Use Absolute references for at least 1 column Fill out cells from J2 - P1 will the appropriate formulas Fill out 3 tables on “More examples” tab the appropriate formulas Fill out 1 table on “Example Chart” tab the appropriate formulas Apply filter for all columns and set filter for Year of your grade level Ensure the alternating white and yellow row strips are not messed up Submission Save Excel files as Lastname-Firstname-Lab2.xlsx (do NOT submit a pdf) Upload the file to Brightspace Rubric 2 points total 1 point for technical requirements 0.0 - a few of the requirements met 0.5 - half of the requirements met 1.0 - most (>80%) of the requirements met 1 point for content 0.0 - no tabs completed 0.5 - 1 tab completed 1.0 - all 3 tabs completed

Learning Objective

Organize an Excel data file for professional presentation

Apply various Excel functions for dynamic calculations

Important concepts and actions within Excel

Freeze Pane

Absolute and relative cell address and cell ranges

Cell address between sheet tabs

Grouping by row and column

Column width

Column format

Paste Options

Sheet Tab

Filter

Functions

Formulas

Conditional formatting

Tasks

Download a copy of “Lab 2 - Excel Formulas.xlsx” (link)

Organize data on “Example” tab

Fill out Example tab columns J - Q with the appropriate Excel functions

Complete 2 tabs (“More Examples”, “Example Charts”) with appropriate Excel functions

Requirements

Technical

Freeze Panes (top row and 2 name columns)

Make 1 Group Column from A1 - A5

Make 2 Row Groups rough even sections rows 1 - 45, and rows 47 - 91

Expand Columns J & K to make sure the names are not cut off

Format A1 - A5 columns as numbers with .1 decimal places

Format column O & P as percentage (optional, this part was a bit confusing. You don’t have to divide by 100)

Format column O to the .01 decimal place (optional, alternatively, you can make this a whole number using =round(,0)

Enable Filters for all columns

Apply Conditional Formatting to Column A1-A5 (E-I) for light red background for score <70

Content