• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/22

Click to flip

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;

22 Cards in this Set

  • Front
  • Back
The quickest method to hide a column or a row in a worksheet is to select the column or row and choose hide from..
Shortcut Menu
The _____ command allows information to repeat on each printed page.
Print areas
Which button will update the PivotTable and Pivot Chart information?
refresh
Which of the following is not a component of data series?
Series Label
______ is an area that labels the data used in a chart.
Legend
If the year 35 is entered into a worksheet, Excel automatically changes it to the four-digit year of ___
1935
The IF function is considered a finacial function.
False.
Which symbol is displayed throughout a cell when there is not enough width to accomodate the entry?
#
Which button on the Home ribbon will allow additonal decimal spaces to be displayed?
Increase decimal.
Which of the following is not an appropriate worksheet tab name?
Employee and Staff Information Sheet
Worksheet names may not exceed 31 characters.
true
Which of the following is NOT a freeze panes option?
Freeze current area.
Once a new sheet is inserted into a workbook, it must remain in the location that it was inserted.
False.
_______ temporarily hides records that do not meet a specific criterion.
Filtering data
When the insert worksheet command is selected, where is the new sheet inserted?
To the right of all sheets.
Dates are considered text data so they are automatically left aligned in the cell.
False.
By default, there are ____ date formats that may be applied to a cell.
17
_______ enhances the readability of a worksheet.
Formatting
The increase and decrease indent commands are located on the _______ ribbon.
Home
In Excel 2010, numbers are automatically _____ aligned.
right
The basic Microsoft Office Excel 2010 window includes seven ribbon tabs that may be selected to view various command groupings.
False.
To identify a cell, specify the row number first, followed by the column letter.
False