Microsoft Excel - gkquestionsguru.com

41.	Which would you choose to create a bar diagram?
a.	Edit, Chart
b.	Insert, Chart
c.	Tools, Chart
d.	Format, Chart 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.	XY Chart
b.	Line Chart
c.	Pie Chart
d.	Column Chart 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.	Copy handle
b.	Fill handle
c.	Insert handle
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.	A type of chart
b.	A cell reference
c.	A collection of related data
d.	A division of results 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.	To insert a background
b.	To add borders
c.	To select a distribution of figures
d.	To add shading or color to a cell range 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.	Contents tab
b.	Answer Wizard tab
c.	Index tab
d.	all of the above 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.	Dialog box
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

Jayakrishna sahu
3 May 2024 at 14:36

Appcation is a great of humanlife
Diane.G
13 July 2024 at 08:00

Very interesting details you have noted, thank you for posting.Raise blog range
Long Herold
10 October 2024 at 19:37

Some really choice content on this site, saved to favorites.
bij nl
14 November 2024 at 09:24

Hey! Do you know if they make any plugins to assist with Search Engine Optimization? I’m
trying to get my website to rank for some targeted keywords but I’m not seeing very good success.
If you know of any please share. Cheers! I saw similar text
here: Eco bij