Microsoft Office-Microsoft Excel (Bank-PO Computer-Basics): Questions 1 - 8 of 12

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 395 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 250.00 or

Question number: 1

» Microsoft Office » Microsoft Excel

MCQ▾

Question

Short cut key to enter the current time in an Excel sheet:

Choices

Choice (4) Response

a.

Ctrl + Shift +@

b.

Ctrl + Shift +;

c.

Ctrl +’

d.

Ctrl + Page up

Question number: 2

» Microsoft Office » Microsoft Excel

MCQ▾

Question

By which command we can create a table from a query?

Choices

Choice (4) Response

a.

Make table query

b.

Cross table query

c.

Append query

d.

None of the above

Question number: 3

» Microsoft Office » Microsoft Excel

MCQ▾

Question

In Excel, by default Numeric Values appears in

Choices

Choice (4) Response

a.

Chart Wizard

b.

Center aligned

c.

Right aligned

d.

Question does not provide sufficient data or is vague

Question number: 4

» Microsoft Office » Microsoft Excel

MCQ▾

Question

To access a mainframe or supercomputer, users often use a ________.

Choices

Choice (4) Response

a.

Terminal

b.

Desktop

c.

node

d.

Handheld

Question number: 5

» Microsoft Office » Microsoft Excel

MCQ▾

Question

The formulae in Excel are made up of -

Choices

Choice (4) Response

a.

only arithmetic operator

b.

only symbols

c.

arithmetical operators and functions

d.

only functions

Question number: 6

» Microsoft Office » Microsoft Excel

MCQ▾

Question

In Microsoft Excel, which of the following formulas is incorrect?

Choices

Choice (4) Response

a.

=AVG (B2 + C2 + D2) /3

b.

=ROUND (SUM (A1: C2), 2)

c.

Both a. and b. are correct

d.

None of the above

Question number: 7

» Microsoft Office » Microsoft Excel

MCQ▾

Question

Types of charts that can be created in a MS-Excel include all EXCEPT a ________ chart.

Choices

Choice (4) Response

a.

bar

b.

scatter

c.

pie

d.

block

Question number: 8

» Microsoft Office » Microsoft Excel

MCQ▾

Question

Each box in a spreadsheet is called a ________.

Choices

Choice (4) Response

a.

Cell

b.

File

c.

Record

d.

Both a. and b. are correct

Sign In