ITE 140 EXAM QUESTIONS WITH
100% CORRECT ANSWERS
The value axis is also known as the _________.
1) Category axis
2) Y-axis
3) X-axis
4) Legend -- Correct Answer ✔✔ y - axis
Tiny charts embedded in a cell that display a visual trend summary
alongside your data are called ________. -- Correct Answer ✔✔
Sparklines
The default number format for cells is the ________ number format. --
Correct Answer ✔✔ General
A defined set of formatting characteristics such as font, font size, and
font color are known as a ________. -- Correct Answer ✔✔ Cell Style
When using a touchscreen, which of the following actions is the same
as clicking an item? -- Correct Answer ✔✔ Tap the item
,A text value in Excel is also referred to as a ________. -- Correct Answer
✔✔ Label
Using a touchscreen, which of the following actions is the same as
right-clicking the mouse? -- Correct Answer ✔✔ Press and hold for few
seconds
Which of the following does not display to the right side of a selected
chart? -- Correct Answer ✔✔ Move chart button
________ is used to display the contents of a cell on multiple lines. --
Correct Answer ✔✔ Wrap text command
Which of the following is not a way to create a formula? -- Correct
Answer ✔✔ By using a function button on the status bar
Pixels are measured in ________ per square inch. -- Correct Answer ✔✔
Dots
The ________ visually displays which cells are included in a formula
calculation. -- Correct Answer ✔✔ Range Finder
What are the two contextual tabs that display under Chart Tools when
a chart is selected? -- Correct Answer ✔✔ Design and Format
A cell address is also referred to as a(n) ________. -- Correct Answer ✔✔
Cell Reference
The ________ displays the current cell mode, the page number, and the
zoom buttons. -- Correct Answer ✔✔ status bar
, When a cell is part of an active formula, it is surrounded with ________.
*C is incorrect* -- Correct Answer ✔✔ A) a white border with small
boxes on each corner
B) a bold, black border with small circles on each side
C) a colored background with small circles on each corner
D) a blue border with small boxes on each corner
The Formula Bar in Excel displays the value or formula in the active
cell.
True
False -- Correct Answer ✔✔ True
Which of the following is not part of the Accounting Number Format? --
Correct Answer ✔✔ Three decimal places
The ________ include(s) the Minimize, Restore, and Close buttons. --
Correct Answer ✔✔ application-level buttons
A chart value that originates in a worksheet cell is referred to as
________. -- Correct Answer ✔✔ Data point
Hold down the ________ key to select nonadjacent cells. -- Correct
Answer ✔✔ CTRL
Which of the following statements is false about a workbook? -- Correct
Answer ✔✔ Can only contain one worksheet
An outlined cell in a worksheet is the active cell.
100% CORRECT ANSWERS
The value axis is also known as the _________.
1) Category axis
2) Y-axis
3) X-axis
4) Legend -- Correct Answer ✔✔ y - axis
Tiny charts embedded in a cell that display a visual trend summary
alongside your data are called ________. -- Correct Answer ✔✔
Sparklines
The default number format for cells is the ________ number format. --
Correct Answer ✔✔ General
A defined set of formatting characteristics such as font, font size, and
font color are known as a ________. -- Correct Answer ✔✔ Cell Style
When using a touchscreen, which of the following actions is the same
as clicking an item? -- Correct Answer ✔✔ Tap the item
,A text value in Excel is also referred to as a ________. -- Correct Answer
✔✔ Label
Using a touchscreen, which of the following actions is the same as
right-clicking the mouse? -- Correct Answer ✔✔ Press and hold for few
seconds
Which of the following does not display to the right side of a selected
chart? -- Correct Answer ✔✔ Move chart button
________ is used to display the contents of a cell on multiple lines. --
Correct Answer ✔✔ Wrap text command
Which of the following is not a way to create a formula? -- Correct
Answer ✔✔ By using a function button on the status bar
Pixels are measured in ________ per square inch. -- Correct Answer ✔✔
Dots
The ________ visually displays which cells are included in a formula
calculation. -- Correct Answer ✔✔ Range Finder
What are the two contextual tabs that display under Chart Tools when
a chart is selected? -- Correct Answer ✔✔ Design and Format
A cell address is also referred to as a(n) ________. -- Correct Answer ✔✔
Cell Reference
The ________ displays the current cell mode, the page number, and the
zoom buttons. -- Correct Answer ✔✔ status bar
, When a cell is part of an active formula, it is surrounded with ________.
*C is incorrect* -- Correct Answer ✔✔ A) a white border with small
boxes on each corner
B) a bold, black border with small circles on each side
C) a colored background with small circles on each corner
D) a blue border with small boxes on each corner
The Formula Bar in Excel displays the value or formula in the active
cell.
True
False -- Correct Answer ✔✔ True
Which of the following is not part of the Accounting Number Format? --
Correct Answer ✔✔ Three decimal places
The ________ include(s) the Minimize, Restore, and Close buttons. --
Correct Answer ✔✔ application-level buttons
A chart value that originates in a worksheet cell is referred to as
________. -- Correct Answer ✔✔ Data point
Hold down the ________ key to select nonadjacent cells. -- Correct
Answer ✔✔ CTRL
Which of the following statements is false about a workbook? -- Correct
Answer ✔✔ Can only contain one worksheet
An outlined cell in a worksheet is the active cell.
