Free download excel interview questions

---

What is Microsoft Excel? What version of Excel are you using? Free Excel Templates - get organized 1. Learn Excel Basics - Excel 1. Parts of the Excel Screen TUTORIAL 2. Parts of the Excel Screen TEST 3. Free download excel interview questions Office Index Page Excel Tutorials Excel Tests Excel Tutorials with matching Free download excel interview questions Excel Training Word Tutorials Word Tests Word Tutorials with matching Tests Word Training PowerPoint Tutorials PowerPoint Tests PowerPoint Tutorials with matching Tests PowerPoint Training Website Development.

MS Excel Shortcuts Excel Keyboard Shortcuts Tests - 7 Excel Tests 2. Learn Excel Basics - Excel for Beginners Tests - 7 Excel Tests 3. Entering Data in Excel Tests - 4 Excel Tests 4.

Intermediate Excel Shortcuts Test - Excel Hotkeys Excel Keyboard Shortcuts streamline tasks that you frequently perform in Excel by allowing you to quickly access specific functions. Memorizing a couple of essential shortcut key combinations could save you time and frustration and could even assist you in using different versions of Excel as most shortcut keys have not changed in the last decade! Improve your Excel skills with the free Multiple Choice Excel Test Questions and Answers Quiz with Free download excel interview questions. Improve your Excel proficiency with the free Multiple Choice Excel Test Questions and Answers Quiz with Explanations.

Learn how the tabs are organized into groups, how to open the group dialog box and how to hide the ribbon. A good place to start is with getting to know how cell references work. Experiment with getting Excel to work for you by learning how to use the Add, Subtract, Multiply, Divide, SUM and AutoSum formulas and functions.

Nested functions can contain OR, AND, NOT and multiple IF arguments. PMT payment for a loanPV present value of a loanRATE interest rate of a loan and NPER number of payments that have to be made to repay a loan. BACK TO TOP of page. Another security issue is when other viewers or users of the worksheet inadvertently or intentionally change formulas or data without your knowledge and thus compromise the integrity of the data.

Conditional Formatting Excel TEST 4. Using Data Outline Tools TUTORIAL 4. Using Data Outline Tools TEST 5. What-If Analysis Excel TUTORIAL 5. What-If Analysis Excel TEST 6. Using Free download excel interview questions Validation Tools TUTORIAL 6. Using Data Validation Tools TEST 7. Data Forms Excel TUTORIAL 9. Data Forms Excel TEST Pivot Tables Excel TUTORIAL Pivot Tables Excel Free download excel interview questions More Microsoft Excel 1.

Keyboard Shortcuts for Cell Contents TEST 5. Keyboard Shortcuts for Formatting Numbers TUTORIAL 6. Keyboard Shortcuts for Formatting Numbers TEST 7. Keyboard Shortcuts for Formulas TUTORIAL 7.

Copying formulas using the fill handle saves a lot of time. So does knowing how to free download excel interview questions the formula to its actual value. This is done by formatting numbers for currency, percentage, dates, and fractions including decimal places and negative numbers. Sum and Count Functions are predefined formulas that are the powerhouse behind Excel. Understanding functions, how Excel organizes functions, and creating functions using the Function dialog box takes Excel beyond basic math.

Excel Formula Basics TUTORIAL 1. Excel Formula Basics TEST 2. Excel Formatting Numbers Basics TUTORIAL 3. Excel Formatting Numbers Basics TEST 4. Understanding Functions TUTORIAL 4. Free download excel interview questions Functions TEST 5. Using IF, SUMIF and COUNTIF TUTORIAL 5.

Using IF, SUMIF and COUNTIF TEST 6. Using Nested Functions TUTORIAL 7. Using Nested Functions TEST 8. Using Financial Functions Excel TUTORIAL 8. Using Financial Functions Excel TEST 5. Excel Basic Worksheet Formatting TUTORIAL 1. Excel Basic Worksheet Formatting TEST 2. Advanced Worksheet Formatting TUTORIAL 2. Advanced Worksheet Formatting TEST 3. Protecting Worksheets Excel TUTORIAL 3. Protecting Worksheets Excel TEST 4. Working with Multiple Worksheets TUTORIAL 4.

LINK TO US Contact Us What's New?

The sort and filter tools in Excel allow you to organize and manipulate your data quickly and easily. Use the concatenate function to combine words and even numbers that are contained across different columns into one free download excel interview questions. The converse function of concatenate is the Text to Columns function which allows you to separate text across different columns.

Free download excel interview questions power of IF, SUMIF and COUNTIF creates dynamic worksheets that provides results based on data being entered, calculated and evaluated removing the manual task of analyzing a worksheet. This is where nested IF statements, COUNTIFs and SUMIFs come in.

Excel Formulas and Functions Tests - 8 Excel Tests 5. Excel Worksheets - free download excel interview questions Excel Tests 6. Excel Charts Tests - 1 Excel Test 7. Printing Excel Worksheets - 2 Excel Tests 8. Macros - 1 Excel Test 9. Working with Data in Excel - 10 Excel Tests We've added a fun 30 second Excel Shortcuts Video tutorial.

What Version of Excel are you using? Find out how to find out! Easy Excel Shortcuts TEST 2. Intermediate Excel Shortcuts TEST 3. Keyboard Shortcuts for Worksheets TUTORIAL 3. Keyboard Shortcuts for Worksheets TEST 4. Keyboard Shortcuts for Cell Contents TUTORIAL 4.

How to create a bar or pie chart. Knowing how to format charts using the Design, Layout and Format tabs to change colors, labels and scale makes you an Excel Chart Wizard! Then you can change margins, paper size and layout, page breaks and column widths and print the cell borders and column headings at the top of each page to make it easy to read. There are modifications you can make to print an Excel worksheet either on one page or at least with all of the columns on one page.

Excel even has a free download excel interview questions function to remove duplicate values to ensure your data is free from repeat entries. You can apply different formatting to a cell or cells that meet your specific conditions i. Outline tools such as Group and Subtotal give you quick results when looking for answers in your data. A What-if analysis lets you see how those changes will affect the outcome of the formula. Free download excel interview questions Solver, data tables, and Goal Seek to test multiple values and see how free download excel interview questions results change.

Keyboard Shortcuts for Formulas TEST 8. Excel Basics TUTORIAL 1. Excel Basics TEST 2. Using the File Tab TUTORIAL 2. Using the File Tab TEST 3. The Views in Excel TUTORIAL 3. The Views in Excel TEST 4. Moving Around the Worksheet TUTORIAL 4. Moving Around the Worksheet TEST 5. Using the Ribbon Excel TUTORIAL 5. Using the Ribbon Excel TEST 6.

Test your Excel skills with the free 10 Question Multiple Choice Excel Quiz with Answers and Answer Explanations. Understanding and using the different views in Excel can make your work much easier. This includes Normal, Page Layout, Page Break views and the Zoom feature. Knowing how to use the mouse, keyboard and Go To features as well as how to select columns, rows and multiple cells makes using Excel much easier and can save you a lot of time.

Doing this manually can take up a lot of time and can lead to data entry errors. Formulas allow you to perform the above functions in record time. Data Forms allow you to find data, view entries, add and delete data to a worksheet with a user-friendly form. You can insert images and shapes, background colors and use SmartArt to make a worksheet in Excel visually more appealing.

You can do the same with dates and numbers using the fill handle and Auto Fill feature. You can even create your own list.

Data analysis tools ensure that values are entered in the same format where specified throughout your worksheet. Sometimes you need to change the case of words to free download excel interview questions or lower case or remove extra spaces or characters.

Working with Multiple Worksheets TEST 6. Printing Basics Excel TUTORIAL 1. Printing Basics Excel TEST 2. Printing Large Excel Worksheets TUTORIAL 2. Printing Large Excel Worksheets TEST 8. Using Macros Excel TUTORIAL 1. Using Macros Excel TEST 9. Sort and Filter Data in Excel TUTORIAL 1. Sort and Filter Data in Excel TEST 2. Conditional Formatting Excel TUTORIAL 3.

Customizing the Quick Access Toolbar TUTORIAL 6. Customizing the Quick Access Toolbar TEST 7. The Excel Screen TEST 3. Copying and Pasting Excel TUTORIAL 2. Copying and Pasting Excel TEST 3. Using Autofill Excel TUTORIAL 3. Using Autofill Excel TEST 4. Formatting Text Excel TUTORIAL 4. Formatting Text Excel TEST 4.

Excel shortcut keys make performing tasks that you frequently perform in Excel, quick and easy. A number of keyboard combinations provide quick access to specific tasks.

How to create and edit macros is easy and makes you an Excel pro. You need tools that allow you to organize your data according to specific criteria, for example, alphabetically sort surnames or apply specific filters to a worksheet to only display data that meets specific filter criteria.

How to use Excel - What is Microsoft Excel? What can Microsoft Excel be used for? What are the benefits of using Microsoft Excel to perform the above functions? What MS Excel Training is best for you?

The Excel shortcut inset row, delete row, columns and cells as well as adjust column width and row height are ones you will use every day. Improve your Excel proficiency with this free Excel Quiz. The Ribbon, Tabs, the Quick Access Toolbar, the Name Box, the Formula Bar, Column and Row Labels, Cells and Cell Addresses and the Worksheet Tabs.

If you like it we will add more Learn how to add, delete and change the position of the buttons you use the most. Knowing the correct names for different areas on the screen will assist you in understanding tutorials and Microsoft Office help answers and is well worth investing time in. Using the copying and pasting functions in Excel will not only save you time from having free download excel interview questions re-enter data repeatedly, it may also ensure more accurate data entry and less frustration.

Home Microsoft Office Index Excel Word PowerPoint What's New? Do the Test then study the Tutorial if you need to…or do the Tutorial then Test yourself!

You could have a worksheet for each month, or each location, or each person. You need to know how to add and delete worksheets, format multiple worksheets at the same time, insert data into multiple worksheets and calculate formulas across worksheets.

Split the worksheet to see two different parts at the same time using the Split Screen function. It can be helpful to name cells and cell ranges rather than referring to a cell by its address. Switching rows and columns gives you another view of your data. Like using a sticky note, inserting comments can help explain your data. BACK TO TOP of page 6. BACK TO TOP of page 8. MS Excel spreadsheets are not only great for financial workbooks and budgets, it can also be used for creating calendars and schedules, fitness tracker, invoices, to do lists, weight loss tracker, vehicle service logs, address lists and much more.

You can copy formatting by using the Format Painter. Formatting is the key. This includes changing the appearance of the worksheet including inserting and deleting columns and rows, changing column widths and row heights, cell color and borders and how to add Headers, Footers and page numbers.

This is a great time saver. Free download excel interview questions includes changing the appearance of the data including the font, font color, text alignment, merging cells, wrapping text and using the fit to cell feature.