Excel Review

Accounting Format

Fixes a currency symbol at the left edge of the column. Displays negative numbers within parenthesis. Also displays zero values with a dash. Slightly indents values from the right edge.

Office Clipboard

The Clipboard task pane shows the contents of the _____________.

Edit the conditional formatting rule

To change a range's conditional formatting from data bars to icon sets, which of the following can you do?

Font

To change the color of a cell's content, you can use the ___________ color list arrow

Sheet Tab

To change the name of a worksheet, you rename the __________ ?

Merge and Center button

To combine multiple cells into one combined cell, which of the following do you use?

Format Painter

To copy a cell's formatting to another cell, which of the following can you use?

The New command on the File tab, The New command in Backstage view

To create a new, blank workbook, which of the following can you use? Select all that apply.

Clicking the column heading

To delete a worksheet column, you can first select it by __________ ?

Highlight Cell Rules

To format a cell range so that values between 100 and 500 appear in red, which of the following can you use?

Conditional Formatting

To format a range so that all values greater than $500 appear in red, which of the following can you use?

Color

To help you easily identify sheets in a workbook, you can add ____________ to the sheet tab.

File

To print more than one copy of your worksheet, which tab would you go in?

No scaling

To print your worksheet at its actual size, which of the following would you select?

Clear Formats

To return cell contents to its default font and style, you can use the _________ command.

Orientation

To rotate cell contents to an exact value, you change its __________ ?

Click the cell

To select a single worksheet cell so you can work with it, which of the following would you do?

Merge & Center

Merges the range into one cell and horizontally centers the content

Theme Colors

12 colors that belong to the workbook's theme.

=COUNTA(B1:B20)

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?

Paintbrush

Amari wants to paint the format of one object onto a target object. She selects the first object, then clicks on Format Painter, on the Clipboard group in the Home tab. She then observes the cursor change to a specific icon. Which of the following is the icon into which the cursor changed?

Theme Font

Associated with a particular theme, used for headings and body text, changes automatically when you change the theme applied to the workbook.

Two

Clicking the Percentage style in the Number Format list applies _________ decimal places by default.

Cell Style

Collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders.

Mini Toolbar

Contains buttons for common formatting options used for the selection.

Long Date Format

Displays the day of the week and the full month name in addition to the day of the month and the year.

Click on the select button in Rows to repeat at top area and select a title row.

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog Box > X > OK?

Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

Relative cell reference

In the formula =A8*$A$1, which of the following describes A8?

Argument

In the formula =SUM(A6:A9), which of the following describes A6?

Worksheet > View tab > Workbook Views group > Custom Views > Add > Name box (Type a name) > Include in view (Tick check box - Hidden rows, columns and filter settings) > OK

Luis wants to unhide and view all rows and columns in a worksheet. Which of the following series of clicks/entries/selections can he use to create a custom view of the worksheet?

Merge Cells

Merges the range into a single cell, but does not horizontally center the cell content.

Pick the color set he wants

Musa wants to choose a standard color theme for an Excel worksheet he is working on. He clicks on the Page Layout tab and then clicks Colors. What should he do next to complete the procedure?

Sheet tab > Home Tab > Cells group > Format > Visibility > Hide/Unhide > Hide Sheet

Myra wants to hide a worksheet to remove it from view. Which of these series of clicks will help her do so?

Currency format

Places a currency symbol left of the first digit. Displays negative numbers with a negative sign.

Theme

Predefined coordinated set of colors, fonts, graphical effects, and other formats that can be applied to workbooks to give them a consistent pro look.

Page Break Preview

Shows only those parts of the active sheet that will print and how the content will be split across pages.

Margin

Space between the page content and the edges of the page.

Click Margins in the Page Setup group on the Page Layout tab and then click on Normal

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page. To do this, what can you do after selecting the worksheet for this purpose?

False; default

True or False: A predesigned combo of formats, such as font size and color, is called a cell default.

False; decimal

True or False: Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5

False; increase

True or False: Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

False; Miley

True or False: Miley wants to perform calculations on four worksheets with identical structures at the same time. So in order to group them and perform the task faster, she can press the CTRL+Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

False; comma style format

True or False: The comma style format adds a comma and a dollar sign to a cell value.

True; the AutoSum button is the easiest way

True or False: The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

True; increase

True or False: To format the cell value 44.54 as 44.540 you can use the Increase Decimal button

True; command

True or False: To insert information that appears at the bottom of every worksheet page, you can use a command on the Insert tab.

False; cell alignment

True or False: When you change cell contents to italics, you are changing the cell's alignment.

False; copy/paste

True or False: When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

True; you can edit cell contents

True or False: You can edit cell contents in the Formula bar or in the cell itself.

Font Style

When you underline cell content, you are using ____________.

The formula =SUM(B6:B10)

Which of the following formulas totals the cells B6, B7, B8, B9, & B10 most efficiently?

SUM

Which of the following functions inserts the total of a range?

Scroll bars

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

AutoSum button

Which of the following inserts a function into a cell?

When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells

Which of the following is true when you delete a cell?

Home Tab, Format Cells Dialog Box, & Mini Toolbar

Which of the following lets you apply bold formatting to selected cells?

Double click the cell or click in the formula bar

Which of the following lets you edit the contents of a cell?

The COUNT function returns the number of calls in a range that contain numeric data

Which of the following statements is true about COUNT functions?

Quick Analysis Tool

You can create conditional cell formats using either the Home tab or the _________ ?

Page Layout View

You can edit a worksheet footer in ___________ ?

Hidden

You receive a worksheet in which the rows are numbered 1, 2, 3, 5, 6. This means that row 4 is __________ ?

Find and Replace

You want to change all worksheet occurences of "Radio" to "TV" to do this, you can use the ____________ feature.

Hide

Your worksheet contains info in column C that others should not see. To prevent this info to be displayed (but you still want to have access to this data,) you can _________ column C.

Merge Across

merges each row in the selected range across the columns in the range

Short Date Format

mm/dd/yyyy

Unmerge Cells

reverses a merge, returning the merged cell to a range of individual cells