MS Word Test 04

Total Questions: 31

1 - Spreadsheet is a computer program used to....data for record keeping

A ) Enter
B ) Analyze
C ) Calculate
D ) All of these

2 - Spreadsheet stores and presents data in

A ) Rows
B ) Columns
C ) A and b
D ) Paragraphs

3 - Data can easily be.... from spreadsheet

A ) Entered
B ) Modified
C ) Erased
D ) All of these

4 - Spreadsheets are used in different fields for various purpose like

A ) Accounting and budgeting
B ) Charting and financial analysis
C ) Graphing and scientific application
D ) All of these

5 - Excel is one of the well known and commonly used..... software

A ) Pirated
B ) Spreadsheet ✅
C ) Antivirus
D ) PowerPoint

6 - Excel can be used for

A ) Storing data
B ) Organizing data
C ) Manipulating data
D ) All of these

7 - In excel horizontal and vertical rows are identified by

A ) Numbers and alphabets ✅
B ) Numbers and digits
C ) Alphabets and digits
D ) Digits and shapes

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

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

9 - MS Excel 2007 workbook is stored with extension

A ) xis
B ) xisx ✅
C ) xsl
D ) xsix

10 - A worksheet is a single page in a

A ) Row
B ) Column
C ) Workbook ✅
D ) All of these

12 - In excel window the office button is located at the.....corner

A ) Top right
B ) Top left ✅
C ) Bottom right
D ) Bottom left

13 - When office button is clicked

A ) Excel is closed
B ) Office menu appears ✅
C ) New workbook is created
D ) New worksheet is created

15 - On the title bar, Microsoft excel shows the name of the.... currently used

A ) Application
B ) Program
C ) Workbook ✅
D ) Software

16 - On the right side of the title bar which buttons appeared

A ) Minimize and restore
B ) Maximum and close
C ) A and b
D ) Save and undo

17 - Formula bar displays the contents of

A ) Active cell and formulae ✅
B ) Active program and formulae
C ) Active application and formulae
D ) Active drive and formulae

18 - In MS Name Box can be used to go to a

A ) Specific program by entering the name of the program
B ) Particular cell by entering the name of the cell ✅
C ) Specific application by entering the name of the application
D ) None of these

19 - At the bottom of each worksheet there is a

A ) Formula bar
B ) Name Box
C ) Numbered sheet tab ✅
D ) Title bar

20 - Numbered sheet tabs are used to access....in a workbook

A ) Different worksheet ✅
B ) Different cells
C ) Different rows
D ) Different columns

21 - The basic Elements of a worksheet are

A ) Columns
B ) Rows
C ) Cells
D ) All of these

22 - Columns and rows in a worksheet are

A ) Columns
B ) Rows
C ) Cella
D ) All of these

23 - Columns and rows in a worksheet are managed

A ) Vertically, parallel
B ) Vertically, horizontally ✅
C ) Perpendicular, straight
D ) Circular, horizontally

24 - What is the basic unit in the worksheet

A ) Row
B ) Column
C ) Cell
D ) Title bar ✅

25 - In MS Excel worksheet cell reference are used in

A ) Formulae
B ) Function
C ) Charts
D ) All of these

27 - In MS Excel worksheet data manipulation means

A ) Entering data
B ) Editing data
C ) Formatting data
D ) All of these

28 - Doing any change in excel worksheet is called

A ) Entering data
B ) Deleting data
C ) Editing data ✅
D ) Formatting data

29 - The fill handle in excel window is located at the.....of

A ) Left corner
B ) Right corner ✅
C ) Bottom left
D ) Top right

30 - A.....is an equation that perform calculation using values in the worksheet

A ) Formula ✅
B ) Editing
C ) Manipulation
D ) Formatting