or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01

 Flashcards Matching Hangman Crossword Type In Quiz Test StudyStack Study Table Bug Match Hungry Bug Unscramble Chopped Targets

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

# CA Excel

### Computer Apps

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
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