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
CA Excel
Computer Apps
| Question | Answer |
|---|---|
| Appear Vertically and are identified by letters at tje top of the worksheet window | Columns |
| Appear horizontally and are identified by numbers on the left side of the worksheet window | Rows |
| 3 Ways to enter data in a cell | Enter, tab, enter button in formula bar |
| Range reference - example | (A1:F1) |
| Wildcard (find/replace) | * (asterisk) |
| Default magnification | 100% |
| Print Tab | Enables you to select the number of copies to print, a printet, the parts of the worksheet to print, and the way the printed worksheet will look |
| What happens if you try to close a worksheet that has not been saves? | You are prompted to save the file |
| Autofit | Determins the best width for a column or the best hight for a row, based on its contents |
| Explain how to resize the width of several columns at once | Select the columns you want to resize, then use the pointer to click and drag the right edge of one of the selecred column headings |
| Show an example of the SUM function | SUM(F1:F10) |
| Control = `(grave accent) | Used to swich between showing formulas and showing formula results in a worksheet |
| What is the order of poperations when executing an Excel formula? | Inner most parentheses are evaluated first, moving outward |
| Order of evaluation | The sequence used to calculate the value of a formula |
| Show an example of exponentation | A1^3 |
| Show an example of division | A1/2 |
| Show an example of multiplication | A1*7 |
| Identify three ways to enter a formula into a cell | Enter, tab, enter button on the formula bar |
| Footer | Text that prints in the bottom margin of each page |
| Header | Text that prints in the top margin of each page |
| Portrait orientation | Wider tan they are long |
| How do you insert a row in an Excel spreadsheeT? | Click the row number to select the row where you want to new row to appear, then click the insert button |
| CTRL V | paste |
| CTRL C | Copy |
| CTRL U | Underline |
| CTRL B | Bold |
| CTRL I | Italics |
| Wrapped tect | row height will automatically adjuct to show all of the lines of text. Text wraps within a cell like in a word processing document rather than spilling over into te next cell |
| Theme | present collection of design elements, including fonts, colors, and other effects |
| Merge and Center | Center cell contents across several columns |
| alphanumeric data | numbers, text, or a combo of number and text |
| auto number | automatically incremet a numberic counter |
| blank database template | database with an empty table |
| data type | determiens the kind of data that you can enter in the field |
| default value property | enter calie into new records automatically |
| decription property | identify the data ti enter the field |
| deisgn grid | can delete a field from table by selecting it in the design grid |
| design view | add new fields to a table |
| field property | describes a fields contents beyond the fields basic data type |
| field size properties | set number of charactors in a test field or to select the type of numbers to store in a number field |
| format property | lets you specify how to display numbers, dates, times and text |
| primary key | field that contains unique field values for each record in the table |
| required property | use when field must contain a value |
| tamplate | file that serves as a starting point for a new document |
| and operator | placing criteria in the same criteris or in the design grid |
| autofiller | opens when you click arrow on a field selector |
| calculated field | numeric or date field that derives its data from calculation of other fields |
| common field | field where you put data into |
| condition | based on this it will filter out stuff |
| expresesion | combo of math and logical operations, constants, functions, table fields, controls ans properties that evaluates to a single value |
| filter | temperarly all play records in data based on the condition you specify |
| filter by form | display records that match the value you select in a field |
| foreign key | a key thats different |
| multiple query | query that is based on more than 1 table |
| query | database object that lets you ask the database a question about te data it contains |
| referntial integrity | database concept that ensures that relationships between tables remain consistant |
| simple wizard query | asks you about data you want to se and lets you see and lets you select options in dialog boxes |
| sort | organize data |
| subdaa sheet | datasheet within another datasheet |
| best fit | determines best place for new data |
| compacting disk | rearranges how the database is stored on the disk |
| database | a collection of objects |
| DBMS | store, retrieve, analyze, and print info |
| datasheet | sheet w all the data |
| datasheet selector | selects datasheet |
| datasheet view | views datasheet |
| field | record or set of data |
| field name | identifies each firld |
| field selector | selects an entire fields |
| field vie | data in the field |
| navigation pane | where ou navigate |
| record | comlete set of data |
| record selector | selects a record |
| bound control | connected to a field in the record source and is used to display, enter ad update data |
| control added | when you add fields to a form, theyre to the form as contorls in control layout |
| control layout | resize and change controls |
| database tool | tools for the database |
| detail section | the default section in layout view |
| field list plane | creates fields |
| find | locates records |
| form source | database object that displays data from a record |
| form footer section | controls forms footer |
| form header sectin | controls forms header |
| form tool | create a form |
| form view | navigates records displayed in a form |
| form wizard | create a form |
| layout view | has 1 default section |
| multiple items tool | lets you use multiple items |
| record source | used to display |
| split form tool | splits the form |
| theme | chooses a certain font, color, ect... |
| unbound control | not connected to a record source and is used to display info, ect.. |
Created by:
moniquemark
Popular Computers sets