Disc Exam #2

Front 1

Function Name

Back 1

=FUNCTION(argument 1, argument 2....)

Front 2

Syntax

Back 2

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.

Front 3

Function

Back 3

is a predefined or built-in formula for a commonly used calculation.

Front 4

F11

Back 4

press to hide or show Internet Explorer toolbars

Front 5

Auto Fill Options

Back 5

*Copy Cell
*Fill Series
*Fill Formatting Only
*Fill without Formatting

Front 6

Auto Fill

Back 6

When you drag the fill handle, Excel automatically fills in the formulas or formats used in the selected cells.

Front 7

Absolute Reference

Back 7

Is a cell reference that does not change when you copy the formula to a new location on the workbook.

Front 8

Arguments

Back 8

The numbers, text, or cell references used by the funcction to calculate a value.

Front 9

Insert Function Button

Back 9

Is located on the formula bar and is a button that has fx on it.

Front 10

F4

Back 10

Switch between absolute, relative, and mixed reference that shifts when you copu it to a new location on the worksheet.

Front 11

Creating Absolute Reference

Back 11

You preface the column and row designation with a dollar sign ($).

Front 12

Fill Handle

Back 12

A small black square located in the lower-right corner of a selected cell or range.

Front 13

AutoContent Wizard

Back 13

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.

Front 14

Embedded Chart

Back 14

Is a chart that is display within a worksheet.

Front 15

Chart Area

Back 15

The entire chart and all of the elements.

Front 16

Address Bar (toolbar)

Back 16

Where you type URL's into to load webpages.

Front 17

Progressive Disclosure

Back 17

Is the appearance of the bulleted list one item at a time.

Front 18

Gradent Fill

Back 18

Is a type of shading in which one color blends into another making the slide more eye-catching.

Front 19

Slide Transition

Back 19

The manner in which a new slide appears on the screen during a slide show.

Front 20

Navigate Through Presentation

Back 20

Press space bar, ->, or click the left mouse button to advance to the next slide.

Front 21

IP Address (Internet Protocol)

Back 21

A unique idenification number in which each computer on the internet has.

Front 22

Plot Area

Back 22

The basic elements of the chart. A rectangular area that contains data markers.

Front 23

Data Marker

Back 23

Graphical representation of the values in the data series.

Front 24

Modify Your Homepage

Back 24

Click TOOLS on the menu bar, click INTERNET OPTIONS, click the GENERAL tab.

Front 25

HTTP (Hypertext Transfer Protocal)

Back 25

The most common transfer protocal used on the internet; http://

Front 26

Transfer Ptotocal

Back 26

Is the set of rules that computers use to move files from one computer to another on an internet.

Front 27

#REF!

Back 27

Is Excel's way of indicating that there is an invalid cell reference in a formula.

Front 28

Exploded Pie Chart

Back 28

A pie chart with one or more pie slices seperated from the whole.

Front 29

Chart Sheet

Back 29

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.

Front 30

Demote

Back 30

To decrease the outline level.

Front 31

Chart Wizard

Back 31

A series of dialog boxes that prompts you for information about the chart you want to generate.

Front 32

Formatting

Back 32

Is the process of changing the appearance of you workbook.

Front 33

########

Back 33

Represent a value that is so large that it cannot be displayed with the width of the cell.

Front 34

Promote

Back 34

To increase the outline level.

Front 35

Order of Precedence

Back 35

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.

Front 36

Arithmetic Operators

Back 36

+,-,*,/. Are applied to either values or cells in the workbook.

Front 37

Formula

Back 37

Is an expression that is used to calculate a value.

Front 38

Non Adjacent Range

Back 38

Is comprised of two or more seperate adjacent ranges.

Front 39

Current Date Functions

Back 39

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.

Front 40

Adjacent Range

Back 40

Is a single rectangular block such as all of the data entered in cells A1 through B10.

Front 41

Range (Cell Range)

Back 41

A group of worksheet cells.

Front 42

F5

Back 42

Opens the GO TO dialog box in which you can enter the cell address of the cell that you want to make active.

Front 43

Formula Bar (toolbar)

Back 43

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.

Front 44

Workbook (document in Excel)

Back 44

Electronic spreadsheets in documents.

Front 45

Outlook (E-mail)

Back 45

E-mail program installs as part of Internet Explorer. (E-mail Client Software).

Front 46

AutoSum Button

Back 46

On the standard toolbar. Quick access to SUM, AVERAGE, COUNT, MIN, and MAX functions.

Front 47

Summary Slide

Back 47

Is a slide containing the slide titles in the presentation.

Front 48

AutoShapes

Back 48

Located in drawing toolbar.

Front 49

Title Master

Back 49

Contains the objects that appear on the title slide.

Front 50

Slide Master

Back 50

Contains the objects that appear on all the slides except the title slide.

Front 51

Fix Problems w/ Style Checker

Back 51

Find slide with the lightbulb button. Click the lightbulb, to find out the problem. Choose the blue bullet of the options.

Front 52

Style Checker

Back 52

Automatically checks your presentation for consistency and style, and marks problems on a slide with a light bulb.

Front 53

Place Holder

Back 53

Is a region of a slide or a location in an out-line reserved for inserting text or graphics.

Front 54

Design Template

Back 54

Is a file that contains the colors and format of the background and the type style of the titles, accents, and other text.

Front 55

URL(Uniform Resource Locators)

Back 55

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.

Front 56

URL(Uniform Resource Locators)

Back 56

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.

Front 57

E-mail Guidelines

Back 57

*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.

Front 58

4 Steps

Back 58

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.

Front 59

Data Functions

Back 59

*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.