Excel_TTH

xlsx

School

Southeast Technical Institute *

*We aren’t endorsed by this school

Course

105

Subject

Computer Science

Date

Feb 20, 2024

Type

xlsx

Pages

10

Uploaded by SargentTeamTiger18

Report
Excel Assignment There are four sheets to complete for this assignment: Part 1, Part 2, Part 3, and Part 4 Please be sure to complete all sheets before submitting your assignmen
nt.
CSC-105 Assignments: Normal Introduction Syllabus/Intro Quiz Introduction Webmail OneNote Word Totals: Assignments: In-Class Word Day 2 Word Day 3 Excel Day 2 Excel Day 4 Totals: Exams Exam 1: Quiz Exam 1: Hands On Totals: Part 1: Calculate Your Grade Use the provided worksheet to calculate your grade. All green cells should provide a user provided formula or Excel provided function. You can continue to build upon this worksheet, or modify it for your other classes, to help claculate your grade throughout the semester. *Note - this is not a weighted class*
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Point Received Points Possible Calculations Assignments 10 10 100.00% 20 20 20 20 Exams 20 20 100.00% 20 20 20 20 Grade Percentage: 110 110 96% 5 5 5 5 5 5 5 5 20 20 28 30 20 20 48 50
Group A: Group B: 38.61 92.41 98.56 34.55 18.18 98.08 47.60 86.74 99.39 50.77 Part 2: Functions and Formulas Please use the appropriate Excel functions to compute the orange cells and a formula to compute the yellow cells. Calculate the answers for each row. *Note - These are the only Excel functions that should be used to help complete the sheet: SUM(), MAX(), MIN(), and AVERAGE()
Group C: Group D: 6.24 52.29 189.54 189.54 47.3861897 47.39 6.24 92.41 88.65 85.48 307.25 307.25 76.8117661 76.81 34.55 98.56 39.55 88.61 244.42 244.42 61.1048913 61.10 18.18 98.08 32.61 25.15 192.09 192.09 48.023539 48.02 25.15 86.74 5.37 98.71 254.24 254.24 63.558901 63.56 5.37 99.39 Total (function) Total (formula) Average (function) Average (formula) Smallest Number Largest Number
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
NBA Fi Team Los Angeles La Boston Celti Under 10 wins: Golden State W Chicago Bu San Antonio S Philadelphia 7 Detroit Pisto Miami Hea Count numb Count non-emp Count the number of time Calend How many days are there and August 4, Part 3: Counting Please use the three count functions we covered and the NBA Finals Winners data to calculate the blue cells. Please use the appropriate Date & Time function we covered to calculate the number of days in the Calendar Example. *Note - for full points you must use a function coverd in the class.
inals Winners Total Wins akers 17 tics 17 Warriors 7 uls 6 Spurs 5 76ers 3 ons same at same Desired Results: bers 6 6 pty cells 8 es 'same' appears 2 2 dar Example Desired Results: 64 from June 1, 2023 2023?
Active Co ID State 85407 NE 30722 IA 31804 MN 74383 IA 58966 WI 42040 NE 56316 ND 18626 SD 29178 MN 56971 IA 71280 SD Part 4: Conditional Formatting and More! On the Active Compliance table please make the following formatting changes: 1. Center all text within the table 2. Convert the Result column to a percentage format with two decimal places showing 3. Use the Highlight Cell Rules conditional formatting to make all state cells that contain IA "light red fill with dark red text". 4. Use Top/Bottom Rules conditional formatting to make all result cells that are above the average "yellow with dark yellow text".
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
ompliance Age Result 40 0.431 36 0.4251 78 0.1878 23 0.4185 42 0.9766 80 0.2467 63 0.5331 19 0.7834 38 0.9862 75 0.5227 45 0.2857

Related Documents

module 2 short responses.docx
CS330-project proposal.docx
tutorial3.docx
CS_161_Proj_3_Write_up_.pdf
Aestethic_soul-piercing_polyhalogen.docx
Skip To Content.docx
exam-1-template.docx
Assignment2Sample.tex
Module Three Assignment - CS340.docx
CS 340 README.docx
6-2 _ CS370.docx
IT 145 Global Rain Summary Report Template.docx
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Cengage Learning
Text book image
CMPTR
Computer Science
ISBN:9781337681872
Author:PINARD
Publisher:Cengage
SEE MORE TEXTBOOKS