CIS *** Midterm

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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)

pdf

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


Kaugnay na mga set ng pag-aaral

Art Hist 101: Test 4 (19th C. (Realism, Impressionism, Post Impressionism, Art Nouveau, 19th Century Architecture))

View Set

The role of banks and fractional reserves: 14.3 and 14.4

View Set

pathophysiology pain and sensory

View Set

Enphase Solar PV Installation Certification Training

View Set