Ms Excel Frequently asked Question and Answer
What function displays row data in a column or column data in a row ?
Index
Transpose
Rows
Hyperlinks
Which of these will not select all the cells in a document?
Pressing Ctrl + A on the keyboard
All of above
Using the Edit + Select All menu
Clicking three times with the right mouse button in the spreadsheet
How are data organized in a spreadsheet?
Height and width
Lines and spaces
Layers and planes
Rows and columns
Which among following is associated with excel?
Graphic program
Word Processor
Spreadsheet
Presentation
Which among following is not associated with spelling dialogue box?
Change
Ignore All
Ignore
Edit
On an excel sheet the active cell in indicated by?
A dotted border
A dark wide border
By italic text
A blinking border
Formula palette is used to?
entered assumptions data
create and edit formulas containing functions
copy all cells
format cells containing numbers
What term describes a background that appears as a grainy, non smooth surface?
Texture
Gradient
Pattern
Velvet
Except which of the following function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result?
NOT
AND
OR
IF.
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
Which of the following is not a valid Zoom percentage in Excel?
500
300
100
10
What term describes explanatory text attached to a cell?
Comment
Callout
Context
Dialog
A typical worksheet has _____ Number of columns
256
128
512
1024
How do you change column width to fit the contents?
Single-click the boundary to the left to the column heading
Double click the boundary to the right of the column heading
Press Alt and single click anywhere in the column
All of above
Which types of charts can excel produce?
Only line graphs
Bar charts, line graphs and pie charts
Bar charts and line graphs only
Line graphs and pie charts only
To open an existing workbook, click the Open button on the ___ toolbar?
Form
Standard
Formatting
Drawing
If you press ___, the cell accepts your typing as its contents?
Enter
Ctrl+Enter
Alt+Enter
Tab
Gridlines may be turned off for display but turned on for printing.
True
False
The default style for new data keyed in a new workbook is?
Normal
Currency
Percent
Comma
A value used in a formula that does not change is called a?
Constant
Cell address
Variable
Static
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called?
HTML
Pivot Table Field List
Pivot Table Report
None of above
Pivot Table List
Macros can be executed from which of the following menu?
Insert
Tools
Format
Home
To insert three columns between columns A and B you would
Select column A
Select A and B
Select B
All of above
You can convert existing Excel worksheet data and charts to HTML document by using the?
Export Wizard
Intranet Wizard
Import Wizard
Internet Assistant Wizard
How we can view a cell comment?
position the mouse pointer over the cell
click the edit comment commands on the Insert menu
click the comment command on the view menu
click the Display comment command on the window menu
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
With which of the following all formulas in excel starts?
$
=
*
/
How can we set Page Border in Excel?
From Home
You cannot set page border in Excel
From Edit menu
From Tools menu
.
Which of the following keyboard shortcut can be used for creating a chart from the selected cells?
F11
F4
F2
F10
The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row is?
C1:H:10
C1:H-10
C1:H10
C1:10H
.
Just type - #DiscoverTalentPresents on the Google and be found.
We are also available on the –
#Pinterest https://www.pinterest.com/pin/6591440
#Instagram: #DiscoverTalent143
#Tumblr: - https://discover-talent-presents.tumb... #Youtube - youtube.com/DiscoverTalent143
#Facebook: - Facebook.com/DiscoverTalent143
#LinkedIN: - Check out Discover Talent’s profile on LinkedIn
Do you know we also run online Instagram quiz show for Ms excel and Ms office to enhance your skill set our first draw winner is below.
