MOS Study Guide for Microsoft Excel Expert Exam MO-201 by Paul McFedries

Author:Paul McFedries [Paul McFedries]
Language: eng
Format: epub
Publisher: Microsoft Press
Published: 2020-03-15T16:00:00+00:00

❑ On the Inventory worksheet, populate the Reorder Now? column with formulas that use nested logical functions to determine whether a product should be reordered based on two conditions: The Qty Available is less than or equal to the Reorder Level, and the Qty on Order is 0. Each function should return “Yes” if a reorder is required, and nothing otherwise.

❑ On the Inventory worksheet, create a formula in cell K1 that uses the SUMIF function to sum the Value range for products with a non-zero Qty Available value.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.