BUS 1350 Final Exam Questions with Correct Answers 100% Verified by Experts| 2025/2026
Latest Update
How are chart sheets different than worksheets? Worksheets contain a grid of cells in which
text and formulas can be entered and can also containgraphical objects. Chart sheets contains
charts and graphic objects but do not contain grids in which textand formulas can be entered.
What is the cell reference for the cell located in the third column and fourth row of a
worksheet? Cell C4
What is the range reference for the block of cells D3 through E10? D3:E10
How is text aligned within a worksheet cell by default? Text is left-aligned in a cell by
default.
How would the number 00514 appear in a cell? 514
Cell B2 contains the entry May 3, 2025. Why doesn't Excel consider this a text entry? Dates
and times are stored as numbers and not as text.
How do you AutoFit a column to match its longest entry? Double-click the right border of
the column heading or click the Format button in the Cells group on theHome tab and click
Autofit Column Width
What is a formula to add values in cells A1, B1, and C1? =A1+B1+C1
What is a function that will add the cell values of A1, B1, and C1 =SUM(A1:C1)
What is the function to count the number of numeric values in the range A1:A30?
=COUNT(A1:A30)
,If you insert cells into the range C1:D10, shifting the cells to the right, what is the new location
of thedata that was previously in cell F4? H4
Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is
inserted above row 5? =SUM(E1:E11)
In the following function, which arguments are required and which arguments are optional:
=AVERAGE(number1, [number2], [number3], ... ) number1 is required, number2 and
number 3 are optional
What is a formula to sum all numeric values in column C? =SUM(C:C)
Describe 4 ways of viewing worksheet contents in Excel? Normal View; Page Layout View;
Page Break View; Formula View
How are page breaks indicated in Page Break View? Page breaks are identified with blue
dotted lines
What is the difference between a serif font and a san serif font? Serif fonts have extra
decorative strokes at the end of each character. Sans serif fonts do not includethese decorative
strokes.
What is the difference between theme colors and standard colors? Theme colors are a set of
12 coordinated colors that belong to a theme. Standard colors are 10 colorsthat are always
available regardless of the workbook's theme
A cell containing a number displays #######. Why does this occur, and what can you do to fix
it? The number of digits could not fit within the width of the cell. To correct this problem,
either increasethe width of the cell column or reduce the number of digits to the right of the
decimal point
, How do you change the color of a worksheet tab? Right-click the sheet tab, click Tab Color
on the shortcut menu, and then select the color you want touse.
What is the General format? The default Excel number format that displays numbers just as
they are entered.
Describe the differences between the Accounting format and the Currency format? The
Accounting format places the currency symbol on the left edge of the cell, adds a thousands
separator, shows values to two decimals places, displays negative values in parentheses, and
displays zero values as dashes. The Currency format places the currency symbol to the left of
the first digit of the monetary value, adds a thousands separator, shows values to two decimal
places, and displays negative numbers with a negative sign
The range B3:B13 is merged into a single cell. What is its cell reference? B3
How do you format text so that it is set vertically within the cell? Click the Orientation
button in the Alignment group on the Home tab, and then click Vertical Text.
Describe two methods of applying the same format to different ranges? You can use the
Format Painter to copy and paste the format from one range into another, or you canapply the
same cell style to both ranges.
Red is a standard color. What happens to red text when you change the workbook's theme?
It remains red; a standard color is not changed when you change the workbook's theme
What is a conditional format? A conditional format is a format that changes based on the
value entered in the cell.
How would you highlight the top 10% values in the range A1:C20? Select the range A1:C20.
On the Home tab, in the Styles group, click the Conditional Formatting button.Point to
Latest Update
How are chart sheets different than worksheets? Worksheets contain a grid of cells in which
text and formulas can be entered and can also containgraphical objects. Chart sheets contains
charts and graphic objects but do not contain grids in which textand formulas can be entered.
What is the cell reference for the cell located in the third column and fourth row of a
worksheet? Cell C4
What is the range reference for the block of cells D3 through E10? D3:E10
How is text aligned within a worksheet cell by default? Text is left-aligned in a cell by
default.
How would the number 00514 appear in a cell? 514
Cell B2 contains the entry May 3, 2025. Why doesn't Excel consider this a text entry? Dates
and times are stored as numbers and not as text.
How do you AutoFit a column to match its longest entry? Double-click the right border of
the column heading or click the Format button in the Cells group on theHome tab and click
Autofit Column Width
What is a formula to add values in cells A1, B1, and C1? =A1+B1+C1
What is a function that will add the cell values of A1, B1, and C1 =SUM(A1:C1)
What is the function to count the number of numeric values in the range A1:A30?
=COUNT(A1:A30)
,If you insert cells into the range C1:D10, shifting the cells to the right, what is the new location
of thedata that was previously in cell F4? H4
Cell E11 contains the formula =SUM(E1:E10). How is the formula adjusted when a new row is
inserted above row 5? =SUM(E1:E11)
In the following function, which arguments are required and which arguments are optional:
=AVERAGE(number1, [number2], [number3], ... ) number1 is required, number2 and
number 3 are optional
What is a formula to sum all numeric values in column C? =SUM(C:C)
Describe 4 ways of viewing worksheet contents in Excel? Normal View; Page Layout View;
Page Break View; Formula View
How are page breaks indicated in Page Break View? Page breaks are identified with blue
dotted lines
What is the difference between a serif font and a san serif font? Serif fonts have extra
decorative strokes at the end of each character. Sans serif fonts do not includethese decorative
strokes.
What is the difference between theme colors and standard colors? Theme colors are a set of
12 coordinated colors that belong to a theme. Standard colors are 10 colorsthat are always
available regardless of the workbook's theme
A cell containing a number displays #######. Why does this occur, and what can you do to fix
it? The number of digits could not fit within the width of the cell. To correct this problem,
either increasethe width of the cell column or reduce the number of digits to the right of the
decimal point
, How do you change the color of a worksheet tab? Right-click the sheet tab, click Tab Color
on the shortcut menu, and then select the color you want touse.
What is the General format? The default Excel number format that displays numbers just as
they are entered.
Describe the differences between the Accounting format and the Currency format? The
Accounting format places the currency symbol on the left edge of the cell, adds a thousands
separator, shows values to two decimals places, displays negative values in parentheses, and
displays zero values as dashes. The Currency format places the currency symbol to the left of
the first digit of the monetary value, adds a thousands separator, shows values to two decimal
places, and displays negative numbers with a negative sign
The range B3:B13 is merged into a single cell. What is its cell reference? B3
How do you format text so that it is set vertically within the cell? Click the Orientation
button in the Alignment group on the Home tab, and then click Vertical Text.
Describe two methods of applying the same format to different ranges? You can use the
Format Painter to copy and paste the format from one range into another, or you canapply the
same cell style to both ranges.
Red is a standard color. What happens to red text when you change the workbook's theme?
It remains red; a standard color is not changed when you change the workbook's theme
What is a conditional format? A conditional format is a format that changes based on the
value entered in the cell.
How would you highlight the top 10% values in the range A1:C20? Select the range A1:C20.
On the Home tab, in the Styles group, click the Conditional Formatting button.Point to
