2024/2025 1|Page
BCIS FINAL Questions and Answers
to add a ______ to a sheet tab, right click a sheet tab, point to tab color on the short cut
menu, and then click a color.
a) fill color
B) format color
c) tab setting
d) formatting style
o :# A) fill color
when creating an excel document, you should avoid using _____ text and background
together, since this is the most common form of color blindness.
a: red and green
b:black and white
c: yellow and blue
d: red and yellow
o :# a: red and green
By default, numbers appear in the _____ and generally display values exactly as you type
them.
a: home tab
b: general number toolbar
, 2024/2025 2|Page
c: general format
d: currency format
o :# c: general format
Because Excel stores dates and times as _____, you can apply different formats without
affecting the date and time value.
a: numbers
b: universal number
c: text
d: greenwhich mean time
o :# a: numbers
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
a: right
b: center
c: left
D:top
o :# Right
as a general rule, you should _____________.
a: center column titles, left align text, and right align numbers
, 2024/2025 3|Page
b: center column titles, right align text, and left align numbers
c: right align column titles, left align text, and right align numbers.
o :# center column titles, left align text, and right align numbers.
________ merges each of the rows, in the selected range across the columns in the range.
a:merge build
b: merge across
c: merge and center
d: merge cells
o :# merge cross
in excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the
merged cell.
a: A1!E!
b: E1
c:A1
d: A1-E1
o :# A1
Options to rotate cells in Excel are available using the _____ button in the Alignment
group on the Home tab.
a: format
, 2024/2025 4|Page
b: sorter
c:orientation
d: alignment
o :# orientation
The Format Cells dialog box has six tabs, including _____.
a: decimals
b: security
c: border
d: shading.
o :# border
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing
decimal places, comma separators, and regular number displays.
a: number
b: alignment
c:font
d: fill
o :# number
you can open the format cells dialog box by right-clicking the format painter button to
paste the same format multiple times and click the format painter again to _______.
BCIS FINAL Questions and Answers
to add a ______ to a sheet tab, right click a sheet tab, point to tab color on the short cut
menu, and then click a color.
a) fill color
B) format color
c) tab setting
d) formatting style
o :# A) fill color
when creating an excel document, you should avoid using _____ text and background
together, since this is the most common form of color blindness.
a: red and green
b:black and white
c: yellow and blue
d: red and yellow
o :# a: red and green
By default, numbers appear in the _____ and generally display values exactly as you type
them.
a: home tab
b: general number toolbar
, 2024/2025 2|Page
c: general format
d: currency format
o :# c: general format
Because Excel stores dates and times as _____, you can apply different formats without
affecting the date and time value.
a: numbers
b: universal number
c: text
d: greenwhich mean time
o :# a: numbers
In Excel, dates are _____-aligned in the cell by default, regardless of date format.
a: right
b: center
c: left
D:top
o :# Right
as a general rule, you should _____________.
a: center column titles, left align text, and right align numbers
, 2024/2025 3|Page
b: center column titles, right align text, and left align numbers
c: right align column titles, left align text, and right align numbers.
o :# center column titles, left align text, and right align numbers.
________ merges each of the rows, in the selected range across the columns in the range.
a:merge build
b: merge across
c: merge and center
d: merge cells
o :# merge cross
in excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the
merged cell.
a: A1!E!
b: E1
c:A1
d: A1-E1
o :# A1
Options to rotate cells in Excel are available using the _____ button in the Alignment
group on the Home tab.
a: format
, 2024/2025 4|Page
b: sorter
c:orientation
d: alignment
o :# orientation
The Format Cells dialog box has six tabs, including _____.
a: decimals
b: security
c: border
d: shading.
o :# border
In the Format Cells dialog box, the _____ tab allows you to format currency by choosing
decimal places, comma separators, and regular number displays.
a: number
b: alignment
c:font
d: fill
o :# number
you can open the format cells dialog box by right-clicking the format painter button to
paste the same format multiple times and click the format painter again to _______.
