Excel lesson 9

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Which characters may not be used to begin a field name in a table?

= @ -

From which of the following does Excel not have features for importing data?

A Web search

What is 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.

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

What 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]

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.

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

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

Field names in a table, as opposed to a named range, must begin with an alphabetic character.

False

Immediately after you group together a cluster of adjacent rows, Excel prompts you to create a total row beneath it.

False

The @ character is required before any reference to a specific value in a named row.

False

The title given to a table appears above the field names row.

False

You cannot sort a table in alphabetical or numerical order for one column, and by conditional formatting for another column, at the same time.

False

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 of the following attributes is not a potential criterion for an AutoFilter sort?

Font style

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

Format as Table

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

Home

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

Importing data

What is the difference between an Auto Outlined worksheet and a worksheet with multiple groups?

None

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

Query

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

Right-click on a style and choose Duplicate

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 organize data in ascending or descending order?

Sort & Filter

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

Sort & Filter

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

Which is a valid reason you'd want to convert a table to a range?

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

Excel will not let any macro run in a worksheet without the user's direct approval, unless the option for that notification is explicitly turned off.

True

Once you remove an automatic style from a table, it is no longer a table.

True

When importing data from a text file, you can tell Excel to recognize a character other than a comma as a field delimiter.

True

You can have no more than two criteria in a custom AutoFilter.

True

You remove duplicate rows from a table the same way you would for a named range of AutoFiltered records.

True

What is the reason you would want to record a macro with absolute references rather than relative is because?

You want the macro to reproduce its results in the same place each time.


संबंधित स्टडी सेट्स

Solve Quadratic Equations mixed review, Solving Quadratic Equations by Factoring, Solving Quadratics with Square Roots, Solving Quadratic Equations by Graphing, Solving Quadratic Equations and the Quadratic Formula, Solving Quadratic Equations by Com...

View Set

ch. 37 - reproduction in flowering plants

View Set

Philippine Government: Chapter 4

View Set

History Reading Due 2/1 Pages 238-241

View Set