INFS TEST 2
1) A ________ application is a computer program has a user interface comprised of a
grid of rows and columns.
A) database
B) spreadsheet
C) matrix
D) tabular - Correct Answers -Spreadsheet
2) The intersection of a row and column is called a ________.
A) cell
B) container
C) chamber
D) cubicle - Correct Answers -Cell`
3) Formulas and functions begin with a(n) ________ sign.
A) =
B) #
C) @
D) & - Correct Answers -=
4) Which of the following is NOT contained in a cell?
A) Functions
B) Formulas
C) Subroutines
D) Text - Correct Answers -Subroutines
5) The extension for Microsoft Excel 2013 workbooks is ________.
A) .xlx
B) .xls
C) .xlxs
D) .xlsx - Correct Answers -.xlsx
6) When there are multiple worksheets, you can use the keyboard shortcut Ctrl +
________ to move one worksheet to right.
A) Page Down
B) Page Up
C) Home
,D) End - Correct Answers -Page down
7) The keyboard shortcut to move one column to the left is ________.
A) Tab
B) Shift + Tab
C) Ctrl + Tab
D) Alt + Tab - Correct Answers -Shift + Tab
8) The keyboard shortcut to move to cell A1 is ________.
A) Home
B) Shift + Home
C) Ctrl + Home
D) Alt + Home - Correct Answers -Ctrl + Home
9) To move right one screen, you would use the keyboard shortcut ________.
A) Page Down
B) Shift + Page Down
C) Ctrl + Page Down
D) Alt + Page Down - Correct Answers -Alt + Page down
11) A comment is indicated by the presence of a ________ in the upper-right corner of
a cell.
A) red square
B) blue square
C) red triangle
D) blue triangle - Correct Answers -red square
12) To insert a comment into a cell, you click New Comment in the:
A) Comments group on the REVIEW tab.
B) Comments group on the INSERT tab.
C) Documentation group on the REVIEW tab.
D) Documentation group on the INSERT tab. - Correct Answers -Comments group on
the REVIEW tab
13) Which of the following is typically NOT contained in a separate documentation
worksheet?
A) Author
B) Modification dates
C) Charts
D) Modification history - Correct Answers -
14) The base date for date and time data in Excel 2013 is ________.
A) January 1, 1000
B) January 1, 1900
C) December 31, 999
D) December 31, 1899 - Correct Answers -January 1, 1000
,15) Which of the following data types is NOT automatically right-aligned by Excel?
A) Text
B) Numeric
C) Date
D) Time - Correct Answers -Text
16) The keyboard shortcut for Undo is ________.
A) Ctrl + U
B) Ctrl + Z
C) Ctrl + Y
D) Ctrl + W - Correct Answers -Ctrl + Z
17) To insert a line break or hard return in a cell, you would press ________.
A) Enter
B) Ctrl + Enter
C) Alt + Enter
D) Shift + Enter - Correct Answers -Ctrl + Enter
18) Which of the following is NOT a cell range?
A) A single cell
B) Noncontiguous cells
C) A table
D) Contiguous cells - Correct Answers -A single cell
19) 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.
A) Alt
B) Ctrl
C) F5
D) F7 - Correct Answers -Ctrl
) An example of a range of cells is ________.
A) A1&A3
B) A1+A3
C) A1-A3
D) A1:A3 - Correct Answers -A1:A3
21) After selecting a row, pressing the shortcut key ________ will insert a new row
above the selected row.
A) Ctrl + I
B) Ctrl + +
C) Ctrl + #
D) Ctrl + R - Correct Answers -Ctrl ++
, 22) The Merge & Center button is located in the
A) Alignment group on the HOME tab.
B) Styles group on the HOME tab.
C) Alignment group on the PAGE LAYOUT tab.
D) Styles group on the LAYOUT tab. - Correct Answers -Alighnment group on the home
tab
23) To select several contiguous columns, you:
A) click the header of the first column, then double-click the header of the last column.
B) click the header of the first column, then right-click the header of the last column.
C) click the header of the first column, press and hold Shift, and click the header of the
last column.
D) click the header of the first column, press and hold Ctrl, and click the header of the
last column. - Correct Answers -click the header of the first column, press and hold shift,
and click the header of the last column
24) To select noncontiguous rows, you:
A) click the header of the first row, then double-click the header of each additional row.
B) click the header of the first row, then right-click the header of each additional row.
C) click the header of the first row, press and hold Shift, and click the header of each
additional row.
D) click the header of the first row, press and hold Ctrl, and click the header of each
additional row. - Correct Answers -click the header of the first row, press and hold Ctrl,
and click the header of each additional row
25) In Excel, the height of the rows is measured in ________.
A) points
B) picas
C) pixels
D) ppm - Correct Answers -pixels
26) To change the width of a column, you click Column Width in the:
A) Cells group on the FORMAT tab.
B) Adjustment group on the FORMAT tab.
C) Cells group on the HOME tab.
D) Adjustment group on the HOME tab. - Correct Answers -cells group on the HOME
tab
27) To AutoFit the width of a column, you click Format and then click AutoFit Column
Width in the:
A) Cells group on the VIEW tab.
B) Format group on the VIEW tab.
C) Cells group on the HOME tab.
D) Format group on the HOME tab. - Correct Answers -Cells group on the HOME tab
1) A ________ application is a computer program has a user interface comprised of a
grid of rows and columns.
A) database
B) spreadsheet
C) matrix
D) tabular - Correct Answers -Spreadsheet
2) The intersection of a row and column is called a ________.
A) cell
B) container
C) chamber
D) cubicle - Correct Answers -Cell`
3) Formulas and functions begin with a(n) ________ sign.
A) =
B) #
C) @
D) & - Correct Answers -=
4) Which of the following is NOT contained in a cell?
A) Functions
B) Formulas
C) Subroutines
D) Text - Correct Answers -Subroutines
5) The extension for Microsoft Excel 2013 workbooks is ________.
A) .xlx
B) .xls
C) .xlxs
D) .xlsx - Correct Answers -.xlsx
6) When there are multiple worksheets, you can use the keyboard shortcut Ctrl +
________ to move one worksheet to right.
A) Page Down
B) Page Up
C) Home
,D) End - Correct Answers -Page down
7) The keyboard shortcut to move one column to the left is ________.
A) Tab
B) Shift + Tab
C) Ctrl + Tab
D) Alt + Tab - Correct Answers -Shift + Tab
8) The keyboard shortcut to move to cell A1 is ________.
A) Home
B) Shift + Home
C) Ctrl + Home
D) Alt + Home - Correct Answers -Ctrl + Home
9) To move right one screen, you would use the keyboard shortcut ________.
A) Page Down
B) Shift + Page Down
C) Ctrl + Page Down
D) Alt + Page Down - Correct Answers -Alt + Page down
11) A comment is indicated by the presence of a ________ in the upper-right corner of
a cell.
A) red square
B) blue square
C) red triangle
D) blue triangle - Correct Answers -red square
12) To insert a comment into a cell, you click New Comment in the:
A) Comments group on the REVIEW tab.
B) Comments group on the INSERT tab.
C) Documentation group on the REVIEW tab.
D) Documentation group on the INSERT tab. - Correct Answers -Comments group on
the REVIEW tab
13) Which of the following is typically NOT contained in a separate documentation
worksheet?
A) Author
B) Modification dates
C) Charts
D) Modification history - Correct Answers -
14) The base date for date and time data in Excel 2013 is ________.
A) January 1, 1000
B) January 1, 1900
C) December 31, 999
D) December 31, 1899 - Correct Answers -January 1, 1000
,15) Which of the following data types is NOT automatically right-aligned by Excel?
A) Text
B) Numeric
C) Date
D) Time - Correct Answers -Text
16) The keyboard shortcut for Undo is ________.
A) Ctrl + U
B) Ctrl + Z
C) Ctrl + Y
D) Ctrl + W - Correct Answers -Ctrl + Z
17) To insert a line break or hard return in a cell, you would press ________.
A) Enter
B) Ctrl + Enter
C) Alt + Enter
D) Shift + Enter - Correct Answers -Ctrl + Enter
18) Which of the following is NOT a cell range?
A) A single cell
B) Noncontiguous cells
C) A table
D) Contiguous cells - Correct Answers -A single cell
19) 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.
A) Alt
B) Ctrl
C) F5
D) F7 - Correct Answers -Ctrl
) An example of a range of cells is ________.
A) A1&A3
B) A1+A3
C) A1-A3
D) A1:A3 - Correct Answers -A1:A3
21) After selecting a row, pressing the shortcut key ________ will insert a new row
above the selected row.
A) Ctrl + I
B) Ctrl + +
C) Ctrl + #
D) Ctrl + R - Correct Answers -Ctrl ++
, 22) The Merge & Center button is located in the
A) Alignment group on the HOME tab.
B) Styles group on the HOME tab.
C) Alignment group on the PAGE LAYOUT tab.
D) Styles group on the LAYOUT tab. - Correct Answers -Alighnment group on the home
tab
23) To select several contiguous columns, you:
A) click the header of the first column, then double-click the header of the last column.
B) click the header of the first column, then right-click the header of the last column.
C) click the header of the first column, press and hold Shift, and click the header of the
last column.
D) click the header of the first column, press and hold Ctrl, and click the header of the
last column. - Correct Answers -click the header of the first column, press and hold shift,
and click the header of the last column
24) To select noncontiguous rows, you:
A) click the header of the first row, then double-click the header of each additional row.
B) click the header of the first row, then right-click the header of each additional row.
C) click the header of the first row, press and hold Shift, and click the header of each
additional row.
D) click the header of the first row, press and hold Ctrl, and click the header of each
additional row. - Correct Answers -click the header of the first row, press and hold Ctrl,
and click the header of each additional row
25) In Excel, the height of the rows is measured in ________.
A) points
B) picas
C) pixels
D) ppm - Correct Answers -pixels
26) To change the width of a column, you click Column Width in the:
A) Cells group on the FORMAT tab.
B) Adjustment group on the FORMAT tab.
C) Cells group on the HOME tab.
D) Adjustment group on the HOME tab. - Correct Answers -cells group on the HOME
tab
27) To AutoFit the width of a column, you click Format and then click AutoFit Column
Width in the:
A) Cells group on the VIEW tab.
B) Format group on the VIEW tab.
C) Cells group on the HOME tab.
D) Format group on the HOME tab. - Correct Answers -Cells group on the HOME tab
