SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 21 Dec 2017 My Price 10.00

designed to practice the use of built-in MS Excel Conditional

Can you do the whole assignment before the due date? Thank you

  • CS170 – Computer Applications for Business Spring 2017 • Assignment 11 Due Date: Before 11:00 p.m. on Saturday, April 15th , 2017 Accept Until: Before 11:00 p.m. on Friday, April 21st, 2017 Evaluation: 10 points Submit to Sakai: assignment11.xlsx file To get credit for this assignment: 1 Deliver the assignment11.xlsx file to Sakai on time. 2 Your TA should be able to open your file by clicking on its link. Background: This assignment is designed to practice the use of built-in MS Excel Conditional Math & Statistical Functions. For this assignment, you will upload your Excel file to Sakai so that it can be accessed by just clicking on the file's link. The main topics exercised in this assignment are: Conditional Math & Statistical Functions. Directions: ï‚· Follow the requirements listed on the next page. ï‚· Use conditional mathematical or statistical functions - or formulas containing such functions - to complete the Employees and Statistical Data worksheets of this assignment using the information listed on the next pages. ï‚· Enter your name on cell A1 of each of the two worksheets. ï‚· Submit your assignment11.xlsx file to Sakai using the Sakai-> Assignments link. Page 1 of 2 Requirements: Employees spreadsheet Complete the missing information (yellow cells) on the last column of the spreadsheet with the appropriate function to list the rank of the employee by salary. In other words, 1 will be entered for the employee with the highest salary, 2 for the employee with the second highest salary until 49 is assigned to the employee with lowest salary. The data should not be sorted. Statistical Data spreadsheet Complete the light blue colored cells with the appropriate Math and Statistical function or formula using such functions. The data to be used is the data in the Employees spreadsheet. TIP: The notation WorksheetName!CellRange may be used. Example: Employees!A2:B2 refers to the the cell range A2:B2 on the Employees spreadsheet. References: 1. Chapter 14 of the Fluency6 textbook 2. Advanced Functions recitations and lectures Page 2 of 2

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 21 Dec 2017 01:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)