1 The portion of a chart that forms a background to the entire chart, including the titles, legend and plotted data

 Wall Area Chart area Bar chart Chart

2 When copying a term in a formula that has ____ ______ cell referencing, the displacement has no effect on the resulting formula.

3 A circular chart divided into triangular areas proportional to the percentages of the whole.

 Pie chart Chart Bar chart Line chart

4 A chart with bars whose lengths are proportional to quantities.

 Chart Line chart Pie chart Bar chart

5 A numeric format that includes a currency symbol, e.g. \$, and two decimal places.

 Currency Cell Chart Borders

6 A chart that uses points connected by a line to illustrate values in a worksheet.

 Chart Bar chart Line chart Pie chart

7 Lines around the edge(s) of text, a page, a cell, or a table.

 Filter Legend Column Borders

8 The portion of a chart that forms the background to the plotted data.

 Data Label Chart area average Wall Area

9 A spreadsheet function that determines the average value in the specified range, e.g. =average(A3:D4)

 Axis Range average max

10 A graphical representation of data.

 Bar chart Chart Cell Pie chart

11 The intersection of a row and column.

 Chart Axis Cell Column

12 A group of related information in a column or row of a worksheet that is plotted on a chart.

 Data Label Borders Wall Area Data Series

13 a unique identifier for a cell which is formed by combining the cell's column letter and row number. E.g. B12

 Cell Background Currency Wall Area Cell Reference

14 A spreadsheet function that determines the smallest value in the specified range, e.g. =min(A3:D4)

 Sum Axis min max

15 A vertical collection of cells. Usually labelled alphabetically A..Z, AA..AZ, etc

 Sum Column Cell min

16 The vertical and horizontal lines on a coordinate plane or graph.

 Range min max Axis

17 A spreadsheet function that determines the largest value in the specified range, e.g. =max(A3:D4)

 min max Row Sum

18 An arrangement of cells in colums and rows used to organize, analyze, calculate, and report information, usually in numerical form, similar to a table.

19 A rectangular collection of cells. Identified by naming diagonally opposite corner cells.

 Range Axis max average

20 The area behind the contents of a cell, which may be coloured in a solid colour or a gradient.

 Cell Cell Background Wall Area Cell Reference

21 To separate a wedge of a pie chart slightly from other wedges in a pie

 Explode Legend Column Cell

22 A list that identify the different data series in a chart, usually by colour or marker symbol.

 min Cell Range Legend

23 An effect in which colors are gradually blended.

24 A spreadsheet function that calculates or adds up the total of the cells in a range.

 max Row min Sum

25 A chart option where data series are added on top of each other.

 Stacked Chart Range max

26 A horizontal collection of cells. Usually labelled numerically.

 Row Sum max min

27 Text or numbers that provides additional information about a data marker.

 Data Label Data Series Wall Area average

28 The active cell is the cell currently being edited. A border appears around this cell to highlight it and make it easy to locate.

 Line chart Active cells Pie chart Cell

29 A condition that data must meet to be included in a selection.

 Range Cell min Filter

30 When copying a formula from one cell to another, Excel uses _____ ________which means that the same function will be used, but the letters or row numbers will be changed reelative to the destination location.

31

 Excel macros are written in the programming language .

32

 To edit a VBA macro, you need to use the Visual Basic .

33

 To quickly switch to the Visual Basic Editor, press on your keyboard.

34

 The is a Visual Basic Editor window.

35

 A(n) is a collection of macros, worksheets, data entry forms, and other items that make up a customized application.

36

 Within each project are various items called .

37

 A(n) is any element within the Excel working environment, such as a worksheet, macro, or workbook.

38

 When you enter the name and description of a project, you are actually modifying two of its .

39

 When you want to view the VBA macro code associated with any item in Project Explorer, you use the window.

40

 Formatting a cell or displaying a chart are examples of procedures in Visual Basic.

41

 A procedure returns a value.

42

 To create sub procedures without using the macro recorder, you need to know some rules of VBA .

43

 The command is always the last line in a sub procedure and tells Excel to stop running the macro.

44

 Comments must begin with a(n) .

45

 Procedure names cannot contain .

46

 The Excel object you will use to create VBA programs and refer to a range in a worksheet is .

47

 A(n) is a named element in a program that can be used to store and retrieve information.

48

 Every variable is identified by a unique variable .

49

 You can define exactly what type of data can be stored in a variable with the command.

50

 The symbol is used to combine two text strings into a single text string.

51

 Most software programs can both save and retrieve data in a(n) file format.

52

 When you use Excel to connect to a text file, the Wizard determines whether the data is in a fixed-width format or a delimited format.

53

 The row at which you begin the import process is called the row.

54

 Unless you specify a format, Excel will apply a format to all columns.

55

 In response to a(n) , a database displays the records and fields that meet the question's requirements.

56

 If you want to extract only specific records when you query a database, your query would contain .

57

 The Wizard lets you preview the structure of the database and its contents.

58

 When you data, you specify which records you want to retrieve using specific criteria.

59

 The default folder for queries is the folder on the hard disk.

60

 Microsoft Query is a(n) that includes several tools that allow you to create even more complex queries.

61

 has been widely used in database programs, Web programming, and word processing.

62

 Clicking a in a worksheet will activate the computer's Web browser to display the Web page associated with that entry.

63

 In XML, the rules about which elements are required and which are not are stored in a document called the .

64

 Databases such as those created in Access are examples of databases which reduce data redundancy and increase data integrity.

65

 In order to override Excel so that it always enables data sources and refreshes the connection to the source without prompting, you should define the location of the data sources as .

66

 If you orient a one-variable table so that the input values are in the first row, you would use the input cell option.

67

 In two-variable tables, you must always place a reference to the result cell in the corner of the table at the intersection of the row values and the column values.

68

 are a powerful feature of Excel. If used properly, they help you perform complex calculations within a single formula and extend a single formula over a range of cells.

69

 A(n) arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.

70 What operating systems can someone use Excel on?

 , , and