In cell P6, create a formula using the MIN function to find the lowest number of the Bizzy Caz clothing set ordered (the range B6:M6). Copy the formula from cell P6 to fill the range P7:P10 without formatting.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
- In cell P6, create a formula using the MIN function to find the lowest number of the Bizzy Caz clothing set ordered (the range B6:M6). Copy the formula from cell P6 to fill the range P7:P10 without formatting.
![1
2
K11
3
MAGN
File
7
Default
60
11
12
13
14
15
16
AutoSave Off 19 NP_EX16_3b_Raven MarieJones_1 ✓
H Keep
17
18
19
20
21
22
23
24
25
26
27
Home Insert Page Layout Formulas Data Review View Automate Help
New Perspectives Excel 2016 | Module 3: SAM Project 1b
You've Got Style
4 PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONS
Ready
Exit New Options
Sheet View
X✓ fx
Normal Page Break Page Custom
Preview Layout Views
Workbook Views
Documentation
B
Circular References: M6
8
9
s sheet. If your name does not appear in cell B6, please download a new copy of the
file from the SAM website.
10
#NAME?
Product Lookup Orders
Accessibility: Investigate
Navigation
+
✔Ruler
0
Gridlines Headings
Search
с
Show
0
Formula Bar
D
0
E
Zoom 100% Zoom to
Selection
0
F
Zoom
0
G
0
New Arrange Freeze
Window All Panes
H
A
0
I
0
J
Split
Hide
Unhide
0
K
View Side by Side
[DI Synchronous Scrolling
Reset Window Position
Window
0
L
0
Marie Jones
M
B
N
MJ
Switch
Windows
E
O
Comments
I
Macros
Macros
0
0
0
0
P
o o o o o
0
+
Ō
Share
Q
X
100%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fde0a9949-9fd7-4731-897b-5ba0b9f65d7c%2F87dd5b53-2b20-4568-9140-9a4476c408d4%2Figai6a8_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)