Aptitude Tests, Mental Ability, Objective MCQ Sets, Questions and Answers, PDF, Shortcut Tips

Microsoft Excel → Page 5

Microsoft Excel solved MCQ sets : MS Excel Questions Answers (MCQ -Multiple Choice, Objective Type) Online test : Microsoft Excel is a spreadsheet software and is part of the widely used MS Office Package. Here you will find a great collection of Multiple Choice (MCQ)Questions in the category of Microsoft Excel with answer. Most of the questions are applicable to all versions of M...READ MORE


TEST INSTRUCTION: CLICK OPTION (A, B, C, D) TO SEE ANSWER.




Q.

1. How many sheets are there, by default, when we create a new Excel file ?

A.
1
B.
3

C.
5
D.
10


Show Answer
Q.

2. In Excel, which one denoted a range from B1 through E5

A.
B1 - E5
B.
B1:E5

C.
B1 to E5
D.
B1$E5


Show Answer
Q.

3. An Excel file is generally called a / an :

A.
E-Spreadsheet
B.
Woorksheet

C.
Workbook
D.
Sheet


Show Answer
Q.

4. It is a collection of data that is stored electronically as a series of records in a table.

A.
spreadsheet
B.
presentation

C.
database
D.
MS Word


Show Answer
Q.

5. What type of chart will you use to compare performance of sales of two products ?

A.
Column Chart
B.
Line Chart

C.
Pie Chart
D.
Both A and B


Show Answer