Q2181
Easy
Excel stores its documents as files called ____.
note!Answer: B) Workbooks
An Excel file is called a workbook, and it contains one or more worksheets.
Computer & IT
कम्प्युटर
Subjects
Computer Fundamental
कम्प्युटरको आधारभूत ज्ञान Hardware, memory, generations, number systems 752 questionsComputer Networking
कम्प्युटर नेटवर्किङ Networks, internet, protocols 217 questionsOperating System
अपरेटिङ सिस्टम Windows, Linux, files and processes 251 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 348 questionsWebpage Designing
वेबपेज डिजाइन HTML, CSS and the web 142 questionsAll questions
Showing 2181–2200 of 2,830 · Mix the order
Q2182
Easy
The contents of an active cell are displayed in the ____.
note!Answer: D) formula bar
The formula bar shows the content of the active cell, including formulas.
Q2183
Easy
A chart can be displayed ____.
note!Answer: D) both a and c
A chart can be embedded in a worksheet or placed on its own chart sheet.
Q2184
Easy
By default, an Excel workbook is made up of ____ worksheets.
note!Answer: B) Three
A new Excel workbook contains three worksheets by default.
Q2185
Easy
"AD" is an example of a ____.
note!Answer: B) cell reference
AD is a column letter, and a cell reference combines a column letter and row number, such as AD1.
Q2186
Easy
Row headings identify each row using a different ____.
note!Answer: C) Number
Excel row headings are numbers, while column headings are letters.
Q2187
Easy
The intersection of a row and column is known as a ____.
note!Answer: A) Cell
The intersection of a row and column in a spreadsheet is called a cell.
Q2188
Easy
60%-Accent6 is an example of a cell ___.
note!Answer: C) Style
60%-Accent6 is a built-in cell style in Excel, found in the Cell Styles gallery.
Q2189
Easy
Using AutoFill, what would be the extended series of the initial entry Jan?
note!Answer: C) Feb, Mar, Apr
Excel recognizes month names and continues the series in calendar order: Feb, Mar, Apr.
Q2190
Medium
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ___.
note!Answer: C) A does not equal B
IF returns the value_if_false (C2) when the logical test A1=B1 is false, which means A1 does not equal B1.
Q2191
Easy
For which of the following reasons would you choose to use a chart or graph?
note!Answer: B) To show trends or relationships across data
Charts are used to visualize trends and relationships in data, which are hard to see in raw tables.
Q2192
Easy
The ___ is the only one of the following charts to compare relative values from different categories to the whole.
note!Answer: A) Pie
A pie chart shows each category as a share of the whole, which is why it is used for part-to-whole comparison.
Q2193
Easy
The ___ Chart Tools contextual tabs appear on the Ribbon when you select a chart.
note!Answer: C) Design, Layout, and Format
When a chart is selected, Excel shows the Chart Tools contextual tabs: Design, Layout, and Format.
Q2194
Easy
Placing a chart in a ___ displays only the chart and no worksheet cells.
note!Answer: D) chart sheet
A chart sheet is a separate sheet that holds only a chart, with no worksheet cells visible.
Q2195
Easy
In the Move Chart dialog box, selecting ___ will embed the chart in the selected worksheet.
note!Answer: C) Object in:
The 'Object in' option embeds the chart as an object on an existing worksheet.
Q2196
Easy
Red triangle at the top right corner of a cell indicates
note!Answer: B) There is comment associated with the cell
A red triangle in the top-right corner of a cell is the indicator for a cell comment (note).
Q2197
Easy
A(n) ___ is text associated with a data value.
note!Answer: B) data label
A data label is the text shown on a chart that describes a specific data point's value.
Q2198
Easy
To move one slice of a pie chart away from the pie creates a(n) ___
note!Answer: B) exploded pie chart
Pulling out one slice from the pie creates an exploded pie chart.
Q2199
Easy
The ___ axis displays the categories associated with each data value.
note!Answer: C) Horizontal
In a column chart, the horizontal (category) axis shows the categories, while the vertical axis shows values.
Q2200
Easy
To display Mar 17, 2008 as a custom format, you would type ___ in the Format Code: box in Excel.
note!Answer: B) mmm-dd-yyyy
'mmm' shows the three-letter month name, 'dd' the day, and 'yyyy' the four-digit year, giving 'Mar-17-2008'.