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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- random numbers and stochastic simulations in excel
- ms excel mcq quiz set 1 e library wcl
- microsoft excel quiz what you need to know
- activity 3 7 statistical analysis with excel answer key
- excel pivot tables 2007
- introduction to excel maine
- schedule of values instruction sheet
- formatting in excel
- hud u s department of housing and urban
- an excel 2003 spreadsheet contains 65536 lines and 256
Related searches
- what you need to buy a house
- what you need to become a lawyer
- what you need to start a business
- what you need to become a teacher
- what you need to buy a car
- what you need to travel
- everything you need to know about stocks
- need to know business terms
- what you need to survive
- what you need to get a mortgage
- what degree do you need to be a marketing manager
- what do you need to know in public speaking