MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Fundamentals
MS Excel
Quiz 4
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 cell pointer indicates that you can fill series?
Doctor’s symbol (Big Plus)
Small thin plus icon
Mouse Pointer with anchor at the tip
None of above
Q.2
Which of the following you can paste selectively using Paste Special command?
Validation
Formats
Formulas
All of above
Q.3
Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Square
Percentage
Goal Seek
Divide
Q.4
Which of the following is not a basic step in creating a worksheet?
Save workbook
Modifiy the worksheet
Enter text and data
Copy the worksheet
Q.5
How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Hold down the shift key as you click anywhere in the column
Hold down the Ctrl key as you click anywhere in the column
Q.6
How can you print three copies of a workbook?
Select File > Properties form the menu and type 3 in the Copies to print text box
Select File > Print from the menu and type 3 in the Number of copies text box
Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made
Press Ctrl+P+3
Q.7
To create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
Choose the new command from the file menu
Q.8
Which of the following will not cut information?
Pressing Ctrl + C
Selecting Edit > Cut from the menu
Clicking the Cut button on the standard
Pressing Ctrl+X
Q.9
The active cell:
Is defined by a bold border around the cell
Receives the data the user enters
It is the formula bar
Only A and B
Q.10
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns
Select the cells containing the title text plus the range over which the title text is to be enfettered
Format the cells with the comma style
Q.11
Which of the following is not a way to complete a cell entry?
Pressing enter
Pressing any arrow key on the keyboard
Clicking the Enter button on the Formula bar
Pressing spacebar
Q.12
You can activate a cell by
Pressing the Tab key
Clicking the cell
Pressing an arrow key
All of the above
Q.13
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?
Logical
Math & Trigonometry
Statistical
Financial
Q.14
B7:B9 indicates:
Cells B7 and cell B9 only
Cells B7 through B9
Cell B8 only
None of the above
Q.15
Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
Q.16
How do you insert a row?
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
Select the row heading where you want to insert the new row and select Edit >Row from the menu
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
All of the above
Q.17
Which of the following methods cannot be used to enter data in a cell
Pressing an arrow key
Pressing the Tab key
Pressing the Esc key
Clicking on the formula bar
Q.18
You can auto fit the width of column by
Double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Q.19
Which of the following option is not available in Paste Special dialog box?
Add
Subtract
Divide
SQRT
Q.20
Which command will you choose to convert a column of data into row?
Cut and Paste
Paste Special > Transpose
Both of above
None of above
Q.21
Which of the following format you can decide to apply or not in AutoFormat dialog box?
Number format
Border format
Font format
All of above
Q.22
In Excel, a Data Series is defined as what?
A type of chart
A cell reference
A collection of related data
A division of results
Q.23
To record a sequence of keystrokes and mouse actions to play back later we use:
Media player
Sound Recorder
Calculator
Macro Recorder
Q.24
In Excel, the Fill Color button on the Formatting toolbar is used for what?
To insert a background
To add borders
To select a distribution of figures
To add shading or color to a cell range
Q.25
In help menu of Excel, which of the following tabs are found?
Contents tab
Answer Wizard tab
Index tab
all of the above
Q.26
We can save and protect the workbook by
Write Reservation Password
Protection Password
Read-only Recommended
Any of the above
Q.27
The first cell in EXCEL worksheet is labeled as
AA
A1
Aa
A0
Q.28
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)
An absolute cell address is created
Cell address will change when it is copied to another cell
The sheet tab is changed
The status bar does not display the cell address
Q.29
A ________ is a grid with labeled columns and rows.
Dialog box
Worksheet
Clipboard
Toolbar
Q.30
What are the tabs that appear at the bottom of each workbook called?
Reference tabs
Position tabs
Location tabs
Sheet tabs
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