click below
click below
Normal Size Small Size show me how
ICT2 9 wks
| Question | Answer |
|---|---|
| What term describes a cell that is ready for data entry | Active cell |
| What term describes a group of selected cells | Range |
| Which Ribbon tag is the Alignment group located on | HOME |
| The file used to store worksheets | Workbook |
| What 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 |
| To combine multiple cells into one cell | Merge |
| Which number formats display numbers preceded by a dollar sign | Accounting, currency |
| 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 |
| 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 this at the bottom of the worksheet window | Sheet tabls |
| These appear vertically and are identified by letters at the top of the worksheet window | columns |
| Appear horizontally and are identified by numbers on the left side of the worksheet window | Row |
| Each cell is identified by a unique cell reference, which is formed by combining the cell’s column letter and what | Row number |
| The 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 what | colon |
| Numbers that extend beyond a cell’s width appear these in the cell | ###### |
| What happens to text that is too long to fit within a cell | It’s displayed in the next cell, if empty |
| The default number format is __________ which displays numbers the way you type them | General |
| 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 |
| Formulas with functions have three parts | equal sign, function name and argument |
| Which chart shows the relationship of a part to a whole | Pie |
| Which chart uses points connected by a line to illustrate values in a worksheet | Line |
| Which chart uses bars of varying heights to illustrate values in a worksheet | Column |
| Which 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 which group do you click the Move Chart button | Location |
| What tab are the chart types are available on | Insert |