Microsoft Excel Assessment Test

Q-1) What is Microsoft Excel?
Ans:
Microsoft Excel is an application of MS office Package which is an electronic spreadsheet application that enables users to store, organize, calculate and manipulate the data with formulas using a spreadsheet system.
Q-2) What is Spread sheet?
Ans:
Spread sheet is an electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
 Q-3) What is cell in Excel?
Ans:
A cell is the intersection between a row and a column on a spreadsheet.
 Q-4) What is ribbon?
Ans:
The "Ribbon" is the strip of buttons and icons located at topmost area of Excel application in Excel 2007.  
Q-5) How many data formats are available in Excel?
 Ans:
Eleven data formats are available in Microsoft Excel.
Number
: Stores data as a number
Currency : Stores data in the form of currency
Date : Data is stored as dates
Percentage : Stores numbers as a percentage
Text Formats : Stores data as string of texts
 Q-6) How can you wrap the text within a cell?
Ans:
You must select the text you want to wrap, and then click wrap text from the home tab and you can wrap the text within a cell.  
Q-7) How we protect the data in cell that No one  copying the cell from your worksheet?
Ans:
For this purpose Select the Review and then  Protect Sheet and then Password. By entering a password, you can secure your sheet from getting copied by others.
Q-8) Which of the following methods you use to zoom in?
1-Holding Ctrl key and scrolling the mouse wheel
2- Ctrl + + (Ctrl + Plus Sign)
3- Ctrl+Shift+z 
4- Ctrl+Shift+ +( Ctrl + Shift + Plus sign)
Q-9) Which of the following methods you use to Move in Next Work Sheet?
1-Ctrl+ S  key
2- ALt + Pag down Key
3- Ctrl + Page down key
4 -Ctrl+Shift+ Home
Q-10) How can you sum up the Rows and Column number quickly in the Excel sheet?
Ans:
Use AutoSum function to add a row or column. For this purpose highlight all of the cells you want to add up then click AutoSum on the Ribbon in the Editing group. This will quickly add the sum of your selected cells in a cell below or to the right of your selection.
Q-11) What does a red triangle at the top right of a cell indicate?
Ans:
The red triangle indicates that some comment is associated with the cell.
Q-12) Which shortcut key combinations would you use to quickly select the column that the selected cell (B4) is situated in?
1- Shift + Space
2- Ctrl + Space
3- Ctrl+Shift + Space
Q-13) If you quickly want to undo  an action in Excel, which shortcut keys would you use?
1-  Ctrl+z
2-  Ctrl+y
3-  Ctrl+u 
4-  Ctrl+n
5-  All of the above shortcut keys will work.
Q-14) Which shortcut key combination allows you to quickly select multiple adjacent groups of cells?
1- Alt+Arrow Keys
2- Ctrl+a
3- Ctrl+Arrow Keys
4- Ctrl+Shift+Arrow Keys
Q-15) What is the keyboard shortcut to display the Insert Hyperlink dialog box?
1- Ctrl + K
2- Ctrl + H
3- Ctrl + N
4- Ctrl + I
Q-16) To quickly insert new worksheets, which shortcut should you use?
1- Ctrl+N+W
2- Ctrl+F12
3- Ctrl+F11
4- Shift+F11
Q-17) When you right click on any cell then a menu is display. Which of the following shortcuts will allow you to access this menu without using your mouse?
1- SHIFT+F10
2- SHIFT+F4
3- SHIFT+%
4- SHIFT+@
Q-18) What are charts in MS-Excel?
Ans:
The  graphical representation of the data in Excel are called chart.
Q-19) What is pivot tables in Excel?
Ans:
A pivot table is a tool that allows for quick summarization of large data. It automatically performs a sort, count, total or average of the data stored in the spreadsheet and displays result in another spreadsheet.
Q-20) Which shortcut could you use to save a workbook under a different name (save as)?
1- Ctrl+S
2- Ctrl+N
3- F12
4- Ctrl+R
Q-21) Where will you find options to change the font type, size and color?
1- On the Home tab in the Text group.
2- On the Review tab in the Font group.
3- On the Page Layout group in the Font dialogue box.
4- On the Home tab in the Font group.
Q-22) What is Freeze Panes in MS-Excel?
Ans:
When we want to lock any row or column then we use  freeze panes option.
Q-23) What is the use of LOOKUP function in Excel?
Ans: In Microsoft Excel, the LOOKUP function returns a value from a range or an array.
Q-24) What happens when you press Ctrl+9 when a row is selected?
1- This hides the selected row(s)
2- This inserts a new row above the selected row
3- This deletes the row
4- This copies the content of the selected row to the clipboard
Q-25) Wrote the name of the very first Cell in Excel Sheet.
Ans:
Very First Cell is A1
Q-26) What is Cell Reference?
Ans:
A cell reference refers to a cell on a worksheet and can be used in a formula. its is also called cell Name or Box Name.
Q-27) What is Cell Range in Excel?
Ans:
Collection of More then one cell is called cell range. we also say that a range is block or group of cell which is refer in formula.
 Q-28) what is formula of adding two value for example A1 cell contain 50 and A2 cell Contain 40
Ans: The formula is =A1+A2 or we also use =Sum(A1:A2)
 Q-29) How we create a name by using the names of rows and column labels (Using Keyboard Short Cut)
1- Ctrl + Shift+F3
2- Ctrl+F3
3- Ctrl+Space
 Q-30)which short cut key is used for closing the Excel File ?
1- Ctrl+c
2- Ctrl + w
3- Ctrl + F4
  Q-31) which short cut key is used for Fill Down ?
1- Ctrl+D
2- Ctrl+F
3- Ctrl+F7
Q-32) which short cut key is used for Fill Right ?
1- Ctrl+D
2- Ctrl+R
3- Ctrl+F7
  Q-33) which short cut key is used for Recalculate all workbooks?  
1- Ctrl +R
2- F9
3- Ctrl +F9
  Q-34) which short cut key is used for inserting the New Chart?  
1- Ctrl +C
2- F11
3- Ctrl +F11  
Q-35) which short cut key is used for inserting the Current Time?
1- Ctrl +:
2- Ctrl + ;
3- Ctrl + T  
  Q-36) which short cut key is used for inserting the Current Date?  
1- Ctrl +D
2- Ctrl + Space
3- Ctrl + ;
Q-37) which short cut key is used for  Copy Value from Cell Above?
1- Ctrl +:
2- Ctrl + "
3- Ctrl + C
Q-38)What is Name in Excel?
Ans: You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.
 Q-39) which short cut key is used for  Defining the Name?
1- Ctrl + F3
2- F3
3- Ctrl + D
Q-40) which short cut key is used for  convert the cell value in Currency format?
1- Ctrl + Shift +$
2- Ctrl + F
3- Ctrl + Shift + C
Q-41)which short cut key is used to display the Format Cell Dialog Box?
1- Ctrl + F
2- Ctrl + 1
3- Ctrl + 2
  Q-42)which short cut key is used to BOLD the Cell Text? 1- Ctrl + B
2- Ctrl +2
3- Both
Q-43)Form which Menu we can define the Name for cell?
Ans:
Insert > Names > Define  
Q-44)How we format number in Comma Style?
Ans: To format numbers in Excel 2010 with the Comma style, follow these steps: Select the cells containing the numbers you want to format. On the Home tab, click the Number dialog box launcher. In the Category list, select Number. Select the Use 1000 Separator (,) check box. Click OK.
 Q-45) which short cut key is used to format the cell value in  Comma Style?
1- Ctrl + Shift + '
2- Ctrl +shift + !
3- Ctrl + Shift + "
Q-46) which short cut key is used to display the  Font  Drop Down List?
1- Ctrl + Shift + F
2- Ctrl +F2
3- Ctrl + Shift + F2
Q-47)which short cut key is used for  AutoSum?
1- Alt + =
2- Ctrl + A
3- Alt + +
Q-48) which short cut key is used to Print The File?
1- Ctrl + P
2- Ctrl +shift + P
3- Both
Q-49 which short cut key is Replace the word in Excel File?
1- Ctrl + R
2- Ctrl +H
3- Ctrl + F
Q-50) which short cut key is used to  Select current region ?
1- Ctrl + Shift + *
2- Ctrl + Shift + R
3- Ctrl + Shift + !





View and Download More Papers !

Microsoft Excel Assessment Test