Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/59

Click to flip

59 Cards in this Set

  • Front
  • Back
Function Name
=FUNCTION(argument 1, argument 2....)
Syntax
the specifies the order in which you must enter the different parts of the function and the location in which you must insert commas, parenthese, and other punctuation.
Function
is a predefined or built-in formula for a commonly used calculation.
F11
press to hide or show Internet Explorer toolbars
Auto Fill Options
*Copy Cell
*Fill Series
*Fill Formatting Only
*Fill without Formatting
Auto Fill
When you drag the fill handle, Excel automatically fills in the formulas or formats used in the selected cells.
Absolute Reference
Is a cell reference that does not change when you copy the formula to a new location on the workbook.
Arguments
The numbers, text, or cell references used by the funcction to calculate a value.
Insert Function Button
Is located on the formula bar and is a button that has fx on it.
F4
Switch between absolute, relative, and mixed reference that shifts when you copu it to a new location on the worksheet.
Creating Absolute Reference
You preface the column and row designation with a dollar sign ($).
Fill Handle
A small black square located in the lower-right corner of a selected cell or range.
AutoContent Wizard
asks you series of questions about your tasks and then helps you perform them. You choose a presentation category and it creates a general outline for you to follow and formats the slides using a built-in-design template.
Embedded Chart
Is a chart that is display within a worksheet.
Chart Area
The entire chart and all of the elements.
Address Bar (toolbar)
Where you type URL's into to load webpages.
Progressive Disclosure
Is the appearance of the bulleted list one item at a time.
Gradent Fill
Is a type of shading in which one color blends into another making the slide more eye-catching.
Slide Transition
The manner in which a new slide appears on the screen during a slide show.
Navigate Through Presentation
Press space bar, ->, or click the left mouse button to advance to the next slide.
IP Address (Internet Protocol)
A unique idenification number in which each computer on the internet has.
Plot Area
The basic elements of the chart. A rectangular area that contains data markers.
Data Marker
Graphical representation of the values in the data series.
Modify Your Homepage
Click TOOLS on the menu bar, click INTERNET OPTIONS, click the GENERAL tab.
HTTP (Hypertext Transfer Protocal)
The most common transfer protocal used on the internet; http://
Transfer Ptotocal
Is the set of rules that computers use to move files from one computer to another on an internet.
#REF!
Is Excel's way of indicating that there is an invalid cell reference in a formula.
Exploded Pie Chart
A pie chart with one or more pie slices seperated from the whole.
Chart Sheet
Is a new sheet that is automatically inserted in the workbook, occupying the entire document window and thus providing more space and details for the chart.
Demote
To decrease the outline level.
Chart Wizard
A series of dialog boxes that prompts you for information about the chart you want to generate.
Formatting
Is the process of changing the appearance of you workbook.
########
Represent a value that is so large that it cannot be displayed with the width of the cell.
Promote
To increase the outline level.
Order of Precedence
Is a set of predefined rules that Excel follows to unambiguously calculate a formula by determining which operator is applied first, which operator is applied second, and so forth.
Arithmetic Operators
+,-,*,/. Are applied to either values or cells in the workbook.
Formula
Is an expression that is used to calculate a value.
Non Adjacent Range
Is comprised of two or more seperate adjacent ranges.
Current Date Functions
Click DOCUMENTATION tab to make it the active worksheet, click INSERT FUNCTION(fx) on formula bar, select DATE & TIME from the function category list, click TODAY and then click OK, and click OK.
Adjacent Range
Is a single rectangular block such as all of the data entered in cells A1 through B10.
Range (Cell Range)
A group of worksheet cells.
F5
Opens the GO TO dialog box in which you can enter the cell address of the cell that you want to make active.
Formula Bar (toolbar)
Is located immediately below the toolbars, displays the contents of the active cell. As you type or edit data, the changes appear in the formula bar.
Workbook (document in Excel)
Electronic spreadsheets in documents.
Outlook (E-mail)
E-mail program installs as part of Internet Explorer. (E-mail Client Software).
AutoSum Button
On the standard toolbar. Quick access to SUM, AVERAGE, COUNT, MIN, and MAX functions.
Summary Slide
Is a slide containing the slide titles in the presentation.
AutoShapes
Located in drawing toolbar.
Title Master
Contains the objects that appear on the title slide.
Slide Master
Contains the objects that appear on all the slides except the title slide.
Fix Problems w/ Style Checker
Find slide with the lightbulb button. Click the lightbulb, to find out the problem. Choose the blue bullet of the options.
Style Checker
Automatically checks your presentation for consistency and style, and marks problems on a slide with a light bulb.
Place Holder
Is a region of a slide or a location in an out-line reserved for inserting text or graphics.
Design Template
Is a file that contains the colors and format of the background and the type style of the titles, accents, and other text.
URL(Uniform Resource Locators)
Is a four part addressing scheme that tells the web browser the following information:
*what TRANSFER PROTOCAL to use when transporting the file.
*The DOMAIN NAME of the computer on which the file resides.
*The PATHNAME of the folder or directory on the computer on which the files resides.
*The NAME OF THE FILE.
URL(Uniform Resource Locators)
Is a four part addressing scheme that tells the web browser the following information:
*what TRANSFER PROTOCAL to use when transporting the file.
*The DOMAIN NAME of the computer on which the file resides.
*The PATHNAME of the folder or directory on the computer on which the files resides.
*The NAME OF THE FILE.
E-mail Guidelines
*check your mail regulary.
*reply to messages only when necessary
*let people know when you need to send a large attachment.
*provide meaningful information in the subject line.
*review your message before you send it.
*consider that e-mail is not private.
*follow proper netiquette.
4 Steps
1)CHART TYPE-selct from list of available chart types and corresponding type sub-type, or choose to customize a chart type.
2)CHART SOURCE DATA-specify the worksheet cells that contain the data on which the chart will be based and the worksheet cells that contain the labels that will appear in the chart.
3)CHART OPTIONS-change the appearance of the chart by selecting the options that affect titles, axis, gridlines, legends, data labels, and data tables.
4)CHART LOCATION-specify where the chart will be placed. Embedded as an object in the worksheet containing the data or on a sperate worksheet also called a chart sheet.
Data Functions
*YEAR(year,month,day)-extracts the year # from date value.
*DATE(year,month,day)-returns the integer for the data represented by the year, month, and day.
*DAY(date)-extracts the day of the month from the date value.
*MONTH(date)-extracts the month # from the date value, where Jan=1, Feb=2.....
*NOW(),TODAY()-returns the integer for the current date and time.
*WEEKDAY(date)-Calculate the day of the week using the date value, where Sun=1, Mon=2.