excel exam
TRANSCRIPT
![Page 1: Excel Exam](https://reader036.vdocuments.us/reader036/viewer/2022082805/54fe00314a7959ba458b52e1/html5/thumbnails/1.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082805/54fe00314a7959ba458b52e1/html5/thumbnails/2.jpg)
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