MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Fundamentals
MS Excel
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Q.1
Which of the following is a popular DOS based spreadsheet package?
Word
Smart cell
Excel
Lotus 1-2-3
Q.2
An excel workbook is a collection of
Workbooks
Worksheets
Charts
Worksheets and charts
Q.3
Excel files have a default extension of in Excel-2003
Xls
Xlw
Wk1
123
Q.4
You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
Q.5
You can use the formula palette to
Format cells containing numbers
Create and edit formulas containing functions
Enter assumptions data
Copy a range of cells
Q.6
Microsoft Excel is a powerful ________
Word processing package
Spreadsheet package
Communication S/W Package
DBMS package
Q.7
How do you rearrange the data in ascending or descending order?
Data, Sort
Data, Form
Data, Table
Data Subtotals
Q.8
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
Q.9
What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ?
5430
5436.80
5436.8
6.8
Q.10
How do you display current date and time in MS Excel?
Date ()
Today ()
Now ()
Time ()
Q.11
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.
AutoFill
Auto correct
Auto sum
Auto format
Q.12
To select an entire column in MS-EXCEL, press?
CTRL + C
CTRL + Arrow key
CTRL + S
None of the above
Q.13
To return the remainder after a number is divided by a divisor in EXCEL we use the function?
ROUND ( )
FACT ( )
MOD ( )
DIV ( )
Q.14
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
Q.15
Multiple calculations can be made in a single formula using ________
Standard Formulas
Array Formula
Complex Formulas
Smart Formula
Q.16
An Excel Workbook is a collection of ________
Workbooks
Worksheets
Charts
Worksheets and Charts
Q.17
What do you mean by a Workspace?
Group of Columns
Group of Worksheets
Group of Rows
Group of Workbooks
Q.18
MS-EXCEL is based on ________
WINDOWS
DOS
UNIX
OS/2
Q.19
Getting data from a cell located in a different sheet is called ________
Accessing
Referencing
Updating
Functioning
Q.20
Which of the following is not a valid data type in Excel?
Number
Character
Label
Date/Time
Q.21
Which elements of a worksheet can be protected from accidental modification?
Contents
Objects
Scenarios
All of the above
Q.22
A numeric value can be treated as label value if ________ precedes it.
Apostrophe ( ‘ )
Exclamation ( ! )
Hash ( # )
Tilde ( ~ )
Q.23
Concatenation of text can be done using
Apostrophe ( ‘ )
Exclamation ( ! )
Hash ( # )
Ampersand ( & )
Q.24
You can move a sheet from one workbook into new book by
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
None of above
Q.25
What is the shortcut key to replace a data with another in sheet?
Ctrl + R
Ctrl + Shift + R
Ctrl + H
Ctrl + F
Q.26
Comments can be added to cells using ________
Home > Comments
Insert > Comment
Data > Comments
Review > Comments
Q.27
Which menu option can be used to split windows into two?
Review > Window
View > Window > Split
Window > Split
View > Split
Q.28
The Delete key of keyboard is assigned to which command in Excel?
Edit > Clear > Contents
Edit > Clear > All
Edit > Delete
All of above
Q.29
Edit > Delete command
Deletes the content of a cell
Deletes Formats of cell
Deletes the comment of cell
Deletes selected cells
Q.30
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must
From Edit menu choose Clear and then Formats
From Edit menu choose Delete
Click on Remove Formatting tool on Standard Toolbar
Double click the Format Painter and then press Esc key in keyboard
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page