midterm-review-problems

midterm-review-problems - CSCE120 Computerized Information...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CSCE120 – Computerized Information Systems Excel Practice Problems Use the following spreadsheet for answering the questions below: 1. The contents of cell B4 were copied to cell E23. Determine what the formula or function in cell E23 would look like given the following: Cell B4 contains the formula =D4 + E5 + F6 ____________________________________ Cell B4 contains the function =$A$4 * E7 ____________________________________ Cell D12 contains the formula =($F3 * J5) – G$14 ____________________________________ Cell B4 contains the function =SUM(B2, $C$13) ____________________________________ Cell B4 contains the function =MIN($D$4:D9) ____________________________________ Cell D12 contains the function =COUNTIF($F$3:J$5, “>20”) ____________________________________
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Using the spreadsheet above, lightly shade in the cell range F7:H12. Using the spreadsheet above, evaluate the following formulas and functions: S =(B5 * C12) – 18 / 3^2 __________________________________________ S =MIN( B5:B14 ) __________________________________________ S =MAX( C5:C14 ) __________________________________________ S =AVERAGE( B5:B10 ) __________________________________________ S =COUNT( C10:C14 ) __________________________________________ S =COUNTA( A10:A14 ) __________________________________________ S =COUNTBLANK( C5:C14 ) __________________________________________ S =SMALL( B5:B14, 3 ) __________________________________________ S =LARGE( C5:C14, 2 ) __________________________________________ S =MEDIAN( B7:B11 ) __________________________________________ S =MODE( B5:B14 ) __________________________________________ S =RANK(C5, C5:C8, 1) __________________________________________ S =TODAY() - 7 __________________________________________ S =A14 – A5 __________________________________________ S =”12:00 PM” – “6:00 AM” __________________________________________ S
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 5

midterm-review-problems - CSCE120 Computerized Information...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online