Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
50 Cards in this Set
- Front
- Back
If the active cell is A1, the cell address A1 displays in the:
|
name box
|
|
By default, excel spreadsheets have 3
|
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
|
|
Excel spreadsheets display rows and columns which are made up of individual:
|
cells
|
|
________ Row Height adjusts the height of selected rows to fit the contents in the cells.
|
auto fit
|
|
To ensure that the reference to a specific cell does not change, use ________ cell referencing.
|
absolute
|
|
To change a 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 list 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 possible to set a ________ on a protected sheet to allow 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 put 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 ________.
|
3 columns, five rows
|
|
When you enter data into a table that you've created, the text:
|
automatically wraps in the cell.
|
|
When you press the Tab key from the last cell in a table, what happens?
|
a 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 ñ and é found in the Spanish language can be entered by selecting the:
|
insert tab, and 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
|