MS EXCEL QUIZ | EXAMIANS

Which of the following methods cannot be used to enter data in a cell

Pressing the Esc key

Clicking on the formula bar

Pressing an arrow key

Pressing the Tab key

TRUE ANSWER : ?
YOUR ANSWER : ?

You can select a single range of cells by

Dragging over the desired cells

Pressing the Ctrl key while dragging over the desired cells

Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

Pressing the Shift key and an arrow key

TRUE ANSWER : ?
YOUR ANSWER : ?

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

Column Chart

XY Chart

Pie Chart

Line Chart

TRUE ANSWER : ?
YOUR ANSWER : ?

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

Work sheet

Data sheet

Macro sheet

Chart sheet

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the following is an absolute cell reference?

#a#1

$A$1

A1

!A!1

TRUE ANSWER : ?
YOUR ANSWER : ?

A typical worksheet has ___ number of columns.

128

256

1024

16384

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Data, Form

Data Subtotals

Data, Table

Data, Sort

TRUE ANSWER : ?
YOUR ANSWER : ?

The Cancel and Enter buttons appear in the:

Sheet tabs

Formula bar

Title bar

Menu bar

TRUE ANSWER : ?
YOUR ANSWER : ?

Which language is used to create macros in Excel?

Visual Basic

Java

Visual C++

C

TRUE ANSWER : ?
YOUR ANSWER : ?

Comments can be added to cells using

File > Comments

Insert > Comments

View > Comments

Edit > Comments

TRUE ANSWER : ?
YOUR ANSWER : ?