MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Computer Fundamentals
MS Excel
Quiz 7
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Q.1
When you want to insert a blank embedded excel object in a word document you can
Click the object command on the insert menu
Click the office links button on the standard toolbar
Click the create worksheet button on the formatting toolbar
Click the import excel command on the file menu
Q.2
The Paste Special command lets you copy and paste:
Multiply the selection by a copied value
Cell comments
Formatting options
The resulting values of a formula instead of the actual formula
Q.3
The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this?
You have to retype everything and manually add the dollar signs, commas, and decimals
Select Format > Money from the menu
Click the Currency Style button on the formatting toolbar
None of these
Q.4
Excel worksheet cells work very similarly to what common element of the windows graphical user interface
Option buttons
List boxes
Text boxes
Combo boxes
Q.5
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Pie chart
Row chart
Line chart
Column chart
Q.6
Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
Q.7
Excel probably considers the cell entry January 1, 2020 to be a
Label
Value
Formula
Text string
Q.8
You can convert existing excel worksheet data an charts to an HTML document by using
FTP wizard
Internet assistant wizard
Intranet wizard
Import wizard
Q.9
You can enter which types of data into worksheet cells?
Labels, values, and formulas
Labels and values but not formulas
Values and formulas but not labels
Formulas only
Q.10
All worksheet formula
Manipulate values
Manipulate labels
Return a formula result
Use the addition operator
Q.11
Which of the following is a correct order of precedence in formula calculation?
Multiplication and division exponentiation positive and negative values
Multiplication and division, positive and negative values, addition and subtraction
Addition and subtraction, positive and negative values, exponentiation
None of above
Q.12
A circular reference is
Geometric modeling tool
A cell that points to a drawing object
A formula that either directly or indirectly depends on itself
Always erroneous
Q.13
Which of following is Not one of Excel's what-if function?
Goal seek
Solver
Scenario manager
Auto Outline
Q.14
When you insert an excel file into a word document. The data are
Hyperlinked placed in a word table
Linked
Embedded
Use the word menu bar and toolbars
Q.15
Which of the following is not information you can specify using the solver?
Input cells
Constraints
Target cell
Changing cells
Q.16
Comments can be added to cells using
Edit > Comments
Insert > Comments
File > Comments
View > Comments
Q.17
Which of the following options is not located in the Page Setup dialog box?
Page Break Preview
Page Orientation
Margins
Headers and Footers
Q.18
What is represented by the small, black square in the lower-right corner of an active cell or range?
Copy handle
Fill handle
Insert handle
Border
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
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