• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle 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

image

PLAY BUTTON

image

PLAY BUTTON

image

Progress

1/24

Click to flip

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