NVCC ITE 140 Exam 1 Questions &
Answers 2024/2025
A chart value that originates in a worksheet cell is referred to as ________. - ANSWERSa data point
A defined set of formatting characteristics such as font, font size, and font color are known as a
________. - ANSWERScell style
A text value in Excel is also referred to as a ________. - ANSWERSlabel
All formulas begin with an ________. - ANSWERS=
Comma Style format displays a number with ________. - ANSWERStwo decimal places
Hold down the ________ key to select nonadjacent cells. - ANSWERSCtrl
In Excel 2016, row headings are identified by ________. - ANSWERSnumbers
The Percent Style button formats selected cells as a percentage with
________. - ANSWERSzero decimal places
The ________ displays the current cell mode, the page number, and the
zoom buttons. - ANSWERSstatus bar
The default number format for cells is the ________ number format. - ANSWERSGeneral
The keyboard shortcut to display Print Preview is ________. - ANSWERSCtrl + F2
,The value axis is also known as the ________. - ANSWERSy-axis
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called
________. - ANSWERSSparklines
To display the document properties, click the ________ tab. - ANSWERSFile
Using a touchscreen, which of the following actions is the same as right clicking the mouse? -
ANSWERSPress and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a chart is selected? -
ANSWERSFormat and Design
When a cell is part of an active formula, it is surrounded with ________. - ANSWERSa 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. - ANSWERSvertical dotted line between columns
When using a touchscreen, which of the following actions is the same as clicking an item? - ANSWERSTap
the item
When you type data in a cell and press Enter, what cell becomes the active cell? - ANSWERSThe cell
below
When you type text in a cell it is ________. - ANSWERSleft-aligned
Where is the fill handle located? - ANSWERSIn the lower right corner of a selected cell
Which of the following does not display to the right side of a selected chart? - ANSWERSMove Chart
button
, Which of the following is FALSE about a workbook? - ANSWERSIt can contain only one worksheet.
Which of the following is NOT a way to create a formula? - ANSWERSBy using a Function button on the
status bar
Which of the following is NOT one of the default calculations displayed by Auto Calculate? -
ANSWERSMaximum
Which of the following is NOT part of the Accounting Number Format? - ANSWERSThree decimal places
Which of the following is the default number format in Excel 2016? - ANSWERSGeneral format, Calibri,
11 pt
________ is a procedure that determines which digit to the right of a number will be the last to be
displayed. - ANSWERSRounding
________ is the keyboard shortcut for the Spelling command. - ANSWERSF7
The symbols <,>,<> can be described as _________. - ANSWERSComparison operators
How do banded rows display? - ANSWERSEven 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? -
ANSWERSRow numbers display in blue
If a sheet tab has ________ you know that it is not selected. - ANSWERSa background color
In a large worksheet, which two Excel commands help to make the
worksheets attractive and easier to read? - ANSWERSPrint Titles and Scale to Fit
Answers 2024/2025
A chart value that originates in a worksheet cell is referred to as ________. - ANSWERSa data point
A defined set of formatting characteristics such as font, font size, and font color are known as a
________. - ANSWERScell style
A text value in Excel is also referred to as a ________. - ANSWERSlabel
All formulas begin with an ________. - ANSWERS=
Comma Style format displays a number with ________. - ANSWERStwo decimal places
Hold down the ________ key to select nonadjacent cells. - ANSWERSCtrl
In Excel 2016, row headings are identified by ________. - ANSWERSnumbers
The Percent Style button formats selected cells as a percentage with
________. - ANSWERSzero decimal places
The ________ displays the current cell mode, the page number, and the
zoom buttons. - ANSWERSstatus bar
The default number format for cells is the ________ number format. - ANSWERSGeneral
The keyboard shortcut to display Print Preview is ________. - ANSWERSCtrl + F2
,The value axis is also known as the ________. - ANSWERSy-axis
Tiny charts embedded in a cell that display a visual trend summary alongside your data are called
________. - ANSWERSSparklines
To display the document properties, click the ________ tab. - ANSWERSFile
Using a touchscreen, which of the following actions is the same as right clicking the mouse? -
ANSWERSPress and hold for a few seconds
What are the two contextual tabs that display under Chart Tools when a chart is selected? -
ANSWERSFormat and Design
When a cell is part of an active formula, it is surrounded with ________. - ANSWERSa 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. - ANSWERSvertical dotted line between columns
When using a touchscreen, which of the following actions is the same as clicking an item? - ANSWERSTap
the item
When you type data in a cell and press Enter, what cell becomes the active cell? - ANSWERSThe cell
below
When you type text in a cell it is ________. - ANSWERSleft-aligned
Where is the fill handle located? - ANSWERSIn the lower right corner of a selected cell
Which of the following does not display to the right side of a selected chart? - ANSWERSMove Chart
button
, Which of the following is FALSE about a workbook? - ANSWERSIt can contain only one worksheet.
Which of the following is NOT a way to create a formula? - ANSWERSBy using a Function button on the
status bar
Which of the following is NOT one of the default calculations displayed by Auto Calculate? -
ANSWERSMaximum
Which of the following is NOT part of the Accounting Number Format? - ANSWERSThree decimal places
Which of the following is the default number format in Excel 2016? - ANSWERSGeneral format, Calibri,
11 pt
________ is a procedure that determines which digit to the right of a number will be the last to be
displayed. - ANSWERSRounding
________ is the keyboard shortcut for the Spelling command. - ANSWERSF7
The symbols <,>,<> can be described as _________. - ANSWERSComparison operators
How do banded rows display? - ANSWERSEven 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? -
ANSWERSRow numbers display in blue
If a sheet tab has ________ you know that it is not selected. - ANSWERSa background color
In a large worksheet, which two Excel commands help to make the
worksheets attractive and easier to read? - ANSWERSPrint Titles and Scale to Fit
