MS Excel Exam Paper

                                                     MS Excel Exam Paper 

MS Excel Exam Paper

Q1. How many rows and columns are there in Excel? 

Q2. Which shortcut can be used for inserting new row and column ?

Q3. Conditional formatting is used for data cleaning (T/F)

Q4. Vlookup command is used for data extraction (T/F)

Q5. Fill in the blanks 

1. Countif is used for __________________________

2. Sumif is for____________________________

3.Advance Excel Filter is used for _____________________________

Q6. Excel Pivot table can be extract data from Sql server 2008 (T/F)

Q7.The advantage of using a spreadsheet is

(1)For Calculations   (2)For Data Insertion (3)Simple database

Q7 The cell labeled F5 refers to 

row F column 5	column F row 5
functions available in cells	Function key F4

Question 6)

There are three types of data found in a spreadsheet.

data, words, numbers	equations, data, numbers
words, numbers, labels	d) numbers, formulas, labels

     

 

MS Office Exam Paper (Online Exam)

          Online Exams

MS Office Exam get Free 

Marks 25

EXAM Shahzad.cdcu@gmail.com

Section A: Short Answer Questions [10 marks]

1.What is operating system?2.Define the method of CUT-COPY-PASTE in windows?3.Write the Important Features of MS Word?4.Describe the various options available in the main menu bar of Ms-Word?5.In Word, which is the best view to use if you're running low on resources?6.Define Tack Change option and Task Pane?7.How can you highlight text without using the mouse?8.Which keyboard shortcut bolds selected text?9.How do you save a document in word?10.What is the function of UNDO command? 

Section B: Fill in the Blanks: [8 marks]

1. CTRL + S key is used for _______________________ 2.Print Preview is for _______________________ 

3. Microsoft Word is

 _______________________ 

4.

 _______________ 

Key moves your cursor from one cell to the next in a table.5.In page preview mode you can see

 _______________________ 

6. F2 key is used for 

 _______________________ 

7.

 _______________________ 

Keyboard shortcut bolds selected text.8.Task pane is

 _______________________ 

Section C: True/False: [7 marks]

1.The Table Auto Format command is located under the Format drop down menu.(T/F)2.Selecting a table and pressing the Del key will delete a table. (T/F)3.You can use either a numbered or lettered format for numbering lists. (T/F)

4.Word has three ways to copy text. (T/F)

5.You can move and copy text both within documents and between documents. (T/F)