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