Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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
Popular Business sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards