Question Bank

1.      Explain spread sheet and its basics.

2.      What are charts in MS-Excel?

3.      How can you add a new Excel worksheet?

4.      How can you resize the column?

5.      List any three functions of MS Excel.

6.      Explain Sorting method.

1.      Discuss auto fill method in detail.

2.      Discuss Auto sum method with example.

Define

1.      Cell

2.      Spread sheet

3.      Cell address

4.      Rename

5.      Sheet

6.       MS Excel

7.      Chart

8.      Data

9.      Functions

10. Database 

Mid term Test

Basic Worksheet Formatting Test

1) Which of the following options most accurately represent a method for inserting rows into a worksheet in Excel?

 a) Select the whole worksheet by pressing Ctrl+A and then right-click and select Insert from the menu list.
 b) Select a row in the worksheet by clicking on the row label to select it and then right-click and select insert from the menu list.
 c) Select a row in the worksheet by clicking on the row label to select it and then press the Enter key to insert a new row.
 d) All of the above options are correct.

2) Study the screenshot above.  What is a quick way to resize the columns in the screenshot above to ensure all content fits within their respective column widths?

 a) Select each individual column and then drag the column divider to resize each column.
 b) Select all the columns, right-click and select Resize Columns from the menu list, then enter the column width value required.
 c) Select all the columns and then double click any of the column dividers in the selection to resize columns to fit content.
 d) Select the last column on the right and then double click its divider to resize all the columns in the worksheet.

3) Study the screenshot above.  In order to apply borders that look like those in the worksheet above, which option would you have to select from the Borders menu?

 a) Outside Borders.
 b) Right border, left border and bottom border.
 c) Inside Borders.
 d) All Borders.

4) How do you remove borders that have been applied to a worksheet?

 a) Select all the cells you wish to remove the borders from and then click on No Border in the Borders menu list.
 b) Select all the cells you wish to remove the borders from and then click on Remove Borders in the Borders menu list.
 c) Select all the cells you wish to remove the borders from and press Ctrl+Delete on your keyboard. 
 d) All of the above are methods for removing borders from selected cells.

5) Casey has an Excel worksheet that prints over several pages.  She wishes to add automatic page numbers to make it easier to collate when printing the worksheet.  Which of the following solutions could she use to add page numbers?

 a) Use the Page Break Preview view to ascertain where page breaks appear.  Then insert a page number above each page break.
 b) In the Print Preview view use the Insert Page Numbers function to number pages before they are printed.
 c) In the Page Layout view, use the Header & Footer tools to insert automatic page numbers in the Header or Footer region of every page. 
 d) None of the above options are correct.

6) Which of the following is NOT an element that can be inserted into the Header & Footer region of an Excel worksheet?

 a) ClipArt, Photos, Images, Shapes and other graphical elements. 
 b) Sheet name, page number, worksheet name and author.
 c) Current date and time.
 d) All of the above are elements that can be inserted into the Header and/or Footer region of a worksheet.

7) How do you remove all Headers & Footers from a worksheet?

 a) In the Page Layout view, go to each page in the worksheet and delete all content from the Header and Footer regions.
 b) In the Normal view, right-click either the Header or Footer area and select Delete Headers & Footers from the menu list.
 c) In the Page Layout view, select None from both the Header and Footer menus under the Header & Footer Tools – Design tab.
 d) All of the above options are correct.

8) The Header & Footer Tools – Design tab is a contextual tab.  What condition(s) must be met before the Header & Footer Tools Ribbon displays?

 a) Page Layout view must be activated.
 b) You must click in the Header or Footer region of the worksheet.
 c) You must click on the Header & Footer – Design tab in the Ribbon.
 d) All of the above are essential elements in gaining access to the Header & Footer Design Tools.

9) Katy attempted to insert an automatic page number into the Footer of every worksheet.  She followed all the instructions for inserting an automatic page number in the Page Numbering tutorial, but her page number is still displaying as:  &[Page] .  How can she fix this?

 a) If she presses the Enter key on her keyboard, the correct page number will appear.
 b) She has inserted an incomplete formula.  She needs to insert an equal sign so that the formula reads: =&[Page]
 c) She needs to click away from the Header region back into the body of the document to view the page number.
 d) She needs to reinsert the page number by selecting Page Number from the Header & Footer Elements group.

10) Where will you find options to change the line style and color of borders in a worksheet?

 a) By clicking on the Format button in the Cells group under the Home tab and selecting Format Cells.
 b) By pressing Ctrl+1 on your keyboard and then clicking on the Border tab in the Format Cells dialogue box.
 c) By clicking on the Border button in the Font group and selecting Line Color and Line Style from the menu list.
 d) All of the above options are correct. 

Class 7

Graph

http://faculty.kutztown.edu/schaeffe/Excel/Watts/Watts_Excel.pdf

Class 6

Pictograph

http://faculty.kutztown.edu/schaeffe/Excel/Vallone/Vallone_Excel.pdf

Class 5

Grade sheet 

http://faculty.kutztown.edu/schaeffe/Excel/Smoyer/Smoyer_Excel.pdf

Class 4

Chart 

http://faculty.kutztown.edu/schaeffe/Excel/Biese/Biese_Excel.pdf

Project

Project

http://www.jr7.k12.mo.us/UserFiles/Servers/Server_2964848/File/keyboarding/Excel_Projects.pdf

Assignment 1

Expences and Income

http://service.cs.fsu.edu/CGS2060/Assignments/Assg4_ExcelSpreadSheet.pdf

Class 3

Mean Median Mode

http://faculty.kutztown.edu/schaeffe/Excel/Beichey/Beichey_Excel.pdf

Class 2

Report Card

http://faculty.kutztown.edu/schaeffe/Excel/Finnerty/Finnerty_Excel.pdf

Class 1

Basic SpreadSheet

http://faculty.kutztown.edu/schaeffe/Excel/Rickert/Rickert_Excel.pdf

syllabus

Overview

The online Microsoft Excel 2013 Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software. Whether you need to learn the skills for work, want to fill the gaps in your CV or simply fancy learning something new, this Excel beginner course is perfect to do so.

Description

The online Microsoft Excel Beginner, Intermediate & Advanced course will provide learners with a core understanding of how to effectively operate and use the Excel spreadsheet software at an advanced level. Whether you need to learn the skills for work, fill the gaps in your CV or simply fancy learning something new, this Excel Advanced course is perfect.

Course Syllabus

Basic Level:

• Introduction to Spreadsheets
• Understanding Microsoft Excel
• Excel Workbook Windows
• Basic Spreadsheet Skills
• Excel Help System
• Opening and Closing Workbooks
• Understanding Workbook File Formats
• Creating New Workbooks
• Selecting Cells
• Auto Sum and Auto Fill Function
• Cell Referencing and Request
• Formatting Cells
• Formatting Numbers
• Placing Cell Alignment
• Cell, Rows and Columns
• Understanding Worksheets
• Editing, Copying and Moving Cells
• Page Layouts in Excel
• Proofing Workbooks
• Basic Options, Ribbons and Toolbar
• Final Assessment

Intermediate Level:

• Introduction to Excel Spreadsheet Intermediate Level
• Defining Names in Excel
• Sorting Data
• Using Excel Tables
• Filtering Data in Excel
• Understand Charts
• Chart Design Options and Tools
• Chart Format Tools
• Combo Charts
• Functions within Excel
• Understanding Date Function
• Information Functions
• Logical Functions
• Financial Functions
• Find and Replace
• Headers and Footers
• Adding Comments
• Conditional Formatting
• Final Assessment

Advanced Level:

• Introduction to Excel Advanced
• Using Text to Columns
• The Paste Special Function
• Data Validation
• Subtotals and Grouping
• Consolidating Data
• Scenario Analysis
• Data Tables in Scenario Analysis
• What-if Analysis
• Mats and Trig Functions
• Text Functions in Excel
• Using Lookup Functions
• Vlookups
• HLookups
• Using Statistical Functions
• Databse Functions
• Formaula Auditing and Error Tracing
• Hyperlinks in Excel
• Linking Data
• Understanding Pivot Tables
• Using Pivot Charts
• Workbook Properties
• Protecting and Sharing Worksheets
• Data Encrypting and Finalising Workbooks
• Understanding to Macros
• Custom Number Formats in Excel
• Using Custom Lists
• Working with Templates
• Tracking Changes in Excel
• Merging and Compare Excel Workbooks
• Final Assessment
• Microsoft Excel Software

This course relates to Microsoft 2013 software. In order to complete the course, learners should have their own copy of Microsoft Excel 2013. If learner does not own a copy of the software, Microsoft provide a free trial version of Microsoft Excel 2013.

Assessment

To assess the learners ability and knowledge to effectively understand the topics contained within the Microsoft Excel Basic, Intermediate & Advanced course, the course features a number of end of module interactive quiz questions.

Additionally, at the end of the course learners will also take an online multiple choice assessment test. This online multiple choice test is marked automatically so you will receive an instant grade and know whether you have passed the course.

Certificate

On successful completion of this Microsoft Excel Basic, Intermediate & Advanced course learners will receive a CPD Certificate of Achievement award from Oplex Careers.

This certificate will be produced in PDF format, hard copies of the certificate will be available at an additional fee of £9.99.

Course Format

This course is delivered online through eLearning. Learners of the course will receive instant access to our interactive student learning portal, which offers 24/7 access to the Microsoft Excel Basic, Intermediate & Advanced course.

Course Duration

The online Microsoft Excel Basic, Intermediate & Advanced course requires 90 hours to complete the course in full. This is only a guide to the learning hours required and it depends on how quickly an individual can absorb the information. The learning is online so it can be spread out over multiple sessions or done in one session.

Learners will have access to this course for up to 12 months from the date of joining. There is no time limit to complete the course during this period.

Tutor Support

When you are studying a course it is always useful to know that you have the help and support of tutors that want you to succeed in your studies.

As part of the Microsoft Excel Basic, Intermediate & Advanced course you will receive access to our dedicated tutor support service. The academic tutors will be able to provide you with unlimited online email support to help answer any questions that you may have whilst you are studying the course.

Course Compatibility

Our Microsoft Excel Advanced course is fully compatible with PC’s, Mac’s, Laptop, Tablet and Smartphone devices.

We know that more and more people are using the web whilst they are on the move, so we have designed this Microsoft Excel Advanced course to be fully compatible across tablet and smartphone devices. You will be able to access the same content from the course, just over a 3G or 4G network whilst on the move.

MS Excel

http://www.mcrhrdi.gov.in/Downloads/04.MS%20Excel.pdf

Spreadsheet

 Google Docs spreadsheet is a free and simple way to keep data in a spreadsheet form. If you add a lot of information, knowing how to quickly search for a keyword or topic is handy.

Method1

Browser

1. 
   1
   Open the Google Docs spreadsheet in Drive.
2. 
   2
   Open the tab that is relevant for your search.
3. 
   3
   Open "Find and Replace". There are two ways to do this:
   

   • Drop-down menu: Click on the Edit tab in the drop-down menu. Scroll down to Find and Replace.
     1. • You can also do the short key by pressing CTRL+H or CTRL+F on your keyboard. The “Find and Replace” window will appear.
4. 
   4
   Type the term or word you're searching for into the Find box. Don't put anything in the Replace box unless that's the action you're wanting to perform.
5. 
   5
   Click Find. The document is searched and if the term or word is there, the first occurrence of it will appear (it will have a blue box around it in the spreadsheet).
   

   • You can continue scrolling for more by clicking on Find again. It will jump to the next occurrence if there is one. If it finds nothing, it will tell you "No more results, looping around".
6. 6
   Exit. When you’re done, click “Done” at the bottom of the window to exit the “Find and Replace” window and go back to your spreadsheet.

Method2

Google Sheets App

1. 
   1
   Launch Google Sheets. Locate the app on your device and tap on it. The app icon has a green document or file icon on it.
   

   • You won’t need to sign in, unless this is your first time to use the app.
2. 
   2
   View your Google spreadsheets. All your Google spreadsheets, those you own and those shared with you, will be displayed. Swipe through the list and find the spreadsheet you’d like to open.
3. 
   3
   Open a spreadsheet. Tap the spreadsheet you want to view. It will be opened on your screen.
4. 
   4
   Access the search function. Search can be accessed from the menu. Tap the button with three vertical dots on the top right corner to bring out the menu. Tap “Find and Replace” from here, and a header search box will appear at the top of your spreadsheet.
5. 
   5
   Do a search. Enter the word, number, or string you want to look for in the search box. Tap the Search key on your keypad to begin.
6. 
   6
   View matches. If a match is found, the first cell containing the match will be highlighted and you will be brought to it.
   

   • On the rightmost part of the header search box are two arrow buttons. The upward button goes to the previous match and the downward button goes to the next match. Tap the downward button to go to the next cell containing the match. Continue tapping this button to go through the matches until you find the data you’re looking for.
7. 7
   Exit. When you’re done, tap the “X” button iHelpful 0