Join Us ::

Menu Home Classes GK Engineering Past Papers Current Affairs Technical GAT Subject Programming Medical Papers

Computer Science :: All Aptitude Test ::

Home » Engineering » Computer Science » Aptitude Test - 26
1.A features that displays only the data in column (s) according to specified criteria
A. Formula
B. Sorting
C. Filtering
D. Formula
2.Statistical calculations and preparation of tables and graphs can be done using
A. Adobe Photoshop
B. Excel
C. Notepad
D. Adobe Photoshop
3.What type of chart will you use to compare performance of two employees in the year 2016 ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Column Chart
4.Which one is not a Function in MS Excel ?
A. SUM
B. AVG
C. MAX
D. SUM
5.Functions in MS Excel must begin with ___
A. An () sign
B. An Equal Sign
C. A Plus Sign
D. An () sign
6.Which functionin Excel checks whether a condition is true or not ?
A. SUM
B. COUNT
C. IF
D. SUM
7.In Excel, Columns are labelled as ___
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. A, B, C, etc
8.The Greater Than sign (>) is an example of _____ operator.
A. Arithmatic
B. Logical
C. Conditional
D. Arithmatic
9.What type of chart is useful for showing trends or changes over time ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Pie Chart
10.The process of arrenging the items of a column in some sequence or order is known as :
A. Arrengin
B. Autofill
C. Sorting
D. Arrengin
11. The ____ feature of MS Excel quickly completes a series of data
A. Auto Complete
B. Auto Fill
C. Fill Handle
D. Auto Complete
12.What type of chart is useful for comparing parts of a whole ?
A. Pie Chart
B. Column Chart
C. Line Chart
D. Pie Chart
13. In Excel, Rows are labelled as ______
A. A, B, C, etc
B. 1,2,3 etc
C. A1, A2, etc.
D. A, B, C, etc
14.What do you use to create a chart?
A. Pie Wizard
B. Excel Wizard
C. Data Wizard
D. Pie Wizard
15.How will you graphically represent expenditure in different departments ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Column Chart
16.What type of chart is good for single series of data ?
A. Column Chart
B. Line Chart
C. Pie Chart
D. Column Chart
17.The basic unit of a worksheet into which you enter data in Excel is called a
A. cell
B. table
C. box
D. cell
18.Open the Save As dialog box
A. F1
B. F2
C. F10
D. F1
19.Which tool do you use to create a query object?
A. Table query wizard
B. Simple query wizard
C. Simple filer wizard
D. Table query wizard
20.In Access, ____ are used to store the data.
A. Report
B. Form
C. Table
D. Report
21.What is the maximum length a text field can be?
A. 72
B. 120
C. 255
D. 72
22.A _____ is an area reserved for a specific piece of data.
A. Report
B. Key
C. Record
D. Report
23.Microsoft Access is a _____
A. Network Database Model
B. RDBMS
C. ORDBMS
D. Network Database Model
24.Which of the following is not a type of Microsoft access database object?
A. Macros
B. Modules
C. Worksheets
D. Macros
25.A subset of characters within a data field is known as
A. Byte
B. File
C. Record
D. Byte
26.Press _____ to quit MS Access.
A. Tab +F4
B. Esc+ W
C. Ctrl +F4
D. Tab +F4
27.____ is not a valid data type in MS Access.
A. Auto number
B. Currency
C. Memo
D. Auto number
28._____ enables the user to automatically insert numbers in a sequential or random number.
A. Auto Number
B. Look up Wizard
C. Hyperlink
D. Auto Number
29.A file containing relatively permanent data is
A. Sequential file
B. Transaction file
C. Master file
D. Sequential file
30.The checking operation performed on input data is called the
A. Control of data
B. Validation of data
C. Cross check
D. Control of data
Related Subjects

Date to Date Current Affairs 2022

PakMCQs.net

Quick Links

GAT Subject



   Computer Science    English Mcqs    Agriculture    

Engineering



   Computer Science    Civil Engineering    

Technical



   Networking    Electronics    Database    

Past Papers



   Model Papers    FPSC Papers    
Our Team | Career | Contact | JoinUs | Privacy Policy | DMC

© 2020-2024 by Pak-MCQs.net All Rights Reserved.

Email: [email protected]