bsan 101 Excel Chapter 1: Testbank Quiz

The Merge & Center button is located in the ________ tab. (1 point) a.Styles group on the Home b.Styles group on the Layout c.Alignment group on the Layout d.Alignment group on the Home

Alignment group on the Home

To move right one screen, you would use the keyboard shortcut ________. (1 point) a.Alt + PgDn b.Ctrl + PgDn c.PgDn d.Shift + PgDn

Alt + PgDn

) If a numerical value is too narrow to be displayed in a cell, a series of ________ characters is displayed. (1 point) a.% b.@ c.& d.#

#

The file extension for Microsoft Excel 2016 workbooks is ________. (1 point) a..xlx b..xlls c..xlsx d..xls

.xlsx

Normal margins for Excel are ________ inch on the left and right sides of the page. (1 point) a.0.3 b.0.75 c.0.5 d.0.7

0.7

Formulas and functions begin with a(n) ________ sign. (1 point) a.# b.= c.& d.@

=

An example of a range of cells is ________. (1 point) a.A1:A3 b.A1+A3 c.A1-A3 d.A1&A3

A1:A3

The keyboard shortcut to move one column to the left is ________. (1 point) a.Ctrl + Tab b.Ctrl + Home c.Tab d.Shift + Tab

Shift + Tab

Which of the following is NOT a type of data that can be contained in a cell? (1 point) a.Text b.Formulas c.Subroutines d.Functions

Subroutines

51) A comment is added to an individual cell. (1 point) True False

True

The cell that receives an action, such as a click, calculation, or paste is the cell.

active

Match the following terms with their definition. (5 points) Active worksheet An Excel file that contains one or Workbook Eliminates the need to use a mouse Active cell An Excel file that contains one or more worksheets Cell reference An Excel file that contains one or more worksheets Keyboard shortcut Has a white background with bold letters and a thick bottom border

active worksheet -Has a white background with bold letters and a thick bottom border Workbook- An Excel file that contains one or more worksheets active cell worksheet- Identified by the thick green border cell reference worksheet- A reference within a formula or function instead of a value key board shortcut- Eliminates the need to use a mouse

To insert a line break or hard return in a cell, you would press ________. (1 point) a.Shift + Enter b.Alt + Enter c.Ctrl + Enter d.Enter

alt +enter

is a smart copy that will try to guess how you want values or formulas changed as you copy.

autofill

The intersection of a row and column is called a ________. (1 point) a.chamber b.cubicle c.container d.cell

cell

Which of the following is typically NOT contained in a separate documentation worksheet? (1 point) a.Modification History b.Modification dates c.Charts d.Author

charts

If you click ________, the insertion point is displayed in the formula bar. (1 point) a. worksheet tab b.the Home tab c.in the formula bar d.in a cell

in the formula bar

The base date for date and time data in Excel 2016 is ________. (1 point) a.January 1, 1000 b.December 31, 1899 c.January 1, 1900 d.December 31, 999

janurary 1, 1900

When using orientation, the horizontal dimension of the paper is longer

landscape

combines selected cells into a single cell and then centers the text within that single cell.

merge and center

27) In Excel, the height of the rows is measured in ________. (1 point) a.ppm b.picas c.pixels d.points

points

When using orientation, the vertical dimension of the paper is longer.

portait

To select noncontiguous rows, click the header of the first row, ________ the header of each additional row. (1 point) a. press and hold Ctrl, and click b. then right-click c. press and hold Shift, and click d. then double-click

press and hold Ctrl, and click

To select several contiguous columns, click the header of the first column, ________ the header of the last column. (1 point) a.press and hold Shift, and click b.then right-click c.press and hold Ctrl, and click d.then double-click

press and hold shift, and click

data is formatted as a serial number.

Correct Answer: Date

data contains numbers and special characters such as the period (.) and hyphen (-). (1 point)\

Correct Answer: Numeric

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)

Correct Answer: PDF and Portable Document Format

Which of the following data types is NOT automatically right-aligned by Excel? (1 point) a.Date b.Text c.Numeric d.Time

Correct Answer: Text

The worksheet that is visible in the Excel application window is the

Correct Answer: active worksheet.

69) The intersection of each row and column is called a(n)

Correct Answer: cell

When collecting data in a spreadsheet, each is a field in a record.

Correct Answer: column

A(n) cell range consists of cells directly adjacent to one another.

Correct Answer: contiguous

Time data is represented as a(n)

Correct Answer: decimal value.

A(n) is an equation that produces results such as numbers or text.

Correct Answer: formula

A(n) is a built-in program that performs a task such as finding the sum of a series of numbers.

Correct Answer: function

The cells on a worksheet that have been selected are a cell

Correct Answer: range

A(n) example of a cell

Correct Answer: reference is K12.

allows you to examine the outcome of the changes to values in a worksheet. (1 point)

Correct Answer: what-if analysis

A file that contains one or more worksheets is a(n)

Correct Answer: workbook

When using Excel, a spreadsheet is also referred to as a(n)

Correct Answer: worksheet

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. (1 point) a.Ctrl b.Alt c.F7 d.F5

Ctrl

After selecting a row, pressing the shortcut key ________ will insert a new row above the selected row. (1 point) a.Ctrl + R b.Ctrl + + c.Ctrl + I d.Ctrl + #

Ctrl + +

The keyboard shortcut to move to cell A1 is ________. (1 point) a.Shift + Home b.Alt + Home c.Home d.Ctrl + Home

Ctrl + Home

The keyboard shortcut for Undo is ________. (1 point) a.Ctrl + Z b.Ctrl + Y c.Ctrl + W d.Ctrl + U

Ctrl + Z

Which of the following is NOT an example of worksheet documentation? (1 point) a.Descriptive worksheet names b.Descriptive cell labels c.Descriptive column titles d.Descriptive drop-down documentation menus

Descriptive drop-down documentation menus

________ worksheet tabs identify inactive worksheets. (1 point) a.Gray b.Blue c.Green d.White

gray

Match the following terms with their definition. (5 points) Record A two-dimensional grid that can be used to model quantitative data Row Allows you to examine the outcome of the changes to values in a worksheet Spreadsheet A horizontal set of cells that encompasses all the columns in a worksheet What-if analysis All of the categories of data that are formatted as a row in a worksheet Worksheet All of the categories of data that are formatted as a row in a worksheet

record- All of the categories of data that are formatted as a row in a worksheet row- A horizontal set of cells that encompasses all the columns in a worksheet spreadsheet- A two-dimensional grid that can be used to model quantitative data what-if analysis -Allows you to examine the outcome of the changes to values in a worksheet worksheet - Each instance of a spreadsheet

A comment is indicated by the presence of a ________ in the upper-right corner of a cell. (1 point) a.red triangle b.red square c.green triangle

red square

A(n) is a horizontal set of cells that encompasses all the columns in a worksheet.

row

Headers and footers contain ________ section(s). (1 point) a.two b.three c.one d.four

three

In , the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.

touch mode

44) The active worksheet has a white tab with bold letters and a thick bottom border. (1 point) True False

true

46) The Ctrl + S shortcut quickly saves your file to the same location as the last save. (1 point) True False

true

48) Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse. (1 point) True False

true

53) In Excel, date and time data are special forms of numeric data. (1 point) True False

true

56) Data formatted as a date takes the form of a serial number, with the number 1 representing January 1, 1900. (1 point) True False

true

63) White space refers to blank areas of a worksheet that do not contain data or documentation, regardless of the actual color. True False

true

64) Gray worksheet tabs identify inactive worksheets. (1 point) True False

true

A destination cell is the location cell to be modified by a move or paste operation. (1 point) True False

true

Adobe System's PDF reader application CANNOT be used to edit a document that was saved with the pdf extension. (1 point) True False

true

By default, numeric data is right-aligned in a cell. (1 point) True False

true

One of the most efficient ways of moving data from one cell to another is to drag and drop. (1 point) True False

true

Page Break Preview allows you to manually adjust the location of page breaks. (1 point) True False

true

When collecting data in a spreadsheet, each row contains a record. (1 point) True False

true

When using a what-if analysis, you change values in spreadsheet cells to see the effects on calculated values of interest. (1 point) True False

true

in Microsoft Excel 2016, workbooks have a file extension of .xlsx. (1 point) True False

true

Worksheets can be oriented to print on paper in one of ________ ways. (1 point) a. three b.four c. five d.two

two

Blank areas of a worksheet that do not contain data or documentation are called

white space

A ________ is a grid of columns and rows in which data is entered. (1 point) a.database b.worksheet c.presentation d.document

worksheet

Match the following terms with their definition. (5 points) Cell range The cell that receives the result of an operation Clipboard The cells in the worksheet that have been selected Contiguous cell range A range consisting of multiple selected cells, at least one of which is not directly adjacent to at least one other Destination cell A temporary storage location Noncontiguous cell range A range consisting of multiple selected cells, all of which are directly adjacent to at least one other

Cell range :The cells in the worksheet that have been selected Clipboard : A temporary storage location Contiguous cell range: A range consisting of multiple selected cells, all of which are directly adjacent to at least one other Destination cell : The cell that receives the result of an operation Noncontiguous cell range :A range consisting of multiple selected cells, at least one of which is not directly adjacent to at least one other

To AutoFit the width of a column, you click Format and then click AutoFit Column Width in the ________ tab. (1 point) a.Format group on the Home b.Cells group on the View c.Cells group on the Home d.Format group on the View

Cells group on the Home

To change the width of a column, you click Column Width in the ________ tab. (1 point) a. Cells group on the Home tab. b.Adjustment group on the Home tab. c.Cells group on the Format tab. d.Adjustment group on the Format tab.

Cells group on the Home tab.

Match the following terms with their definition. (5 points) Cell Performs a mathematical calculation Column A vertical set of cells that encompasses all the rows in a worksheet Field An item of information in a worksheet column that is associated with something of interest Formula Performs a mathematical calculation Function The intersection of a row and a column in a table or worksheet

Column A vertical set of cells that encompasses all the rows in a worksheet Field An item of information in a worksheet column that is associated with something of interest Formula Performs a mathematical calculation cell The intersection of a row and a column in a table or worksheet

To insert a comment into a cell, you click New Comment in the:________ tab. (1 point) a.Documentation group on the Insert b.Comments group on the Review c.Documentation group on the Review d.Comments group on the Insert

Comments group on the Review

Match the following terms with their definition. (5 points) Normal view -Layout of how the workbook will print on paper Page Break Preview- Does not show page margins, headers, or footers Print Preview -Layout of how the workbook will print on paper Page Layout view - Layout of how the workbook will print on paper Orientation The Backstage View of a workbook

Normal view : Only the cells in the worksheet are visible Page Break Preview: Does not show page margins, headers, or footers Print Preview:The Backstage View of a workbook Page Layout view:Shows page margins, print headers and footers, and page breaks Orientation: Layout of how the workbook will print on paper

7) When there are multiple worksheets, you can use the keyboard shortcut Ctrl + ________ to move one worksheet to right. (1 point) a.Home b.PgDn c.PgUp d.End

PgDn

The file extension PDF stands for ________. (1 point) a. Portable Data Format b.Portable Data File c.Portable Document File d.Portable Document Format

Portable Document Format

The default print range in Excel is ________. (1 point) a.Print Active Print Areas b.Print Selection c.Print Entire Workbook d.Print Active Sheets

Print Active Sheets

You can copy a worksheet within a workbook, by ________, and then dragging a copy of the worksheet to its new location. (1 point) a.double-clicking the worksheet tab b.clicking the worksheet tab, pressing and holding Shift c.clicking the worksheet tab, pressing and holding Ctrl d.right-clicking the worksheet tab

clicking the worksheet tab, pressing and holding Ctrl

A red triangle in the upper-right corner of a cell indicates the existence of a(n)

comment

Match the following terms with their definition. (5 points) Comment Represented as a decimal value Date data Takes the form of a serial number Numeric data Data that contains only the digits 0-9 and possibly a period (.) Text data Represented as a decimal value Time data A text box, similar to a sticky note, that is attached to a cell

comment A text box, similar to a sticky note, that is attached to a cell Date data Takes the form of a serial number Numeric data Data that contains only the digits 0-9 and possibly a period (.) text data-Can contain any combination of printable characters time data Represented as a decimal value

You can rename a worksheet by ________ its tab and then typing the new name. (1 point) a.right-clicking b.double-clicking c.pressing Ctrl and clicking d.clicking

double-clicking

50) When using a touch screen, the Excel 2016 commands on the ribbon and in shortcut menus are rearranged to accommodate the use of a fingertip. (1 point) True False

false

62) Merge & Center can only be applied to horizontal cell ranges. (1 point) True False

false

65) If you mistakenly delete a worksheet, you can recover it by pressing Undo. (1 point) True False

false

66) The AutoFill property adjusts the height of a row so that its cell contents fit in the row. (1 point) True False

false

A cell reference is a combination of a row number followed by a column letter such as 12C. (1 point) True False

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. (1 point) True False

false

A contiguous cell range consists of multiple cells where at least one cell is not directly adjacent to other cells. (1 point) True False

false

A formula is a built-in program that would be used to find the average of a series of numbers. (1 point) True False

false

A function is an equation that produces a result and may contain numbers, operators, text, and/or functions. (1 point) True False

false

A noncontiguous cell range consists of multiple cells where all cells are directly adjacent to each other. (1 point) True False

false

A worksheet is a file containing at least one workbook. (1 point) True False

false

By default, text data is center-aligned in a cell. (1 point) True False

false

The dollar sign ($) and comma (,) are stored as part of a numeric cell value. (1 point) True False

false

To move up one screen, you use the Ctrl + PgUp keyboard shortcut. (1 point) True False

false

A ________ application is a computer program has a user interface comprised of a grid of rows and columns. (1 point) a.spreadsheet b.database c.matrix d.tabular

spreadsheet

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. (1 point) a.Numeric b.Date c.Text d.Time

text