Microsoft Excel

41.Which would you choose to create a bar diagram?
a.
b.
c.
d.

Option “B” is correct.
Click the Insert > Chart
42.Which setting you must modify to print a worksheet using letterhead?
a.Paper
b.Margin
c.Layout
d.Orientation

Option “B” is correct.
We need to set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon.
43.What do you call the chart that shows the proportions of how one or more data elements relate to another data element?
a.
b.
c.
d.

Option “C” is correct.
Scatter plot (XY chart) used to show scientific XY data. Scatter plots are often used to find out if there’s a relationship between variable X and Y.
Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis.
Pie charts are used to display the contribution of each value (slice) to a total (pie). Pie charts always use one data series.
Column charts are used to compare values across categories by using vertical bars.
44.The spelling dialog box can be involved by choosing spelling from ________ menu.
a.Insert
b.File
c.Tools
d.View

Option “C” is correct.
In Excel 2003 and earlier version Tools > Spelling
From Excel 2007 and higher version Ribbon > Review tab > Proofing group > Spelling
45.Which key do you press to check spelling?
a.F3
b.F5
c.F7
d.F9

Option “C” is correct.
In most Microsoft Office apps (including Word, Excel, PowerPoint and Outlook), tap F7 to begin the spellcheck process.
46.What is represented by the small, black square in the lower-right corner of an active cell or range?
a.
b.
c.
d.Border

Option “B” is correct.
Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.
47.In Excel, a Data Series is defined as what?
a.
b.
c.
d.

Option “C” is correct.
In Excel, a Data Series is defined as a collection of related data. A data series is just a fancy name for a collection of related numbers in the same row, or the same column.
48.In Excel, the Fill Color button on the Formatting toolbar is used for what?
a.
b.
c.
d.

Option “D” is correct.
Fill Color is used to add or change the background color or pattern of cells.
49.In help menu of Excel, which of the following tabs are found?
a.
b.
c.
d.

Option “D” is correct.
In help menu of Excel 2003, Contents tab, Answer Wizard tab, Index tab are available.
50.A ________ is a grid with labeled columns and rows.
a.
b.Worksheet
c.Clipboard
d.Toolbar

Option “B” is correct.
A worksheet in Excel is made up of Rows and Columns grids. Intersection of a Row and column in an Excel worksheet is a rectangle called as a Cell. Cells store a value, a formula, or text.
Pages: 1 2 3 4 5 6 7