excel exam

3
ID: Name: Semester: Department Bangladesh Skill Development Institute Spreadsheet Analysis Subject Teacher: Md. Aminul Islam Excel Skill Test –page 1 1. What type of chart is this? A: Doughnut B: Radar C: Bar D: Pie 2. What tool is used to split the window into different parts of the same worksheet? A: The title bar B: The scroll bar C: The toolbar D: The split box 3. What is the combination of keys required to come back to the top of the worksheet? A: PageUp (PgUp) B: Alt and PageUp C: Ctrl and Home D: Ctrl and left arrow 4. What function offers you the possibility to view different results depending on the entered condition? A: =If() B: =Sum() C: =SumIf() D: =TrueFalse() 5. What is the native file format for MS Excel? A: .doc B: .txt C: .xls D: .lxs

Upload: aminul-daffodil

Post on 08-Mar-2015

31 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Excel Exam

ID:Name:Semester: Department

Bangladesh Skill Development InstituteSpreadsheet Analysis

Subject Teacher: Md. Aminul Islam

Excel Skill Test –page 11. What type of chart is this?

A: Doughnut B: Radar C: Bar D: Pie

2. What tool is used to split the window into different parts of the same worksheet?

A: The title barB: The scroll bar C: The toolbarD: The split box

3. What is the combination of keys required to come back to the top of the worksheet?

A: PageUp (PgUp)B: Alt and PageUpC: Ctrl and HomeD: Ctrl and left arrow

4. What function offers you the possibility to view different results depending on the entered condition?

A: =If()B: =Sum()C: =SumIf()D: =TrueFalse()

5. What is the native file format for MS Excel?

A: .doc B: .txt C: .xls D: .lxs

6.How many rows are there in one excel sheet?

A: 10000 B: 65536 C: 7535 D: 7865

7.To arrange rows in alphabetical order based on column A, you need to use the command _____.

A:  Tools | Sort B: Data | Sort C:  Edit | Data | Sort D: none of the above

Page 2: Excel Exam

ID:Name:Semester: Department

Excel Skill Test –page 2

8.  The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is _____.

A: (D4+C2)*B2 B:  D4+C2*B2 C: =(D4+C2)*B2 D: =(B2*(D4+C2)

9. What is the name of the bar?

Ans:

10. If I need to arrange excel sheets what we can do?

ANS:

11. What is the difference between Save and Save AS?

Ans:

12. What is the use of Filter in Excel sheet?Ans:

13.Write a formula for calculate 20% from 5000.Ans:

14. Write down five tools name in Excel.

15. In previous class which Topic u likeed? Where u can use it.

Good Luck