GL19 U5 (Excel) CH03 Concepts Exam Questions with Verified Solutions Latest Version (2024-2025)
Already Passed
Accountants often emphasize a row of data totals in an Excel worksheet by - Answers placing a single
border at the top and a double border at the bottom.
After using Excel's Merge & Center feature, be sure to - Answers check all formatting to see if any has
changed.
After you merge a range of cells, the cell reference that appears in the Name box is the address for the
_____ cell(s) in the merged range. - Answers far left
Apply _____ to help readers spot trends and patterns in data. - Answers conditional formatting
By default, the Accounting format displays negative values - Answers in parentheses.
Change the fill color of a cell or range of cells by clicking the Fill Color button arrow in the - Answers Font
group on the Home tab.
Changing the theme of a worksheet changes all the following characteristics except - Answers page
setup.
Excel _____ if a cell is not wide enough to display a long number. - Answers displays a string of pound
signs (####
Font size is measured in - Answers points.
How can you automatically adjust the width of a column to fit the size of the longest entry? - Answers
Double-click the right border of the column heading.
If a cell is not wide enough to display a long text entry and the cell to the right of it also contains text,
what will Excel do? - Answers display as much of the entry as fits in the original cell
If you do not type the year when entering a date, what does Excel do? - Answers It uses the current
year.
If you want to center the title in cell C3 across columns C, D, and E, drag to select the range C3:E3 and
then click the - Answers Merge & Center button.
In Excel, dates are stored _____ so they can be used in calculations. - Answers s sequential serial
numbers
The Borders button is located in the _____ group on the Home tab. - Answers Font
To adjust the default column width for a workbook, start by - Answers clicking the Format button and
then clicking Default Width
Already Passed
Accountants often emphasize a row of data totals in an Excel worksheet by - Answers placing a single
border at the top and a double border at the bottom.
After using Excel's Merge & Center feature, be sure to - Answers check all formatting to see if any has
changed.
After you merge a range of cells, the cell reference that appears in the Name box is the address for the
_____ cell(s) in the merged range. - Answers far left
Apply _____ to help readers spot trends and patterns in data. - Answers conditional formatting
By default, the Accounting format displays negative values - Answers in parentheses.
Change the fill color of a cell or range of cells by clicking the Fill Color button arrow in the - Answers Font
group on the Home tab.
Changing the theme of a worksheet changes all the following characteristics except - Answers page
setup.
Excel _____ if a cell is not wide enough to display a long number. - Answers displays a string of pound
signs (####
Font size is measured in - Answers points.
How can you automatically adjust the width of a column to fit the size of the longest entry? - Answers
Double-click the right border of the column heading.
If a cell is not wide enough to display a long text entry and the cell to the right of it also contains text,
what will Excel do? - Answers display as much of the entry as fits in the original cell
If you do not type the year when entering a date, what does Excel do? - Answers It uses the current
year.
If you want to center the title in cell C3 across columns C, D, and E, drag to select the range C3:E3 and
then click the - Answers Merge & Center button.
In Excel, dates are stored _____ so they can be used in calculations. - Answers s sequential serial
numbers
The Borders button is located in the _____ group on the Home tab. - Answers Font
To adjust the default column width for a workbook, start by - Answers clicking the Format button and
then clicking Default Width
