ITE 140 EXAM 1 QUESTIONS WITH 100% ACCURATE
SOLUTIONS
1) ________ is a procedure that determines which digit to the right of a number will
be the last to be displayed.
a. Rounding
b. An absolute cell reference
c. A constant value
d. Cell addressing -- Correct Answer ✔✔ rounding
2) ________ is the keyboard shortcut for the Spelling command.
a. F1
b. F2
c. F7
d. F12 -- Correct Answer ✔✔ F7
3) the <,>, and <> can be used as
a. logical tests
b. comparison operators
c. criteria
, d. arguments -- Correct Answer ✔✔ comparison operators
4) How do banded rows display?
a. Even rows are formatted differently from odd rows
b. Even rows are bolded; odd rows are not
c. With a sold border around each row
d. Even rows are have a different background and font color than do odd rows -
- Correct Answer ✔✔ Even rows are formatted differently from odd rows
5) How do you know if some rows of a table have been hidden from view when a filter
is invoked?
a. Row numbers display is red
b. Row numbers are bolded
c. Row numbers display in blue
d. A number pertaining the number of hidden rows displays next to the funnel
icon -- Correct Answer ✔✔ row numbers display in blue
6) If a sheet tab has ________ you know that it is not selected.
a. a dotted background
b. a background color
c. a bolded border
d. a red border -- Correct Answer ✔✔ a background color
7) In a large worksheet, which two Excel commands help to make the worksheets
attractive and easier to read?
a. Print Titles and Summary sheet
b. Detail sheet and Summary Sheet
c. Print Titles and Scale to Fit
, d. Print Titles and Conditional format -- Correct Answer ✔✔ Print Titles and
Scale to Fit
8) In the excel window, where does [Group] display when worksheets are grouped?
a. On the title bar
b. On the ribbon
c. On the sheet tab
d. On the status bar -- Correct Answer ✔✔ on the title bar
9) On your keyboard, which two symbols function identically in date formats?
a. The comma and the forward slash key
b. The dollar sign and the ampersand
c. The forward slash key and the period
d. The hyphen key and the forward slash key -- Correct Answer ✔✔ The
hyphen key and the forward slash key
10) Sheet tab names are ________ when they are grouped.
a. underlined
b. bolded
c. italicized
d. in red -- Correct Answer ✔✔ underlined
11) The Count Function counts the number of cells in a range that ________.
a. Contain a number or text
b. Match a given value
c. Contain text
d. Contain a number -- Correct Answer ✔✔ contain a number
, 12) The COUNTIF function has two arguments ________.
a. The range of cells to check and the sum of the range
b. A value as the criteria and an average of a range of cells
c. The range of cells to check and the criteria
d. The range of cells to sum and the criteria -- Correct Answer ✔✔ The range
of cells to check and the criteria
13) The MEDIAN function finds ________.
a. The middle value in a range of cells
b. All numbers that correspond to an argument in the function
c. The average value in a range of cells
d. The one number that corresponds to an argument in the function -- Correct
Answer ✔✔ The middle value in a range of cells
14) The _________ is the temporary storage location for cell contents copied from a
worksheet.
a. Excel table
b. Clipboard
c. Paste area
d. Office Pane -- Correct Answer ✔✔ clipboard
15) The quickest way to repeat an action in Excel is the ________ function key.
a. F4
b. F6
c. F11
d. F2 -- Correct Answer ✔✔ F4
SOLUTIONS
1) ________ is a procedure that determines which digit to the right of a number will
be the last to be displayed.
a. Rounding
b. An absolute cell reference
c. A constant value
d. Cell addressing -- Correct Answer ✔✔ rounding
2) ________ is the keyboard shortcut for the Spelling command.
a. F1
b. F2
c. F7
d. F12 -- Correct Answer ✔✔ F7
3) the <,>, and <> can be used as
a. logical tests
b. comparison operators
c. criteria
, d. arguments -- Correct Answer ✔✔ comparison operators
4) How do banded rows display?
a. Even rows are formatted differently from odd rows
b. Even rows are bolded; odd rows are not
c. With a sold border around each row
d. Even rows are have a different background and font color than do odd rows -
- Correct Answer ✔✔ Even rows are formatted differently from odd rows
5) How do you know if some rows of a table have been hidden from view when a filter
is invoked?
a. Row numbers display is red
b. Row numbers are bolded
c. Row numbers display in blue
d. A number pertaining the number of hidden rows displays next to the funnel
icon -- Correct Answer ✔✔ row numbers display in blue
6) If a sheet tab has ________ you know that it is not selected.
a. a dotted background
b. a background color
c. a bolded border
d. a red border -- Correct Answer ✔✔ a background color
7) In a large worksheet, which two Excel commands help to make the worksheets
attractive and easier to read?
a. Print Titles and Summary sheet
b. Detail sheet and Summary Sheet
c. Print Titles and Scale to Fit
, d. Print Titles and Conditional format -- Correct Answer ✔✔ Print Titles and
Scale to Fit
8) In the excel window, where does [Group] display when worksheets are grouped?
a. On the title bar
b. On the ribbon
c. On the sheet tab
d. On the status bar -- Correct Answer ✔✔ on the title bar
9) On your keyboard, which two symbols function identically in date formats?
a. The comma and the forward slash key
b. The dollar sign and the ampersand
c. The forward slash key and the period
d. The hyphen key and the forward slash key -- Correct Answer ✔✔ The
hyphen key and the forward slash key
10) Sheet tab names are ________ when they are grouped.
a. underlined
b. bolded
c. italicized
d. in red -- Correct Answer ✔✔ underlined
11) The Count Function counts the number of cells in a range that ________.
a. Contain a number or text
b. Match a given value
c. Contain text
d. Contain a number -- Correct Answer ✔✔ contain a number
, 12) The COUNTIF function has two arguments ________.
a. The range of cells to check and the sum of the range
b. A value as the criteria and an average of a range of cells
c. The range of cells to check and the criteria
d. The range of cells to sum and the criteria -- Correct Answer ✔✔ The range
of cells to check and the criteria
13) The MEDIAN function finds ________.
a. The middle value in a range of cells
b. All numbers that correspond to an argument in the function
c. The average value in a range of cells
d. The one number that corresponds to an argument in the function -- Correct
Answer ✔✔ The middle value in a range of cells
14) The _________ is the temporary storage location for cell contents copied from a
worksheet.
a. Excel table
b. Clipboard
c. Paste area
d. Office Pane -- Correct Answer ✔✔ clipboard
15) The quickest way to repeat an action in Excel is the ________ function key.
a. F4
b. F6
c. F11
d. F2 -- Correct Answer ✔✔ F4
