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 8-3
You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
If you omit the range_lookup value from a LOOKUP function, which of the following is true?
a. The function returns the #NAME? error value.
b. Your function can only search the first column of the lookup table.
c. It is considered an approximate match.
d. It is considered an exact match.
Answer
This answer is hidden. It contains 1 characters.
Related questions
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:
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 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:
If an optional argument is not included, Excel assumes a(n) ____ value for it.
a. default b. generic
c. static d. absolute
Q:
The ____ category of Excel functions returns (true-false) values.
a. Information b. Statistical
c. Logical d. Math & Trig
Q:
The WORKDAY function displays the date of the weekday a specific number of weekdays past a starting date.
Q:
The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false. _______________
a. True
b. False
Q:
A(n) ____________________ is text printed in the top margin of each page.
Q:
The ____________________ copies the formatting from one cell or range to another cell or range without duplicating any of the data.
Q:
Case 2-1
Harold has been working as a real estate agent. He has a lot of housing data to report and needs help organizing his data sheet for an effective presentation. Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges.
a. selective b. nonadjacent
c. consecutive d. specific
Q:
To set a page break in Excel, select the _____.
a. first cell below the row where you want to insert a page break
b. first cell above the row where you want to insert a page break
c. row above where you want to insert a page break
d. row below where you want to insert a page break
Q:
Setting the _____ to A1:L10 will print only data in those cells.
a. Page Format b. Print Area
c. Page Break d. Print Preview
Q:
In Excel, to merge cells A1, B1, C1, D1, and E1, _____ is the correct reference for the merged cell.
a. A1!E1! b. A1
c. E1 d. A1-E1
Q:
By default, numbers appear in the _____ and generally display values exactly as you type them.
a. Home tab b. General format
c. General number toolbar d. currency format
Q:
One of the benefits of Live Preview is that it _____.
a. lets you see and evaluate different formats as you develop your workbook
b. shows you what a document will look like when printed
c. applies thematic styles to your document
d. allows you to track changes in your document
Q:
Text and numbers are displayed vertically within cells. _________________________
Q:
The background image does not affect any cells format or content. _________________________
Q:
Each header and footer has three sectionsa left section, a center section, and a right section. _________________________
a. True
b. False
Q:
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. _________________________
a. True
b. False
Q:
____________________ removes the data from the row or column as well as removes the row or column itself.
Q:
The active cell is highlighted with a thick green border, its cell reference appears in the ____________________, and the corresponding column and row headings are highlighted.
Q:
To move the active cell up one row, press ____.
a. Shift + Enter b. Ctrl + Tab
c. Shift + Tab d. Ctrl + Enter
Q:
In ____ orientation, a page is taller than it is wide.
a. natural b. landscape
c. portrait d. basic
Q:
____ enters text based on patterns it finds in the data.
a. AutoComplete b. Flash Fill
c. AutoFit d. Fill
Q:
If you want to create a new line within a cell, press the ____ keys to move the insertion point to the next line within the cell.
a. Ctrl + Enter b. Alt + Enter
c. Alt + E d. Ctrl + E
Q:
AZ is an example of a ____.
a. column heading b. row heading
c. cell reference d. Name box