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