Q1. What is Microsoft Excel?

Answer: Microsoft Excel is an electronic spreadsheet program, created by multiple highly skilled
engineers from Microsoft. It enables users to organize, format, and calculate data with formulas using a
spreadsheet system broken up by rows and column. We also use this tool for storing, organizing and
manipulating the data. In addition, it also offers programming that supports VBA, and we can use
external database to make dynamic reports, analysis etc. Smart use of this program saves a lot of time
and helps in creating our own applications too.

Q2. What is Ribbon in MS-Excel?

Answer: The ribbon in Excel consists of the tabs at the top. These tabs are split into groups which
categorize related command buttons into sub tasks. Each group has its respective command button and
the dialog box launcher, which are present in the lower right corner in some of the groups. This opens a
dialog box containing a bunch of additional options we can choose from.

As per Excel’s default settings, we have 8 tabs.

Which are: File

 Home

 Insert

 Page Layout

 Formulas

 Data Review View

Q3. How many rows and columns are there in Microsoft Excel 2003 and later versions?

Answer: Refer to the table below for the number of rows, columns and cells for Microsoft Excel 2003 &
later version:-

Excel Versions Rows Columns Total Cells

MS Excel 2003 65536 256 16777216

MS Excel 2007 1048576 16384 17179869184

MS Excel 2010 1048576 16384 17179869184

MS Excel 2013 1048576 16384 17179869184

 Q4. Which option do we use to adjust the text within a cell and what is the procedure to do it?

Press Ctrl+1 on your keyboard Format cells dialog box will appear

 In the Alignment Tab

 Click on Wrap tex

t And then click on OK

Q5. What is the shortcut to put the filter on data in Microsoft Excel 2013?

Answer: Ctrl+Shift+L is the shortcut key to put the filter in data.

Q6. How many report formats are available in Excel and what are their names?

Answer: In Excel, we have three formats available:

 Compact
 Report
 Tabular

Q7. What is the difference between function and formula in MS-Excel?

Answer:

Q8. What is the process of making a chart and why is it important to make it right?

Answer: Chart is a medium to present the data in graphical visualization, and it is the most important
insight of the data. To present the data with perfect visualization and appropriate information, we
should always pre-decide on the information to be presented. We prepare the chart and then format it
in presentable format.

Q9. What is IF function in Microsoft Excel?

Answer: ‘If function’ is one of the logical functions in Excel. We use this function to check the logical
condition and specify the value whether it’s true or false. ‘If function’ has three arguments but only first
argument is mandatory and other two are optional.

Q10. What is mean by cell?.

Ans: Cell is a combination of rows and columns

Q11. What is file extension or file type of excel?.

Ans: .xls

Q12. Name at least six file extensions of Microsoft access

Some of the file extensions present in MS Access are

► Access blank project template .adn
► Access database .accdb
► Access project .adp
► Access Workgroup .mdw
► Protected access database .accde
► Access workgroup .mdw

Q13. What is meant by MS Access?

MS Access is defined as a database computer program by Microsoft used to organize and

use information for home or business. An example of MS Access is a program for keeping
detailed notes about all your business contacts.

Q14. What is Primary key in access?

A primary key is a field or set of fields with values that are unique throughout a table. Values of
thekey can be used to refer to entire records, because each record has a different value for
the key. ...Access automatically manages primary keys for new tables in Access web apps
and web databases.

Q14. File extension for database?

 .csv - Comma separated value file

 .dat - Data file
 .db or .dbf - Database file
 .log - Log file
 .mdb - Microsoft Access database file
 .sav - Save file (e.g., game save file)
 .sql - SQL database file
 .tar - Linux / Unix tarball file archive
 .xml - XML file

Q15. Explain about query?

A query is a request for data results, and for action on data. You can use a query to
answer a simple question, to perform calculations, to combine data from different
tables, or even to add, change, or delete table data.

Q16. How you can create query in ms access 2003?

 Open your database

 Go to -> create tab
 Click on the query wizard icon
 Select a query type
 From the pull-down menu choose the appropriate table
 Select the field you want in the query results
 To add information from additional tables, repeat steps 5 and 6
 Click on next
 Choose the type of results that you would like to produce
 Give your query a title
 Click on finish

Q17. Explain how you can create a form in Microsoft Access 2013?

Forms allow to insert data across multiple tables. There are different methods for creating forms
but with Form Wizard method, you can always modify the form later using Design View. To
create a form

 From the main menu, click on CREATE and then choose the FORM option
 It will create a new form in Layout view, based on the fields in the Customer table
  Scroll the drop down arrow under the View icon and select Form View. This how the
user will see the form.
 On the form, you will see fields like CustomerId, First Name, Last Name and Date
Created
 After filling of all details in the form, you can see the newly created record with data in
the table
 Once you completed filling the field in the form, confirm that you click on the save
button on the top of the ribbon

Q18. In MS Access 2013 what are the different ways you can enter data?

Different methods you can enter data in MS Access are

 Datasheet View
 Form
 SQL View
 Import from External Data (XML, Data Services, HTML etc.)

Q19. Explain how MS Access is better than MS SQL Server?

 With a small number of users, MS Access is easy to handle and suited for desktop use
 Easy compatibility and sharing compare to MS SQL Server
 SQL server is, usually, used by developers and in a bigger organization
 MS Access is cheaper than MS SQL
 MS Access requires less database administration
Q20. What are the most important data formats seen in Excel, and how are they used?

Numbers.

Dates.

Percentages.

Strings.

Q21. What is the order of operations used when evaluating formulas in Excel?

Excel uses an order of operations when evaluating different operators within

the formula bar.

 Parentheses
  Exponents
 Multiplication
 Division
 Addition
 Subtraction
Q22. What is a function in Excel?

The name of the function is like the title of the recipe. It describes what the
function does, like take a SUM or an AVERAGE.

Q23. Explain Macro in MS-Excel.

Macros are used for iterating over a group of tasks. Users can create macros for their
customized repetitive functions and instructions. Macros can be either written or
recorded depending on the user.

Q24. Explain few useful functions in Excel.

Following are the functions available in Excel for manipulating the data:

 Math and Financial Functions – SQRT, DEGREE, RAND(), GCD

 Logical Functions – IF, AND, FALSE, TRUE
 Date and Time functions – NOW(), DATEVALUE(), WEEKDAY(NOW())
 Index Match – VLOOKUP and INDEX MATCH
 Pivot tables

Q25. How can you add a new Excel worksheet?

To add a new Excel worksheet, you should insert worksheet tab at the bottom of the
screen.

Q26. What is the use of NameBox in MS-Excel?

Name Box is used to return to a particular area of the worksheet by typing the range
name or cell address in the name box.

Q27. Explain pivot tables and its uses.

A pivot table is a tool that allows for quick summarization of large data. It automatically
performs a sort, count, total or average of the data stored in the spreadsheet and displays
result in another spreadsheet. It saves a lot of time. Allows to link external data sources to
our Excel.
Q28. What are three report formats that are available in Excel?

Following are the types of report formats

 Compact
 Report
 Tabular

Q29. What is the use of LOOKUP function in Excel?

In Microsoft Excel, the LOOKUP function returns a value from a range or an array.

Q30. What is the benefit of using formula in Excel sheet?

Calculating the numbers in Excel sheet, not only help you to give the final 'sum up' of the
number but, it also calculates automatically the number replaced by another number or
digit. Through Excel sheet, the complex calculations become easy like payroll deduction or
averaging the student's result.

Q31. What is the "What If" condition in Excel formulas?

The "What If" condition is used to change the data in Microsoft Excel formulas to give
different answers.

Q32. Why are charts used?

A chart helps to present the data in graphical visualization. It helps the user to
understand the data and highlights the important insights of the data. It helps to
give the appropriate information to the user.

Q33. What is Freeze Panes in MS Excel? What steps do you use to freeze
columns?

Freeze panes freezes or locks any row or column on the screen and still, it will
be visible on the screen. Even if you scroll your screen horizontally or vertically
you will be able to see those locked rows or columns. In order to freeze
columns, select the cell immediately to the right of the column you want to
freeze. The next step is to go to the View tab, select the freeze panes command
and choose "Freeze Panes".