- Shuffle
Toggle OnToggle Off
- Alphabetize
Toggle OnToggle Off
- Front First
Toggle OnToggle Off
- Both Sides
Toggle OnToggle Off
Front
How to study your flashcards.
Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key
Up/Down arrow keys: Flip the card between the front and back.down keyup key
H key: Show hint (3rd side).h key
![]()
PLAY BUTTON
![]()
PLAY BUTTON
![]()
24 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
|
|
Which command in the Print tab backstage view must be selected to print all sheets in a
workbook? |
Print entire workbook
|
|
Where are user created styles able to be used?
|
In all of Microsoft Excel 2010
|
|
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
|
|
Which window displays information about an active cell and allows formulas to be
edited? |
status bar.
|
|
What is the process for selecting all information in a worksheet?
|
Right-click a sheet tab, choose Select All from the shortcut menu
|
|
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
|
|
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? |
Relative cell reference
|
|
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 feature allows the user to organize data numerically is:
|
sort & filter.
|
|
There are only two methods to start Microsoft Office Excel 2010.
|
False
|
|
To identify a cell, specify the column letter first, followed by the row number.
|
True
|
|
The Currency style button is located on the Home Ribbon.
|
True
|
|
Formatting a worksheet could possibly change the data on the sheet.
|
False
|
|
When formatting data, most of the formatting commands are located on the
Home Ribbon. |
True
|
|
By default all areas of the worksheet will print.
|
False
|
|
A file name can have up to 250 characters.
|
False
|
|
Characters that can be used in naming a workbook are the following: / \ < > ? *
|
False
|
|
Labels are right aligned.
|
False
|
|
Values are right aligned.
|
True
|
|
To change the margins use the Home Tab.
|
False
|
|
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
|