Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Title: Intro To Excel
Description: Basic Excel Terminology for the Excel Beginner
Description: Basic Excel Terminology for the Excel Beginner
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
Intro Excel Notes
10/21/15
Cell Basics
• Cell- intersection of a column and a row on a worksheet
...
Displays Name
...
• Make simple corrections
• Before pressing enter use
backspace
• Before finalizing press escape or
click the Cancel button
• After entering data click on the
cell to activate
• Also double click a cell to make
changes to only part of the cell
...
Grouping
• Active Sheet tab- the selected worksheet; the tab name of an
active sheet is bold
• Grouping-worksheets that are selected as an unit; any action
performed on this unit will affect all worksheet in this group
• Shift select sheets
• Crtl to select nonconsecutive sheets
Terms to Know
• Function-a predefined formula that uses the values in the cell you
select to calculate answer
• Argument-the part of the formula that are variables
• AutoCalculate-a feature that temporarily perform the following
calculations on the range of cells without making you write the
formulas
• Nest-to use a function as an argument within another function
Functions
• Regular Function
1
...
Function name entered
3
...
Enter Argument
5
...
Function in function
=ROUND(SUM(B12:B23),2)
Common Functions
•
•
•
•
•
•
•
=sum() adds values
=average() averages values
=COUNT() counts the cells containing numbers in a range of cells
=COUNTA()counts the number of non-blank cells
=MAX() finds Max number
=MIN() finds Min Number
Round() rounds values to a specific digit
Excel Tables
• Range of data with a special column header that enables you to
reference a range of data in a formula more naturally
• Create table by selecting a range of data that includes headings for every
column
• Then select the format as table button and select a table format
...
• [#ALL]
• [#TOTAL]
Comments
• To attach text note to a cell, use the New Comment command
• Red triangle appears in the upper right hand corner of the cell
• To Display the comment ,rest the mouse pointer on the red triangle
Named Ranges
• Rules For Naming Ranges
spaces are not allowed
...
• You cannot begin a name with a number
• Avoid using column labels
• A range name may include letters, numbers, (_)(\),(
...
”
Conditional operaters
• = equals
• >Greater than
•
• & Use for Joining text
• <> Not equal to
• >= greater than or equal to
• <=less that or equal to
=SUMIF() and =SUMIF() Function
• =SUMIF() function is a math trig function
• If the condition is true, then data in a corresponding cell is added
to the total: if it is false, then the corresponding data is skipped\
• Format for a SUMIF function is:
=SUMIF(range_to_test,condition,sum_range)
• =SUMIF(D2:D55),”Widget”, G2:G55)
• SUMIF() allows you to enter multiple qualifying condition
=COUNTIF and COUNTIF function
• =COUNTIF() is stat function
• If the result of the condition is true, then the item is added to a
running count; if it is false, then the item is skipped
• Format for a COUNTIF function is:
• =COUNTIF(range_to_test,condition)
• =COUNTIF(D2:D55),”Widget”, G2:G55)
• COUNTIF () allows you to enter multiple qualifying conditions
Ch
Title: Intro To Excel
Description: Basic Excel Terminology for the Excel Beginner
Description: Basic Excel Terminology for the Excel Beginner