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;
8 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? A. Absolute cell reference B. Mixed cell reference C. Partial cell reference D. Relative cell reference |
D. Relative cell reference
|
|
|
What method is used in conjunction with the mouse to change the height of a column in
Microsoft Excel 2010? A. Double-click the column header B. Triple-click the column header C. Click and drag the boundary line between rows D. Click and drag the boundary |
D. Click and drag the boundary
|
|
|
The command on the Page Layout ribbon that refers to data printed on the top of each
worksheet page is the: A. Header. B. Top data. C. Border. D. Print first. |
A. Header.
|
|
|
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. |
A. status bar.
|
|
|
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 |
C. Right-click a sheet tab, choose Select All from the shortcut menu
|
|
|
When a formula is copied from one cell to another, what allows the cell address to
adjust the column letter and row number to the new copy location? A. Absolute cell reference B. Mixed cell reference C. Partial cell reference D. Relative cell reference |
D. Relative cell reference
|
|
|
How do you copy formatting to different locations in the worksheet?
A. Copy format B. Format copier C. Paint formats D. Format painter |
B. Format copier
|
|
|
What are a predefined set of attributes such as font, font size, and shading?
A. Design B. Style C. Format D. Template |
B. Style
|
