CIS *** Midterm
The Merge & Center button is located in the ________ tab.
Alignment group on the Home
In a worksheet, to move right one screen you would use the keyboard shortcut ________.
Alt + Page down
The file extension for Microsoft Excel 2019 workbooks is ________.
.xlsx
Formulas and functions begin with a(n) ________ sign.
=
An example of a range of cells is ________.
A1:A3
In a worksheet, the keyboard shortcut to move one column to the left is ________.
Shift + Tab
By default, _____ data is left-aligned in a cell.
Text
If you enter a date or time that is not recognized, Excel treats the information as ________ and left-aligns it in the cell.
Text
Which of the following data types is NOT automatically right-aligned by Excel?
Text
A comment is added to an individual cell.
True
A destination cell is the location cell to be modified by a move or paste operation.
True
By default, numeric data is right-aligned in a cell.
True
Data formatted as a date takes the form of a serial number, with the number 1 representing January 1, 1900.
True
Gray worksheet tabs identify inactive worksheets.
True
In Excel, date and time data are special forms of numeric data.
True
In Microsoft Excel 2019, workbooks have a file extension of .xlsx.
True
Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse.
True
One of the most efficient ways of moving data from one cell to another is to drag and drop.
True
Page Break Preview allows you to manually adjust the location of page breaks.
True
The Ctrl + S shortcut quickly saves your file to the same location as the last save.
True
The active worksheet has a white tab with bold letters and a thick bottom border.
True
When collecting data in a spreadsheet, each row contains a record.
True
When using a what-if analysis, you change values in spreadsheet cells to see the effects on calculated values of interest.
True
White space refers to blank areas of a worksheet that do not contain data or documentation, regardless of the actual color.
True
The worksheet that is visible in the Excel application window is the _____ worksheet
active
The intersection of a row and column is called a ________.
cell
The intersection of each row and column is called a(n)
cell
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
When using _______ orientation, the horizontal dimension of the paper is longer.
landscape
A(n) _____ cell range consists of multiple selected cells with at least one cell not directly adjacent to other cells.
noncontiguous
______ is a file type that preserves most formatting attributes of a source document regardless of the software in which the document was created.(1 point)
When using _______ orientation, the vertical dimension of the paper is longer.
portrait
To select noncontiguous rows, click the header of the first row, ________ the header of each additional row.
press and hold Ctrl, 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 the mouse.
Ctrl
In a worksheet, the keyboard shortcut to move to cell A1 is ________.
Ctrl + Home
The keyboard shortcut for Undo is ________.
Ctrl + Z
Which of the following is NOT an example of worksheet documentation?
Descriptive drop-down documentation menus
If you mistakenly delete a worksheet, you can recover it by pressing Undo.
False
Merge & Center can only be applied to horizontal cell ranges.
False
The AutoFill property adjusts the height of a row so that its cell contents fit in the row.
False
The dollar sign ($) and comma (,) are stored as part of a numeric cell value.
False
To move up one screen, you use the Ctrl + PgUp keyboard shortcut.
False
When using a touch screen, the Excel 2019 commands on the ribbon and in shortcut menus are in a different order to accommodate the use of a fingertip.
False
________ worksheet tabs identify inactive worksheets.
Gray
Which of the following is NOT a type of data that can be contained in a cell?
Recordings
In a worksheet, a comment is indicated by the presence of a ________ in the upper-right corner of a cell.
Red triangles
An example of a cell _____ is K12
reference
A(n) _____ is a horizontal set of cells that encompasses all the columns in a worksheet.
row
Worksheets can be oriented to print on paper in one of ________ ways.
two
A file that contains one or more worksheets is a(n)
workbook
A ________ is a grid of columns and rows in which data is entered.
worksheet
When using Excel, a spreadsheet is also referred to as a(n)
worksheet
When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right.
CTRL + pg down
Headers and footers contain ________ section(s).
three
Which of the following is typically NOT contained in a separate documentation worksheet?
Charts
A red triangle in the upper-right corner of a cell indicates the existence of a(n)
Comment
A cell reference is a combination of a row number followed by a column letter such as 12C.
False
A comment is a temporary storage location where information that was cut or copied is stored until you paste, move, or clear the information.
False
A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells.
False
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
A noncontiguous cell range consists of multiple cells where all cells are directly adjacent to each other.
False
A worksheet is a file containing at least one workbook.
False
Adobe System's PDF reader application CANNOT be used to edit a document that was saved with the pdf extension.
False
By default, text data is center-aligned in a cell.
False
The default print range in Excel is ________.
Print Active Sheets
A(n) _____ cell range consists of cells directly adjacent to one another.
contiguous
_____ data is formatted as a serial number.
date
You can rename a worksheet by ________ its tab and then typing the new name.
double-clicking
A ________ application is a computer program with a user interface comprised of a grid of rows and columns.
spreadsheet