Q2121
Easy
Which of the cell pointer indicates that you can fill series?
note!Answer: B) small thin plus icon
The small thin black plus appears when hovering over the fill handle, which is used to fill series.
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 2121–2140 of 2,796 · Mix the order
Q2122
Easy
To make A1 the active cell, press which of the following keys?
note!Answer: D) Ctrl+Home
Ctrl+Home moves the active cell to A1 of the worksheet.
Q2123
Easy
The expression used to calculate values displayed in a worksheet is called a(n) ___.
note!Answer: A) Formula
A formula is the expression that calculates values in a worksheet cell.
Q2124
Easy
An Excel formula always begins with a(n) ___.
note!Answer: C) equals sign
Every Excel formula starts with an equals sign (=).
Q2125
Easy
To divide the value of a cell by some number, use the ___ operator.
note!Answer: B) /
The forward slash (/) is the division operator in Excel.
Q2126
Medium
Which of the following is nonadjacent cell range?
note!Answer: C) A1:A5;F1:G5
A semicolon separates two separate ranges that do not touch, so this is a nonadjacent range.
Q2127
Easy
To select a nonadjacent range, select an adjacent range, press and hold ___ and then select other adjacent ranges.
note!Answer: B) Ctrl
Holding Ctrl while selecting additional ranges adds them to the selection without removing the earlier ones.
Q2128
Easy
To change the order of operations, enclose part of the formula in______
note!Answer: B) parentheses
Parentheses are used in formulas to make parts of the expression calculate first.
Q2129
Easy
What is the syntax for a SUM formula adding the values of Cell F6 to F9?
note!Answer: D) =SUM(F6:F9)
The correct syntax is =SUM(first cell:last cell), so =SUM(F6:F9) adds F6 through F9.
Q2130
Easy
Italic, bold, bold italic and underline are examples of ___.
note!Answer: C) font styles
Bold, italic, and underline are font styles applied to text.
Q2131
Easy
You can create a ___ color by specifying a mixture of red, blue, and green color values.
note!Answer: C) Custom
Custom colors are created by choosing RGB values for red, green, and blue.
Q2132
Medium
When creating an Excel document, you should avoid using ___ text and background together, since this is the most common form of color blindness.
note!Answer: A) red and green
Red-green color blindness is the most common form, so red and green should not be combined for text and background.
Q2133
Medium
In Excel, dates are ___-aligned in the cell by default, regardless of date format.
note!Answer: A) Right
Excel right-aligns numeric values, and dates are stored as numbers, so they align right by default.
Q2134
Medium
All of the following options are available on the Format Cells dialog box except ___.
note!Answer: D) Size
The Format Cells dialog has Number, Alignment, Font, Border, Fill and Protection tabs, but font size is set under Font, not as a separate tab.
Q2135
Easy
In the Format Cells dialog box, the ___ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.
note!Answer: A) Number
The Number tab holds currency, number, and comma style formatting options.
Q2136
Easy
The Paste Options button allows you to ___.
note!Answer: D) all of the above
Paste Options provides choices to keep source formatting, paste values only, or paste formatting only.
Q2137
Medium
The most efficient way to format an entire table is to ___.
note!Answer: C) use a table style
Applying a table style formats the whole table at once and is faster than formatting cells one by one.
Q2138
Easy
Which of the following is not What IF analysis tool in Excel?
note!Answer: C) Macros
Goal Seek and Scenarios are What-If analysis tools in Excel. Macros are automation scripts, not a What-If tool.
Q2139
Easy
You can set Excel in Automatic or Manual calculation mode. If it is in manual mode which key you will press to update the formula values?
note!Answer: A) F9
In manual calculation mode, F9 recalculates all formulas in open workbooks.
Q2140
Easy
By default the cell pointer moves down when you press Enter. From where can you change this setting?
note!Answer: C) Tools → Options → Edit tab
The 'Move selection after Enter' direction is set in Tools → Options → Edit tab.