lab-exam-sample - Faculty of Arts & Sciences Department of...

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

View Full Document Right Arrow Icon
Faculty of Arts & Sciences Department of Computer Science CMPS 209 - Sample Lab Exam Questions Page 1 of 5 Exercise 1 Open the Excel “PrivateJet.xlsx” datafile Formatting the table: o The title must be inserted in Cell A1 on 2 different lines. o Format all the values in the tables as shown. o Format the borders as shown below. o Adjust the alignment as shown below Fill the “total (EURO)” B10 and “total” B22 rows and columns H7 and H16 in both tables using the appropriate function, use the fill handle to copy the function when possible. Use the appropriate tool to change the color of the revenue cells holding the lowest 20% values. Use the appropriate tool to change the cell format of the expenses cells as shown below. Insert in cell B11 a formula that convert the EURO amount of the total cell into LBP using the value in B3. Insert in cell D25, a function that computes the average of values that are between 1000 and 1200 in the expenses table. In cell D26, insert a function that computes the sum of all the values in the expenses table that are less than €1000. Chart:
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/29/2010 for the course COMPUTER S Computer s taught by Professor Him during the Spring '10 term at American University of Beirut.

Page1 / 5

lab-exam-sample - Faculty of Arts & Sciences Department of...

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

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