Information Technology Quiz – 31

1. How can we remove the border applies in cells?
(A) Open the list on border tool in format cell toolbar then choose first option none
(B) Choose none on the border tab of format cells
(C) Both A & B
(D) None of these

2. Microsoft is powerful?
(A) Data maintaining software
(B) Database package
(C) Spreadsheet package
(D) Word processing package

3. In MS Excel, how to rearrange data in ascending or descending order?
(A) Data table
(B) Data sort
(C) Data format
(D) Data form

4. Which of the following chart can be created in MS excel?
(A) Line chart
(B) Pie chart
(C) Stack chart
(D) All of the above

5. In MS excel how a current date can be displayed?
(A) Date()
(B) Now()
(C) Current()
(D) DateTime()

6. MS excel is based on?
(A) OS/2
(B) DOS
(C) UNIX
(D) Windows

7. In MS excel a workspace is a____?
(A) Group of workbooks
(B) Group of columns
(C) Group of rows
(D) Group of sheets

8. In MS excel to return the remainder of a number after the divide, which of the following function is used?
(A) DIV()
(B) AVG()
(C) MOD()
(D) None of these

9. In MS excel to display the sum of large data can be displayed by which of the following selecting a tool button?
(A) Auto SUM
(B) Autofill
(C) Auto correct
(D) All of the above

10. In MS excel which of the following function is not available in a consolidated dialog box?
(A) Sum
(B) Pmt
(C) Div
(D) Count