Chapter 6.1, Problem 8QC

In case you wish to have a 4X8 table with variable column width and row height. What is the best way to do it? a. Insert -> Table ICON ()-> Draw Table b. Something Else c. Insert -> Table ICON ()-> Insert Table.

The table VideoVisitFact has a single primary key column of VideoVisitKey. The column is numeric. Which of the following returns the number of rows in the VideoVisitFact table? A. SELECT MAX (VideoVisitKey) FROM VideoVisitFact B. SELECT COUNT (*) FROM VideoVisitFact C. SELECT (*) FROM VideoVisitFact D. SELECT SUM(VideoVisitKey) FROM VideoVisitFact

To set up a Pivot Table with years listed horizontally as shown above, the Year field should be dragged into the following Pivot Area: Group of answer choices COLUMNS ROWS VALUES FILTERS

A Data Table is one of the table types that you can associate with a given table. Group of answer choices True False

Word's built-in table creation tools come in handy when you need to layout data visually. Are you curious about the pros and cons of making a table in Word on the fly?

True or False Rather than showing multiple rows at once, a Details view lets the user see one row at a time.

What is the maximum number of columns you can define as a primary key when using the column-level approach to creating a table? a. 0 b. 1 c. 30 d. 255

The SAS table hold.work contains a numeric column named ID. Write an entire DATA step to create a table named hold.work2 that is a copy of hold.work but additionally contains a new character column named Name. Name should have the value "Food" when the existing numeric column ID is 50, and it should have the value "Ok" otherwise. [Note: Make sure the entire value is stored.]

When getting rid of rows, columns, and tables, what is the one thing that you absolutely must keep in mind at all times?