Excel Exam
Which of the following is true about adding cell borders?
You can add a border to the left, top, right, or bottom edge of a cell or range.
Which of the following is not true about setting column width?
You can change the width of only one column at a time.
Which of the following is true about moving cell contents?
You can move cells using the drag-and-drop feature.
To format a range so that all values greater than $500 appear in red, which of the following can you use?
conditional formatting
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
Which of the following lets you edit the contents of a cell?
Double-click the cell or click in the formula bar.
To move cell contents one space to the right, you can use the Increase Space button.
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 align a range, you combine the cells into one cell.
False
When you change cell contents to italics, you are changing the cell's alignment.
False
When you click a cell to insert a cell reference in a formula, you must type a(n) number to lock the cell reference in the formula.
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 select a cell range, the cells must be adjacent to each other.
False
Which of the following statements is true about COUNT functions?
The COUNT function returns the number of cells in a range that contain numeric data.
If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?
The Undo button on the Quick Access toolbar
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently?
The formula =SUM(B6:B10)
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
Dean wants to insert two blank rows above row 5. To do so, he can click the row 5 heading, and then click the Insert button in the Cells group two times.
True
Flash Fill enters text based on patterns it finds in the data.
True
A _______ refers to a collection of characters with a similar, specific design.
font
Which of the following is a built-in formula that helps you perform complex calculations?
function
When you click the File tab and then click Print, which of the following elements appears in the preview of the worksheet printout?
worksheet data
The Percent style formats numbers as percentages with _____ decimal places by default.
zero
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
Which of the following is not a way to move cell contents?
holding the CTRL key while dragging the selected cells
Which of the following formulas adds 25 and 10, and then multiplies the result by 50?
(25+10)*50
To apply a cell style, you would use the Cell Styles command on the _____ tab.
Home
You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?
-Before you paste it, you only need to select cell C1. -After you paste it, the information is deleted from the original location.
Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.
-Home tab -Format Cells dialog box -Mini toolbar
Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.
-Left -Center
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.
When you double-click the right border of a column heading, which of the following occurs?
AutoFit resizes the column to the widest cell entry.
Louis has entered a column of expense values. What feature can he use to insert the total expenses at the end of the column?
AutoSum button
How can you reverse your most recent action in Excel?
Click the Undo button.
To select a single worksheet cell so you can work with it, which of the following would you do?
Click the cell.
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do?
Edit the conditional formatting rule.
Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C?
Flash fill
To change the color of cell content, you use the ________ color list arrow.
Font
Which of the following functions inserts the total of a range?
SUM
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?
Page Break Preview
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 format the cell value 44.54 as 44.540, you can use the Increase Decimal button.
True
To move a worksheet, you can drag its sheet tab to the left or right.
True
To print a worksheet, you begin by going to Backstage view.
True
To enter a typed number into a cell, you can press Tab or Backspace.
False
To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider.
False
A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so?
=COUNTA(B1:B20)
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab.
Color
To create a new, blank workbook, which of the following can you use ? Select all the options that apply.
-New command on the File tab -CTRL+N keys
To paste copied cell contents with values only, not including formatting, which of the following can you use? Select all the options that apply .
-Paste Special -Paste Options button
The default worksheet text is _____-point Calibri.
11
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)
To change the background color of a cell, you use the Background color button.
False
Which of the following can you use to insert a formula using a function? Select all the options that apply.
All the Above
How can you distinguish between a manually added page break and an automatic page break in a worksheet?
Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.
Which of the following keys do you press to copy cells while dragging them?
CTRL
Your worksheet is too wide to fit on one page in portrait orientation. What is the best way to fix this problem?
Change the page orientation to landscape.
Which of the following is the temporary storage area that holds selections you copy or cut?
Clipboard
Jacquan wants to use a cell style similar to the default Title style, but with a larger font size and different font color. What can he do?
Create a custom cell style.
When you copy a formula from cell A10 to cell B10, what happens to the cell references in the formula?
Excel changes the cell references in the copied formula to reflect the new location of the formula.
A good practice is to move the most important worksheets to the end of the workbook.
False
A predesigned combination of formats, such as font size and color, is called a cell default.
False
Changing a worksheet window to Normal view changes the contents of the worksheet.
False
Decreasing a cell's indent moves its contents to the right one space.
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
The Comma Style format adds a comma and a dollar sign to a cell value.
False
To copy a cell's formatting to another cell, which of the following can you use?
Format Painter
In a complex formula, how does Excel determine which calculation to perform first?
It follows the order of operations.
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
Steffie needs a wider left margin in her worksheet. Which of the following can she do to change the margin?
On the Margins tab of the Page Setup dialog box, change the number in the Left box.
Preview
Scaling
What must you do before removing a page break?
Select a cell below or to the right of the page break.
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.
True
When you use the Windows Start menu to start Excel, it opens in Backstage view.
True
You can edit cell contents in the formula bar or in the cell itself.
True
You can set a scaling option to resize a worksheet to fit within a single page.
True
You use conditional formatting to format a cell based on its value.
True
When you underline cell content, you are using _____.
a font style
In the formula =SUM(A6:A9), which of the following best describes A6:A9?
argument
You can use the Find and Replace dialog box to find and replace _____.
cell formatting
Which of the following indicates the column and row where a cell is located?
cell reference
When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell.
paste