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
|