Basics of Information Technology Test 09

Total Questions: 30

1 - Most commonly used spreadsheet program is

A ) PowerPoint
B ) MS Word
C ) Excel ✅
D ) Database

2 - A sheet with a grid of columns and rows is called

A ) Workbook
B ) Worksheet ✅
C ) Video
D ) Animation

3 - The horizontal rows in excel screen are identified by

A ) Alphabet
B ) Numbers ✅
C ) Special characters
D ) Symbols

4 - A sheet tab appears at the.....of Excel window

A ) Top
B ) Bottom ✅
C ) Left
D ) Right

5 - The vertical columns in Excel screen are identified with

A ) Alphabet ✅
B ) Numbers
C ) Special characters
D ) Symbols

6 - Which of the following is a file created by Excel spreadsheet application

A ) Worksheet
B ) Document
C ) Columns
D ) Workbook ✅

7 - By default,a workbook contains

A ) Six worksheets
B ) 5 worksheets
C ) 4 worksheets
D ) 3 worksheets ✅

8 - Combination of menus and buttons that performs actions when clicked

A ) Standard toolbar
B ) Title bar
C ) Status toolbar
D ) Menu bar ✅

9 - Gives access to frequently used commands

A ) Quick Access toolbar ✅
B ) Command buttons
C ) Active cell
D ) Title bar

10 - MS Excel displays the name of the workbook used currently

A ) Toolbar
B ) Menu bar
C ) Formula bar
D ) Title bar ✅

11 - Displays the contents of the active cell

A ) Menu bar
B ) Title bar
C ) Formula bar ✅
D ) Status bar

12 - Which of the displays the reference of the active cell

A ) Name Box ✅
B ) Main Cell
C ) Rows
D ) Command group

13 - Which of the following are used to access different worksheets in a workbook

A ) Rows.
B ) Columns
C ) Sheet tabs ✅
D ) Formula Bars

14 - Identifies the location of a cell or group of cells in a worksheet

A ) Active cell
B ) Formula
C ) Cell address ✅
D ) Border

15 - Which of the following involves entering, editing and formatting data

A ) Data Manipulation ✅
B ) Name Box
C ) Auto filling
D ) Copying

16 - Intersection of rows and columns is called

A ) Worksheet
B ) Cell ✅
C ) Workbook
D ) Alphabetic data

17 - User an also edit Data by pressing

A ) F2 ✅
B ) F1
C ) F4
D ) F3

18 - Each cell may contain

A ) Values
B ) Formula
C ) Label
D ) All of these

19 - The position of the cell in the Excel sheet is called its

A ) Cell position
B ) Formula bar
C ) Active Cell
D ) Cell Address ✅

20 - Data can be entered or edited in the.....of the Excel sheet.

A ) Cell position
B ) Formula Bar
C ) Active Cell ✅
D ) Cell Address

21 - Group of adjacent cells in the worksheet is

A ) Cell Range ✅
B ) Active Cell
C ) Cell Reference
D ) Passive Cell

23 - Use to perform a process and build up required formula

A ) Formula
B ) Values
C ) Cell Addresses.
D ) Operators ✅

24 - An area of memory in which user can store data temporarily

A ) Clipboard ✅
B ) RAM
C ) Cell Range
D ) Formula

26 - By default,text is aligned

A ) Left ✅
B ) Right
C ) Center
D ) Justified

28 - Instructions to perform a calculation

A ) Formulas ✅
B ) Values
C ) Label
D ) Text