Software Apps Exam 2

Software Apps Exam 2 What is a field? What is a record? - ANSWER-A field is a single value that describes a person, place, or thing. A record is a group of related fields. If you split the worksheet into panes at cell E3, how many panes are created? - ANSWER-Four panes are created. What are the three freeze pane options? - ANSWER-Freeze panes for panes placed at the top and left of the workbook window, Freeze Top Row to freeze the worksheet's top, and Freeze First Column to freeze the worksheet's first column. When highlighting duplicate values with a conditional format, do the duplicate values have to be adjacent to each other? - ANSWER-No, duplicate values located anywhere within the selected range will be highlighted by the conditional format rule. Why is it not a good idea for a company to treat employee records with duplicate first and last names as duplicate records? - ANSWER-In a large enough company, there is a risk that two different employees will have the same name. When an ascending sort order is used, how is a date-time field sorted? - ANSWER-From the earliest date and time to the latest If you want to sort employees by the value of the Hire Date field within each value of the Dept field, which field is the primary sort field? Which is the secondary sort field? - ANSWER-Dept is the primary sort field; Hire Date is the secondary sort field. Before you can add subtotals to a data range, what must you first do with the data? - ANSWER-Sort the data range by order the field for which you want the subtotals calculated. What happens to worksheet rows that do not match the filter criteria? What happens to the data they contain? - ANSWER-They are hidden in the worksheet, but the data is not removed.