ITE 140 Exam 1 Question and answers
correctly solved 2025/2026
A defined set of formatting characteristics such as font, font size, and font color are known as a ____
label
theme
cell style
series - correct answer ✔cell style
A chart value that originates in a worksheet cell is referred to as ______
a data point
a data marker
a data series
the x-axis - correct answer ✔a data point
A text value in Excel is also referred to as a ___
label
Formula
Constant
Cell address - correct answer ✔label
All formulas begin with ____
,= sign
% sign
+ sign
# sign - correct answer ✔= sign
Comma Style format displays a number with ___
two decimal places
a dollar sign and two decimal places
three decimal places
no decimal places - correct answer ✔two decimal places
Hold down the ________ key to select nonadjacent cells.
Spacebar
Ctrl
Alt
F2 - correct answer ✔Ctrl
In Excel 2016, row heading are identified by _____
uppercase letters
,lowercase letters
roman numerals
numbers - correct answer ✔numbers
the percent style button formats selected cells as a percentage with ____
zero decimal places
one decimal place
two decimal places
three decimal places - correct answer ✔zero decimal places
the ______ displays the current cell mode, the page number, and the zoom buttons.
ribbon
status bar
formula bar
quick access toolbar - correct answer ✔status bar
the default number format for cells is the _____ number format
, General
Currency
Comma style
Accounting number - correct answer ✔General
The keyboard shortcut to display Print Preview is ______
Alt + F2
F2
Ctrl + F2
F3 - correct answer ✔Ctrl + F2
the value axis is also known as the ______
x-axis
y-axis
correctly solved 2025/2026
A defined set of formatting characteristics such as font, font size, and font color are known as a ____
label
theme
cell style
series - correct answer ✔cell style
A chart value that originates in a worksheet cell is referred to as ______
a data point
a data marker
a data series
the x-axis - correct answer ✔a data point
A text value in Excel is also referred to as a ___
label
Formula
Constant
Cell address - correct answer ✔label
All formulas begin with ____
,= sign
% sign
+ sign
# sign - correct answer ✔= sign
Comma Style format displays a number with ___
two decimal places
a dollar sign and two decimal places
three decimal places
no decimal places - correct answer ✔two decimal places
Hold down the ________ key to select nonadjacent cells.
Spacebar
Ctrl
Alt
F2 - correct answer ✔Ctrl
In Excel 2016, row heading are identified by _____
uppercase letters
,lowercase letters
roman numerals
numbers - correct answer ✔numbers
the percent style button formats selected cells as a percentage with ____
zero decimal places
one decimal place
two decimal places
three decimal places - correct answer ✔zero decimal places
the ______ displays the current cell mode, the page number, and the zoom buttons.
ribbon
status bar
formula bar
quick access toolbar - correct answer ✔status bar
the default number format for cells is the _____ number format
, General
Currency
Comma style
Accounting number - correct answer ✔General
The keyboard shortcut to display Print Preview is ______
Alt + F2
F2
Ctrl + F2
F3 - correct answer ✔Ctrl + F2
the value axis is also known as the ______
x-axis
y-axis
