MS Office
1-F11 creates a chart of the data in the current range in a separate Chart sheet.
2-F9 calculates all worksheets in all open workbooks.
3-Excel to hide a column ctrl + 0
4-To hide a row ctrl + 9
5-What function displays row data in a column or column data in a row: Transpose
6-No of types of sorting in MS excel: 2
7-When you insert an Excel file into a Word document, the data are: placed in word table
8-Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result, ans If
9-Each excel file is called a workbook because: It can contain many sheets including worksheets and chart sheets
10- No. of predefined charts in MS Excel: 8
11- Row and column combination is called: cell
12-What does the VLOOKUP function do?
13- You can edit a header by : double click on it
14- A function inside another function is called a ….. function: Nested
15- Sum is used for calculation of monthly income.
16- Arrow keys allow you to: move in a availble file
Plz correct if I am wrong

__________________
"Be satisfied with what Allah has alloted you and you will be the richest of people"