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