click below
click below
Normal Size Small Size show me how
computer apps cards
Study guide cards.
Question | Answer |
---|---|
Columns | Appear vertically and are identified by letters at the top of the worksheet window. |
Rows | 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. |
Wildcard(find/replace) | *(asterisk) |
Default magnification | 100% |
Print tab | Enables you 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 try to 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 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 selected column headings. |
How are numbers displayed in a cell? | Right aligned. |
Merge and 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 bottom 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 exponentation. | A1^3 |
Order of evaluation | The sequence used to calculate the value of a 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 formulas 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 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 slides per page. |
What is the PowerPoint file extension? | .pptx |
Placeholders | Placeholders are boxes with dotted borders that contain content and reside whithin 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 color, to have the same header or footer, or to carry a particular logo. |
How do you insert a table into a PP slide using the Content slide layout? | Click the 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 contained in the column. |
How are fields rearranged in Datasheet view? | By clicking and dragging them to a new location. |
What is the purpose of Print Preview? | To check the print settings prior to printing. |
Field selector | A small bar or box that you press to select an entire column in datasheet. |
Show an example of a field name. | Address |
Show an example of a "field value" for the field 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 Properties 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 letting 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 tables 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 containg "many" records. |
Referential integrity | A set of rules to ensure that there are matching values in the common field used to form the relationship. |