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-2
Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service.
On a lark, for a year-end trivia contest, your boss wants you to calculate the length of service in complete days. What is the correct formula?
a. =DATEDIF(C2, $AE$2, today) b. =DATEDIF($AE$2, C2, dy)
c. =DATEDIF($AE$2, C2, day) d. =DATEDIF(C2, $AE$2, d)
Answer
This answer is hidden. It contains 36 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