COMP EXAM 2
Terms
undefined, object
copy deck
- If the active cell is A1, the cell address A1 displays in the __________.
- name box
- Excel spreadsheets display rows and columns which are made up of individual _.
- cells
- By default, a new excel workbook has three
- worksheets
- All _____ in excel begin with an equal sign.
- formulas.
- Which of the following formulas is referring cells in a correct format?
- =A6 + Z35
- When new rows are added to an existing worksheet, cell references in formulas __________.
- automatically adjust
- THe _____ command uses the fill handle to copy the data in a range of cells.
- AutoFill
- If the active cell is B1 and you insert a new row, where will it be inserted?
- Above B1
- The _________ command is used to center text within one cell so that it displays appropriately across the content of a worksheet.
- Merge and Center
- To modify the appearance of a range of cells, utilize commands on the _______ dialog box.
- Format Cells
- _____ Row Height adjusts the height of selected rows to fit the contents in the cells.
- AutoFit
- To ensure that the reference to a specific cell does now change, use ____cell referencing.
- absolute
- TO change the relative cell reference to an absolute cell reference, use the _____ key.
- F4
- If you double click a cell with a formula, Excel _______ the formula for easy editing.
- highlights
- To easily select predefined functions in excel, select the _______.
- Function Wizard
- To determine the highest score on a test from among lists of student scores, use the ____ function.
- MAX
- TO determine the middle number in a range of cells, use the _______ function.
- MEDIAN
- A(n) _______ is tested in an IF function to determine if it is true or false.
- condition
- To use text as a condition in an IF function, it must be enclosed in:
- quotation marks
- The ______ number is the number of the column in the lookup table that contains the return values.
- column index
- Parameters in an IF function can be ____ a value, a formula, or a nested function.
- text
- There are ______ main steps to creating a chart.
- 6
- A chart can be placed on a new worksheet or
- embedded
- An embedded chart is a(n) _____ that can be copied, deleted, or resized.
- object
- The _________ group contains options to change a chart layout.
- Quick Layout
- To be able to move a chart, it must be selected and pointer must appear as a:
- 4 headed arrow
- TO change a chart type after it has been created, choose the Change Chart type option in the ____ tab of the Chart tools.
- design
- To preview an excel worksheet saved as a web page, open the page in a(n):
- web browser
- Once a chart has been created, it cannot be enhanced.
- false!
- If there are certain columns of information that you do not want to be viewed by others, ______ the columns.
- hide
- It is posible to set a _____ on a protected sheet to allows users with authority to edit data.
- password
- A page break is represented by a _____ line.
- blue-dashed
- Options for modifying the appearance of table data are in the ____ drop down list.
- format
- To organize the records in your table by last name, use the
- sort
- Sorting records puts them in order by _____.
- values.
- the options to arrange data in ascending or descending order are found in the _____ group.
- Sort and Filter
- A 3x5 table represents _____ and ______.
- three columns and five rows
- When you press the Tab key from the last cell in a table, what happens?
- A new blank row is added.
- When you insert a new row into a table _______.
- You can specify if you want it inserted above or below the current row.
- Use the ____ command on the layout tab to join two or more cells together.
- merge cells.
- To change an image to a percentage of its initial size, use the _______.
- scale feature
- Characters such as the n and e found in the Spanish language can be entered by selecting the ______.
- Insert tab, then symbols.
- Comments that you write are contained inside:
- markup balloons
- Where do comments appear in a document?
- In the right margin
- Comments display in markup balloons in all of the following views EXCEPT:
- draft
- What feature monitors all additions, deletions, and formatting changes in a document.
- track changes
- To accept all changes in a document at one time, click the ____ arrow on the ____ tab.
- accept all, review
- All of the following except _____ are track changes options.
- original
- If you have several copies of the same document with different reviewer comments, use the ______ feature to view the differences.
- Compare
-
macro
-
constant