midterm-review-problems

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

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

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”) ____________________________________

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

View Full Document
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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online