0

Computer Basics

Description: An Introductory Test to Check the Knowledge of Students in Computer Basics
Number of Questions: 25
Created by:
Tags: Computer Basic Fundamentals Computer Fundamentals Fundamental of Computers Basics of Computers Computer Basics Databases
Attempted 0/25 Correct 0 Score 0

When did Microsoft release the first window version of Excel?

  1. 1987

  2. 1982

  3. 1988

  4. 1993


Correct Option: A

How many rows are there in an MS Excel Sheet?

  1. 65, 536

  2. 65, 586

  3. 65, 546

  4. 65, 596


Correct Option: A

How many columns are there in an MS Excel Sheet?

  1. 296

  2. 256

  3. 276

  4. 286


Correct Option: B

How many sheets are there in a new MS Excel workbook?

  1. 2

  2. 3

  3. 4

  4. 5


Correct Option: B

Which operator combines multiple references into one reference?

  1. : (colon)

  2. , (comma)

  3. (space)

  4. None of these


Correct Option: A

What is the extension of an Excel file?

  1. .txt

  2. .rft

  3. .xls

  4. .doc


Correct Option: C

When was the first spreadsheet program marketed by Microsoft?

  1. 1985

  2. 1983

  3. 1987

  4. 1982


Correct Option: D

Intersection of rows and columns is called

  1. text box

  2. formula bar

  3. cell

  4. range


Correct Option: C

A group of related cells in an excel worksheet is called a

  1. function

  2. cell reference

  3. range

  4. textbox


Correct Option: C

Which operator is known as Concatenation Operator in Excel?

  1. %

  2. $

  3. &

  4. #


Correct Option: C

A DBMS is a collection of interrelated data and programs.

  1. True

  2. False


Correct Option: A

In hierarchical system, data is stored in the form of parent-child relationship.

  1. True

  2. False


Correct Option: A

FMS (File Management System) allows relations to be set between records.

  1. True

  2. False


Correct Option: B

One can edit formula only in formula bar.

  1. True

  2. False


Correct Option: B

Address of a worksheet cell is defined as its column name, followed by its row name.

  1. True

  2. False


Correct Option: A

Function NOW () returns the serial number of current date and time.

  1. True

  2. False


Correct Option: A

Excel supports ___ different types of operators.

  1. 2

  2. 3

  3. 4

  4. 5


Correct Option: C

Today () function converts the serial number of particular time.

  1. True

  2. False


Correct Option: B

________ was the first method used to store data in a computerized database.

  1. File Management System

  2. Network Database System

  3. Relation Database System

  4. Hierarchical Database System


Correct Option: A

________operators are used to compare two values.

  1. Comparison

  2. Arithmetic

  3. Concatenation

  4. Reference


Correct Option: A

________operators are used to perform basic mathematical operations.

  1. Comparitive

  2. Arithmetic

  3. Concatenative

  4. Reference


Correct Option: B

________operators are used to join one or more text strings to produce a single piece of text.

  1. Comparison

  2. Arithmetic

  3. Concatenation

  4. Reference


Correct Option: C

________operators are used to combine the ranges of cells for calculation.

  1. Comparison

  2. Arithmetic

  3. Concatenation

  4. Reference


Correct Option: D

Sum (number1, number2 …) adds the specified arguments.

  1. True

  2. False


Correct Option: A

________ stores data in the form of a parent-child relationship.

  1. File Management System

  2. Network Database System

  3. Relation Database System

  4. Hierarchical Database System


Correct Option: D
- Hide questions