Q2261
Easy
Which of the following key is used to fill to down in Ms Excel
note!Answer: D) Ctrl+D
Ctrl+D fills the selected cell's content down into the cells below.
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 2261–2280 of 2,796 · Mix the order
Q2262
Easy
Which of the following key is used to fill to the right in Ms Excel?
note!Answer: B) Ctrl+R
Ctrl+R fills the selected cell's content to the right.
Q2263
Easy
If you use function MOD (5,2), what will be result?
note!Answer: A) 1
MOD returns the remainder of 5 divided by 2, which is 1.
Q2264
Medium
If you apply EVEN(1.5), what will be the output?
note!Answer: C) 2
EVEN rounds a number up to the nearest even integer, so 1.5 becomes 2.
Q2265
Easy
Which of the following function is used to round a number down to an integer?
note!Answer: A) INT
The INT function rounds a number down to the nearest integer.
Q2266
Easy
Which of the following is correct for TRUNC() formula?
note!Answer: B) TRUNC(number, num_digits)
The correct syntax is TRUNC(number, num_digits).
Q2267
Easy
If you apply the function, CHAR(65), what will be result?
note!Answer: C) A
CHAR returns the character for an ASCII code, and 65 is the code for 'A'.
Q2268
Easy
Combining two or more cells into a single cell is called
note!Answer: B) Merging
Merging combines selected cells into one cell in Excel.
Q2269
Easy
The highlighted cell on spreadsheet is called
note!Answer: C) Active cell
The active cell is the highlighted cell where data is entered; 'current cell' is not the standard term.
Q2270
Easy
In which menu border and shading is located?
note!Answer: D) Format menu
Border and shading options are found in the Format menu (Format Cells).
Q2271
Easy
What is the conditional formatting used for?
note!Answer: A) To format a cell depending upon values of the content in the cell.
Conditional formatting changes a cell's appearance based on its content or values meeting set rules.
Q2272
Easy
The cell reference $A$2 is a
note!Answer: A) Absolute cell reference
Dollar signs before both column and row make it an absolute reference.
Q2273
Easy
What is the function of [Σ] tool in Excel sheet?
note!Answer: C) Auto sum
The Σ (AutoSum) tool automatically inserts SUM formulas.
Q2274
Easy
Type of effect available in chart is:
note!Answer: D) All of the above
Chart fill effects include gradient, texture, pattern, and picture fills.
Q2275
Easy
What is the name of the box shown in the left side of the formula bar?
note!Answer: A) Name or reference box
The box on the left of the formula bar is the Name Box, which shows the active cell reference.
Q2276
Easy
The view that puts a blue line around each page that would be printed is the
note!Answer: B) Page break Preview
Page Break Preview shows blue lines marking where each printed page ends.
Q2277
Easy
Type of the fill series is
note!Answer: D) All of the above
Excel's Series dialog offers Linear, Growth, and Date fill types.
Q2278
Easy
What are the methods to rename the sheet?
note!Answer: C) Both of the above
A sheet can be renamed by right-clicking its tab and choosing Rename, or by double-clicking the tab.
Q2279
Easy
How can you write in a cell by line break?
note!Answer: D) Alt+Enter
Alt+Enter inserts a line break within a cell in Excel.
Q2280
Easy
How do you apply sheet background?
note!Answer: A) Format->sheet->background
In Excel, Format > Sheet > Background applies a background image to the sheet.