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
