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