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 ________.
- ANS.... -a data point
A defined set of formatting characteristics such as font, font size, and font
color are known as a ________. - ANS.... -cell style
A text value in Excel is also referred to as a ________. - ANS.... -label
All formulas begin with an ________. - ANS.... -=
Comma Style format displays a number with ________. - ANS.... -two
decimal places
Hold down the ________ key to select nonadjacent cells. - ANS.... -Ctrl
In Excel 2016, row headings are identified by ________. - ANS.... -
numbers
The Percent Style button formats selected cells as a percentage with
________. - ANS.... -zero decimal places
The ________ displays the current cell mode, the page number, and the
,zoom buttons. - ANS.... -status bar
The default number format for cells is the ________ number format. -
ANS.... -General
The keyboard shortcut to display Print Preview is ________. - ANS.... -Ctrl
+ F2
The value axis is also known as the ________. - ANS.... -y-axis
Tiny charts embedded in a cell that display a visual trend summary
alongside your data are called ________. - ANS.... -Sparklines
To display the document properties, click the ________ tab. - ANS.... -File
Using a touchscreen, which of the following actions is the same as right
clicking the mouse? - ANS.... -Press and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a
chart is selected? - ANS.... -Format and Design
When a cell is part of an active formula, it is surrounded with ________. -
ANS.... -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. - ANS.... -vertical dotted
line between columns
, When using a touchscreen, which of the following actions is the same as
clicking an item? - ANS.... -Tap the item
When you type data in a cell and press Enter, what cell becomes the active
cell? - ANS.... -The cell below
When you type text in a cell it is ________. - ANS.... -left-aligned
Where is the fill handle located? - ANS.... -In the lower right corner of a
selected cell
Which of the following does not display to the right side of a selected chart?
- ANS.... -Move Chart button
Which of the following is FALSE about a workbook? - ANS.... -It can
contain only one worksheet.
Which of the following is NOT a way to create a formula? - ANS.... -By
using a Function button on the status bar
Which of the following is NOT one of the default calculations displayed by
Auto Calculate? - ANS.... -Maximum
Which of the following is NOT part of the Accounting Number Format? -
ANS.... -Three decimal places
Which of the following is the default number format in Excel 2016? - ANS....
-General format, Calibri, 11 pt
ANSWERS | 2026 UPDATE | WITH COMPLETE
SOLUTIONS.
A chart value that originates in a worksheet cell is referred to as ________.
- ANS.... -a data point
A defined set of formatting characteristics such as font, font size, and font
color are known as a ________. - ANS.... -cell style
A text value in Excel is also referred to as a ________. - ANS.... -label
All formulas begin with an ________. - ANS.... -=
Comma Style format displays a number with ________. - ANS.... -two
decimal places
Hold down the ________ key to select nonadjacent cells. - ANS.... -Ctrl
In Excel 2016, row headings are identified by ________. - ANS.... -
numbers
The Percent Style button formats selected cells as a percentage with
________. - ANS.... -zero decimal places
The ________ displays the current cell mode, the page number, and the
,zoom buttons. - ANS.... -status bar
The default number format for cells is the ________ number format. -
ANS.... -General
The keyboard shortcut to display Print Preview is ________. - ANS.... -Ctrl
+ F2
The value axis is also known as the ________. - ANS.... -y-axis
Tiny charts embedded in a cell that display a visual trend summary
alongside your data are called ________. - ANS.... -Sparklines
To display the document properties, click the ________ tab. - ANS.... -File
Using a touchscreen, which of the following actions is the same as right
clicking the mouse? - ANS.... -Press and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a
chart is selected? - ANS.... -Format and Design
When a cell is part of an active formula, it is surrounded with ________. -
ANS.... -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. - ANS.... -vertical dotted
line between columns
, When using a touchscreen, which of the following actions is the same as
clicking an item? - ANS.... -Tap the item
When you type data in a cell and press Enter, what cell becomes the active
cell? - ANS.... -The cell below
When you type text in a cell it is ________. - ANS.... -left-aligned
Where is the fill handle located? - ANS.... -In the lower right corner of a
selected cell
Which of the following does not display to the right side of a selected chart?
- ANS.... -Move Chart button
Which of the following is FALSE about a workbook? - ANS.... -It can
contain only one worksheet.
Which of the following is NOT a way to create a formula? - ANS.... -By
using a Function button on the status bar
Which of the following is NOT one of the default calculations displayed by
Auto Calculate? - ANS.... -Maximum
Which of the following is NOT part of the Accounting Number Format? -
ANS.... -Three decimal places
Which of the following is the default number format in Excel 2016? - ANS....
-General format, Calibri, 11 pt
