IC3/Spreadsheets/Quiz

{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
 * type="" coef="1"}

{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
 * type="" coef="1"}

{A circular chart divided into triangular areas proportional to the percentages of the whole. +Pie chart -Chart -Bar chart -Line chart
 * type="" coef="1"}

{A chart with bars whose lengths are proportional to quantities. -Chart -Line chart -Pie chart +Bar chart
 * type="" coef="1"}

{A numeric format that includes a currency symbol, e.g. $, and two decimal places. +Currency -Cell -Chart -Borders
 * type="" coef="1"}

{A chart that uses points connected by a line to illustrate values in a worksheet. -Chart -Bar chart +Line chart -Pie chart
 * type="" coef="1"}

{Lines around the edge(s) of text, a page, a cell, or a table. -Filter -Legend -Column +Borders
 * type="" coef="1"}

{The portion of a chart that forms the background to the plotted data. -Data Label -Chart area -average +Wall Area
 * type="" coef="1"}

{A spreadsheet function that determines the average value in the specified range, e.g. =average(A3:D4) -Axis -Range +average -max
 * type="" coef="1"}

{A graphical representation of data. -Bar chart +Chart -Cell -Pie chart
 * type="" coef="1"}

{The intersection of a row and column. -Chart -Axis +Cell -Column
 * type="" coef="1"}

{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
 * type="" coef="1"}

{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
 * type="" coef="1"}

{A spreadsheet function that determines the smallest value in the specified range, e.g. =min(A3:D4) -Sum -Axis +min -max
 * type="" coef="1"}

{A vertical collection of cells. Usually labelled alphabetically A..Z, AA..AZ, etc -Sum +Column -Cell -min
 * type="" coef="1"}

{The vertical and horizontal lines on a coordinate plane or graph. -Range -min -max +Axis
 * type="" coef="1"}

{A spreadsheet function that determines the largest value in the specified range, e.g. =max(A3:D4) -min +max -Row -Sum
 * type="" coef="1"}

{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
 * type="" coef="1"}

{A rectangular collection of cells. Identified by naming diagonally opposite corner cells. +Range -Axis -max -average
 * type="" coef="1"}

{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
 * type="" coef="1"}

{To separate a wedge of a pie chart slightly from other wedges in a pie +Explode -Legend -Column -Cell
 * type="" coef="1"}

{A list that identify the different data series in a chart, usually by colour or marker symbol. -min -Cell -Range +Legend
 * type="" coef="1"}

{An effect in which colors are gradually blended. -Borders +Gradient -Range -Stacked
 * type="" coef="1"}

{A spreadsheet function that calculates or adds up the total of the cells in a range. -max -Row -min +Sum
 * type="" coef="1"}

{A chart option where data series are added on top of each other. +Stacked -Chart -Range -max
 * type="" coef="1"}

{A horizontal collection of cells. Usually labelled numerically. +Row -Sum -max -min
 * type="" coef="1"}

{Text or numbers that provides additional information about a data marker. +Data Label -Data Series -Wall Area -average
 * type="" coef="1"}

{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
 * type="" coef="1"}

{A condition that data must meet to be included in a selection. -Range -Cell -min +Filter
 * type="" coef="1"}

{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
 * type="" coef="1"}

{ Excel macros are written in the programming language { VBA (i) _5 }.
 * type="{}" coef="1"}

{ To edit a VBA macro, you need to use the Visual Basic { Editor (i) _8 }.
 * type="{}" coef="1"}

{ To quickly switch to the Visual Basic Editor, press { Alt + F11 (i) _11 } on your keyboard.
 * type="{}" coef="1"}

{ The { Properties window (i) _19 } is a Visual Basic Editor window.
 * type="{}" coef="1"}

{ A(n) { project (i) _9 } is a collection of macros, worksheets, data entry forms, and other items that make up a customized application.
 * type="{}" coef="1"}

{ Within each project are various items called { objects (i) _9 }.
 * type="{}" coef="1"}

{ A(n) { object (i) _8 } is any element within the Excel working environment, such as a worksheet, macro, or workbook.
 * type="{}" coef="1"}

{ When you enter the name and description of a project, you are actually modifying two of its { properties (i) _12 }.
 * type="{}" coef="1"}

{ When you want to view the VBA macro code associated with any item in Project Explorer, you use the { Code (i) _6 } window.
 * type="{}" coef="1"}

{ Formatting a cell or displaying a chart are examples of { sub (i) _5 } procedures in Visual Basic.
 * type="{}" coef="1"}

{ A { function (i) _10 } procedure returns a value.
 * type="{}" coef="1"}

{ To create sub procedures without using the macro recorder, you need to know some rules of VBA { syntax (i) _8 }.
 * type="{}" coef="1"}

{ The { End Sub (i) _9 } command is always the last line in a sub procedure and tells Excel to stop running the macro.
 * type="{}" coef="1"}

{ Comments must begin with a(n) { apostrophe (i) _12 }.
 * type="{}" coef="1"}

{ Procedure names cannot contain { spaces (i) _8 }.
 * type="{}" coef="1"}

{ The Excel object you will use to create VBA programs and refer to a range in a worksheet is { range (i) _7 }.
 * type="{}" coef="1"}

{ A(n) { variable (i) _10 } is a named element in a program that can be used to store and retrieve information.
 * type="{}" coef="1"}

{ Every variable is identified by a unique variable { name (i) _6 }.
 * type="{}" coef="1"}

{ You can define exactly what type of data can be stored in a variable with the { Dim (i) _5 } command.
 * type="{}" coef="1"}

{ The { & _3 } symbol is used to combine two text strings into a single text string.
 * type="{}" coef="1"}

{ Most software programs can both save and retrieve data in a(n) { text (i) _6 } file format.
 * type="{}" coef="1"}

{ When you use Excel to connect to a text file, the { text (i) _6 } Wizard determines whether the data is in a fixed-width format or a delimited format.
 * type="{}" coef="1"}

{ The row at which you begin the import process is called the { starting (i) _10 } row.
 * type="{}" coef="1"}

{ Unless you specify a format, Excel will apply a { general (i) _9 } format to all columns.
 * type="{}" coef="1"}

{ In response to a(n) { query (i) _7 }, a database displays the records and fields that meet the question's requirements.
 * type="{}" coef="1"}

{ If you want to extract only specific records when you query a database, your query would contain { criteria (i) _10 }.
 * type="{}" coef="1"}

{ The { query (i) _7 } Wizard lets you preview the structure of the database and its contents.
 * type="{}" coef="1"}

{ When you { filter (i) _8 } data, you specify which records you want to retrieve using specific criteria.
 * type="{}" coef="1"}

{ The default folder for queries is the { queries (i) _9 } folder on the hard disk.
 * type="{}" coef="1"}

{ Microsoft Query is a(n) { Office program (i) _16 } that includes several tools that allow you to create even more complex queries.
 * type="{}" coef="1"}

{ { XML (i) _5 } has been widely used in database programs, Web programming, and word processing.
 * type="{}" coef="1"}

{ Clicking a { hyperlink (i) _11 } in a worksheet will activate the computer's Web browser to display the Web page associated with that entry.
 * type="{}" coef="1"}

{ In XML, the rules about which elements are required and which are not are stored in a document called the { schema (i) _8 }.
 * type="{}" coef="1"}

{ Databases such as those created in Access are examples of { relational (i) _12 } databases which reduce data redundancy and increase data integrity.
 * type="{}" coef="1"}

{ 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 { trusted locations (i) _19 }.
 * type="{}" coef="1"}

{ If you orient a one-variable table so that the input values are in the first row, you would use the { row (i) _5 } input cell option.
 * type="{}" coef="1"}

{ In two-variable tables, you must always place a reference to the result cell in the { upper-left (i) _12 } corner of the table at the intersection of the row values and the column values.
 * type="{}" coef="1"}

{ { Array formulas (i) _16 } 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.
 * type="{}" coef="1"}

{ A(n) { tracer (i) _8 } arrow provides a visual clue to the relationship between two cells by pointing from the precedent cell to the dependent cell.
 * type="{}" coef="1"}

{What operating systems can someone use Excel on? { Windows (i) _9 },{ macOS (i) _7 },{ Android (i) _9 } and { iOS (i) _5 }
 * type="{}" coef="4"}