Microsoft Excel and Access 1.07, 1.08, and 1.09

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

Row height

__________ is the top-to-bottom measurement of a row, measured in points.

Scaling

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

Subtotal

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?

Collapse

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?

Right-click on a style and choose Duplicate

How can a table style be quickly modified to meet user preferences?

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

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

Click and drag the sheet tab to the new location

How would sheet tabs be moved to a new position in the workbook?

Formatting

In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?

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

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

On the Page Layout tab, in the Sheet Options group

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

Freeze

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

Hide

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

Scale

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

Print titles

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?

Custom filter

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?

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?

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?

Ascending

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?

Unhide

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

Move

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

Delete

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

Freeze Panes

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

Format as table

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

Sort

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?

Filter

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?

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?

Find and replace

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

50%

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?

Move

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

Rename

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

Tab color

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

Styles

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

Header and footer

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

Freeze panes

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

String

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

Importing data

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

Before the active worksheet

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

August (2)

When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names?

Sheet Options

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

Select Remove Page Break from the Breaks drop-down area

Which command is used to remove manual page breaks from a worksheet area?

Find and select

Which command on the Home Ribbon do you use to organize data in ascending or descending order?

Find and select

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

Sort and filter

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

Format

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

Delete

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

Breaks

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

Query

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

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

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

Font style

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

@

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

Paste special

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

A Web search

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

Auction Items[#Totals]

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?

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

Which of the following procedures is not a way to delete one or more worksheets from a workbook?

Click the AutoFilter button in the total row at the bottom

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

Click an AutoFilter button in the total row.

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

A hidden worksheet cannot be inadvertently deleted.

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

It lets you reuse formats and formulas in a new sheet.

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook?

Right-click the tab and select Tab Color.

Which of the following statements describes how to change the color of a worksheet tab?

Drag the boundary next to the column heading

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

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

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

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

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

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

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

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

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

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

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

On the Insert tab, click Worksheet.

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

Page layout

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

Home

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

Theme

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

Margins

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

Header

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

Theme

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

Boundary

The __________ is the line between rows or columns.

Column header

The identifying letter at the top of a column is called the _____.


Set pelajaran terkait

ATI Fundamentals large file study ****

View Set

Biology 106 Chapter 20: Genes Within Population

View Set

Chapter 21- The Immune System Part 1

View Set

Anatomy & Physiology Chapter 12 Homework

View Set