MIS1305
The Merge & Center button is located in the _ tab
Alignment group on the Home
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 + PgDn
If a numerical value is too narrow to be displayed in a cell, a series of _ characters is displayed
#
Normal margins for Excel are _ inch on the left and right sides of the page
.7
The file extensian for Microsoft Excel 2016 is
.xlsx
Formulas and functions begin with a(n) _ sign
=
An example of a range of cells is
A1:A3
The keyboard shortcut to move one column to the left is
Shift + Tab
___ is not a type of data that can be contain in a cell
Subroutines
If you enter a date or time that is not recognized, Excel treats the informations as _ and left-aligns it in the cell
Text
_ data types in NOT automatically right-aligned by Excel
Text
When collecting data in a spreadsheet, each row contains a record
True
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 _ tab.
cells group on the Home
You can copy a worksheet within a workbook, by _, and then dragging a copy of the worksheet to its new location
clicking the worksheet tab, pressing and holding Ctrl
If you click _, the insertion point is displayed in the formula bar
in the formula bar
To select noncontiguous rows, click the header of the first row, _ the header of each additional row
press and hold Ctrl, and click
To select several contiguous columns, click the header of the first column, _ the header to the last column
press and hold Shift, and click
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 mouse
Ctrl
After selecting a row, pressing the shortcut key _ will insert a new row above the selected row
Ctrl + +
The keyboard shortcut to move to cell A1 is
Ctrl + Home
The keyboard shortcut for undo is
Ctrl + Z
_ worksheet tabs identify inactive worksheet
gray
A comment is indicated by the presence of a _ in the upper-right corner of a cell
red square
The active worksheet has a white tab with bold letters and a a think bottom border
true
When using a what-if analysis, you change values in spreadsheet cells to see the effects on calculated values of interest
true
worksheets can be oriented to print on paper in one of _ ways
two
A _ is a grid of columns and rows in which data is entered
worksheet
To change the width of a column, you click Column Width in the _ tab
Cells group on the Home tab
_is typically not contained in a separate documentation worksheet
Charts
A formula is a built-in program that would be used to find the average of a series of numbers
False
A function is an equation that produces a result and may contain numbers, operators, text, and/or functions
False
The base date for date and time data in Excel 2016
January 1, 1900
When there are multiple worksheets, you can use the keyboard shortcut Ctrl + _ to move one worksheet to the right
PgDn
In Excel, the height of the rows is measured in
Points
The file extension PDF stands for
Portable Document Format
The default print range in Excel is
Print Active Sheets
To insert a comment into a cell, you click New Comment in the: _ tab
comments group on the Review
_ is NOT an example of worksheet documentation
description drop-down documentation menus
You can rename a worksheet by _ its tab and then typing the new name
double-clicking
A worksheet is a file containing at least one workbook
false
A _ application is a computer program has a user interface comprised of a grid of rows and columns
spreadsheet
Headers and footers contain _ sections(s)
three
