Microsoft Excel Domain 1: Manage Worksheets & Workbooks
| mos_od_excel_associate_1220.pdf |
Subdomain 1.1 Import data into workbooks
1 1 1 Import data from txt files
Directions:
1.) Go to data tab.
2.) Go to "Get And Transform" data group.
3.) Click "From Text/CSV"
4.) Download Employees.txt file (Above) Note: After you download it you will find the download in downloads.
5.) Press "Import"
6.) Set delimeter as "Tab"
7.) Click "Load"
To Get Credit: Show me the document after it was loaded on your computer
1.) Go to data tab.
2.) Go to "Get And Transform" data group.
3.) Click "From Text/CSV"
4.) Download Employees.txt file (Above) Note: After you download it you will find the download in downloads.
5.) Press "Import"
6.) Set delimeter as "Tab"
7.) Click "Load"
To Get Credit: Show me the document after it was loaded on your computer
1 1 2 Import data from csv files
Directions:
1.) Download the Planets.csv file above. (I suggest that you save it to downloads)
2.) Go to Data tab.
2.) Click "From Text/CSV"
3.) Import Planets.csv file from downloads
4.) Set the delimiter to comma.
5.) Click "Edit"
6.) In the "Transform" group, select "use first row as headers".
7.) Click the dropdown (shown in video) and select "close and load to".
8.) Click "existing worksheet"
9.) Press OK
To Get Credit: Show me the document after it was loaded on your computer
1.) Download the Planets.csv file above. (I suggest that you save it to downloads)
2.) Go to Data tab.
2.) Click "From Text/CSV"
3.) Import Planets.csv file from downloads
4.) Set the delimiter to comma.
5.) Click "Edit"
6.) In the "Transform" group, select "use first row as headers".
7.) Click the dropdown (shown in video) and select "close and load to".
8.) Click "existing worksheet"
9.) Press OK
To Get Credit: Show me the document after it was loaded on your computer
Subdomain 1.2 Navigate within workbooks
1.2.1 Search for data within a workbook
Directions:
1.) Download the FinancialSample1.xlsx file above. (I suggest that you save it to downloads)
2.) Go to "Home" tab.
3.) Go to "Editing" group.
4.) Click "Find And Select"
5.) Select "Find"
6.) Search for the word "unknown"
7.) Search within entire workbook.
To Get Credit: There are 2 instances of the word "unknown". Show me both.
1.) Download the FinancialSample1.xlsx file above. (I suggest that you save it to downloads)
2.) Go to "Home" tab.
3.) Go to "Editing" group.
4.) Click "Find And Select"
5.) Select "Find"
6.) Search for the word "unknown"
7.) Search within entire workbook.
To Get Credit: There are 2 instances of the word "unknown". Show me both.
1.2.2 Navigate to named cells, ranges, or workbook elements
Directions:
1.) Download the file above.
2.) Show me the two methods used in the video on how to identify named ranges in a worksheet.
To Get Credit: Demonstrate the two methods shown in the video to identify the named ranges in the worksheet.
1.) Download the file above.
2.) Show me the two methods used in the video on how to identify named ranges in a worksheet.
To Get Credit: Demonstrate the two methods shown in the video to identify the named ranges in the worksheet.
1.2.3 Insert and remove hyperlinks
Directions:
1.) Download the "Insert and remove hyperlinks" worksheet.
2.) Watch the video and add a hyperlink to this website in B1.
3.) Remove the hyperlink in B2.
To Get Credit: Add the hyperlink in B1. Remove the hyperlink in B2.
1.) Download the "Insert and remove hyperlinks" worksheet.
2.) Watch the video and add a hyperlink to this website in B1.
3.) Remove the hyperlink in B2.
To Get Credit: Add the hyperlink in B1. Remove the hyperlink in B2.
Subdomain 1.3 Format worksheets and workbooks
1.3.1 Modify page setup
Directions:
1.) Download the document above.
2.) Go to Page Layout tab.
3.) Use the suggestions in the video to adjust the print area to start at A1 and end at D9. Note: this is NOT shown in the video
To Get Credit: Show me a print area of A1 to D9.
1.) Download the document above.
2.) Go to Page Layout tab.
3.) Use the suggestions in the video to adjust the print area to start at A1 and end at D9. Note: this is NOT shown in the video
To Get Credit: Show me a print area of A1 to D9.
1.3.2 Adjust row height and column width
Directions:
1.) Download the document above.
2.) Set the row height to 18 and the column width to 25.
To Get Credit: Show me row height of 18 and column width of 25.
1.) Download the document above.
2.) Set the row height to 18 and the column width to 25.
To Get Credit: Show me row height of 18 and column width of 25.
1.3.3 Customize headers and footers
Directions:
1.) Download the "Financial Sample" document.
2.) Go to "Insert" tab.
3.) Go to "Text" group and click "Header And Footer"
4.) Follow the directions in the video to add one element to each section of the header and one element to each section of the footer.
To Get Credit: Show me a header with three elements (one in each box) and a footer with three elements (one in each box).
1.) Download the "Financial Sample" document.
2.) Go to "Insert" tab.
3.) Go to "Text" group and click "Header And Footer"
4.) Follow the directions in the video to add one element to each section of the header and one element to each section of the footer.
To Get Credit: Show me a header with three elements (one in each box) and a footer with three elements (one in each box).
1.4 Customize options and views
1.4.1 Customize the Quick Access toolbar
Directions:
1.) Download the document above.
2.) Hit the (More) arrow at the top of the document.
3.) Add "Spelling" to the quick access toolbar.
4.) Step 4 is NOT MENTIONED in the video. Right click on a menu item (any menu item) and add it to the quick access toolbar.
To Get Credit: Add spelling to the quick access toolbar. Right click and add a menu item (any menu item) to the quick access toolbar.
1.) Download the document above.
2.) Hit the (More) arrow at the top of the document.
3.) Add "Spelling" to the quick access toolbar.
4.) Step 4 is NOT MENTIONED in the video. Right click on a menu item (any menu item) and add it to the quick access toolbar.
To Get Credit: Add spelling to the quick access toolbar. Right click and add a menu item (any menu item) to the quick access toolbar.
1.4.2 Display and modify workbook content in different views
Directions:
1.) Download the file (above).
2.) Go to view tab.
3.) Go to workbook views group.
4.) Show me the "Page Layout" view.
To Get Credit: Show me the "Page Layout" view.
1.) Download the file (above).
2.) Go to view tab.
3.) Go to workbook views group.
4.) Show me the "Page Layout" view.
To Get Credit: Show me the "Page Layout" view.
1.4.3 Freeze worksheet rows and columns
Directions:
1.) Download document (above).
2.) Go to view tab.
3.) Go to D14 and click Freeze Panes
To Get Credit: Show me that you froze panes at D14.
1.) Download document (above).
2.) Go to view tab.
3.) Go to D14 and click Freeze Panes
To Get Credit: Show me that you froze panes at D14.
1.4.4 Change window views
Directions:
1.) Download the document.
2.) Go to view tab.
3.) Click view side by side
To Get Credit: Show the two workbooks side by side.
1.) Download the document.
2.) Go to view tab.
3.) Click view side by side
To Get Credit: Show the two workbooks side by side.
1.4.5 Modify basic workbook properties
Directions:
1.) Download file (above)
2.) Go to "File" tab.
3.) Look for "Properties" section.
4.) Click show all properties.
5.) Change "Subject" to ExcelKazanjian (Note: NO SPACES BETWEEN EXCEL AND KAZANJIAN)
To Get Credit: Show me the subject ExcelKazanjian
1.) Download file (above)
2.) Go to "File" tab.
3.) Look for "Properties" section.
4.) Click show all properties.
5.) Change "Subject" to ExcelKazanjian (Note: NO SPACES BETWEEN EXCEL AND KAZANJIAN)
To Get Credit: Show me the subject ExcelKazanjian
1.4.6 Display formulas
Directions:
1.) Download the file above.
2.) Go to "Formulas" tab.
3.) Go to "Formula Auditing" group.
4.) Click "Show Formulas"
To Get Credit: Show the formulas on the spreadsheet.
1.) Download the file above.
2.) Go to "Formulas" tab.
3.) Go to "Formula Auditing" group.
4.) Click "Show Formulas"
To Get Credit: Show the formulas on the spreadsheet.
1.5 Configure content for collaboration
1.5.1 Set a print area
Directions:
1.) Download the excel file above.
2.) Drag the mouse over the print area.
3.) Go to "Page Layout" tab.
4.) Click Print Area drop down.
To Get Credit: Set the print area and show me.
1.) Download the excel file above.
2.) Drag the mouse over the print area.
3.) Go to "Page Layout" tab.
4.) Click Print Area drop down.
To Get Credit: Set the print area and show me.
1.5.2 Save workbooks in alternative file formats
Directions:
1.) Download the file above.
2.) Click File
3.) Click "Save As"
4.) Click "Browse"
5.) Save the document as a CSV file to the desktop.
To Get Credit: Show me the CSV file on the desktop.
1.) Download the file above.
2.) Click File
3.) Click "Save As"
4.) Click "Browse"
5.) Save the document as a CSV file to the desktop.
To Get Credit: Show me the CSV file on the desktop.
1.5.3 Configure print settings
Directions:
1.) Download the file above.
2.) Go to "File" tab.
3.) Go to "Print" tab.
To Get Credit: Set print copies to 5 and set to landscape (don't press print)
1.) Download the file above.
2.) Go to "File" tab.
3.) Go to "Print" tab.
To Get Credit: Set print copies to 5 and set to landscape (don't press print)
1.5.4 Inspect workbooks for issues
Directions:
1.) Download File above.
2.) Click File Tab.
3.) Go to Info Tab
4.) Find Inspect Workbook tab and do the three checks (Inspect Document, Check Accessibility, Check Compatibility)
To Get Credit: Walk me through the process or show me the completed process.
1.) Download File above.
2.) Click File Tab.
3.) Go to Info Tab
4.) Find Inspect Workbook tab and do the three checks (Inspect Document, Check Accessibility, Check Compatibility)
To Get Credit: Walk me through the process or show me the completed process.