Almost every job these days requires you to have a basic, functional knowledge of Excel. Excel is the top spreadsheet application in the world with over a billion users, and most offices rely on Excel for many daily tasks. If you’re applying for jobs that require any amount of tracking, data, or simple calculations, you will be expected to know Excel. Here are some interview questions you could expect at a basic job interview. The Excel 2013: Introducing Excel course offers a great introduction to Excel and is a fantastic place to start.
What is Excel?
Excel is a spreadsheet application that allows you to record, store, manipulate and analyze data. Data is stored in areas called cells. Each cell has a unique address depending on the row and column value of the cell. Excel allows for simple mathematical manipulation of data as well as data representation through graphs
What is the Ribbon?
The ribbon is an area that runs along the top of the application that contains menu items and toolbars available in Excel. The ribbon has various tabs that contain groups of commands for use in the application. The ribbon can be minimized or maximized by pressing CNTRL F1.
What are worksheets and how can you add or remove worksheets?
A worksheet is a single page or sheet within a workbook in Excel. When you start a new blank workbook, Excel automatically adds three blank worksheets. To add a worksheet to the workbook you can click the insert worksheet tab at the bottom of the workbook. You can also insert a sheet using the SHIFT key and then pressing F11.
For a great step-by-step tutorial that covers all the Excel basics you need to harness the power of Excel in your job, sign up for the Excel 2013 Made Easy course from Udemy.
How can you add cells, rows or columns in Excel?
To add a cell, row or column in Excel, right click the cell you want to add to and then select insert from the cell menu. The insert menu allows you to select to add a cell, a column or a row and to shift the cells affected by the additional cell right or down.
To learn how to add cells and columns, and for tutorials on all the aspects of Excel, sign up for the Excel for Beginners course from Udemy.
How can you make space for text in a cell where the text is longer than the cell size?
Where the text within a cell is larger or longer than the cells, you can either increase the cell width or use the wrap text cell format to accommodate the text.
You can increase the cell width by adjusting the column width by dragging the cell boundary on the right hand side of the column. You can also use the format function on the home tab and select column width and enter a new column width. You can also use the auto fit column width function to automatically adjust the size of the column.
Name 5 data formats available in Excel and where you would use them
Excel offers over eleven different data formats for data storage. The most popular formats includes the number, currency, date, percentage, text formats.
The Number format stores data as a number. A number can include decimal values and separators for values greater than one thousand. Numbers can be used for mathematical formulas available in Excel.
The currency format in Excel is a specialized number format that stores data in the form of a specific currency. Currency indicators can be set using the number formats available on the home tab. Currencies are treated like numbers by Excel for the purposes of calculations and formulas.
The date format in Excel allows for data to be stored as dates. Dates are stored as number values by Excel for the purposes of formulas and calculations. Learn more about working with dates by reading Excel Date Format: Get Your Way with the Date!
The percentage format stores numbers as a percentage. The numbers are stored as a percentage value and the format is taken into account for calculations. More details about the percentage format and formula are available in this article: Excel Percentage Formula: What Did the Sale Actually Cost?
The text format stores data as strings of texts. Text can include both numbers, letters and symbols. Certain formulas and functions cannot be performed on cells formatted as text like the mathematical functions.
What are comments, how do you add comments to a cell?
Excel allows you to add comments to a cell. Comments are used for a variety of reasons. You can add comments to a cell to clarify the purpose of the cell, to clarify a formula used in the cell, or to leaves notes for other users about a cell.
To add a comment to a cell, you right click the cell and choose insert comment from the cell menu. Type your comment in the comment area provided. A red triangle at the top right hand corner of a cell indicates that there is a comment linked to that particular cell. To remove a comment from a cell, right lick the cell and then select delete comment from the cell menu.
What is the simplest way to create a table to sort data in Excel?
Excel offers the format as table option on the home tab. To format data as a table with a heading that allows simple sorting of data, you select the range of data you want to format as a table and then select the format as table from the styles options on the home tab. The first row of the selected range can be assigned as the table headings. Table headings are used by Excel to allow you to simply sort data within the table. You can sort data alphabetically, by color, or by using number filters.
For an great tutorial on data tables in Excel, read Using Excel Data Table to Compare Mathematical Results
What is a Macro in Excel and how would you create an Excel Macro?
Excel Macros as sets of instructions that a user records for repetition purposes. Users create macros for repetitive instructions and functions they perform on a regular basis. To record an Excel macro, you need to select record macro from the developers tab and then record the instructions used in the worksheet. Macros can be triggered via a keyboard shortcut.
Recording Macros from Udemy offers you a comprehensive course on how to build macros to carry out repetitive tasks in Excel.
These are just a few of the tricks that Excel offers. Keep learning to unlock all the functions of this program and make any Excel interview question a breeze!