click below
click below
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.. |