EL1 C3 Flashcards
The Increase Decimal and Decrease Decimal buttons change decimal places for…
existing numbers only
To insert a new row in a worksheet, select _____ and then click the Insert button.
the row below where the row is to be inserted
If you want to enter data on more than one line in a cell, you can enter the data on the first line and then move the insertion point to the next line in the cell by…
pressing ALT + ENTER
What does the Merge & Center button in the Alignment group on the HOME tab do?
merges the selected cells and centers the data within the merged cells
Which of the following is not one of the options at the Merge & Center button’s drop-down list?
Merge Workbooks
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
By default, numbers typed in a cell are formatted to…
right-align, with no decimals or commas unless they are typed in the cell
If you enter the value $45.50 into a cell with default formatting, Excel automatically…
applies currency formatting to the number
The column width number in the Column Width dialog box represents…
the average number of characters in the standard font that will fit in a cell
Which button do you click to display the Column Width dialog box?
Format
You can use your mouse to change the height of multiple rows at the same time if the rows are…
adjacent to one another
The name of this button in the Font group changes depending on the most recent option it was used to apply.
boarders
To give your worksheet a professional look, you can apply a predefined set of colors, fonts, lines and fill effects by…
applying a theme
Which of the following number formatting categories is not found in the Format Cells dialog box?
Exponents
What happens if you select three columns in a worksheet, click the Insert button arrow, and then click Insert Sheet Columns?
Three columns are inserted immediately to the left of the selected columns
By default, when inserting a column in a worksheet, the new column is placed…
immediately to the left of the column containing the active cell
Which of the following changes in text format can you not make on the Font tab of the Format Cells dialog box?
Orientation
When text is too long to fit in a cell, it normally overlaps into the next cell to the right. If you want data to remain in a cell and wrap to the next line within the same cell, select the _____ option at the Format Cells dialog box.
Wrap text
How is clearing cell contents different from deleting cells?
Clearing cell contents gives you the option of removing both contents and formatting from a cell
To change the height of all rows in a worksheet, click _____ and then drag a row boundary to the desired position.
Select All button
When you insert rows into a worksheet, all references affected by the insertion…
are automatically adjusted
The Clipboard group on the HOME tab contains the _____ button, which can be used to copy formatting to different locations in the worksheet.
format printer
You can insert a new row in a worksheet by clicking the Insert button arrow, clicking Insert Cells, and then clicking this at the Insert dialog box.
entire row
You can specify the formatting for numbers in a cell…
(?)
What does the Orientation button in the Alignment group do?
rotates data in a cell
If you enter numbers into a cell, they will be automatically aligned…
at the right side of the cell
If you want to copy formatting to several different locations in a worksheet, select the cell that contains the desired formatting and then _____ the Format Painter button.
double click
What happens if you select multiple columns and then drag one of the selected column boundaries?
all selected column widths change
To add a background color to a selected cell, use the _____ button in the Font group on the HOME tab.
fill color
To reduce the size of the text font so that all selected data fits within a column, click the _____ option on the Alignment tab in the Format Cells dialog box.
shrink to fit
Which component of a theme consists of a set of line and fill effects?
effects theme
On which tab in the Format Cells dialog box can you choose the degrees to rotate text?
alignment
Which number category in the Format Cells dialog box lines up the currency symbol and decimal points in a column?
accounting
The gridlines that display in a worksheet..
do not print by default
To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a _____, then drag the boundary to the desired height.
double headed arrow pointing up and down
Using the Delete key to delete cells…
only deletes the cell contents
You can see how a theme will affect your worksheet before you apply it by using the _____ feature.
live preview
Approximately how many points are contained in a vertical inch?
72
When a row height is being changed, the row height number that displays represents a measurement in…
points
What happens if you select and merge a block of cells that contain data?
Only the data in the upper left cell of the block will be retained.
Select the rows or columns you do not want to display on the screen and point to Hide & Unhide…
(?) in the drop-down menu of the Format button in the Cells group on the HOME tab
Click this button arrow in the Number group on the HOME tab to display a drop-down list of common number formats.
Number Format
You can adjust a column width to fit the longest entry in the column by double-clicking…
on the column boundary line
Excel measures row height in _____ and column width in _____.
points; characters
Right-clicking in a cell will display the…
mini toolbar
Which of these formatting options is not found in the Font group on the HOME tab?
superscript
By default, all columns in a worksheet…
are all the same width
In which number category can you specify the formatting for Zip codes?
Special
This number category in the Format Cells dialog box is used for very large or very small numbers.
Scientific
To delete a row, select the row and then click the Delete button in the _____ group on the _____ tab.
Cells; HOME
When you specify that column titles are to print on worksheet pages, how does Excel know what cells to use as the column titles?
You specify the range in the Rows to repeat at top text box in the Page Setup dialog box
At the Page Setup dialog box with the Sheet tab selected, you can specify rows and/or columns to print on every page of the worksheet. How is this feature normally used?
to print row and column titles on multipage worksheets
