ICT CHAPTER 4

B

All of the following statements regarding fields are true except: A) Field names must be entered in the first row of the list B) Field names will change from record record C) Field names must be unique D) Fields will be in the same order in every record

Table

An area in the worksheet that contains rows and columns of similar or related information

Sorting

Arranges records in a table by the value in field(s) within a table

C

Columns a and b contain row headings, columns c through t contain the results of individual measurements you have taken, and columns u,v, and w contain summary and statistical information based on those measurements. What can you do to display and/ or print only the row headings and the summary information? A) apply the outline feature B) freeze rows and columns C) hide columns c through t D) hide columns a and b

Eternal table data

Export data , refresh table data when linked to external source

D

How must the data be arranged before creating a summary report? A). In a table B) in a list C). In either a table or a list D). In a range

Freezing

Process of keeping headings on the screen at all times

Properties

Properties of table such as name, size, and resize table

Sort command

Puts lists in ascending or descending order according to specific keys

Data

Refer to facts about a specific record or sets of records

Table styles

Select and apply styles from a gallery of options

Page Break Preview

Shows where page breaks occur and gives you the opportunity to change where the page breaks

Hidden

State of rows, columns, and sheets being invisible

Tools

Summarize with pivot table, remove duplicates, and convert table to a range

D

The command that lets you specify the order in which rows in a table appear is: A) autofilter command B) autofill command C) hide rows command D) sort command

Keys

The fields that records are sorted in

Table style options

Toggle headers, totals, first and last column, banded rows or columns with check marks

A

Which of the following lets you see and/or modify page breaks that will occur when the worksheet is printed? A) the page break preview command B) the page Setup command C) the page breaks command D) the print preview command

B

Which of the following options enables you ti increase the number of columns that will be displayed on a printed worksheet? A) freezing panes B) changing from portrait to landscape orientation C) hiding columns D) using the split command

B

Which of the following statements about about the auto filter command is true? A) Records that do not meet the criteria are deleted B). If two criteria are entered, records must meet both conditions to be selected C). Records that meet the selected criteria or copied to another worksheet D) all of the above

D

Which of the following statements is true? A) the delete command can be used to delete a field but not record B) The delete command can be used to delete a record but not feel C) to delete command erases the contents of the selected area but does not delete it D) the delete command can be used to do it either a record or a field

B

Which of the following will compute a summary function for groups of records within a list? A) The advanced filter command B). The subtotals command C). The auto filter command D). The totals command

A

You are working with a large worksheet. Your row headings are in column A. Which command(s) should be used to see the row headings and the distant information in columns, x,y,z? A) the freeze panes command B) the hide rows command C) the new window command and cascade the windows D) the split rows command

B

You have a list of all the employees in your organization. The list contains employee name, location, title and salary. You want to list all employees in each location. The locations should be listed alphabetically , with the highest paid employees listed first for each location. Which is true of your sort order? A) sort by location ascending, then by salary ascending B) sort by location ascending, then by salary descending C) sort by salary descending, then by location ascending D) sort by location descending, then by salary ascending

A

You have a list of all the employees in your organization. The list contains employee name, location, title and salary. You want to list all employees in each location. Which is true of your sort order? A) branch office is the primary source should be in ascending order B) salary is the primary sort it should be in the descending order C). Salary is the primary sort it should be in ascending order D) branch office is the primary sort should be in descending order

D

You have a list of all the employees in your organization. You select the Autofilter command, and then select New York from the location field. What is the result? A) The list is sorted by city, New York first B) Close where the location is New York are written to another worksheet C). The rows where the location is not New York are deleted D) The rows where the location is not New York are hidden

C

You have a list of all the members of the club that you belong to. The worksheet contains other data as well. How can ypu be sure Excel recognizes the boundaries of the list? A)insert a comment in the upper left corner of the list. B)it's her the bank row between The field names and the data C) insert a blank row and a blank column between the list and other data in the worksheet D) type a row of dashes ( - - - )after the last row of the list

C

You have used the autofilter command to display only certain rows. The other rows are not displayed . What has happened to them? A) nothing; the filtered rows are displayed in a new worksheet B)they have been written to a new worksheet C) they have been hidden D) they have been deleted

D

You want to show total sales for each location. What should you do before executing the subtotals command? A) sort by sales, in ascending order B) sort by sales, in descending order C) sort by sales, in either ascending or descending order, then by location D) sort by location, in either ascending or descending order

Information

data that have been arranged in some form and are viewed as useful