IC3/Spreadsheets/Quiz

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.

	Relative addressing
	Chart area
	Wall Area
	Absolute addressing

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.

	Gradient
	Spreadsheets
	Pie chart
	Borders

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.

	Borders
	Gradient
	Range
	Stacked

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.

	Active cells
	Line chart
	Relative addressing
	Absolute addressing

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