click below
click below
Normal Size Small Size show me how
MAA 135 SG
Computer applications for the medical office
Question | Answer |
---|---|
What does a green wavy line below text indicate? | capitalize |
Print Layout can be helpful for creating what? | columns of text |
AutoComplete suggest what? | text to insert |
Save As is used for what? | create new file from old one |
Dictionaries, Encyclopedias and Translations are resources for which task pane? | research |
What doew Format Painter do? | copies multiple settings to other texts |
What command do you use to make all rows in a table the same height? | distribute rows |
The style type List allows you to do what? | format series of lines, bullets |
Pressing TAB allows you to do what? | move to next cell in row |
What does the organizer dialog box do? | Copy styles from an existing doc to a new doc |
How do you add a gutter to a document? | Page setup, Margins to Gutter - adjust setting |
What determines how labels and values of a cell will appear? | The format of a cell |
What is an argument in excel? | The information in a function necessary to calculate an answer. |
What is operator for exponent in Excel? | ^ (caret) |
What is a spreadsheet? | An application used to perform numeric calculations and analyze/present numeric data. |
What does the developer tab do? | Has the buttons to create and/or modify a form |
What must be done before you can protect a document that includes a form? | turn off design mode |
If you use a function alone, what will always be the prefix? | = (equal sign) |
What are sheet tabs for? | To identify sheets in a workbook and to allow switching between sheets. |
What is an example of a delimiter? | comma |
What does Excel use to separate arguments? | a comma |
Line and Scatter charts do what? | illustrate trends over time |
What are the rows called in a Table? | records |
What is Banding? | different formatting for adjacent rows and columns |
What does the Excel filter feature do? | displays data in an Excel table that meet specific criteria |
What is office clipboard? | temporary storage for cut and copied items ready to be pasted |
What is Function? | a special predefined formula that provides a shortcut for commonly used calculations |
What is Absolute cell reference? | cell address that doesn't change when formula is copied |
What is Relative cell reference? | cell address automatically changes when formula is copied or moved |
What is a Template? | A pre-formatted doc or worksheet upon which you can fill in or replace text with your own info |
What is a Data bar? | conditional formatting differences among values |
What is Column width? | default 8.43 characters or about 3/4 of an inch |
What is a font? | a complete set of characters with the same typeface or design |
What is a point? | 1/72 of an inch |
What is a Theme? | Predefined color, fonts, etc. used to give spreadsheets a professional look. |
What can database functions do? | count, average, total |
What is the extension on an Excel workbook? | .xlsx |
Can you edit a document in print preview? | No. |
Can you temporarily freeze columns and rows in Excel? | Yes. |
Tabs can: | Move from higher to lower level. |
How do you add a cover page? | Insert |
How do you insert a page break? | Control Enter. |
How do you add colors, patterns, highlights & borders to cells? | Format cells |
To freeze colomns A,B & C where would you position the pointer? | Row D |
Where would you find print options for gridlines, etc? | Page Layout |
When a table is created in Excel, Excel creates what? | A List arrow by each column header. |
The wild card in excel is what? | The asterisk, * |
In Excel when addition/subtraction generates a subtotal it is in this form. | Outine. |
Including twwo decimals automatically adds $ signs. | False |
typing underscores for filenames necessary? | False |
Tables are made of_______ which are made of fields. | Records |