Tag: Automatically

 Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3

Put an X to mark the appropriate cells to show that everyone in Sales and HR attended Part 2

Highlight the cells and fill the cells with Red containing the names of the individuals in Claims that did not attend Part 3

Format Column J to be ‘Currency’ with 2 decimal places. Be sure it includes the $ automatically.

Each individual must pay $25 for each session they attended. Using a formula, fill Column H with the total owed for sessions attended, subtracting anything already paid.

Sort the entire file (except the headers) A-Z by Last name

Add a filter to all Columns, but do not filter the file

Bold ‘Total Paid’

Add conditional formatting to the Total Owed cell for anyone who owes more than $25 for the conference. Have the cell turn red if the total owed is more than $25.

Change the last name ‘Crocker’ to your professor’s last name

 

Select an artist who is alive today or an artist no longer alive today. You may select an artist from outside the United States.

Identify a disability artist whose work you are interested in. You should find and select an artist we have not discussed this week.

Select an artist who is alive today or an artist no longer alive today. You may select an artist from outside the United States.

Remember, disability art is art about (the experience disability. Disability i:tle=°f:V4t7Veby :sabtpe o automatically become disability just it was a disabled person who made it. Also, a disability artist does not have to identify as disabled.