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
Case 7-3
Juan tells you that your work in Excel will go a lot faster if you start using defined names instead of cell and range addresses. You believe him but you have been frustrated by defined names in the past because you did not know the rules for naming them and you have run into errors as a result. Juan offers to help you.
Which of the following is a true statement Juan can make about defined names as he is explaining the rules to you?
a. The name can include letters, numbers, periods, and underscores
b. To distinguish multiword names, use a hyphen between the words
c. Defined names are case sensitive
d. The name should start with a hash tag
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