Q2241
Easy
In the text alignment, what are the option in horizontal drop down list:
note!Answer: D) All of the above
The horizontal alignment dropdown in Excel includes General, Fill, Center Across Selection and others.
Computer & IT
कम्प्युटर
Subjects
Computer Fundamental
कम्प्युटरको आधारभूत ज्ञान Hardware, memory, generations, number systems 723 questionsComputer Networking
कम्प्युटर नेटवर्किङ Networks, internet, protocols 216 questionsOperating System
अपरेटिङ सिस्टम Windows, Linux, files and processes 248 questionsWord Processing
वर्ड प्रोसेसिङ MS Word and documents 588 questionsElectronic Spreadsheet
इलेक्ट्रोनिक स्प्रेडसिट MS Excel, formulas, charts 416 questionsPresentation System
प्रस्तुतीकरण प्रणाली MS PowerPoint and slides 116 questionsDatabase System
डाटाबेस प्रणाली DBMS, SQL, MS Access 347 questionsWebpage Designing
वेबपेज डिजाइन HTML, CSS and the web 142 questionsAll questions
Showing 2241–2260 of 2,796 · Mix the order
Q2242
Easy
The view allows you to add or remove page break, change the print area is
note!Answer: B) Page break preview
Page Break Preview lets you add, remove and move page breaks and adjust the print area.
Q2243
Easy
What is the function for searching the data of left most column vertically
note!Answer: D) Vlookup
VLOOKUP searches the first (left-most) column of a table vertically and returns a matching value.
Q2244
Medium
To create name by using labels in a selected range is:
note!Answer: B) Insert->Name->Create
Insert > Name > Create creates range names from the labels in the selected range.
Q2245
Easy
Which of the following is 3-D reference?
note!Answer: D) Sheet1!$a$1
A 3-D reference includes a sheet name, such as Sheet1!$A$1.
Q2246
Easy
Which of the following is not a valid reference in Excel?
note!Answer: D) Join Reference
Excel cell references are relative, absolute and mixed; 'Join Reference' does not exist.
Q2247
Easy
Grid coordinate of cell is refer by
note!Answer: C) Both a and b
A cell's grid coordinate combines its column heading letter and its row heading number, such as B5.
Q2248
Easy
You can paste with paste special command
note!Answer: D) All of the above
Paste Special allows pasting formulas, comments, values, formats and more.
Q2249
Medium
Which is not tool for what-if-analysis?
note!Answer: A) Pivot table
What-If Analysis tools are Goal Seek, Scenario Manager and Data Tables; a Pivot Table summarizes data and is not a what-if tool.
Q2250
Easy
Which of the following command is used to recalculate the formula?
note!Answer: C) F9
F9 recalculates all formulas in all open workbooks.
Q2251
Easy
The mode of operation can be displayed at
note!Answer: C) Status bar
The status bar shows the current mode, such as Ready, Edit or Enter.
Q2252
Medium
The shortcut key for defining name is
note!Answer: D) Ctrl+F3
Ctrl+F3 opens the Define Name dialog box in Excel.
Q2253
Easy
Which of the following method can be used to edit the content of cell?
note!Answer: D) All of the above
In Excel, a cell's content can be edited by pressing F2, clicking the formula bar, or double-clicking the cell.
Q2254
Easy
Which of the following method can't be used to edit the content of cell?
note!Answer: A) Press Alt key
Pressing Alt alone does not start cell editing; F2, the formula bar and double-clicking do.
Q2255
Easy
Sheet tab scrolling buttons
note!Answer: A) Allow you to view additional sheet tabs.
Sheet tab scroll buttons let you scroll to see sheet tabs that are not currently visible.
Q2256
Medium
If a=5, b=6.5, c=5, then what will be the output of function i.e. int (SUM(a,b,c))
note!Answer: B) 16
SUM gives 5+6.5+5=16.5, and INT rounds down to 16.
Q2257
Medium
If you apply int(SUM(x,y,z)), where x=2, y=3, z=1.7
note!Answer: A) 6
SUM gives 2+3+1.7=6.7, and INT rounds down to 6.
Q2258
Easy
Which of the following chart is used for composition and contribution of each value to total?
note!Answer: B) Pie chart
Pie charts show each part's share of a whole.
Q2259
Medium
Earliest date allowed for calculation is
note!Answer: B) January 1, 1900
Excel's date system begins on January 1, 1900 (serial number 1).
Q2260
Medium
Latest date allowed for calculation is
note!Answer: A) December 31, 9999
Excel supports dates up to December 31, 9999; the other options are invalid dates.