MCQ

MCQ 11 Mark

The sample of an Excel worksheet on the screen can be seen by ………………..

✓
Print preview
B
Print
C
Review
D
None of the above

Answer

Correct option: A.

Print preview

Print preview enables you to view the sample of worksheet before printing it on a paper.

View full question & answer→

MCQ 21 Mark

For selecting the entire worksheet in Excel, you need to press ……………….

A
Alt + Shift + eSpacebar
✓
Ctrl + Shift + Spacebar
C
Shift + Spacebar
D
None of the above

Answer

Correct option: B.

Ctrl + Shift + Spacebar

You need to press Ctrl + Shift + Spacebar for selecting the entire worksheet in Excel.

View full question & answer→

MCQ 31 Mark

For selecting a non-continuous range of cells, you need to do what?

A
Press Alt key
✓
Press Shift key
C
Press Esc key
D
Press Ctrl key

Answer

Correct option: B.

Press Shift key

By pressing Ctrl key and clicking on the desired cells a non-continuous cell range can be selected.

View full question & answer→

MCQ 41 Mark

Which of the following shortcut keys brings the cursor to the last cell on the sheet that contains data?

A
Ctrl+Home
✓
Ctrl+End
C
Ctrl + Page down
D
Ctrl+down arrow

Answer

Correct option: B.

Ctrl+End

Ctrl+End shortcut is used to bring the cursor to the last cell.

View full question & answer→

MCQ 51 Mark

The another name for the XY chart is ……………….

A
Column chart
B
Net chart
C
Bar chart
✓
Scatter chart

Answer

Correct option: D.

Scatter chart

XY chart is also called Scatter chart.

View full question & answer→

MCQ 61 Mark

Which of the following chart selects only one range of the data series?

A
Line chart
✓
Pie chart
C
Scatter Chart
D
Bar chart

Answer

Correct option: B.

Pie chart

Pie chart can select only one range of the data series.

View full question & answer→

MCQ 71 Mark

Which of the following charts is used for comparing the changes in data over a period of time?

A
Bar chart
B
Area chart
C
Scatter chart
✓
Line chart

Answer

Correct option: D.

Line chart

Line chart emphasizes on rate of change rather than volume of change over time.

View full question & answer→

MCQ 81 Mark

A chart is created on the basis of values in ………………

A
mail merge
B
database
✓
spreadsheet
D
document

Answer

Correct option: C.

spreadsheet

A chart is a pictorial representation of data that created on the basis of values in a spreadsheet.

View full question & answer→

MCQ 91 Mark

You have used a spreadsheet to calculate the average marks of a class in Mathematics. Which input is essential to find the average marks?

A
Marks of each student of class in Science
✓
Marks of each student of class in Mathematics
C
Average marks in Mathematics of each student of class
D
Names and roll numbers of each student of class

Answer

Correct option: B.

Marks of each student of class in Mathematics

Marks of each student tor Mathematics will be required for calculating average marks of mathematics.

View full question & answer→

MCQ 101 Mark

in Excel chart, text displayed at data points to indicate the specific category is called ……………..

A
data point
B
data series
✓
data label
D
legends

Answer

Correct option: C.

data label

Text displayed at data points to indicate the specific category is called data label.

View full question & answer→

MCQ 111 Mark

You can place the chart legend in the chart at ……………..

A
Bottom
B
Corner
✓
Top, Right and Left
D
All of these

Answer

Correct option: C.

Top, Right and Left

You can place the chart legend in the chart at Bottom, Corner, Top, Right and Left.

View full question & answer→

MCQ 121 Mark

If you type =2 * (6-4) in cell Al, what value will be display?

A
2
✓
4
C
6
D
8

Answer

Correct option: B.

$=2^*(6-4)=2^{\star}(2)=4$

View full question & answer→

MCQ 131 Mark

$\text{COUNTA} (4, 78,$ False, $18)$ will return $…………$

A
$2$
B
$3$
✓
$4$
D
$5$

Answer

Correct option: C.

$4$

View full question & answer→

MCQ 141 Mark

If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display.

✓
22.167
B
27.167
C
10
D
40

Answer

Correct option: A.

22.167

View full question & answer→

MCQ 151 Mark

A cell range always has the symbol between the cell references.

A
; (semicolon)
B
. (full stop)
C
.(comma)
✓
:(colon)

Answer

Correct option: D.

:(colon)

A cell range always has the : (colon) symbol between the address of ranges

View full question & answer→

MCQ 161 Mark

A cell range starting from first row, first column to fourth row and fifth column can be represented as

✓
[A1 : E4]
B
[AO : E3]
C
[E4 : Al]
D
[E3 : AO]

Answer

Correct option: A.

[A1 : E4]

[A1:E4] because row count starts from 1 and column count starts from A and first we write the starting cell address.

View full question & answer→

MCQ 171 Mark

While entering a formula, cell address $B5$ represents

A
Absolute Referencing
✓
Mixed Referencing
C
Relative Referencing
D
All of these

Answer

Correct option: B.

Mixed Referencing

View full question & answer→

MCQ 181 Mark

Cell address $B5$ in a formula means

A
it is a mixed reference
B
it is an absolute reference
✓
it is a relative reference
D
None of the above

Answer

Correct option: C.

it is a relative reference

View full question & answer→

MCQ 191 Mark

Find out the odd one

A
Absolute
B
Relative
C
Mixed
✓
AutoFill

Answer

Correct option: D.

AutoFill

Absolute, relative and mixed all three are the types of cell referencing but AutoFill is not.

View full question & answer→

MCQ 201 Mark

Absolute cell referencing occurs when ……………

✓
formula is dragged but the cell references do not adjust.
B
spreadsheet is saved with “absolute” as file name.
C
formula is dragged and the cell reference adjusts automatically.
D
$ symbol is automatically added with each cell value.

Answer

Correct option: A.

formula is dragged but the cell references do not adjust.

Absolute cell referencing occurs when formula is dragged but the cell references do not adjust.

View full question & answer→

MCQ 211 Mark

The default alignment of text in a cell is

✓
Left
B
Right
C
Centered
D
Justified

Answer

Correct option: A.

Left

In Excel, by default the text is left aligned.

View full question & answer→

MCQ 221 Mark

A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell.

✓
Wrap
B
Line Break
C
Cell Break
D
Multiline Cell

Answer

Correct option: A.

Wrap

View full question & answer→

MCQ 231 Mark

Word wrapping means

A
the text remains in the straight line
✓
the text distributed in multiple lines
C
displays text vertically within a cell
D
displays the selected text in a different font style

Answer

Correct option: B.

the text distributed in multiple lines

Word wrapping distributes the text in multiple lines.

View full question & answer→

MCQ 241 Mark

The default page orientation in Excel is

A
Landscape
B
Horizontal
✓
Portrait
D
None of these

Answer

Correct option: C.

Portrait

The default page orientation in Excel is Portrait.

View full question & answer→

MCQ 251 Mark

The AutoFill can apply from

A
left to right
B
right to left
C
up to down
✓
All of these

Answer

Correct option: D.

All of these

View full question & answer→

MCQ 261 Mark

The simplest way to move data from one location to another in Excel is $………$

A
by Quick Access toolbar
B
using Cut and Paste
C
by the drag and drop method
✓
Both $(b)$ and $(c)$

Answer

Correct option: D.

Both $(b)$ and $(c)$

View full question & answer→

MCQ 271 Mark

By default, a workbook in Excel contains how many worksheets?

A
16
✓
3
C
15
D
256

Answer

Correct option: B.

3 worksheets are present in every workbook by default.

View full question & answer→

MCQ 281 Mark

A worksheet is a ……………….

A
collection of workbooks
B
processing software
✓
combination of rows and columns
D
None of the above

Answer

Correct option: C.

combination of rows and columns

A worksheet is a combination of rows and columns.

View full question & answer→

Information Technology MCQ

Test yourself on this topic