Microsoft Excel Quiz: What you need to know



Microsoft Excel Quiz: What you need to know!

1. Identify Window Parts:

Active Cell

Alignments AutoSum (Sigma) Column

Document Name Formula Bar Horizontal Scroll

Merge and Center Number Format Options Name Box

Program Name Row Sheet Tab

Task Pane Title Bar Vertical Scroll

2. Format Spreadsheets:

• Fill

• Border

• change height of rows and width of columns

• select cells

• insert footer

• change orientation (landscape)

• Print to 1 page wide by 1 page tall

3. Format Cells:

• Wrap Text

• Currency Style

• Comma Style

• Increase and Decrease Decimal

• Merge and Center

• Fonts, Font Sizes, Font Colors

• Alignment of Text

• Alignment of Numbers

4. Formulas:

• Add, subtract, multiply and divide using mathematical operations

• Find average

• AutoSum

• Show Formulas

5. Charts:

• Insert Column Graph

• Insert Pie Graph

• Legend

• Title, x-axis title, y-axis title

• Date Labels (Include value/percent)

*6. Insert and delete rows, columns, and cells:

• right click on worksheet row and column headings, select delete

• OR right click on cell, delete, select option

• OR Insert rows or columns.

[pic]

|# |EXCEL WINDOW ITEMS |

|1 |Active Cell |

|2 |Alignments |

|3 |AutoSum (Sigma) |

|4 |Column |

|5 |Document Name |

|6 |Formula Bar |

|7 |Horizontal Scroll |

|8 |Merge and Center |

|9 |Number Format Options |

|10 |Name Box |

|11 |Program Name |

|12 |Row |

|13 |Sheet Tab |

|14 |Task Pane |

|15 |Title Bar |

|16 |Vertical Scroll |

Part 1: Identify the correct window item by placing a number in the correct circle. To add text to circles, right click and select “add text”.

Part 2:

Create Worksheet as shown

1. Title:

• Merge and Center,

• Font Color Blue,

• Font Size 18,

• Font Bookman

2. Row 3:

• Fill color Red,

• Merge

• Height 24.00

3. Column Headings:

• Font Color Blue,

• Font Ariel,

• Center Align,

• All Caps (except large and small)

• MERGE: B4 + B5, C4 +D4, E4 + E5, F4 + F5, G4 + G5.

4. Items:

• Left Align,

• Font Batang,

5. Quantity:

• Enter data,

• Calculate Total Quantity for each item

6. Price:

• Change price to currency with 2 decimal places,

• Calculate Total Sales

7. Calculate

• Totals, Average, Max and Min using Autosum

8. Rows 15-18:

• Fill color grey,

• border red broken line,

• Font elephant,

• font size 12

9. Outside Border: thick black line

10. Delete: row 14

11. Create Chart (as object):

12. Print landscape 1 tall by 1 wide

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download