Excel

I. Explain the following concepts.
1. Excel: A software used to collect and organize data in rows and columns.
2Active cell: The cell that is selected inspreadsheet.
3. Formula Bar: It will display the contents of cells or allow you to type formulas.
4. Work sheet: It’s where you working.
5. Work sheet table: used toidentify sheets.
6. Book: It’s composed by a set of work sheets.
7. Formulas: where you can do operations with the content cells
8. Database: informationcaptured in a form of table.
II. Explain the following procedure
1. Increase of decrease decimals: Home-Number-increase/decrease decimals
2. Merge and center:Home-Alignment-merge and center
3. Auto zoom: With this button you can make zoom in many cells.
4. Create a chart: Select the cells-insert tab-choose the type ofchart-design-chart style-move chart
III.Write the syntaxes of the following functions
1. Averarge: AVERAGE(Arguments)
2. Count if:COUNTIF(range,criteria)
3.If:IF(Logic_test_value_if_true,value_if_false)
4: Addition: SUM(Arguments)
5. Multiplication: =(cell*cell)
6. Today’s date
IV. Answer the following
1. What is a range? Arange is a block of cells together, sometimes called a block. You use ranges in formulas.
2. Which is the alignment of numbers on text? Is used to improve thepresentation of the numerical and alphanumerical data contented in the cells.
3. Which one the default setting for Excel?
4. How can we insert a function?Formulas-insert function-select a categories-ok
5. How can we insert a comment?Review tab- comments-new coments
6. How can we determine the maximum or minimum wake of range?