Upgrade to remove ads
Unit 5, CH.3
Terms in this set (30)
When you type 6/12 into a cell, Excel automatically applies the _____ format.
Which of the following is not a default setting for the Accounting format?
To change the format of a value, click the Number Format option box arrow in the
Number group on the Home tab.
In Excel, dates are stored _____ so they can be used in calculations.
as sequential serial numbers
If you do not type the year when entering a date, what does Excel do?
It uses the current year.
By default, the Accounting format displays negative values
To apply several formatting settings at once, use the
Cell Styles gallery in the Styles group on the Home tab.
Font size is measured in
Which of the following formatting buttons is not found in the Font group on the Home tab?
To change the way a value is displayed in a cell, you can
right-click the Format Painter button and select a format.
Changing the theme of a worksheet changes all the following characteristics except
When you increase the font size of the text in a cell, you may need
manually adjust column width or row height.
Excel _____ if a cell is not wide enough to display a long number.
automatically widens the column
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?
display as much of the entry as fits in the original cell
To change the height of a row, begin by clicking the
Format button in the Cells group on the Home tab.
With the buttons in the Alignment group on the Home tab, you can do all of the following except
apply conditional formatting
How can you automatically adjust the width of a column to fit the size of the longest entry?
Hover the mouse pointer over the column heading.
To adjust the default column width for a workbook, start by
clicking the Format button and then clicking Default Width.
Change the fill color of a cell or range of cells by clicking the Fill Color button arrow in the
Font group on the Home tab.
Apply _____ to help readers spot trends and patterns in data.
To copy the format settings from one cell to another, use the _____ tool.
Accountants often emphasize a row of data totals in an Excel worksheet by
placing a single border at the top and a double border at the bottom.
The Borders button is located in the _____ group on the Home tab.
You can apply a format to multiple cells scattered around a worksheet by clicking one of the cells, pressing and holding the _____ key, and then clicking the other cells one by one.
Use the Outline button to place a border around
the entire selected range.
Which of the following line styles is available when you click the More Borders option on the Borders button?
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
Merge & Center button.
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.
After using Excel's Merge & Center feature, be sure to
check all formatting to see if any has changed.
To enhance the appearance of your worksheet, you can insert an existing logo or create one using some or all of the following buttons except
THIS SET IS OFTEN IN FOLDERS WITH...
Access Ch. 2 Concept
Access Ch. 4 Concept
Ch. 6 Access Concept
YOU MIGHT ALSO LIKE...
EXCEL Lesson 6: Study Guide
chapter 1 simnet
OTHER SETS BY THIS CREATOR
Test Thursday at 11am
Test Wednesday 9am