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