The Sports Zones
Home
MCQs
Computer — Quiz
Microsoft Excel MCQ Questions Part 7
61 questions · Test your knowledge
Home
/
MCQs
/
Microsoft Excel MCQ Questions Part 7
1
MS-EXCEL can be used to automate
A
Financial statements, Business forecasting
B
Transaction registers, inventory control
C
Accounts receivable, accounts payable
D
Any of the above
2
NOT, AND, OR and XOR are
A
Logical Operators
B
Arithmetic operators
C
Relational operators
D
None of the above
3
In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
A
calendar
B
photograph of rainfall
C
chart showing rainfall amounts
D
database of rainfall
4
You want to record experiment information and create a chart that shows the rate of crystal growth over a period of timThe best application to use would be
A
word processing
B
spreadsheet
C
database
D
graphics
5
You are editing an worksheet that you had previously saveIf you want to save the edited sheet without losing the original one, which command should you use?
A
New
B
Save As
C
Edit
D
Save
6
If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
A
Re-format the spreadsheet
B
Insert a row
C
Increase the column width
D
Use the spacebar
7
In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………
A
ascending order
B
descending order
C
alphabetical order
D
random order
8
In order to perform a calculation in a spreadsheet, you need to use a
A
table
B
formula
C
field
D
variable
9
The box on the chart that contains the name of each individual record is called the ________.
A
cell
B
title
C
axis
D
legend
10
If you want all of the white cats grouped together in the database, you need to sort by ________.
A
Color, then Gender
B
Pet Type, then Color
C
Pet Type, then Gender
D
Color, then Pet Name
11
You accidentally erased a record in the sheeWhat command can be used to restore it immediately?
A
Insert
B
Copy
C
Undo
D
Replace
12
Where a row and a column meet, what do you call that?
A
A cell
B
A block
C
A box
D
None of the above
13
How do you tell one cell from another?
A
By numbers
B
By letters
C
By its address
D
by color
14
Give me an example of a cell address.
A
1125
B
911
C
41A
D
A21
15
What is the symbol for multiplying?
A
>
B
/
C
!
D
*
16
What is the symbol for dividing?
A
A ./
B
%
C
&
D
#
17
A function inside another function is called _______
A
Nested function
B
Round function
C
Sum function
D
Text function
18
Which of the following is not an underline option in the format cells dialog box?
A
Double
B
Single Accounting
C
Double Accounting
D
Single Engineering
19
Formulas in Excel start with
A
%
B
=
C
%
D
–
20
The default header for a worksheet is
A
Username
B
Date and Time
C
Sheet tab Name
D
None
21
Which of the following is not an option of the spelling dialog box?
A
Ignore
B
Ignore all
C
Edit
D
Change
22
Which of the following methods will not enter data in a cell?
A
Pressing the Esc key
B
Pressing an arrow key
C
Pressing the tab key
D
Clicking the enter button to the formula bar
23
The cell reference for cell range of G2 to M12 is _______
A
G2.M12
B
G2;M12
C
G2:M12
D
G2-M12
24
What is the keyboard shortcut for creating a chart from the selected cell range?
A
F2
B
F4
C
F8
D
F11
25
The Software which contains rows and columns is called ______
A
Database
B
Drawing
C
Spreadsheet
D
Word processing
26
You can group noncontiguous worksheets with
A
The alt+enter key
B
The ctrl key and mouse
C
The shift key and the mouse
D
The group button on the standard toolbar
27
What is the AutoComplete feature of Excel?
A
It automatically completes abbreviated words
B
It completes text entries that match an existing entry in the same column
C
It completes text and numeric entries that match an existing entry in the same column
D
It completes text entries that match an existing entry in the same worksheet
28
Which of the following function will return a value of 8?
A
ROUNDUP(8.4999, 0)
B
ROUNDDOWN(8.4999, 0)
C
ROUND(8.4999, 0)
D
Only B and C
29
How to restrict to run a macro automatically when starting Microsoft Excel?
A
Hold down the SHIFT key during startup
B
Hold down the CTRL key during startup
C
Hold down the ESC key during startup
D
Hold down the ALT key during startup
30
How to remove the unwanted action from recorded macro without recording the whole macro again?
A
By using the Find and Edit Action Option
B
By clicking on the Refresh button in the Macro toolbar
C
By edit the macro in the Visual Basic Editor
D
Macro cannot be edited.
31
What should be add before a fraction to avoid entering it as a date?
A
//
B
FR
C
Zero
D
Zero Space
32
Which of the following function will use to find the highest number in a series of number?
A
MAX(B1:B3)
B
MAXIMUM (B1:B3)
C
HIGH (B1:B3)
D
HIGHEST(B1:B3)
33
What does the NOW() function return?
A
It returns the serial number of the current date and time
B
It returns the serial number of the current date
C
It returns the serial number of the current time
D
None of the above
34
What value will display if the formula = “$55.00″+5 is entered into a cell?
A
$60
B
60
C
$55.00+5
D
$60.00
35
What is the shortcut key to insert current date in a cell?
A
CTRL + D
B
CTRL + T
C
CTRL + ;
D
CTRL + /
36
What is the shortcut key to hide entire column?
A
CTRL + −
B
CTRL + 0
C
CTRL + H
D
CTRL + C
37
How to specify cell range from A9 to A99 in Excel?
A
A9, A99
B
A9 to A99
C
A9 : A99
D
A9 – A99
38
Selecting the Column G & H then choose Insert->ColumnWhat will happen?
A
2 Columns will be inserted after Column F
B
2 Columns will be inserted after Column G
C
2 Columns will be inserted after Column H
D
Columns will be inserted after Column I
39
How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell
A
The Settings tab under the menu Format -> Cells
B
The Settings tab under the menu Data -> Validation
C
The Settings tab under the menu Data -> Filter -> Advanced Filter
D
the Settings tab under the menu Format -> Conditional Formatting
40
Clear the contents by pressing “DELETE†key from a keyboard will clear
A
Text Only
B
Format Only
C
Contents Only
D
Both Contents and Format
41
Which of the following shortcuts can be used to insert a new line in the same cell?
A
Enter
B
Alt + Enter
C
Ctrl + Enter
D
Shift + Enter
42
What is the quickest way to select entire worksheet?
A
Choose Edit -> Select all from the Menu
B
Click on the first column, press Ctrl, and then click on the last column
C
Click on the first column, press Shift, and then click on the last column
D
Click on the rectangle box on the upper left corner where column headings and row headings meet
43
A smart tag will be removed from a cell when
A
the cell is moved
B
the cell is hidden
C
the data in the cell is changed or deleted
D
the formatting of the cell is changed
44
Which of the following options is appropriate to show the numbers 9779851089510 in a cell?
A
Enclose the number is brackets
B
Place the character T before the number
C
Place the character TX before the number
D
Apply the Text format in the cell and type the numbers
45
Selecting the Rows 5 & 6 then choose Insert->RoWhat will happen?
A
2 Rows will be inserted after Row 4
B
2 Rows will be inserted after Row 5
C
2 Rows will be inserted after Row 6
D
2 Rows will be inserted after Row 7
46
If 4/6 entered in a cell without applying any formats, Excel will treat this as
A
Fraction
B
Number
C
Text
D
Date
47
How to fit long texts in a single cell with multiple lines?
A
Start typing in the cell and press the Enter key to start another line
B
Use the Wrap Text option in the Format -> Alignment menu
C
Use the Shrink to Fit option in the Format -> Cells -> Alignment menu
D
All of above
48
If particular workbook have to open each time Excel started, where that workbook should be placed?
A
AUTOEXEC Folder
B
AUTOSTART Folder
C
EXCELSTART Folder
D
XLSTART Folder
49
If the cell B1 contains the formula = $A$1, which of the following statements is true
A
There is a relative reference to cell A1
B
There is an absolute reference to cell A1
C
Further changes in value of A1 will not affect the value of B1
D
Further changes in value of B1 will affect the value of A1
50
Worksheet can be renamed by
A
Adding ? symbol at the end of filename while saving workbook
B
Click on Worksheet tab by Holding CTRL Key and type new name
C
Double Click on the Worksheet tab and type new name
D
Worksheet cannot renamed
51
1What is the shortcut key to hide entire row?
A
CTRL + H
B
CTRL + R
C
CTRL + 9
D
CTRL + -
52
What is the shortcut key to insert a new comment in a cell?
A
F2
B
Alt + F2
C
Ctrl + F2
D
Shift + F2
53
Which option allows you to Bold all the negative values within the selected cell range
A
Zero Formatting
B
Conditional Formatting
C
Compare Formatting
D
Negative Formatting
54
What is the shortcut key to insert new sheet in current workbook?
A
F11
B
Alt + F11
C
Ctrl + F11
D
Shift + F11
55
Which one is the last column header in Excel 2007?
A
XED
B
XFX
C
XFL
D
XFT
56
In maximum, how many sheets can be set as default while creating new workbook?
A
254
B
255
C
256
D
No Limit
57
New Comment†option can be found under _________ tab
A
Insert
B
Data
C
Review
D
View
58
In Excel, by default Numeric Values appears in
A
Left aligned
B
Right aligned
C
Center aligned
D
Justify aligned
59
To show/hide the grid lines in Microsoft Excel 2007
A
Page Layout -> Grid lines -> View
B
Insert -> Grid lines -> View
C
View -> Grid lines -> View
D
Edit -> Grid lines -> View
60
What will be the result if you type =A1=B1 in cell C1?
A
Yes or No
B
True or False
C
Value of A1
D
Value of B1
61
In Excel _______ may not contain in Formula
A
Text Constant
B
Number Constant
C
Circular Reference
D
All of them
Submit Quiz
Back to All Quizzes