Microsoft Excel - gkquestionsguru.com

61.	To activate the previous cell in a pre-selected range, press-
a.	The Alt key
b.	The Tab key
c.	The Enter key
d.	None of the above Option “D” is correct. To go to previous cell we use Go To function Ctrl + G.

62.	Which button do you click to add up a series of numbers?
a.	The autosum button
b.	The Formula button
c.	The quicktotal button
d.	The total button Option “A” is correct. AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.

63.	When the formula bar is active, you can see-
a.	The edit formula button
b.	The cancel button
c.	The enter button
d.	All of the above Option “D” is correct. Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar.

64.	To copy formatting from one area in a worksheet and apply it to another area you would use:
a.	The Edit > Copy Format and Edit>Paste Format commands form the menu
b.	The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
c.	There is no way to copy and apply formatting in Excel – You have to do it manually
d.	The Format Painter button on the standard toolbar Option “D” is correct. The Format Painter copies formatting from one place and applies it to another. The Format Painter button on the standard toolbar in Excel 2003 and earlier version. Home tab, in the Clipboard group, click Format Painter in 2007 and higher version.

65.	In a worksheet you can select-
a.	The entire worksheet
b.	Rows
c.	Columns
d.	All of the above Option “D” is correct. In a worksheet we can select cell or range of cells or rows or columns or entire worksheet.

66.	Status indicators are located on the-
a.	Vertical scroll bar
b.	Horizontal scroll bar
c.	Formula bar
d.	Standard toolbar Option “C” is correct. Status indicators are located on the formula bar.

67.	Which of the following is the oldest spreadsheet package?
a.	VisiCalc
b.	Lotus 1-2-3
c.	Excel
d.	StarCalc Option “A” is correct. VisiCalc was the first computer spreadsheet program. It was released to the public in 1979, running on an Apple II computer. While most early microprocessor computers had been quickly supported by BASIC and a few games, VisiCalc introduced a new level in application software. It was considered a fourth generation software program.

68.	Rounding errors can occur-
a.	When you use multiplication, division, or exponentiation in a formula
b.	When you use addition and subtraction in a formula
c.	Because excel uses hidden decimal places in computation
d.	When you show the results of formulas with different decimal places that the calculated results Option “A” is correct. When we use multiplication, division, or exponentiation in a formula, rounding errors can occur.

69.	You can copy data or formulas-
a.	With the copy, paste and cut commands on the edit menu
b.	With commands on the shortcut menu
c.	With buttons on the standard toolbars
d.	All of the above Option “D” is correct. We can copy data or formulas with the copy, paste and cut commands on the edit menu or with commands on the shortcut menu or with buttons on the standard toolbars in Excel 2003 or earlier version.

70.	You cannot link excel worksheet data to a word document
a.	With the right drag method
b.	With a hyperlink
c.	With the copy and paste special commands
d.	With the copy and paste buttons on the standard toolbar Option “D” is correct. We cannot link excel worksheet data to a word document with the copy and paste buttons on the standard toolbar.

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