aKidsZone
Home
MCQs
Computer — Quiz
Microsoft Excel MCQ Questions Part 6
50 questions · Test your knowledge
Home
/
MCQs
/
Microsoft Excel MCQ Questions Part 6
1
Which menu option can be used to split windows into two?
A
Format -> Window
B
View -> Window-> Split
C
Window -> Split
D
View –> Split
2
Getting data from a cell located in a different sheet is called
A
Accessing
B
Referencing
C
Updating
D
Functioning
3
Which of the following is not a valid data type in Excel?
A
Number
B
Character
C
Label
D
Date/Time
4
Which elements of a worksheet can be protected from accidental modification?
A
Contents
B
Objects
C
Scenarios
D
All of above
5
A numeric value can be treated as label value if …… precedes it.
A
Apostrophe
B
Exclamation
C
Hash
D
Tilde
6
Concatenation of text can be done using
A
Apostrophe
B
Exclamation
C
Hash
D
Ampersand
7
Which area in an Excel window allows entering values and formulas?
A
Title Bar
B
Menu Bar
C
Formula Bar
D
Standard Tool Bar
8
Multiple calculations can be made in a single formula using…..
A
Standard Formulas
B
Array Formula
C
Complex Formulas
D
Smart Formula
9
An Excel Workbook is a collection of …….
A
Workbooks
B
Worksheets
C
Charts
D
Worksheets and Charts
10
What do you mean by a Workspace?
A
Group of Columns
B
Group of Worksheets
C
Group of Rows
D
Group of Workbooks
11
MS-EXCEL is based on ……….?
A
WINDOWS
B
DOS
C
UNIX
D
OS/2
12
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
13
To select an entire column in MS-EXCEL press?
A
CTRL + C
B
CTRL + Arrow key
C
CTRL + S
D
None of above
14
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
A
ROUND
B
FACT
C
MOD
D
DIV
15
Which function is not available in the Consolidate dialog box?
A
Pmt
B
Average
C
Max
D
Sum
16
Which is not the function of “Edit Clear†command?
A
Delete contents
B
Delete notes
C
Delete cells
D
Delete formats
17
Microsoft Excel is a powerful………..
A
Word processing package
B
Spreadsheet package
C
Communication S/W Package
D
DBMS package
18
How do you rearrange the data in ascending or descending order?
A
Data Sort
B
Data Form
C
Data Table
D
Data Subtotals
19
Which Chart can be created in Excel?
A
Area
B
Line
C
Pie
D
all of above
20
What will be the output if you format the cell containing 5436.8 as ‘###0.00′?
A
5430
B
5436.8
C
5436.8
D
6.8
21
How do you display current date and time in MS Excel?
A
date
B
Today
C
now
D
time
22
How do you display current date only in MS Excel?
A
date
B
Today
C
now
D
time
23
How do you wrap the text in a cell?
A
Format cells font
B
Format cells protection
C
format cells number
D
Format cells alignment
24
What does COUNTA () function do?
A
counts cells having alphabets
B
counts empty cells
C
counts cells having number
D
counts non-empty cells
25
What is the short cut key to highlight the entire column?
A
Ctrl+C
B
Ctrl+Enter
C
Ctrl+Page Up
D
Ctrl+Space Bar
26
In the formula which symbol specifies the fixed columns or rows?
A
$
B
*
C
%
D
&
27
Excel displays the current cell address in the ……….
A
Formula bar
B
Status Bar
C
Name Box
D
Title Bar
28
What is the correct way to refer the cell A10 on sheet3 from sheet1?
A
sheet3!A10
B
sheet1!A10
C
Sheet3.A10
D
A10
29
Which language is used to create macros in Excel?
A
Visual Basic
B
C
C
Visual C++
D
Java
30
Which of the following is not a term of MS-Excel?
A
Cells
B
Rows
C
Columns
D
Document
31
How many worksheets can a workbook have?
A
3
B
8
C
255
D
None of above
32
Which would you choose to create a bar diagram?
A
Edit Chart
B
Insert Chart
C
Tools Chart
D
Format Chart
33
Which setting you must modify to print a worksheet using letterhead?
A
Paper
B
Margin
C
Layout
D
Orientation
34
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
A
XY Chart
B
Line Chart
C
Pie Chart
D
Column Chart
35
The spelling dialog box can be involved by choosing spelling from ________ menu.
A
insert
B
file
C
tools
D
view
36
Which key do you press to check spelling?
A
F3
B
F5
C
F7
D
F9
37
To record a sequence of keystrokes and mouse actions to play back later we use
A
Media player
B
Sound Recorder
C
Calculator
D
Macro Recorder
38
We can save and protect the workbook by
A
Write Reservation Password
B
Protection Password
C
Read-only Recommended
D
Any of the above
39
The first cell in EXCEL worksheet is labeled as
A
AA
B
A1
C
Aa
D
A0
40
What happens when dollar signs ($) are entered in a cell address?
A
An absolute cell address is created.
B
Cell address will change when it is copied to another cell.
C
The sheet tab is changed.
D
The status bar does not display the cell address.
41
What are the tabs that appear at the bottom of each workbook called?
A
Reference tabs
B
Position tabs
C
Location tabs
D
Sheet tabs
42
What is represented by the small black square in the lower-right corner of an active cell or range?
A
Copy handle
B
Fill handle
C
Insert handle
D
Border
43
In Excel a Data Series is defined as what?
A
A type of chart.
B
A cell reference.
C
A collection of related data
D
A division of results
44
In Excel the Fill Color button on the Formatting toolbar is used for what?
A
To insert a background.
B
To add borders.
C
To select a distribution of figures.
D
To add shading or color to a cell range.
45
In help menu of Excel which of the following tabs are found?
A
Contents tab
B
Answer Wizard tab
C
Index tab
D
All of above
46
A __________ is a grid with labeled columns and rows.
A
Dialog box
B
Worksheet
C
Clipboard
D
Toolbar
47
The active cell:
A
is defined by a bold border around the cell.
B
Receives the data the user enters.
C
It is the formula bar
D
Only A and B.
48
Which function is used to calculate depreciation rates of return future values and loan payment amounts?
A
Logical
B
Math & Trigonometry
C
Statistical
D
Financial
49
B7:B9 indicates
A
Cells B7 and cell B9 only.
B
Cells B7 through B9
C
Cell B8 only
D
None of above
50
The Cancel and Enter buttons appear in the
A
Title bar
B
Formula bar
C
Menu bar
D
Sheet tabs
Submit Quiz
Back to All Quizzes