NVCC ITE 140 Exam 1 | 100% Correct
Answers | Verified | Latest 2024 Version
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? - ✔✔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. - ✔✔Rounding
________ is the keyboard shortcut for the Spelling command. - ✔✔F7
The symbols <,>,<> can be described as _________. - ✔✔Comparison operators
How do banded rows display? - ✔✔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? -
✔✔Row numbers display in blue
If a sheet tab has ________ you know that it is not selected. - ✔✔a background color
In a large worksheet, which two Excel commands help to make the
worksheets attractive and easier to read? - ✔✔Print Titles and Scale to Fit
Answers | Verified | Latest 2024 Version
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? - ✔✔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. - ✔✔Rounding
________ is the keyboard shortcut for the Spelling command. - ✔✔F7
The symbols <,>,<> can be described as _________. - ✔✔Comparison operators
How do banded rows display? - ✔✔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? -
✔✔Row numbers display in blue
If a sheet tab has ________ you know that it is not selected. - ✔✔a background color
In a large worksheet, which two Excel commands help to make the
worksheets attractive and easier to read? - ✔✔Print Titles and Scale to Fit
