Free Essay

Introduction of Excel Function Keys

In: Computers and Technology

Submitted By heansoja
Words 418
Pages 2
[데이터 입력] |단축키 |설 명 |
|Alt + Enter |셀 안에 있는 내용 입력 시 새 줄을 만들어 줍니다. |
|Ctrl + Enter |셀 범위를 지정한 후 내용을 입력하고 Ctrl+Enter를 누르면 셀 범위에 동일한 내용이 |
| |채워집니다. |
|Shift + Enter |셀 입력을 완료하고 위의 이전 셀을 선택합니다. |
|Tab |셀 입력을 완료하고 오른쪽에 있는 다음 셀을 |
| |선택합니다. |
|Shift + Tab |셀 입력을 완료하고 왼쪽에 있는 이전 셀을 선택합니다. |
|F4 또는 Ctrl + Y |바로 전에 작업한 내용을 반복합니다. |
|Ctrl + Z |바로 전에 작업한 내용을 취소합니다. |
|Ctrl + D |빈 셀에 데이터를 입력한 후 아래 셀로 이동하고 Ctrl+D를 누르면 동일한 내용이 |
| |채워집니다. |
|Ctrl + R |빈 셀에 데이터를 입력한 후 오른쪽 셀로 이동하고 Ctrl+R을 누르면 동일한 내용이 |
| |채워집니다. |
|Ctrl + F3 |범위를 지정한 후 Ctrl+F3을 누르면 셀 영역에 셀 이름을 바로 지정할 수 있습니다. |
|Ctrl + Shift + F3 |행/열 레이블을 기준으로 이름을 정의할 수 있습니다. |
|Ctrl + K |하이퍼링크를 삽입합니다. |
|Ctrl + ;(세미콜론) |오늘 날짜를 자동으로 입력합니다. |
|Ctrl + Shift + :(콜론) |현재 시간을 자동으로 입력합니다. |
|Alt+아래쪽 화살표 |목록의 현재 열 값을 드롭다운 목록으로 나타냅니다. |

[데이터 서식]
|단축키 |설 명 |
|Alt + '(아포스트로피) |스타일 대화 상자를 나타냅니다. |
|Ctrl + 1 |셀 서식 대화 상자를 나타냅니다. |
|Ctrl + 2 |데이터를 입력한 후 범위를 지정하고 Ctrl+2를 누르면 데이터에 강조가 지정되거나 |
| |제거됩니다. |
|Ctrl + 3 |데이터를 입력한 후 범위를 지정하고 Ctrl+3을 누르면 데이터에 기울임꼴이 지정되거나 |
| |제거됩니다. |
|Ctrl + 4 |데이터를 입력한 후 범위를 지정하고 Ctrl+4를 누르면 데이터에 밑줄이 지정되거나 |
| |제거됩니다. |
|Ctrl + 5 |데이터를 입력한 후 범위를 지정하고 Ctrl+5를 누르면 데이터에 취소선이 지정되거나 |
| |제거됩니다. |
|Ctrl + Shift + $ |소수 두 자리의 통화 서식을 적용합니다. (음수는 괄호로 표시) |
|Ctrl + Shift + % |소수 자릿수 없이 백분율 서식을 적용합니다. |
|Ctrl + Shift + # |일, 월, 년의 날짜 서식을 적용합니다. |
|Ctrl + Shift + @ |시간과 분, AM/PM으로 시간 서식을 적용합니다. |
|Ctrl + I |기울임꼴 서식을 적용하거나 제거합니다. |
|Ctrl + U |밑줄 서식을 적용하거나 제거합니다. |
|Ctrl + 9 |선택한 행을 숨깁니다. |
|Ctrl+Shift+((여는 괄호) |선택 영역 안에서 숨겨진 행의 숨김을 모두 취소합니다. |
|Ctrl + 0(영) |선택한 열을 숨깁니다. |
|Ctrl+Shift+)(닫는 괄호) |선택 영역 안에서 숨겨진 열의 숨김을 모두 취소합니다. |
|Ctrl+Shift+&(앰퍼샌드) |선택한 셀에 윤곽선 테두리를 적용합니다. |
|Ctrl + Shift + _(밑줄) |선택한 셀에서 윤곽선 테두리를 제거합니다. |

[기타]
|단축키 |설 명 |
|F11 또는 Alt + F1 | 현재 범위의 데이터에 대한 차트를 만듭니다. |
|Ctil+PgUp, Ctrl+PgDn |시트간에 이동을 할 때 사용할 때 사용합니다. |
|Ctrl + - |선택된 행 또는 열을 삭제합니다. |
|Ctrl + Shift + + |선택된 행 또는 열을 삽입합니다. |
|Alt + F11 |Visual Basic Editor 창을 열어줍니다. VBA 소스 코드를 확인할 때 사용합니다. |
|Ctrl + Shift + * |현재 입력된 데이터의 전체 범위를 선택합니다. |
|Ctrl + ~ |현재 시트에서 셀에 입력된 수식을 확인하고 싶다면 해당 셀을 선택하고 Ctrl + ~를 |
| |누르면 됩니다.다시 누르면 원래 상태로 돌아갑니다. |…...

Similar Documents

Premium Essay

Key Functions

...F1 – A Cooke What are the main roles of these departments & key concerns? Research and Development: The main role in the research and development department is the technology that brings new services and products to the market place. Purchasing: The main roles of the purchasing department are Production: The main role of the production department is to turn raw materials into finished goods. The production department have to make sure that the quality of each product is up to a high standard so that customers are satisfied. Marketing: The marketing department is responsible for finding out the best way to reach their target market when releasing a new product. The marketing Administration: The administration department is responsible for making sure all paper work is done and they are also responsible for organising any deliveries. The administration department will deal will phone calls, sending letters and sending e-mails. Finance: The finance department take control of the expenses in the business. They make sure financial records are maintained. The finance department have to pay bills, wages and salaries. Human Resources: The human resources department deals with recruiting people and also How important is co-ordination between departments and how may it be achieved? Co-ordination is very important between departments because in a business in order to be organised you will need good co-ordination. Co-ordination makes......

Words: 281 - Pages: 2

Premium Essay

Functions for Excel

...Sigourney Jackson Unit-5 Discussion Board Introduction to Computer Lab March 14, 2013 Did not know there are so many functions for excel, some of the most useful tools in excel let you perform a variety of tasks automatically within a spreadsheet. They return different result depending on certain circumstance such as whether a particular condition is true or false. Excel includes a number of these functions that you can use to not only to make working with spreadsheets faster, but also to help ensure your accuracy. These functions let you code the decision-making process inside your worksheets rather than relying on the person who enters the data to make the choice and enter the result. For example, to see how a decision-making function can work, consider a situation where you charge a flat fee for shipping up to certain value of invoice and percentage of the invoice value above that. Instead of manually checking to see whether a flat fee or percentage value is appropriate and then entering the amount into a cell, you can have excel do the work for you. There are a number of Excel formulas that work in a similar way by allowing you to create one function to handle multiple situations. This is the IF function that I’m referring to, let's suppose we have a situation where the cost of shipping a product is $4.95 for any amount of product up to and including $20.00 in value and then 25 percent of the invoice price over that amount. The function looks like this: =IF......

Words: 298 - Pages: 2

Premium Essay

Excel

...ADVANCED EXCEL TRAINING Quality Management Objective  To provide the participants with an understanding of the advanced features of MS Excel Today is 7/22/2011 2 Advanced  ® EXCEL Topics Working with Data Lists Naming Cells and Ranges   Conditional Functions Lookup Functions   Pivot Tables Data Validation  Today is 7/22/2011 3 Naming Cells and Ranges Today is 7/22/2011 4 Name cells by using labels Name cells by using existing row and column labels Select the range you want to name, including the row or column labels. On In the Insert menu, point to Name, and then click Create. the Create names in box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box. Note A name created by using this procedure refers only to the cells that contain values and does not include the existing row and column labels. Today is 7/22/2011 5 Name a Cell or Range Using Names Box  1. Select the cell or range you want to name.  2. Click the Name box on the formula bar.  3. Type a name for the range. A range name can include uppercase or lowercase letters, numbers, and punctuation, but no spaces. Try to use a simple name that reflects the type of information in the range, such as BookTitle.  4. Press Enter. The range name will appear in the Name box whenever you select the range. Today is 7/22/2011 6 Conditional......

Words: 1579 - Pages: 7

Premium Essay

It140 Introduction to Operating Systems Key Assignment

...IT140 Introduction to Operating Systems and Client/Server Environments Key Assignment David Anderson Instructor: Mohammed Majid 02/24/2014 Table of Contents Week 1: Introduction to Operating Systems Week 2: Components of a Computer System Week 3: Managing Client Server Environments Week 4: Securing Operating Systems Week 5: System Administrators Week 1 Introduction to Operating Systems For this assignment I have chosen Microsoft because I am most familiar with them and their affiliates. Microsoft is a multibillion dollar organization and without them we would not be where we are today in the world of computers and technology. They have Cloud Computing, Bing search engine, and even Microsoft Dynamics, Lync systems, and even windows server which is used by IT specialists to increase the reliability of their server infrastructures. Each of these services is separately installed and you can buy them real cheap off their website at http://www.microsoft.com/government/ww/safety-defense/products/Pages/index.aspx. I chose Windows 8 because I am currently using it on my computer and I wanted to learn more about this specific operating system. I chose Ubuntu as my choice for Linux distributor because it was number one on the list and the first one I saw and I like the name. The name Ubuntu comes from African culture and it means “I am what I am because of who we all are”. Ubuntu on the other hand comes......

Words: 377 - Pages: 2

Free Essay

Excel Short Keys

...Ctrl+Z Undo Ctrl+C Enter, Ctrl+V Ctrl+X Copy, Paste, Multiple Paste, Cut Ctrl+F, Ctrl+H Find, Find&Replace Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4 Print, Save, Close, Close Excel Ctrl+Arrow Move to edge of region Ctrl+* Select current region Ctrl+A Select all cells Ctrl+Home Ctrl+End Select A1, Select last cell in used range Ctrl+Shift+End Select from active cell to last cell in used range. Ctrl+Shift+Home Select from active cell to A1 Ctrl+Page Down Ctrl+Page Up Move to the next sheet, Move to the previous sheet Ctrl+Tab Move to next open workbook Ctrl+N Open new workbook Shift+F11 Insert new worksheet Shift+F3 Paste function window =+FunctionName+Ctrl+A Insert new function Alt+F11 Open VBE Ctrl+Shift+Enter Array formula Ctrl+F3, F3 Define name, Paste name Ctrl+Spacebar Shift+Spacebar Select columns, Select rows Ctrl+1, Ctrl+B, Ctrl+U Format cells, Bold, Underline Ctrl+; , Ctrl+shift+: Current date, Current time | | | | |Rate this tip | |  RATING: | |Email Tip | |Top of Form | |2.96 | | | | ...

Words: 1257 - Pages: 6

Premium Essay

Excel

...Microsoft Excel 2010 Formulas & Functions  Table of Contents Excel 2010 Formulas & Functions ……………………………………………….….. o Formula Basics ……………………………………………….….. o Order of Operation ……………………………………………….….. Conditional Formatting ……………………………………………….….. Cell Styles ……………………………………………….….. Formulas & Functions ……………………………………………….….. Basic Formulas ……………………………………………….….. o Add the Values in Rows or Columns ……………………………………………….….. o Find the Average, Maximum, or Minimum ……………………………………………….….. Ranges & Individual Cells ……………………………………………….….. Copy a Formula ……………………………………………….….. o Using the Fill Handle ……………………………………………….….. o Using Traditional Copy & Paste ……………………………………………….….. Referencing Cells in Formulas ……………………………………………….….. o Relative References ……………………………………………….….. o Absolute References ……………………………………………….….. o Mixed References ……………………………………………….….. o References to Other Worksheets ……………………………………………….….. o Other Workbook References ……………………………………………….….. Quick Reference Guide ……………………………………………….….. o Add, Subtract, Multiple & Divide ……………………………………………….….. o Understanding Error Values ……………………………………………….….. Practical Purposes of Excel Formulas ……………………………………………….….. o Using Date & Time Formulas ……………………………………………….….. Commonly Used Functions & Formulas ……………………………………………….….. o Math & Trig Icon ……………………………………………….….. Logical Icon ……………………………………………….….. Lookup & Reference Icon ……………………………………………….….. Date & Time Icon ……………………………………………….….. AutoSum Icon ……………………………………………….…........

Words: 5629 - Pages: 23

Premium Essay

Excel

...New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal New Perspectives Excel 2013 Tutorial 3: SAM Project 1a Spring Software ENHANCE A TIMESHEET Project Goal M Project Name Project Goal PROJECT DESCRIPTION Devon Hastings is the human resources director for Spring Software, a software development company in Cambridge, Massachusetts. He has created a workbook for employees to use in recording the hours they work. He would like your help finishing the timesheet. GETTING STARTED * Download the following file from the SAM website: * NP_Excel2013_T3_P1a_FirstLastName_1.xlsx * Open the file you just downloaded and save it with the name: * NP_Excel2013_T3_P1a_FirstLastName_2.xlsx * Hint: If you do not see the .xlsx file extension in the Save file dialog box, do not type it. Excel will add the file extension for you automatically. * With the file NP_Excel2013_T3_P1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. On the Employee List worksheet, select cells A1:B1 and then use the Format Painter copy the format only to the range A2:B9. 2. In cell B1 enter bs001, in cell B2 enter cg001, in cell B3 type dh001, and then use Flash......

Words: 790 - Pages: 4

Premium Essay

Excel Finance Functions

...Financial Functions Using Microsoft Excel FV | PV | RATE | NPV | IRR | PMT |   Printing Formulas | FV FV(rate,nper,pmt,pv,type) Rate is the interest rate per period. Nper is the total number of payment periods in an annuity. Pmt is the payment made each period; it cannot change over the life of the annuity. Pmt must be entered as a negative number. Pv is the present value, or the lump-sum amount that a series of future payments is worth right now. If pv is omitted, it is assumed to be 0 (zero). PV must be entered as a negative number. Type is the number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0 which represents at the end of the period.  If payments are due at the beginning of the period, type should be 1.    PV PV(rate,nper,pmt,fv,type) Rate is the interest rate per period. For example, if you obtain an automobile loan at a 10 percent annual interest rate and make monthly payments, your interest rate per month is 10%/12, or 0.83%. You would enter 10%/12, or 0.83%, or 0.0083, into the formula as the rate. Nper is the total number of payment periods in an annuity. For example, if you get a four-year car loan and make monthly payments, your loan has 4*12 (or 48) periods. You would enter 48 into the formula for nper. Pmt is the payment made each period and cannot change over the life of the annuity. Pmt must be entered as a negative amount. Fv is the future value, or a cash balance you want to attain after......

Words: 2368 - Pages: 10

Free Essay

Excel Financial Functions

...Microsoft Excel for financial calculations? Microsoft Office Excel is a great computer program that is widely used throughout the financial industry. Excel is an invaluable tool in Finance and Accounting. Of course professionals also use special financial calculators. But a financial calculator can be expensive for students. It is not intuitive to use and unless they become investment bankers or realtors, most students will never use it after finishing the financial course. Fortunately, it is very easy to create a financial calculator for free if you have Excel on your computer. In fact, an Excel calculator can do much more than a dedicated financial calculator. Another advantage is the fact that if you learned how to use financial functions of Excel you will be able also to use a special financial calculator should the need arise. Below is a short introduction of how to start using MS Excel for financial calculations. Inserting Functions Excel comes with a wide array of functions that can easily be inserted into a spreadsheet. Adding a function is as easy as clicking on the "Insert Function" button on the top tool bar. Insert Function Button If you don't see the "Insert Function" button on your tool bar, you can easily add it by clicking: Tools > Customize > Commands > Find and click on Insert in the left-hand scroll-down menu. Then, find "Insert Function" in the right-hand scroll-down menu and click and drag it to your tool bar. Clicking on the "Insert Function"......

Words: 488 - Pages: 2

Free Essay

Excel Functions

...Excel Function-INFORMATION  Cell – The cell function returns information about the formatting, location, or content of a cell.For ex if you want to verify that a cell contains a numerical value instead of text before you perform a calculation on it, you can use the following formula =IF (Cell (“type”, A1) =”v”, A1*2, 0) This formula calculate A1*2 only if the cell A1 contains numerical value and returns to zero if it is text or it is blank. Syntax: Cell (info_type, (reference)) Following is the list of possible info_type values: “Address”-Reference of the first cell in the reference as text. “Col”-Column number of the cell in reference. “Color”-The value 1 if the cell is formatted in color for negative values; otherwise it returns to zero. “Content”-Value of the upper left cell in reference; not a formula “Filename”-Gives the path of the file in reference. Returns empty text ("") if the worksheet that contains reference has not yet been saved “Format”- Text value corresponding to the number format of the cell. The text values for the various formats are shown in the following table. Returns "-" at the end of the text value if the cell is formatted in color for negative values. Returns "()" at the end of the text value if the cell is formatted with parentheses for positive or all values. “Row”-Row number of the cell in reference “Type”-Text value correspondence to the type of data in the cell. Returns “b” for blank if the cell is empty,”l”for label if the cell......

Words: 287 - Pages: 2

Premium Essay

The Key Functions of Internal Quality Assurance

...EXPLAIN THE FUNCTIONS OF INTERNAL QUALITY ASSURANCE IN LEARNING AND DEVELOPMENT. Before looking at the functions of an internal quality assurer (IQA) role it is beneficial to understand what quality assurance is and why it has been established within the learning process. ‘Quality assurance can be defined as a system to monitor and evaluate a product or a service.’ Pg122 Assessors handbook It is the role of the IQA to uphold and maintain the credibility of the qualifications undertaken by candidates. The IQA supports this by helping employers and candidates to fully understand how these qualifications can further support and benefit their business. Thus ensuring effective delivery meeting the learners’ needs and expectations, which follows their agreed learning plan. They will maintain a close link between the learner, assessor and employer to enable full understanding in all assessment methods and the criteria they must adhere to. ‘Internal Quality Assurance is a key factor in managing ‘risk’ and ensuring that when certificates are claimed for learners the requirements of the national standards have been reliably met.’ (City & Guilds guidance on Internal Quality Assurance of Qualifications pg 6) The IQA team has a specific function with the assessment process within (education) centres. Although these functions may vary slightly, the guidelines the IQA’s work within remain the same. For example City & Guilds outline 4 main aspects to the IQA role, which state......

Words: 908 - Pages: 4

Premium Essay

Introduction to Computers - Key Terms

...Chapter 1 - Introduction to Computers - Key Terms (pages 1-15) Barcode - (p. 7, 294) used to index documents scanned within a document management systems. Bit - (p. 294) the level of voltage (low or high) in a computer that provides the binary states of 0 and 1 that computers use to represent characters. Bluetooth port - (p. 294) technology that uses radio waves to provide hands-free cellular phone communications. Blu-Ray disc - (p. 294) storage device, similar to CDs and DVDs, but are able to store even larger amounts of data. Bus network - (p. 294) computers networked together that are lined up on a single cable. Byte - (p. 294) eight bits treated as a single unit by a computer to represent a character. Cache memory - (p. 294) a type of memory located on the central processing unit (CPU) that can also be on a part of the processor. Central processing unit (CPU) - (p. 295) the brain of the computer, or the circuits that make the electrical parts function. Client/server network - (p. 295) large networks that could run hundreds of computers in various counties or states. Compact disc (CD) - (p. 296) discs that use a finely focused laser beam to write and read data. Computers on wheels (COWs) - (p. 296) term used to refer to notebook computers mounted on carts and moved with the user. Daisy chain network - (p. 296) the easiest way to add more computers into a network by connecting each computer to the next in a series. Device driver - (p. 297) a specific type......

Words: 1585 - Pages: 7

Premium Essay

Excel

...Applied Statistics Microsoft Excel Decomposition may reduce appeal emphasis on applications. Flow charts help make the analysis decision by identifying technique, computing statistics, and interpreting results. Associated data set accompanies the set purports to build a excel spreadsheet that discovers formula, illustrates the parameters, observes dynamic graphs and simulations that recodes, edits, validate, charts, and automatically links equations, data, and formulas to recalculate the data analysis. Excel recognizes statistical capability conjunction that carries out complex algorithms that implement correlated data columns. Excel quickly analyzes and interprets information filtered into a spreadsheet so the process is much easier then working out these formulas by hand. Excel spreadsheets create charts, graphs, and filters data all into one. Excel uses all of the basic mathematical operations such as addition, subtraction, division, and multiplication. Fractions and decimals are just as common for interpretation data into a excel spreadsheet. An advantage about excel is you can place any formula into the spreadsheet whether in ascending or descending order and using the same formula, it will automatically compute the answer for the next equation. Another advantage is if information is inaccurate, you can go back and check your work with just a click, unlike using y calculations or by hand you have to erase so much and start all over again, which could be time......

Words: 377 - Pages: 2

Premium Essay

Excel

...& D in the January, February, March and Summary sheets as Currency with 2 decimals. Format the %Change column as percentage with 2 decimals. The Total Revenue Difference (cell D10 of the Summary sheet) should be $88,188.00 On the Employee Data sheet: a. Set a Data Validation rule (p. EX 438) on the Job Status column for a drop down List of choices CN, FT or PT. You will need to key these in the Source box. Separate each choice by a comma (,). a) Set the Input Message to say Please select CN, FT or PT from the drop down list. b) Set the Error Alert to Stop Style with the message You did not choose a Status from the list. Use the Employee Data sheet: a) In cell I2, create an IF(And function to determine if an employee is eligible for an award. To be eligible, employees must be FT and be employed at least one year. If they are eligible, display “Yes” in column I, if not display “No”. (p. EX 370, use in conjunction with IF ) b) Copy the formula down to all employees (fill in Column I). Again on the Employee Data sheet a) In cell J2, create an IF function with a nested Vlookup (p. EX 387)as the value_if_true to determine the amount of Award money earned. Use column I (Eligible for Award) as the test for “Yes”, then use a Vlookup (with the array in cells M1:N6) to display the appropriate award amount earned, with 0 being inserted for anyone not eligible (No in column I). b) Copy this formula for all employees in column J. Use......

Words: 1218 - Pages: 5

Premium Essay

Excel

...Terms Definitions The First step in creating an effective workseet is to make sure you __________. Understand what is required In Excel, a number can contain the charaters ________. 0 1 2 3 4 5 6 7 8 9 The cell being copied is called the source area (copy area). The range of cells recieving the copy is called the ________. receiving range You ________ a worksheet to emphasize certain entires and make the worksheet easier to read and understand. Format Pressing the _________ keyboard shorcut key(s) selects cell A1. CTRL + HOME How many chart types does Excel offer? 11 Which of the following keys is an alternative to double-clicking the cell to edit it? F2 Which of the following Opton buttons gives options for filling cells following a fill operation? Auto Fill Options A ________ cell in Excel has a numerical value of zero. Blank The ________ AutoComplete list contains those functiond that akohabetically match the letters you type following thr equal sign. Formula The most popular background color is _______. White ________ text often provides a strong visual appeal. Underlined To open the format cells dialog box with the Alignment sheet active, click the Format Cells ________. Dialog Box Launcher Which of the following is an extension of the fill patten Sunday, Tuesday? Thursday, Saturday, Monday Which of the following formula contains the absolute cell reference? =$B$4 A(n) _______ chart provides a simple way to show trends and variatons in a range of data...

Words: 423 - Pages: 2