MS Excel

Question 1

Comments put in cells are called …

Answer 1

Cell Tip

Question 2

Comments can be added to cells using …

Answer 2

Insert -> Comment

Question 3

Which menu option can be used to split windows into two?

Answer 3

Window -> Split

Question 4

Getting data from a cell located in a different sheet is called …

Answer 4

Referencing

Question 5

Which of the following is not a valid data type in Excel?

a. Number
b. Character
c. Label
d. Date/Time

Answer 5

Character

Question 6

Which elements of a worksheet can be protected from accidental modification?

a. Contents
b. Objects
c. Scenarios
d. All of the above

Answer 6

d. All of the above

Question 7

A numeric value can be treated as label value if _________ precedes it.

Answer 7

Apostrophe ( ‘ )

Question 8

Concentration of text can be done using _____.

a. Apostrophe
b. Exclamation
c. Hash
d. Ampersand

Answer 8

d. Ampersand (&)

Question 9

Which area in an Excel window allows entering values and formulas?

Answer 9

Formula Bar

Question 10

Multiple calculations can be made in a single formula using ______.

a. Standard Formula
b. Array Formula
c. Complex Formula
d. Smart Formula

Answer 10

b. Array Formula

Question 11

An Excel Workbook is a collection of?

Answer 11

Worksheets and Charts

Question 12

What do you mean by a Workspace?

a. Group of Worksheets
b. Group of Rows
c. Group of Workbooks

Answer 12

c. Group of Workbooks

Question 13

MS-Excel is based on?

a. Windows
b. DOS
c. UNIX
d. OS/2

Answer 13

a. Windows

Question 14

In Excel, you can sum a large range of data by simply selecting a tool button called ______ ?

Answer 14

Auto Sum

Question 15

In Excel, you can sum a large range of data by simply selecting a tool button called ______ ?

a. AutoFill
b. Auto Correct
c. Auto Sum
d. Auto Format

Answer 15

c. Auto Sum

Question 16

To select an entire column in MS-Excel, press ______?

a. Ctrl + C
b. Ctrl + Arrow Key
c. Ctrl + S
d. None of the above

Answer 16

d. None of the above

Question 17

We use this function to return the remainder after a number is divided by a divisor in Excel.

a. ROUND ( )
b. FACT ( )
c. MOD ( )
d. DIV ( )

Answer 17

c. MOD ( )

Question 18

Which function is not available in the Consolidate dialog box?

a. Pmt
b. Average
c. Max
d. Sum

Answer 18

a. Pmt

Question 19

Which is not the function of “Edit, Clear” command?

a. Delete Contents
b. Delete Notes
c. Delete Cells
d. Delete Formats

Answer 19

c. Delete Cells

Question 20

Microsoft Excel is a powerful _____.

a. Word Processing Package
b. Spreadsheet Package
c. Communication S/W Package
d. DBMS Package

Answer 20

b. Spreadsheet Package

Question 21

How do you rearrange the data in ascending or descending order?

a. Data, Sort
b. Data, Form
c. Data, Table
d. Data Subtotals

Answer 21

a. Data, Sort