Excel Test 2 - 2019-2020

Which quick-number style button formats numbers to display as currency in the worksheet?

Accounting

When you click the + button (New Sheet) on the tabs bar, where is a worksheet always inserted?

After the active worksheet

Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the top. Which sorting option should she choose?

Ascending

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items?

Auction Items[#Totals]

You just created a copy of a worksheet named August. What name does Excel gives it?

August (2)

Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?

AutoFit

Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl format the cell to correct this problem?

AutoFit

Trey would like to outline the cell range A1:F20. Which formatting style should he select?

Borders

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

Breaks

Which of the following can you not copy using Format Painter?

Cell Content

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?

Cell Style

Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?

Cell Style

You don't like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

Clear the cell's content.

Which of the following steps is not part of inserting a worksheet into a workbook?

Click Worksheet on the Insert menu tab.

Which of the following procedures is not a way to sort a table by the contents of one column?

Click an AutoFilter button in the total row.

How would you move sheet tabs to a new position in the workbook?

Click and drag the sheet tab to the new location

Which of the following procedures is not a way to filter a table by the contents of one column?

Click the AutoFilter button in the total row at the bottom.

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a summary view of all of the first period classes. Which feature would allow him to do this?

Collapse

The identifying letter at the top of a column is called the _____. (hint: answer is two words)

Column header

What type of formatting appears only when the value in a cell meets conditions specified by a user?

Conditional

Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than 50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?

Conditional Formatting

Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?

Currency

Joan has created a spreadsheet that displays sales of her employees. She would like to view only those employees with sales above $25,000 who are from Region 3. What option will allow her to do that?

Custom Filter

Which command do you use to reduce the margin between the border and the text in an indented cell?

Decrease Indent

John would like to remove a worksheet from his workbook. Which option would he choose?

Delete

Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table?

Delete

Which of the following statements describes how to increase or decrease a column's width?

Drag the boundary next to the column heading.

When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.

False

What command do you use to apply a background color to cells in a worksheet?

Fill Color

David only wants to view the employees in the Marketing department who earn a salary of more than $25,000. What command should he use to complete this task?

Filter

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?

Find & Select

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

Find and Replace

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

Font

What defines the color of the characters in a Microsoft Excel worksheet?

Font Color

On the Home Ribbon, what do you use to change the text color of characters in a cell?

Font Color drop-down list

On the Home Ribbon, what do you use to change the font size of characters in a cell?

Font Size drop-down list

Which of the following attributes is not a potential criterion for an AutoFilter sort?

Font style

Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

Format

Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?

Format Cells

Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?

Format Cells

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?

Format as Table

In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?

Formatting

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

Freeze

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?

Freeze

John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?

Freeze Panes

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?

Freeze Panes

What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?

Header & Footer

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

Hide

Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose?

Hide

Which ribbon includes the commands to apply a quick table style to a range of cells?

Home

Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?

Home Ribbon

Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?

Hyperlink

What is the process of bringing data containing text fields separated by commas into Excel called?

Importing data

Why would you need to copy a worksheet within a workbook?

It lets you repeat formats and working formulas into a new sheet.

You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which alignment option do you choose?

Justify

Which term describes the blank portions of a page that fall outside the main body of the printed document?

Margins

Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?

Merge & Center

Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?

Merge and Center

John would like to change the order of the worksheets in his workbook. Which option would he choose?

Move

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

Move

In which of the following locations are check boxes that you can select to view or print gridlines?

On the Page Layout tab, in the Sheet Options group

Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?

Orientation

Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?

Orientation

Which of the following is not useful for changing the font size?

Orientation button

Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?

Page Layout

Which of the following dialog boxes is used to transpose rows and columns?

Paste Special

Which of the following procedures is not a way to delete a worksheet from a workbook?

Press Ctrl + A to select all cells in the worksheet and press Delete.

Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change?

Print Titles

Which is a way to qualify data by specifying a matching condition or asking a question of the data?

Query

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?

Rename

How do you quickly modify a table style to meet user preferences?

Right-click on a style and choose Duplicate

How is an exact copy of a worksheet created within the same workbook?

Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu

How do you change the color of a worksheet tab?

Right-click the tab and select Tab Color.

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook?

Right-click the worksheet's tab and click Hide.

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

Scale

Which command do you use to remove manual page breaks from a worksheet area?

Select Remove Page Break from the Breaks drop-down area

Which of the following statements describes how to you unhide a hidden row or column?

Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

Sheet Options

Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order by last name. What should Cooper apply to the spreadsheet?

Sort

David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task?

Sort

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

Sort & Filter

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?

String

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

Styles

Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know how many members are in the same first period class. Which feature would allow him to do this?

Subtotal

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?

Tab Color

Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?

Text

You want to insert a cell into your worksheet. Which command do you use?

The Insert command in the Cells group on the HOME tab.

Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

Theme

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.

Which of the following are valid reasons for converting a table to a range?

To prepare for importing new data from a non-Excel file.

After you select a color and apply it to a cell's background, the Fill Color button takes on that color.

True

Style attributes include fonts and font sizes, number formats, and borders and shading.

True

When you point to defined styles in the Cell Styles gallery, you can see the formatting that will be used when you apply each style.

True

You cannot split a single worksheet cell that has not been merged.

True

John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?

Unhide

In order for you to freeze the first column of a worksheet into a frozen pane:

You can click Freeze First Column in the Freeze Panes menu.

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative?

You want to preserve the integrity of any cells referenced by formulas in the macro.

The __________ is the line between rows or columns.

boundary

A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.

header

__________ is the top-to-bottom measurement of a row, measured in points. (hint: answer is two words)

row height

__________ refers to shrinking or stretching printed output to a percentage of its actual size.

scaling

A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.

theme

Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table?

A table given a title enables its field names to be used in formulas in place of cell references.

To render twice the normal amount of worksheet displayed for any given area of the screen, which of the following settings would you need to change the Zoom to?

50%

Which of the following characters would not appear on an outline symbol or control for grouped or outlined data?

@

Which of the following does Excel not provide features for importing data?

A Web search

Which of the following statements about hidden and unhidden worksheets is correct?

A hidden worksheet cannot be inadvertently deleted.