NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.
A chart value that originates in a worksheet cell is referred to as ________. - (answer)a data point
A defined set of formatting characteristics such as font, font size, and font color are known as a
________. - (answer)cell style
A text value in Excel is also referred to as a ________. - (answer)label
All formulas begin with an ________. - (answer)=
Comma Style format displays a number with ________. - (answer)two decimal places
Hold down the ________ key to select nonadjacent cells. - (answer)Ctrl
In Excel 2016, row headings are identified by ________. - (answer)numbers
The Percent Style button formats selected cells as a percentage with
________. - (answer)zero decimal places
The ________ displays the current cell mode, the page number, and the
zoom buttons. - (answer)status bar
The default number format for cells is the ________ number format. - (answer)General
The keyboard shortcut to display Print Preview is ________. - (answer)Ctrl + F2
The value axis is also known as the ________. - (answer)y-axis
,NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called
________. - (answer)Sparklines
To display the document properties, click the ________ tab. - (answer)File
Using a touchscreen, which of the following actions is the same as right clicking the mouse? -
(answer)Press and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a chart is selected? -
(answer)Format and Design
When a cell is part of an active formula, it is surrounded with ________. - (answer)a colored border with
small boxes on each side
When preparing a document for printing, a ________ indicates that only the columns to the left will be
printed on the first page. - (answer)vertical dotted line between columns
When using a touchscreen, which of the following actions is the same as clicking an item? - (answer)Tap
the item
When you type data in a cell and press Enter, what cell becomes the active cell? - (answer)The cell
below
When you type text in a cell it is ________. - (answer)left-aligned
Where is the fill handle located? - (answer)In the lower right corner of a selected cell
Which of the following does not display to the right side of a selected chart? - (answer)Move Chart
button
, NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.
Which of the following is FALSE about a workbook? - (answer)It can contain only one worksheet.
Which of the following is NOT a way to create a formula? - (answer)By using a Function button on the
status bar
Which of the following is NOT one of the default calculations displayed by Auto Calculate? -
(answer)Maximum
Which of the following is NOT part of the Accounting Number Format? - (answer)Three decimal places
Which of the following is the default number format in Excel 2016? - (answer)General format, Calibri, 11
pt
________ is a procedure that determines which digit to the right of a number will be the last to be
displayed. - (answer)Rounding
________ is the keyboard shortcut for the Spelling command. - (answer)F7
The symbols <,>,<> can be described as _________. - (answer)Comparison operators
How do banded rows display? - (answer)Even rows are formatted differently from odd rows
How do you know if some rows of a table have been hidden from view when a filter is invoked? -
(answer)Row numbers display in blue
If a sheet tab has ________ you know that it is not selected. - (answer)a background color
WITH COMPLETE SOLUTIONS.
A chart value that originates in a worksheet cell is referred to as ________. - (answer)a data point
A defined set of formatting characteristics such as font, font size, and font color are known as a
________. - (answer)cell style
A text value in Excel is also referred to as a ________. - (answer)label
All formulas begin with an ________. - (answer)=
Comma Style format displays a number with ________. - (answer)two decimal places
Hold down the ________ key to select nonadjacent cells. - (answer)Ctrl
In Excel 2016, row headings are identified by ________. - (answer)numbers
The Percent Style button formats selected cells as a percentage with
________. - (answer)zero decimal places
The ________ displays the current cell mode, the page number, and the
zoom buttons. - (answer)status bar
The default number format for cells is the ________ number format. - (answer)General
The keyboard shortcut to display Print Preview is ________. - (answer)Ctrl + F2
The value axis is also known as the ________. - (answer)y-axis
,NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called
________. - (answer)Sparklines
To display the document properties, click the ________ tab. - (answer)File
Using a touchscreen, which of the following actions is the same as right clicking the mouse? -
(answer)Press and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a chart is selected? -
(answer)Format and Design
When a cell is part of an active formula, it is surrounded with ________. - (answer)a colored border with
small boxes on each side
When preparing a document for printing, a ________ indicates that only the columns to the left will be
printed on the first page. - (answer)vertical dotted line between columns
When using a touchscreen, which of the following actions is the same as clicking an item? - (answer)Tap
the item
When you type data in a cell and press Enter, what cell becomes the active cell? - (answer)The cell
below
When you type text in a cell it is ________. - (answer)left-aligned
Where is the fill handle located? - (answer)In the lower right corner of a selected cell
Which of the following does not display to the right side of a selected chart? - (answer)Move Chart
button
, NVCC ITE 140 EXAM 1 | QUESTIONS AND ANSWERS | 2026 UPDATE |
WITH COMPLETE SOLUTIONS.
Which of the following is FALSE about a workbook? - (answer)It can contain only one worksheet.
Which of the following is NOT a way to create a formula? - (answer)By using a Function button on the
status bar
Which of the following is NOT one of the default calculations displayed by Auto Calculate? -
(answer)Maximum
Which of the following is NOT part of the Accounting Number Format? - (answer)Three decimal places
Which of the following is the default number format in Excel 2016? - (answer)General format, Calibri, 11
pt
________ is a procedure that determines which digit to the right of a number will be the last to be
displayed. - (answer)Rounding
________ is the keyboard shortcut for the Spelling command. - (answer)F7
The symbols <,>,<> can be described as _________. - (answer)Comparison operators
How do banded rows display? - (answer)Even rows are formatted differently from odd rows
How do you know if some rows of a table have been hidden from view when a filter is invoked? -
(answer)Row numbers display in blue
If a sheet tab has ________ you know that it is not selected. - (answer)a background color
