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