microsoft_excel_functions_and_formulas_with_excel_2019_and_office_365.pdf

(54852 KB) Pobierz
M
icrosof t
E
xcEl
f
unctions
®
®
and
f
orMulas
F
iF th
E
dition
LICENSE, DISCLAIMER OF LIABILITY, AND LIMITED WARRANTY
By purchasing or using this book (the “Work”), you agree that this license grants
permission to use the contents contained herein, but does not give you the right
of ownership to any of the textual content in the book or ownership to any of the
information or products contained in it.
This license does not permit uploading of the
Work onto the Internet or on a network (of any kind) without the written consent of
the Publisher.
Duplication or dissemination of any text, code, simulations, images,
etc. contained herein is limited to and subject to licensing terms for the respective
products, and permission must be obtained from the Publisher or the owner of the
content, etc., in order to reproduce or network any portion of the textual material (in
any media) that is contained in the Work.
M
ercury
L
earning and
i
nforMation
(“MLI” or “the Publisher”) and anyone involved
in the creation, writing, or production of the companion disc, accompanying algorithms,
code, or computer programs (“the software”), and any accompanying Web site or soft-
ware of the Work, cannot and do not warrant the performance or results that might be
obtained by using the contents of the Work. The author, developers, and the Publisher
have used their best efforts to insure the accuracy and functionality of the textual mate-
rial and/or programs contained in this package; we, however, make no warranty of any
kind, express or implied, regarding the performance of these contents or programs. The
Work is sold “as is” without warranty (except for defective materials used in manufac-
turing the book or due to faulty workmanship).
The author, developers, and the publisher of any accompanying content, and anyone
involved in the composition, production, and manufacturing of this work will not be
liable for damages of any kind arising out of the use of (or the inability to use) the algo-
rithms, source code, computer programs, or textual material contained in this publica-
tion. This includes, but is not limited to, loss of revenue or profit, or other incidental,
physical, or consequential damages arising out of the use of this Work.
The sole remedy in the event of a claim of any kind is expressly limited to replacement
of the book, and only at the discretion of the Publisher. The use of “implied warranty”
and certain “exclusions” vary from state to state, and might not apply to the purchaser
of this product.
Companion files for this text are available for download by writing to the publisher at
info@merclearning.com.
M
icrosof t
E
xcEl
f
unctions
®
®
and
f
orMulas
With Excel 2019 / Office 365
F
iFth
E
dition
B
Ernd
H
Eld
B
rian
M
oriarty
t
HEodor
r
icHardson
M
ERCURY
L
EARNING AND
I
NFORMATION
d
ullEs
,
V
irginia
Boston, Massachusetts
New Delhi
Copyright © 2019 by
M
ercury
L
earning and
i
nforMation
LLC.
All rights reserved.
This publication, portions of it, or any accompanying software may not be reproduced in any
way, stored in a retrieval system of any type, or transmitted by any means, media, electronic
display or mechanical display, including, but not limited to, photocopy, recording, Internet
postings, or scanning, without prior permission in writing from the publisher.
Publisher: David Pallai
M
ercury
L
earning and
i
nforMation
22841 Quicksilver Drive
Dulles, VA 20166
info@merclearning.com
www.merclearning.com
(800) 232-0223
B. Held, B. Moriarty, and T. Richardson.
Microsoft® Excel® Functions and Formulas, Fifth Edition.
ISBN: 978-1-68392-373-2
Microsoft, Excel, Visual Basic, and Windows are registered trademarks of Microsoft
Corporation in the U.S. and other countries.
The publisher recognizes and respects all marks used by companies, manufacturers, and
developers as a means to distinguish their products. All brand names and product names
mentioned in this book are trademarks or service marks of their respective companies. Any
omission or misuse (of any kind) of service marks or trademarks, etc. is not an attempt to
infringe on the property of others.
Library of Congress Control Number: 2019931784
192021321
This book is printed on acid-free paper in the United States of America.
Our titles are available for adoption, license, or bulk purchase by institutions, corporations,
etc.
Digital versions of this title are available at www.academiccourseware.com and most
digital vendors. Companion disc files are available for downloading by contacting info@
merclearning.com.
For additional information, please contact the Customer Service Dept. at
(800) 232-0223 (toll free).
The sole obligation of
M
ercury
L
earning and
i
nforMation
to the purchaser is to replace the
disc, based on defective materials or faulty workmanship, but not based on the operation or
functionality of the product.
CONTENTS
Acknowledgments
Introduction
Chapter 1 : Formulas in Excel
Calculate production per hour
Calculate the age of a person in days
Calculate a price reduction
Convert currency
Convert from hours to minutes
Determine fuel consumption
Calculate your ideal and recommended weights
The quick calendar
Design your own to-do list
Increment row numbers
Convert negative values to positive
Calculate sales taxes
Combine text and numbers
Combine text and date
Combine text and time
Generate a special ranking list
Determine average output
Determine stock gains and losses
Evaluate profitability
Determine percentage of completion
Convert miles per hour to kilometers per hour
Convert feet per minute to meters per second
Convert liters to barrels, gallons, quarts, and pints
xvii
xix
1
1
2
3
4
5
6
7
9
10
11
12
13
14
15
16
16
18
19
20
21
22
23
24

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin