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
The intersection of a row and column is called a ________. (1 point)
a.chamber
b.cubicle
c.container
d.cell
cell
A ________ is a grid of columns and rows in which data is entered. (1 point)
a.database
b.worksheet
c.presentation
d.document
worksheet
Formulas and functions begin with a(n) ________ sign. (1 point)
a.#
b.=
c.&
d.@
=
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
The file extension for Microsoft Excel 2016 workbooks is ________. (1 point)
a..xlx
b..xlls
c..xlsx
d..xls
.xlsx
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 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
The keyboard shortcut to move to cell A1 is ________. (1 point)
a.Shift + Home
b.Alt + Home
c.Home
d.Ctrl + Home
Ctrl + 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
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
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
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
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
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
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
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
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 keyboard shortcut for Undo is ________. (1 point)
a.Ctrl + Z
b.Ctrl + Y
c.Ctrl + W
d.Ctrl + U
Ctrl + Z
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
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
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 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
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
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 + +
27)
In
Excel, the height of the rows is measured in ________. (1 point)
a.ppm
b.picas
c.pixels
d.points
points
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.
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
)
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.#
#
________ worksheet tabs identify inactive worksheets. (1 point)
a.Gray
b.Blue
c.Green
d.White
gray
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
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
Headers and footers contain ________ section(s). (1 point)
a.two
b.three
c.one
d.four
three
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
Worksheets can be oriented to print on paper in one of ________ ways. (1 point)
a. three
b.four
c. five
d.two
two
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
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
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
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
When collecting data in a spreadsheet, each row contains a record. (1 point)
True
False
true
A worksheet is a file containing at least one
workbook. (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
44) The active worksheet has a white tab with bold letters and a thick bottom border. (1 point)
True
False
true
in Microsoft Excel 2016, workbooks have a file extension of .xlsx. (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
A cell reference is a combination of a row number followed by a column
letter such as 12C. (1 point)
True
False
false
48) Keyboard shortcuts allow rapid navigation in a worksheet without having to use the mouse. (1 point)
True
False
true
To move up one screen, you use the Ctrl + PgUp keyboard shortcut. (1 point)
True
False
false
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
51)
A comment is added to an individual cell. (1 point)
True
False
True
The dollar sign ($) and comma
(,) are stored as part of a numeric cell value. (1 point)
True
False
false
53) In Excel, date and time data are special forms of numeric data. (1 point)
True
False
true
By default, numeric data is right-aligned in a cell. (1 point)
True
False
true
By default, text data is center-aligned in a cell. (1 point)
True
False
false
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
A noncontiguous cell range consists of multiple cells where all cells
are directly adjacent to each other. (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 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 destination cell is the location cell to be modified by a move or paste operation. (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
62) Merge & Center can only be applied to horizontal cell ranges. (1 point)
True
False
false
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
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
Page Break Preview allows you to manually adjust the location of page breaks. (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
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)
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
A(n) is a horizontal set of cells that encompasses all the columns in a worksheet.
row
allows you to examine the outcome of the changes to values in a worksheet. (1 point)
Correct Answer: what-if analysis
When using Excel, a spreadsheet is also referred to as a(n)
Correct Answer: worksheet
The worksheet that is visible in the Excel application window is the
Correct Answer: active
worksheet.
A file that contains one or more worksheets is a(n)
Correct Answer: workbook
The cell that receives an action, such as a click, calculation, or paste is the cell.
active
A(n) example of a cell
Correct Answer: reference
is K12.
In , the ribbon and shortcut menus are enlarged to make selecting commands with your fingertip easier.
touch mode
A red triangle in the upper-right corner of a cell indicates the existence of a(n)
comment
data contains numbers and special characters such as the period (.) and hyphen (-). (1 point)\
Correct Answer: Numeric
data is formatted as a serial number.
Correct Answer: Date
By default, data is left-aligned in a cell.
text
Time data is represented as a(n)
Correct Answer: decimal
value.
A(n) cell range consists of cells directly adjacent to one another.
Correct Answer: contiguous
The cells on a worksheet that have been selected are a cell
Correct Answer: range
combines selected cells into a single cell and then centers the text within that single cell.
merge and center
Blank areas of a worksheet that do not contain data or documentation are called
white space
is a smart copy that will try to guess how you want values or formulas changed as you copy.
autofill
When using orientation, the horizontal dimension of the paper is longer
landscape
When using orientation, the vertical dimension of the paper is longer.
portait
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
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
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
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
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
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
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