QuickHelper

(10)

$20/per page/

About QuickHelper

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

Expertise:
Accounting,Applied Sciences See all
Accounting,Applied Sciences,Business & Finance,Chemistry,Engineering,Health & Medical Hide all
Teaching Since: May 2017
Last Sign in: 356 Weeks Ago, 5 Days Ago
Questions Answered: 20103
Tutorials Posted: 20155

Education

  • MBA, PHD
    Phoniex
    Jul-2007 - Jun-2012

Experience

  • Corportae Manager
    ChevronTexaco Corporation
    Feb-2009 - Nov-2016

Category > Accounting Posted 22 May 2017 My Price 13.00

Obtain familiarity with a variety of useful Excel functions, business and finance homework help

Question description

 

  1. As the starting point for this assignment, download and use the Excel Assignment #2 'data file' template that is provided.
  2. Part #1:

a. On the 'Part1 Datafile' worksheet, follow the instructions in Row #2 to provide the solution in Row #12 for each of the Excel verbs or functions noted.

b. Use the 'Freeze Pane' function to anchor the column and row headers. (To see how this works, first use the arrow keys to navigate to cell AE26 –and notice that the column and row headers are no longer visible (rows 1 and 2; columns A and B). Now, to see how 'Freeze Pane' works: navigate to cell C3, then: View>Freeze Panes>Freeze Panes. Once the 'Freeze Panes' option has been set in cell C3, columns A and B, and rows 1 and 2 will be frozen as you navigate around the worksheet. Now, use the arrow keys again to navigate to cell AE26 –but this time, the column and row headings remain visible. Whammo. Nice.)

3. Part #2: On the 'Part2 Narrative Input' worksheet, write a concise summary of what each of the three the Excel functions do -and provide a description of an analysis situation in which each would be beneficial:

  1. Pivot table (See AYK14 for an example)
  2. VLOOKUP and/or HLOOKUP (see AYK18 for an example)
  3. 'Scenario Manager' (see AYK25 for an example)

Attachments:

Answers

QuickHelper
(10)
Status NEW Posted 22 May 2017 06:05 PM My Price 13.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l

Not Rated(0)