MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Fundamentals
MS Excel
Quiz 6
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 series type is not valid for Fill Series dialog box?
Linear
Growth
Autofill
Time
Q.2
Which of the following formulas will Excel not be able to calculate?
=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10
Q.3
A typical worksheet has ________ number of columns.
128
256
1024
16384
Q.4
How many characters can be typed in a single cell in Excel?
256
1024
32767
65535
Q.5
When you copy a formula
Excel erases the original copy of the formula
Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesn’t adjust relative cell references
Q.6
The autofill feature
Extends a sequential series of data
Automatically adds range of cell values
Applies a boarder around the selected cells
All of the above
Q.7
Which menu option can be used to split windows into two
Format > window
View > window > split
Window > split
View > split
Q.8
Which of the following is an absolute cell reference?
!A!1
$A$1
#a#1
A1
Q.9
To delete an embedded objects, first
Double click the object
Select the object by clicking it
Press the Shift + Delete keys
Select it and then press the delete key
Q.10
It is acceptable to let long text flow into adjacent cells on a worksheet when
Data will be entered in the adjacent cells
No data will be entered in the adjacent cells
There is no suitable abbreviation of the text
There is not time to format the next
Q.11
How can you delete a record?
Delete the column from the worksheet
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
Select Data > Delete Record from the menu
Click the Delete button on the Standard toolbar
Q.12
Right clicking something in Excel:
Deletes the object
Nothing the right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Q.13
What symbol is used before a number to make it a label?
” ( quote )
= ( equal )
_ ( underscore )
‘ ( apostrophe )
Q.14
Which of the following is not a worksheet design criterion?
Efficiency
Aditibility
Description
Clarity
Q.15
To copy cell contents using drag and drop press the
End key
Shift key
Ctrl key
Esc key
Q.16
Documentation should include
Destination and users of the output data
Source of input data
Information on the purpose of the workbook
All of the above
Q.17
Files created with Lotus 1-2-3 have an extension
DOC
XLS
123
WK1
Q.18
Which of the following is the latest version of Excel
Excel 2007
Excel 2016
Excel 365
Excel XP
Q.19
Which is not the function of "Edit, Clear" command?
Delete contents
Delete notes
Delete cells
Delete formats
Q.20
When the formula bar is active, you can see
The edit formula button
The cancel button
The enter button
All of the above
Q.21
The Cancel and Enter buttons appear in the:
Title bar
Formula bar
Menu bar
Sheet tabs
Q.22
To save a workbook, you:
Click the save button on the standard toolbar from the menu
Press Ctrl+ F5
Click Save on the Windows Start button
Select Edit > Save
Q.23
You can edit a cell by
Clicking the formula button
Double clicking the cell to edit it in-place
Selecting Edit > Edit Cell from the menu
None of above
Q.24
You can select a single range of cells by
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 Ctrl key while dragging over the desired cells
Pressing the Shift key and an arrow key
Dragging over the desired cells
Q.25
Which elements of worksheet can be protected from accidental modification
Contents
Objects
Scenarios
All of above
Q.26
You can use the drag and drop method to
Copy cell contents
Move cell contents
Add cell contents
A and B both
Q.27
Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Press Ctrl + Home
Press Home
Press Shift + Home
Press Alt + Home
Q.28
Which of the following methods can not be used to edit the contents of a cell?
Press the Alt key
Clicking the formula bar
Pressing the F2 key
Double clicking the cell
Q.29
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:
Press the Erase key
Press Esc
Press the Enter button
Press the Edit Formula button
Q.30
To view a cell comment
Click the edit comment command on the insert menu
Click the display comment command on the window menu
Position the mouse pointer over the cell
Click the comment command on the view menu
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