Reading...
Play button
Play button
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;
25 Cards in this Set
- Front
- Back
|
When a formula contains references that adjust to the new location, it is referred to as what type of reference?
|
Relative cell reference
|
|
|
What method is used in conjunction with the mouse to change the height of a column in Microsoft Excel 2010?
|
Click and drag the boundary
|
|
|
Where is the command to create a new folder in the user's storage device for Microsoft Excel 2010 files located?
|
File tab, open button
|
|
|
The area of the Microsoft Excel that contains the view and zoom buttons is known as
the: |
status bar.
|
|
|
Which Microsoft Excel 2010 feature automatically inserts data into a cell that begins
with the same characters as a previous entry? |
AutoComplete
|
|
|
Which feature automatically corrects common typographical errors?
|
AutoSpell
|
|
|
What is the black square that appears in the bottom right corner of the cell border to
create a series in multiple cells? |
fill handle.
|
|
|
What key will allow the user to select non-adjacent cells?
|
CTRL key
|
|
|
How do you copy formatting to different locations in the worksheet?
|
Format copier
|
|
|
The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the: |
header.
|
|
|
What is the data printed on the bottom of each worksheet page?
|
footer.
|
|
|
Which method is used to select non-adjacent worksheet tabs?
|
Click a tab, hold down CTRL key and click next tab(s)
|
|
|
What are a predefined set of attributes such as font, font size, and shading?
|
Style
|
|
|
Numerical data is automatically right aligned in a cell and there is no way to
change this. |
false
|
|
|
Formatting a worksheet could possibly change the data on the sheet.
|
false
|
|
|
By default all areas of the worksheet will print.
|
false
|
|
|
Freezing areas in a worksheet is only used to enhance the readability of the worksheet
data. |
true
|
|
|
A file name can have up to 250 characters.
|
false
|
|
|
Characters that can be used in naming a workbook are the following: / \ < > ? *
|
false
|
|
|
Footers are lines that print at the top of each page.
|
false
|
|
|
To change the margins use the Home Tab.
|
false
|
|
|
By default, there are _____ date formats that may be applied to a cell.
|
17
|
|
|
The quickest method to hide a column or row in a worksheet it to select the column or
row and choose hide from _____. |
Shortcut menu
|
|
|
Page breaks may be manually inserted using the breaks command on the _____ ribbon.
|
Home
|
|
|
When the insert worksheet command is selected, where is the new sheet inserted?
|
To the left of all sheets
|
