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;
14 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
|
|
|
Which number format button does NOT appear in the Format group on the Home
ribbon? |
(((A.))) 102 (scientific)
B. $ (currency) C. % (percent) D. , (comma) |
|
|
Where are user created styles able to be used
|
In all of Microsoft Excel 2010
|
|
|
Which window displays information about an active cell and allows formulas to be
edited? |
***A. **status bar.
B. title bar. C. formula bar. D. name box |
|
|
What is the process for selecting all information in a worksheet
|
A. Click Select All button in the upper left corner of the worksheet or use the keyboard
combination of CTRL + A. B. Click Select All button in the upper right corner of the worksheet or use the keyboard combination of ALT + A. ((*C.*)*)* Right-click a sheet tab, choose Select All from the shortcut menu D. Right-click a sheet tab, choose ALT+A |
|
|
What is the black square that appears in the bottom right corner of the cell border to
create a series in multiple cells? |
A. drag box.
B. copy box. C. drag handle. (((((****D. )))fill handle. |
|
|
How do you copy formatting to different locations in the worksheet?
|
B. Format copier
|
|
|
What controls the landscape or portrait print function?
|
B. Orientation
|
|
|
What determines what part of a worksheet prints?
|
C. Print area
|
|
|
The feature allows the user to organize data numerically is:
|
B. sort & filter.
|
|
|
Which method is used to select non-adjacent worksheet tabs
|
A. Double-click the tabs that need to be selected
B. Click first tab, hold down ALT key and click next tab C. Right-click first sheet tab and single click remaining sheet tabs (((D. )))Click a tab, hold down CTRL key and click next tab(s) |
|
|
Which term refers to a group of selected cells
|
A. Segment
B. Set (((C. )))Range D. Cluster |
|
|
Which is an advantage of using Styles to apply formatting to a workbook?
|
((A.))) Styles ensure consistent formatting from one workbook to the next
B. Styles have nicer formatting C. Styles are required by Microsoft Excel 2010 D. Styles prevent users from making changes to the formatting |
