fx | 1 2 3 4 sample calculations File Edit View Insert Format Data T 그리구 100% A Variable diameter height volume a)=PI()*B2^2* B3 b) =pi* diameter 2 * height c) =0.25*PI()*B2^2 * B3 d)=PI*B2^2* B3 B Value 3 5 5 The image above shows a section of a Google sheet. What formula(s) should be written in cell B4 to calculate the volume of a cylinder with a diameter value in B2 and height in B3? e) =(0.5*B2)^2*B3 $% 0 .0 .00 12: C Units m m m^3 2

New Perspectives on HTML5, CSS3, and JavaScript
6th Edition
ISBN:9781305503922
Author:Patrick M. Carey
Publisher:Patrick M. Carey
Chapter1: Getting Started With Html5: Creating A Website For A Food Vendor
Section: Chapter Questions
Problem 11CP1
icon
Related questions
Question

Please written by computer source 

fx |
1
2
3
sample calculations
✩
File Edit View Insert Format Data T
A
Variable
diameter
height
volume
a) =PI()*B2^2 * B3
b) =pi* diameter^2 * height
c) =0.25*PI()*B2^2 * B3
d) =PI*B2^2 * B3
100%
4
5
The image above shows a section of a Google sheet. What formula(s) should be written in
cell B4 to calculate the volume of a cylinder with a diameter value in B2 and height in B3?
e) =(0.5*B2)^2*B3
B
Value
3
5
$ % .0 .00 12:
C
Units
m
m
m^3
2
Transcribed Image Text:fx | 1 2 3 sample calculations ✩ File Edit View Insert Format Data T A Variable diameter height volume a) =PI()*B2^2 * B3 b) =pi* diameter^2 * height c) =0.25*PI()*B2^2 * B3 d) =PI*B2^2 * B3 100% 4 5 The image above shows a section of a Google sheet. What formula(s) should be written in cell B4 to calculate the volume of a cylinder with a diameter value in B2 and height in B3? e) =(0.5*B2)^2*B3 B Value 3 5 $ % .0 .00 12: C Units m m m^3 2
Formula for calculating area of a sheet with unit changes
Sample calculation
File Edit View Insert Format Data Tools Extensio
$% 0.00 123
Default (A
8
2
3
4
5
6
fx |
A
Variable
Length
Width
Area
100%
a) =length*width/(2.54)^2
B
Value
b) =(B2*2.54e-2) * (B3*2.54e-2)
The image above shows a section of a Google sheet. What formula(s) should be written in cell
B4 to calculate the area in m^2 of a rectangle with a length value in B2 and width in B3?
c) =(B2/2.54e-2)* (B3/2.54e-2)
d) =(B2/2.54) * (B3/2.54)
e) =(B2*B3)*0.0254^2
21 inch
35 inch
m^2
Units
D
Transcribed Image Text:Formula for calculating area of a sheet with unit changes Sample calculation File Edit View Insert Format Data Tools Extensio $% 0.00 123 Default (A 8 2 3 4 5 6 fx | A Variable Length Width Area 100% a) =length*width/(2.54)^2 B Value b) =(B2*2.54e-2) * (B3*2.54e-2) The image above shows a section of a Google sheet. What formula(s) should be written in cell B4 to calculate the area in m^2 of a rectangle with a length value in B2 and width in B3? c) =(B2/2.54e-2)* (B3/2.54e-2) d) =(B2/2.54) * (B3/2.54) e) =(B2*B3)*0.0254^2 21 inch 35 inch m^2 Units D
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Hyperlinks
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L