Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
ICT2 Nine Weeks Test
| Question | Answer |
|---|---|
| What term describes a cell that is ready for data entry? | Active cell |
| What term describes a group of selected cells? | Range |
| __________ appear horizontally and are identified by numbers on the left side of the worksheet window. | rows |
| The file used to store worksheets; usually a collection of related worksheets | workbook |
| TRUE or FALSE: One reason for changing the orientation of text in a cell is to save space in your worksheet | TRUE |
| The ________ button combines several cells into one cell and places data in the center of the merged cell. | merge and center |
| determines the best width for a column or the best height for a row, based on its contents | AutoFit |
| Which number format displays numbers with a fixed number of decimal places? | Number |
| A feature that copies format attributes such as colors, borders, and fill effects from an object, text, or cell in order to apply the same formatting to another object, text, or cell. | Format Painter |
| To move data to a new line when the cell is not wide enough to display all the contents | Wrap Text |
| the position of data within a cell | Alignment |
| ________ appear vertically and are identified by letters at the top of the worksheet window. | columns |
| Which number formatS display numbers preceded by a dollar sign | currency and accounting |
| To copy a cell's contents and/or formatting into an adjacent cell or range | fill |
| The black square in the lower right corner of the active cell or range that you drag over the cells you want to fill | fill handle |
| to remove selected text and place it on the Clipboard | Cut |
| Each cell is identified by a unique cell reference, which is formed by combining the cell’s column letter and | row number |
| cell reference area located below the ribbon, which displays the cell reference of the active cell | name box |
| The range is identified by its range reference, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a ______ | colon |
| Numbers that extend beyond a cell’s width appear as ________ in the cell. | ###### |
| TRUE or FALSE- To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want. | TRUE |
| What happens to text that is too long to fit within a cell? | it is displayed in the next cell, if empty |
| The default number format is _______ which displays numbers the way you type them. | general |
| When Excel starts, the program window displays a blank workbook titled Book 1 which includes how many blank worksheets? | three |
| The name of each worksheet appears in the ______ at the bottom of the worksheet window. | sheet tabs |
| An equation that calculates a new value from values in a worksheet | Formula |
| A number or cell reference used in a formula | Operand |
| A symbol that indicates what mathematical operation to perform on the operands, such as a plus sign (+) for addition | Operator |
| In a formula, to click a cell rather than type its cell reference | Point and Click Method |
| A cell reference that adjusts to its new location when copied or moved | Relative |
| A cell reference that does not change when copied or moved to a new cell | Absolute |
| TRUE OR FALSE: The results of the calculation appear in the cell in which the formula is entered. | TRUE |
| TRUE OR FALSE:Formulas can include more than one operator. | TRUE |
| TRUE OR FALSE: Consider the formula =B3+5. In this formula, the cell reference B3 and the constant 5 are operands. | TRUE |
| Each formula begins with an | equal sign |
| When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is | =$A$3+$A$4 |
| A shorthand way to write an equation that performs a calculation | function |
| A feature to help you enter a formula with a valid function name and arguments | AutoComplete |
| If a function contains more than one argument, _________ separate the arguments. | commas |
| TRUE OR FALSE: Some mathematical operations, such as addition, subtraction, multiplication, & division do not require functions. | TRUE |
| To enter a formula with a function, you start with an _________ | equal sign |
| Averages all values in a range | Average |
| Adds/totals all values in a range | SUM |
| Counts all non-blank cells in a range | Count |
| Highest value in a range | MAX |
| Lowest values in a range | MIN |
| a separate sheet in a workbook that stores a chart | chart sheet |
| Formulas with functions have three parts | equal sign, function name and argument |
| an arrangement that specifies which elements are included in a chart and where they are placed | chart layout |
| If you know the function you want to enter, you can click the appropriate category button in the ___________ group on the Formulas tab of the Ribbon | Functions Library |
| A ____ chart shows the relationship of a part to a whole | Pie |
| A _____ chart uses points connected by a line to illustrate values in a worksheet | Line |
| A _____ chart uses bars of varying heights to illustrate values in a worksheet | Column |
| A ______ chart, sometimes called an XY chart, shows the relationship between two categories of data | Scatter |
| You switch between a chart sheet and a worksheet by clicking the appropriate _______ | Sheet tab |
| To move an embedded chart to a chart sheet, click the Design contextual tab under the Chart Tools on the Ribbon. Then, in the _________ group, click the Move Chart button | Location |
| The chart types are available on the _______ tab in the Charts group | Insert |
| TRUE OR FALSE- Embedded charts are useful when you want to print a chart next to the data the chart illustrates | TRUE |
| TRUE OR FALSE- All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart | FALSE |
| TRUE OR FALSE- When you select the data source for a chart, you should also include the text you want to use as labels in the chart | TRUE |
| TRUE OR FALSE- You can quickly change the look of any chart you created by applying a layout and style | TRUE |
| TRUE OR FALSE- Charts make the data in a worksheet easier to understand by providing a visual picture | TRUE |
| TRUE OR FALSE- After you create a chart, you cannot change the chart type or subtype | FALSE |
| TRUE OR FALSE- After you select a chart type, the chart is automatically inserted on a separate worksheet | FALSE |
| formatting applied to a chart based on the colors, fonts, and effects associated with the workbook's theme | chart style |
| a graphical representation of data | Chart |
| a list that identifies patterns, symbols, or colors used in a chart | Legend |
| the graphical representation of all of the data series | Plot Area |
| a chart symbol (such as a bar, line, dot, slice, and so forth) that represents a single data point or value from the corresponding worksheet cell | Data marker |
| a horizontal or vertical line that establishes the relationship between data in a chart | Axis |
| the entire chart and all other chart elements | Chart area |
Created by:
krwhite1
Popular Computers sets