Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

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.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards
share
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

Computer Apps.

Study Guide: Excel, Power Point, Access

QuestionAnswer
Columns Appear vertically and are identified by letters at the top of the worksheet window.
Row Appear horizontally and are identified by numbers on the left side of the worksheet window.
Range reference - example (A1:F1)
###### Numbers extend beyond a cell's width
3 ways to enter data in a cell Enter, Tab, Enter button in formula bar.
Wild card (Find/Replace) *(asterisk)
Default Magnification 100%
Print Tab Enablesnyou to select the number of copies to print, a printer, the parts of the worksheet to print , and the way the printed worksheet will look.
What happens if you trybto close a worksheet that has not been saved? You are prompted to save the file
AutoFit Determines the best width for a column or the best height for a row, based on its contents.
Explain how to resize the width of columns at once. Select the columns you want to resize, then use the pointer to click and drag the right edge of one of selected column headings.
How are numbers displayed in a cell right aligned
Merge & Center Centers cell contents across several columns
Theme Preset collection of design elements, including fonts, colors, and other effects
Ctrl+U Underline
Ctrl+B Bold
Ctrl+I Italics
Wrapped Text With wrapped text, the row height will automatically adjust to show all of the lines of text. Text wraps within a cell like in a word processing document, rather than spilling over into the next cell.
Ctrl+C Copy
Ctrl+V Paste
How do you insert a row in an Excel spreadsheet? Click the row number to select the row where you want the new row to appear, then click the insert button.
Landscape orientation Wider than they are long
Portrait orientation Longer than they are wide
Header Text that prints in the top margin of each page
Footer Text that prints in the buttom margin of each page
Identify three ways to enter a formula into a cell Enter, tab, enter button on the formula bar
Show an example of multiplication A1*7
Show an example of division A1/2
Show an example of exponentiation A1^3
Order of Evaluation The sequence used to calculate the value of the formula
What is the order of operations when executing an Excel formula? Inner most parentheses are evaluated first, moving outward
Control+`(grave accent) Used to switch between showing formula and showing formula results in a worksheet
Show an example of the SUM function SUM(F1:F10)
Title slide Introduces your presentation to your audience
Transition Refers to the way each slide appears on the screen
Animation An effect you can apply to your text, objects, graphics, or pictures to make those objects move during a slide show
Name three color printing options color, grayscale, pure black and white
How many slides per page can be printed using the "Handouts" option? 2-9 slide per page
What is the Powerpoint file extension .pptx
Placeholders Placeholders are boxes with dotted borders that contain content reside within a slide layout. All built-in slide layouts contain content placeholders.
Slide Master View A feature that gives your presentation a consistent, professional look. A slide master is helpful if you want every slide in your show to be the same colorm, to have the same header or footer, to carry a particular logo.
How do you insert a table into a PP slide using the content slide layout? click insert table icon
Access a database management system
Database a collection of objects
Datasheet the table displays its data in rows and columns
How do you move from one field to the next in datasheet view? Tab
How do you move from one field to the previous field in datasheet view? Shift+Tab
Best fit Automatically resizes the column to the best width for the data containned in the column
How are fileds rearranged in datasheet view? By clicking and dragging them to a new locatio.
What is the purpose of Print Preview To check the print sttings prior to printing
Field selector a small bar or box that you press to select a entire column in datasheet
Show an example of field selector Address
Show an example of a "fiel value" for the filed identified above 1255 Dogwood Road
Define "primary key" and give an example a unique identifier for each record in a table. Example: Student Number
Design grid The top half of the Table window
Field Propertie Pane The bottom half of the table window
How do you "run" a query? By opening a query object
Simple Query Wizard An easy way to create a query. It asks you what data you want to see by leeting you select options in dialog boxes.
One to many relationship One record in the first table can match many records in the second table
Primary table The "one" side of two related tabloes in a one-to-many relationship. Example: you have one mother and she has many children. in this case, the "mother" is primary.
Related Table The table containing "many" records.
Referential Integrity A set of rules to ensure that there are matching values in the common field used to form the relationship
Database management system (DBMS) Allows you to store, retrieve, analyze and print information.
Database A collection of objects.
Navigation pane opens on the left side of the screen.
Record Is a comoplete set of data.
Fields the first name of each menber is placed in the field that stores first names.
Filed name To identify the field
Field value The data entered into a field.
Datasheet view The table displays its data in rows and columns in a datasheet.
Field selector appears at the top of each column in a table and contains the field name.
Record selector appears to the left of the first field of each record
Datasheet selector The box in the upper-left corner of a datasheet.
Compacting Database rearranges how the database is stored on the disk and optimizes the perfomance of the database.
Template Create a database
Created by: Yavo