MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Fundamentals
MS Excel
Quiz 5
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 would you choose to create a bar diagram?
Edit, Chart
Insert, Chart
Tools, Chart
Format, Chart
Q.2
Which setting you must modify to print a worksheet using letterhead?
Paper
Margin
Layout
Orientation
Q.3
What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
XY Chart
Line Chart
Pie Chart
Column Chart
Q.4
The spelling dialog box can be involved by choosing spelling from ________ menu.
Insert
File
Tools
View
Q.5
Which key do you press to check spelling?
F3
F5
F7
F9
Q.6
Excel displays the current cell address in the ________
Formula bar
Status Bar
Name Box
Title Bar
Q.7
What is the correct way to refer the cell A10 on sheet3 from sheet1?
Sheet3!A10
Sheet1!A10
Sheet3.A10
A10
Q.8
Which language is used to create macros in Excel?
Visual Basic
C
Visual C++
Java
Q.9
Which of the following is not a term of MS-Excel?
Cells
Rows
Columns
Document
Q.10
How many worksheets can a workbook have?
3
8
255
none of above
Q.11
How do you display current date only in MS Excel?
Date ()
Today ()
Now ()
Time ()
Q.12
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment
Q.13
What does COUNTA () function do?
Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells
Q.14
What is the short cut key to highlight the entire column?
Ctrl + C
Ctrl + Enter
Ctrl + Page Up
Ctrl + Space Bar
Q.15
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
Q.16
You can use drag-and-drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
By dragging a range of excel data to the word button on the taskbar while pressing Shift key
By dragging a range of excel data to the word button on the taskbar while pressing Alt key
None of above
Q.17
The auto calculate feature
Can only add values in a range of cells
Provides a quick way to view the result of an arithmetic operation on a range of cells
Automatically creates formulas and adds them to a worksheet
A and C
Q.18
Excel uniquely identifies cells within a worksheet with a cell name
Cell names
Column numbers and row letters
Column letters and row numbers
Cell locator coordinates
Q.19
Getting data from a cell located in a different sheet is called ________
Accessing
Referencing
Updating
Functioning
Q.20
Tab scrolling button
Allow you to view a different worksheet
Allow you to view additional worksheet rows down
Allow you to view additional worksheet columns to the right
Allow you to view additional sheets tabs
Q.21
A numeric value can be treated as a label value if it precedes with
Apostrophe (')
Exclamation (!)
Hash (#)
Ampersand (&)
Q.22
Concatenation of text can be done using
Apostrophe (')
Exclamation (!)
Hash (#)
Ampersand (&)
Q.23
Data can be arranged in a worksheet in a easy to understand manner using
Auto formatting
Applying styles
Changing fonts
all of above
Q.24
A worksheet can have a maximum of ________ number of rows.
256
1024
65535
1048576
Q.25
Which of the following is not an example of a value?
350
May 10, 2001
0.57
Serial Number 50771
Q.26
The chart wizard term data series refers to
A chart legend
A collection of chart data markers
A set of values you plot in a chart
A data label
Q.27
The Chart wizard term data categories refers to;
A chart plot area
A horizontal axis
The organization of individual values with a chart’s data series
The data range that supply chart data
Q.28
A worksheet range is a
A command used for data modeling
A range of values such as from 23 to 234
A group of cells
A group of worksheets
Q.29
Which symbol must all formula begin with?
=
+
(
@
Q.30
Which of the following formulas is not entered correctly?
=10+50
=B7*B1
=B7+14
10+50
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