Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Question
When you want to reference an entire column of data in a table, you create a column _____.
a. label b. name
c. variable d. qualifier
Answer
This answer is hidden. It contains 1 characters.
Related questions
Q:
The Name dialog box lists all of the names currently defined in the workbook, including Excel table names. _________________________
Q:
A macro ____________________ uses a programs own macro programming language for distribution.
Q:
A(n) ____________________ is a text box that is attached to a specific cell in a worksheet.
Q:
In the Allow list box in the Data Validation dialog box, the _____ option means that the cell will accept only times.
a. Chronology b. Clock
c. Time d. Calendar
Q:
Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.
Q:
____________________ a worksheet duplicates all the values, formulas, and formats into the new worksheet, leaving the original worksheet intact.
Q:
_____ just above the header row of an Excel table to select the column data but not the header.
a. Click b. Double-click
c. Triple-click d. Right-click
Q:
To get the effect of a calculated column in a range of data, you must copy and paste the formula or use the _____ feature.
a. Concatenation b. Merged
c. AutoFill d. Indexed
Q:
The ____________________ function is a logical function that returns a TRUE value if any of the logical conditions are true and a FALSE value if the logical conditions are false.
Q:
Duplicate value highlighting helps to verify that columns of data have unique entries. _________________________
Q:
Two common categories of formula errors in Excel are syntax errors and logic errors.
a. True
b. False
Q:
Nesting IF functions will allow for three or more outcomes.
a. True
b. False
Q:
A _____ can be destructive and can modify or delete files that may not be recoverable.
a. digital signature b. macro virus
c. comment virus d. micro virus
Q:
Protecting the _____ prohibits users from renaming, deleting, hiding, or inserting worksheets.
a. skeleton b. structure
c. format d. location
Q:
An input message appears when the cell becomes active, and can be used to specify the _____ of data the user should enter in that cell.
a. aspect b. type
c. format d. cast
Q:
Any blanks or parentheses in a row or column label will be changed to _____ in defined names.
a. ampersands b. underscore characters
c. hyphens d. dashes
Q:
The Conditional Formatting button provides access to the _____.
a. Replicate Values conditional format b. Manage Rules option
c. Criteria option d. Organize Rules option
Q:
You can use a _____ function to return a value from a table that is based on an approximate match lookup.
a. VLOOKUP b. VAVERAGE
c. VMATCH d. VAPPROXIMATE
Q:
Using the VLOOKUP function, an exact match lookup occurs when the value entered must match one of the values in _____ of the lookup table.
a. the first column b. any column
c. the first row d. any row
Q:
Lookup _____ allow you to use tables of data to look up values and insert them in another worksheet location.
a. functions b. formulas
c. equations d. calculations
Q:
If you are creating a calculated column or formula within an Excel table, you can use the _____ structured reference in the formula.
a. basic b. advanced
c. qualified d. restricted
Q:
The ____________________ function calculates the difference between two dates and shows the result in months, days, or years.
Q:
When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions.
a. menu b. arrow
c. button d. status bar
Q:
To add a sort field in the Sort dialog box, click the ____ button.
a. Add Level b. Add Field
c. New Sort Field d. New Level
Q:
____ order arranges labels in reverse alphabetical order, from A to Z
a. Reverse b. Major
c. Ascending d. Descending
Q:
Which of the following is a valid table name?
a. %_table b. $Table2
c. _Newtable d. 2Table
Q:
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.
a. Design b. Home
c. Insert d. View
Q:
____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet.
a. Hiding b. Freezing
c. Showing d. Sealing
Q:
You can drag one field to the Filters area of the PivotTable Fields pane to change what values are displayed in the PivotTable.
a. True
b. False
Q:
You can use a tables sizing handle to add columns or rows to a table.
a. True
b. False