Explore how excel reports are represented in data tables

Assignment Help Management Information Sys
Reference no: EM131154522

Data, Information, and Organizational Knowledge

The SLPs for Modules 1-3 will introduce you to Microsoft Excel functions for cell formatting and applying simple formulas and functions, basic pivot tables, and what-if equations. You will also explore how Excel reports are represented in data tables, charts, and graphs. Whether you are a novice or have already an understanding of Excel, these exercises will help you acquire and/or refresh Excel skills.

As most of you know, Excel is a powerful application that is used worldwide, and learning Excel skills are important to your career in Information Technology Management. Among the many tasks, Excel is used to work as a calculator and to perform higher math and statistical functions. Since you will be working on different Excel exercises each week, you will be watching the assigned videos first and then completing the exercises step by step.

For a quick introduction to Excel menus, please review the following Lynda.com video. You do not need to start a free trial, but if you want, Lynda.com offers a 10 day free-trial to review the lessons. You can always rejoin the site after that period is over.
https://www.lynda.com/Excel-tutorials/Using-menu-system/116478/125009-4.html

Excel files are called workbooks and are created each time you start a new worksheet. Multiple workbooks can be created within a single file. If you save Excel files to your local drive, you are the only one that can access them; however, if you save them to the cloud using OneDrive, you can export and share them with others. Excel is designed to enter information in cells. A cell is intersection a column and a row. For instance, column A and row 5 create a cell with an address of A5. Page layout is one of the most important features, and a good document presentation depends on correct page layout. The page orientation and margin size allow you to control your documents. Page orientation options are landscape and portrait.

SLP 1 will begin by introducing you to some Excel basic functions as follows.

· Home - The home tab provides access to most common used commands for working with data.

· Insert - The insert tab provides ability to insert charts, tables, Sparkline, filter, and more.

· Page layout - The page layout tab is to change the print formatting of workbook, including margin width, page orientation, and themes.

· Formulas - The formulas tab gives access to useful functions and formulas, and calculate and analyze numerical data, such as average and percentage.

· Data - The data tab is for sorting and filtering information in the workbook.

· Review - The review tab is a powerful editing feature like inserting comments and tracking changes.

· View - The view tab is for switching between different views of the workbook and freezing panes.

· Contextual - Contextual tabs will appears on Ribbon when you working with tables and pictures.

Next, you will review the following link containing a series of videos to prepare you for the SLP exercises. Refer to tutorials at https://www.gcflearnfree.org/excel2013

1. Getting Started with Excel [video 4]

2. Creating Opening Workbooks [video 5]

3. Saving and Sharing Workbooks [video 6]

4. Cell Basics [video 7]

5. Modifying Columns, Rows, and Cells [video 8]

6. Formatting Cells [video 9]

7. Worksheet basics [video 10]

8. Page Layout [video 11]

9. Printing Workbooks [video 12]

In this module, you will be acquainted with an introduction to Excel and some of its basic functions. After watching the recommended videos, perform the following:

1. Open the Excel software, you will see a blank worksheet, click on file, save as, browser to your local C:\ drive, type "Module1-exercise" in the file name section, and OK to save it to hard drive.

2. Close the worksheet.

3. Click to locate and the assignment file "Module1-excericse" and open it.

4. Enter the following data into the worksheet, starting from A2 on the left side, and perform the functions below. Save the file again on your local drive.

Add these numbers in row:

 

 

A

B

C

D

E

5

9

75

51

 

 

 

 

 

 

421

700

985

854

 

 

 

 

 

 

3352

6578

99655

9876

 

13

15

17

21

 

Add these numbers in column:

A

  B

  C

2

1

254

23

3

7523

2

3

234

7

48

105

23

68

22

 

 

 

5. Locate your file on the local drive.

6. Use Save As to make a copy as "Module 1- Exercise 2."

7. Enter the following data and use Calibri font size 11" and AutoFit text to column width.

8. Change the fonts and size to Georgia and 14", then AutoFit to column width again.

· Jack Johnson
· Rayon Robinson
· Alex Hollywood

Change page orientation and change margin to "narrow." Save the file.

Desire margin: Narrow.
Save your file.

After completing the Excel exercises, please upload the Excel file with your results to SLP 1 Dropbox.
SLP Assignment Expectations

Your assignments will be graded following these expectations:

· The assignment file must be developed in Excel and saved as .xls file.

· Precision: the questions asked are answered.

· Clarity: Your answers are clear and show your good understanding of the topic.

· Breadth and depth: The scope covered in your paper is directly related to the questions of the assignment and the learning objectives of the module.

· Critical Thinking: It is important to read the "required readings" posted in the background material plus others you find relevant. Your paper should include important concepts from these readings and incorporate your reactions and examples that illustrate your reflective judgment and good understanding of the concepts.

Reference no: EM131154522

Questions Cloud

Evaluate the frequency for each of the waveforms : Three waveforms seen on an oscilloscope are shown in Figure P1.4.7. If the horizontal scale is set to 50 ms per division (500 ms for the entire screen width), and the vertical scale is set to 5 mV per division (±25 mV for the entire screen height ..
Compare the percent error of both meters : If the temperature at the time of measurement is 20°C above ambient, compare the percent error of both meters when measuring a current of 5 A.
Find the percent of probable error that can exist : A voltmeter with a full scale of 100 V has a probable error of 0.1% of full scale. When this meter is employed to measure 100 V, find the percent of probable error that can exist.
What is the difference between prejudice and discrimination : What is the difference between prejudice and discrimination? In what way do individuals discriminate? What is institutional discrimination- and can you provide an example
Explore how excel reports are represented in data tables : The SLPs for Modules 1-3 will introduce you to Microsoft Excel functions for cell formatting and applying simple formulas and functions, basic pivot tables, and what-if equations. You will also explore how Excel reports are represented in data tab..
Advertising tune for a fast-food chain : Getting hungry upon hearing the advertising tune for a fast-food chain is an example of ____ conditioning
Prepare a statement of cash flows in good : A Boscia Corporation's balance sheet appears below.  The net income for the year was $108. Cash dividends were $28. Prepare a statement of cash flows in good form using the indirect method.
Innovative technology worksheet : What factors must be considered when implementing an innovative technology internally? What factors must be considered when implementing an externally acquired innovative techology?
Compute the realized gross profit for each of the year : Compute the realized gross profit for each of the year 2016. Prepare in journal form all entries required in 2016, applying the installment-sales method of accounting.

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  What are the risks associated with directly executing user i

3. What are the risks associated with directly executing user input ? What are the minimum steps needed to parse user input before it is allowed to be used in execution ?5. What are the risks associated with inheritance in classes ? What are generic ..

  Identify data that should incorporated into cgcs new system

Identify the data that should be incorporated into CGCs new system to provide adequate planning capability. Explain why each data item it is important and the level of detail needed for the data to be useful.

  What is blockbusters business model

What is Blockbuster's business model? How successful has it been? What industry and technology forces have that business model? What problems have they created?

  Brief a medical organization''s executive team on ehr

You are health information management professional who has been asked to brief a medical organization's executive team on the topic of electronic health records (EHR)

  Skills for a technology manager

Skills for a technology manager and What are some of the skills you think a technology manager should have?

  Assess the role of technology in project management

Assess the role of technology in project management

  Information technologycapital investmentinformation

information technologycapital investmentinformation technology now accounts for about 35 to 50 percent of total

  Pros and cons of importance of first impressions

Pros and Cons of Importance of First Impressions - The first impression seems to be an important factor in developing human-to-human interaction.

  About social engineering audit

Social Engineering Audit

  Describe implementation of an emr and ehr/patient portal

In a paper (750-1,000 words), select an environment (one you currently work in, have worked in previously, or wish to move into) and describe the challenges and opportunities associated with the implementation of an EMR, EHR/Patient Portal, or Dec..

  Discuss the different methods by which you can analyze

Excel provides many different ways in which to analyze data.  Discuss the different methods by which you can analyze data in your spreadsheet.  Assume the role of a Regional Manager for a retail organization looking at ways to analyze the large amoun..

  Show how inheritance relation will be reflected in java code

One of the topics covered this week is "Inheritance". The chapter shows the Person/Employee example, what are some other examples that could use Inheritance? Read section 12.3-12.4 and come up with your own example of inheritance. Do not copy the ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd