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
computers semester
| active cell | the active cell is the current cell. there is a green border around the active cell |
| backstage view | a feature of microsoft office from which you access file and program management commands. |
| cell | a cell is the intersection of a column and a row on a worksheet. you enter data into cells to create a worksheet. |
| cell address or cell reference | the location of a cell in a worksheet as identified by its column letter and row number, such as A1. |
| formula bar | as you enter data in a cell, it simultaneously appears in the formula bar, which is located above the worksheet. |
| onedrive | a file hosting service that allows you to upload and sync files to a virtual, or cloud, storage environment. files can then be accessed from a web browser or a local device |
| scroll | a way to view locations on the worksheet without changing the active cell |
| sheet tabs | tabs that appear at the bottom of the workbook window, which display the name of each worksheet. |
| tab scrolling buttons | buttons that appear to the lift of the sheet tabs which allow you to scroll hidden tabs into view. |
| template | a document that contains formatting, styles, and sample text that you can use to create new documents. |
| workbook | an excel file with one or more worksheets. |
| worksheet | the work area for entering and calculating data made up of columns and rows separated by gridlines also called a spreadsheet. |
| blank workbook | a new empty workbook contains one worksheet. |
| clear | to remove a cell's contents and/or formatting. |
| default | the standard setting excel uses in its software, such as column width or bottom alignment of text in a cell |
| footer | descriptive text, such as page numbers, that appear at the bottom of every page of a printout. |
| header | descriptive text, such as page numbers, that appear at the top of every page of a printout |
| label | text entered to identify the type of data contained in a row or column |
| metadata | data about data |
| preview | to see how a worksheet will look when printed. |
| redo | the command used to redo an action that you have undone |
| text | an alphanumeric entry in a worksheet that is not a cell or range address |
| undo | the command to reverse one or a series of edition actions |
| autocomplete | a feature used to complete an entry based on previous entries made in the column containing the active cells. |
| autocorrect | a feature used to automate the correction on common typing errors. |
| numeric label | a number entered in the worksheet as a label. not as a value-such as the year 2017 used as a common label |
| pick from list | a shortcut used to insert repeating information |
| spelling checker | a tool used to assist you in finding and correcting typographical or spelling errors. |
| value | a cell entry that consists of a number and numeric formatting only |
| accounting format | a style that vertically aligns dollar signs, thousands of separators and decimal points. |
| cell style | a combination of a font, text color, cell color, and other font attributes applied to a single cell |
| comma format | a style that displays numbers with a thousand separators |
| currency format | a style that displays dollar signs immediately preceding the number and includes a thousand separators. |
| fill | a color that fills a cell, appearing behind the data |
| font | the typeface or design of the text. |
| font size | the measurement of the typeface in points |
| format | to apply attributes to cell data to change the appearance of the worksheet. |
| live preview | a feature that shows you how a gallery formattinf choice will appear in the worksheet when you move the mouse pointer over that choice |
| merge and center | a feature that enables you to automatically combine cells and center the contents of the original far left cell in the new cell. |
| number format | a format controls how numerical data is displayed, including the use of commas, dollar signs, and the number of decimal places. |
| percent format | a style that displays decimal numbers as a percentage |
| theme | a collection of coordinated fonts, colors, and effects for graphic elements such as charts and images, that can be quickly applied to all sheets in a workbook. |
| auto fill | the feature that enables excel to create a series automtically. |
| date | a cell entry that indicated a date or time and is stored as a date code in excel |
| default column width | the default number of characters that are displayed in a column based on the default font. |
| fill handle | a green box on the lower right corner of the selected cell or range that you can use to fill a series of formulas |
| key tips | keyboard shortcuts for choosing ribbon commands that you display by pressing ALT |
| keyboard shortcuts | specific keyboard keys that you press together or in sequence to execute commands or apply. |
| series | a list of sequential numbers, dates, times, or text. |
| contiguous range | a block of adjacent cells in a worksheet |
| noncontiguous range | cells in a worksheet that acts as a block but are not necessaeily adjacent to each other |
| collapse dialogue button | a button in a dialog box that you click to downsize a dialog box to select on the sheet |
| expand dialogue button | a button that you click to restore a dialog box to its normal size after using a collapse dialog button to select on the sheet |
| range | a block of cells in an excel worksheet |
| arithmetic | symbols using in mathematical operations specified in a formula, based on the typees of mathematical operations. |
| formula | an instruction excel uses to calculate a result |
| order of precedence | the order in which excel performs the mathematical operations specified in a formula, based on the typees of mathematical operations used |
| SUM function | a built in calculation used to add a range of values together. |
Created by:
kozabry29