excel 1-1
The base date for date and time data in Excel 2013 is ________.
December 31, 1899
Which of the following is NOT a cell range?
a table
The Merge & Center button is located in the
alignment group on the home tab
To insert a line break or hard return in a cell, you would press ________.
alt + enter
To move right one screen, you would use the keyboard shortcut ________.
alt + page down
The intersection of a row and column is called a ________.
cell
To AutoFit the width of a column, you click Format and then click AutoFit Column Width in the:
cells group on the home tab
To change the width of a column, you click Column Width in the:
cells group on the home tab
Which of the following is typically NOT contained in a separate documentation worksheet?
charts
To select several contiguous columns, you:
click the header of the first column, press and hold shift, and click the header of the last column
To select noncontiguous rows, you:
click the header of the first row, press and hold ctrl, and click the header of each additional row
You can copy a worksheet within a workbook, by ________, and then dragging a copy of the worksheet to its new location.
clicking on the worksheet tab, pressing and holding ctrl
To insert a comment into a cell, you click New Comment in the:
comments group on the review tab
You can select a noncontiguous range of cells by pressing and holding the ________ key when using it in combination with other navigation keys and/or the mouse.
ctrl
After selecting a row, pressing the shortcut key ________ will insert a new row above the selected row.
ctrl + +
The keyboard shortcut for inserting today's date is ________.
ctrl + ;
The keyboard shortcut to move to cell A1 is ________.
ctrl + home
If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is displayed.
ctrl + s
The keyboard shortcut for Undo is ________.
ctrl + z
Which of the following is NOT an example of worksheet documentation?
descriptive drop down documentation menus
You can rename a worksheet by ________ its tab and then typing the new name.
double clicking
When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.
page down
To print headings on multiple pages, you click Print Titles in the:
page set up group on the page layout tab
In Excel, the height of the rows is measured in ________.
points
The file extension PDF stands for ________.
portable document format
A comment is indicated by the presence of a ________ in the upper-right corner of a cell.
red triangle
The keyboard shortcut to move one column to the left is ________.
shift + tab
A ________ application is a computer program has a user interface comprised of a grid of rows and columns.
spreadsheet
Which of the follow is NOT a worksheet view?
spreadsheet preview
Which of the following is NOT contained in a cell?
subroutines
Which of the following data types is NOT automatically right-aligned by Excel?
text
Headers and footers contain ________ section(s).
three
The extension for Microsoft Excel 2013 workbooks is ________.
.xlsx
Formulas and functions begin with a(n) ________ sign.
=
An example of a range of cells is ________.
A1:A3