<< Back to Menu

USING THIS PAGE:

Below are the links to excel exams. Click on the links below to take you to a exam. Remember to read each question carefully. Good luck!

In the exams you will need to show your answers by putting them into an Excel document as noted in "EXCEL FILE NEEDED". Click on the link to the original Excel file, which opens the Excel file within your browser window. Save this Excel file in your own location and under your own name. Click the browser’s Back button and Forward button as necessary to toggle between the Excel file and these exam instructions.

 

Exam A

Exam F

Exam B

Exam G

Exam C

Exam H

Exam D

Exam I

Exam E

Exam J

 

A

 

EXCEL FILE NEEDED: Excel Exam Data A

1) Widen column D and E to 12. (E)

2) Heighten Row 2 to 15. (E)

3) Enter the words Pigs in D3 and Horses in E3. Bold and Center them both.(E)

4) Copy the box range of B4-C24 and Paste it into D4. (E)

5) Merge and center the row ranges B1-E1 and B2-E2.(M)

6) Create a thin black border around the box range of B4-E24.(M)

7) Shade the box range of B4-C24 with a gray toned color.(D)

8) Create gridlines within the shaded region.(D)

9) Border the box range A1-F26 with a thick black border.(M)

10) Insert the hyperlink www.farmers.com into cell B26and label the text to display as "our website".(D)

[Back To Top]

B

 

EXCEL FILE NEEDED: Excel Exam Data B

1) Insert another row in row 1 moving the cells down.(E)

2) Insert the words "2003 New York Precipitation" into A1, make them 14 size font, and bold and center them between the row range of A1-E1.(E)

3) Cut and paste the row range of B1-C1 into B2.(E)

4) Under the Total Column Insert the formula to add the corresponding B and C column of that row across.(D)

5) Border the box range of B4-D15.(M)

6) Center and Merge all of the Months within their cells at the same time.(M)

7) Format the box range of B4-D15, to two decimals places.(D)

8) Shade the cell(s) with the lowest snow inches.(M)

9) Shade the cell(s) with the lowest rainfall in inches.(D)

10) Shade the cell(s) with the lowest total precipitation.(D)

[Back To Top]

C

 

EXCEL FILE NEEDED: Excel Exam Data C

1) Change the height of row 1 to 15 (M)

2) Bold "Items" and "Cost" (E)

3) Center "Shopping List" (E)

4) Change the width of Column A to 15 (M)

5) Narrow column C to 7 (M)

6) Change the numbers under the title cost to currencies without decimals(M)

7) Change the currencies so that are no decimal places (D)

8) Right Align Column C (E)

9) Underline "Items" and "Cost" (E)

10) Change the font color of "Shopping List" to blue (D)

[Back To Top]

D

 

EXCEL FILE NEEDED: Excel Exam Data D

1) Change the font color of "Events, Date, and Time" back to black or the automatic color (E)

2) Type "My Schedule" in A1 (E)

3) Center "My Schedule" (E)

4) Bold and underline cell A1 (M)

5) Highlight both cells A6 and C6 and bold (M)

6) Narrow colum B to 7 (M)

7) Change the date so that the format of the date is month/day (D)

8) All the events are in the afternoon, format the time to standard time, and so that PM will appear after the time. (D)

9) Change the color of cell A1 to green (M)

10) Adjust column A to 16.14 (D)

[Back To Top]

E

 

EXCEL FILE NEEDED: Excel Exam Data E

1) Merge and center cells A1 to C1.(M)

2) Center cell range A4 - C4.(M)

3) Copy cell A4 and paste it into A12. (M)

4) Move B7 to B9.(E)

5) Copy the formula from B10, and paste to C10.(M)

6) Copy cell range B6 to C8, and paste to cell range A15 to C17.(D)

7) Move the cell range B8 - C8 to cell range B12 - C12.(D)

8) Copy cell range A3 - C3 to cell range A11 - C11, using the options in the “Edit” menu. (D)

9) Remove rows 13 and 14 so that there is no gap between the entries for 1990 and 1994.(D)

10) Cut cell range A14 - C15, and paste to cell range A12 - C13.(M)

[Back To Top]

F

 

EXCEL FILE NEEDED: Excel Exam Data F

1) Enlarge the title’s font size to 12.(E)

2) Widen the columns that need widening (make sure all text can be seen).(E)

3) Right align the cell range B3 - B9.(E)

4) Move the cell range A15 - B16 to cell range A10 - B11. (M)

5) Copy the cell range A18 - B19, and paste to cell range A13 - B14.(M)

6) Move the cell range A11 - B11 to cell range A12 - B12.(M)

7) Insert a row after the 11th row.(D)

8) Right align cell B10.(E)

9) Change the font color of the title to orange.(E)

10) Center the text in the cell range A3 to A15.(E)

[Back To Top]

G

 

EXCEL FILE NEEDED: Excel Exam Data G

1) In cells A1-E1 Input the following title "Section 0101 - Grades". Merge and Center the cells.(E)

2) Starting in A2 going across to E2 input the following cell headings: Student Name, Student ID, Test 1, Test 2, Final(M)

3) Starting in A3 going down the A column, create and input 8 class member names(E)

4) Starting in B3 going down the B column create and input fake Student ID numbers(E)

5) Starting in C3 going down the C column create and input fake Test Scores(M)

6) In A12 create a hyperlink to the professors website www.mygrades.com and change the Text to display to say "The Professor's Website"(D)

7) In A13 create a hyperlink to the University's website www.umd.edu and do not change the Text to display.(M)

8) Shade cells A3 - E3 at the same time with a light grey tone(D)

9) Shift row 1, row 12, and row 13 one cell to the right.(D)

10) Hide column A.(M)

[Back To Top]

H

 

EXCEL FILE NEEDED: Excel Exam Data H

1) Widen columns B and E using Autofit(M)

2) Under the B column shade all the cells by their level of danger. Great-greem, Fair- yellow, dangerous - red(M)

3) Border the box range of A1-E15(D)

4) Input into B16 the following hyperlink and Text to display: www.sailing.com, "Sailing Website"(D)

5) Input into B17 the following hyperlink: www.boating.com(D)

6) Center Align columns D and E.(E)

7) Create a link to another fishing website called www.fisherman.com in B18 changing the Text to display to read "My Website Choice".(D)

8) Center Align column A(E)

9) Delete the entire column C(M)

10) Save this document as a webpage titled "My boating Assignment"(E)

[Back To Top]

I

 

EXCEL FILE NEEDED: Excel Exam Data I

1) Align cell A1 to the center (M)

2) Change the font of cell A1 to Times New Roman (E)

3) Bold the text in cell A1 (E)

4) Left align cells A3, B3, and C3 (D)

5) Bold cells A3, B3, and C3 (E)

6) Change the color of cell A3 to red (D)

7) Change the color of cell B3 to blue (D)

8) Center cells C4, C5, C6, C7 and C8 (M)

9) Change the font of cells A4, A5, A6, A7, and A8 to book antiqua (M)

10)Change all the Font to size 12 and adjust any columns so the words can fit (D)

[Back To Top]

J

 

EXCEL FILE NEEDED: Excel Exam Data J

1) Merge cell A1 across cells A1 through C1. (D)

2) Bold cells A3, B3, and C3. (E)

3) Change cells B4 through B8 to money currency using the Format button and leaving 2 decimal places. (D)

4) Center align cells C4 through C8. (E)

5) Right align cells A4 through C8. (E)

6) Change the words “Bakery Sale” to the color pink. (M)

7) Change the number in cell C6 to 13.(E)

8) Change cells B4 and B6 to Italicized style at the same time. (M)

9) Change the color of the text in cell E11 to pink and the font size to 18. (M)

10) Rotate the text in cell E11 (- 45) degrees. (D)

[Back To Top]

 << Back to Menu