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;
40 Cards in this Set
- Front
- Back
|
There are only two methods to start Microsoft Office Excel 2010.
|
False
|
|
|
The basic Microsoft Office Excel 2010 window includes seven Ribbon tabs that maybe selected to view various command groupings.
|
False
|
|
|
A ribbon may be accessed by clicking once on the ribbon tab
|
True
|
|
|
To identify a cell, specify the row number first, followed by the column letter.
|
False
|
|
|
The Save option on the Quick Access Toolbar may not be used the first time that you save a workbook
|
False
|
|
|
The Currency style button is located on the Home Ribbon.
|
False
|
|
|
Values are defined as numbers that will be used in math.
|
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 Insert Ribbon.
|
False
|
|
|
You can create custom headers by going to the View Tab.
|
False
|
|
|
Hiding worksheet data will delete the data.
|
False
|
|
|
By default all areas of the worksheet will print.
|
True
|
|
|
Once a page break is inserted, it cannot be removed
|
False
|
|
|
Print titles are an excellent way to include titles or column headings on all pages that are printed.
|
True
|
|
|
Footers will be printed immediately below the last line of data on the worksheet.
|
False
|
|
|
Column headers are identified by numbers.
|
False
|
|
|
.Row headers are identified by numbers.
|
True
|
|
|
Formatted numbers are replaced by $$$$$ if the cell is too small for the data to fit.
|
False
|
|
|
New rows are inserted above the selected row
|
True
|
|
|
AutoRecover under the Home tab helps to restore a workbook if Excel closes due to an error
|
False
|
|
|
_____ are a collection of worksheets.
|
Workbooks
|
|
|
_____ is the intersection of a column and row.
|
cell
|
|
|
In order access the information on a ribbon, the user must use the _________.
|
Ribbon Tab
|
|
|
Information on each ribbon is organized a collection called a _____.
|
Group
|
|
|
In Excel 2010, numbers are automatically _____ aligned.
|
Right
|
|
|
The increase and decrease indent commands are located on the _____ ribbon.
|
Formulas
|
|
|
The _____ command will join selected cells and center the contents.
|
Merge and Center
|
|
|
The _____ command allows for only formatting to be copied from one cell to another.
|
Format Painter
|
|
|
By default, there are _____ date formats that may be applied to a cell.
|
5
|
|
|
_____ enhances the readability of a worksheet.
|
Formatting
|
|
|
The quickest methods to hide a column or row in a worksheet it to select the column or row and choose hide from _____.
|
Shortcut menu
|
|
|
The _____ is the space between the page content and the edges of the paper.
|
Margin
|
|
|
The _____ command allows information to repeat on each printed page.
|
print area
|
|
|
Page breaks may be manually inserted using the breaks command on the _____ ribbon.
|
Page Layout
|
|
|
An entire worksheet may be hidden by choosing hide on the _____.
|
Print Layout Ribbon
|
|
|
Which of the following would best be created in Excel 2010
|
Creating a household budget
|
|
|
What is the maximum number of characters for a file name?
|
255
|
|
|
A benefit of using a template would be
|
To use a different setup for documents with a specific purpose
|
|
|
Which of the following content would be considered a label?
|
Social Security Number
|
|
|
John is working with a large spreadsheet file and only needs certain parts of the spreadsheet at different times. What would you recommend him doing in order to only view the columns he needs?
|
Hide the columns he does not need at the current time
|
