Microsoft Excel Final
When you click a cell to insert a cell reference in a formula, you must type a number to lock the cell reference in the formula
False
a predesigned combination of formats, such as font size and color, is called a cell default
False
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____.
hidden
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.
hide
Flash Fill enters text based on patterns it finds in the data
true
the percent style formats numbers as a percentages with ___ decimal places
zero
To increase the magnification of a worksheet from 100% to 120%, you use the magnification slider
False
To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.
False
When you copy cell contents, the data is removed from its original location and placed on the Clipboard.
False
When you enter a number, date, or time in a cell it is left-aligned by default
False
When you print in portrait orientation, the page is wider than it is tall
False
When you use the windows start menu to start excel, it opens backstage view
False
the comma style format adds a comma and a dollar sign to a cell value
False
when you change cell contents to italics, you are changing the cell's alignment
False
to change the color of cell content, you use ____ color list arrow
font
Which of the following lets you apply bold formatting to a selected cell
format cells dialog box, mini toolbar, home tab
to copy a cells formatting to another cell, what do you use
format printer
Which of the following is a built-in formula that helps you perform complex calculations
function
If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider_____ the worksheet
hiding
To print a worksheet, you begin by going to the backstage view
true
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward
true
You can edit the contents in the formula bar or the cell itself
true
a theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats
true
currency is an example of a number format
true
you use conditional formatting to format a cell based on its value
true
When you double click the right border if the column heading, which of the following occurs?
AutoFit resizes the column to the widest cell entry
What feature can be used to insert the total expenses at the end of a column
AutoSum Button
A good practice is to move the most important worksheets is to the end of the workbook
False
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Page Break View
Which of the following tabs lets you set worksheet print options
Page Layout
Which of the following views shows how a worksheet will appear when printed
Page Layout view
To move a worksheet, you can drag its sheet tab to the left or right.
True
Which of the following lets you edit the contents of the cell
double click the the cell or click in the formula bar
To enter a typed number into a cell, you can press Tab or backspace
False
The default worksheet text is _____-point Calibri.
11
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true?
A button appears near the selected cells with options for pasting formulas and values
Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?
COUNT(B1:B20)
Which of the following is the temporary storage area that holds selections you copy or cut
Clipboard
Changing a worksheet window to normal view changes the contents of the worksheet
False
If you want to paste values and number formatting only, click the paste numbers button that appears below the pasted cell
False
In formulas, calculations in square brackets are calculated first
False
to apply a cell style, you would use the cell styles command on the ____ tab
Home
To combine multiple cells into one combined cell, which of the following do you use?
Merge and center button
the ___ displays the cell reference of the active cell
Name Box
To paste copied cell contents with values only, not including format, what can you use?
Paste options button, paste special
Which of the following functions inserts the total of a range
SUM
Which of the following is true about moving cell contents
You can move cell contents using a drag and drop feature
When you underline cell content, you are using _____.
a font style
In the formula =SUM(A6:A9), which of the following best describes A6?
argument
Which of the following indicates the column and row where the cell is located
cell reference
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
color
In a complex formula, how does Excel determine which calculation to perform first?
it follows the order of operations
When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.
paste
You double-click the Format Painter button when you want to _____.
paste the same format multiple times
Which of the following is true about deleting a worksheet row
to delete a row, you can select the row, and then click the delete button in the cells group