ExamVeda
Login
Home
21
To activate the previous cell in a pre-selected range, press
Discuss
Answer & Solution
Answer: Option D
Solution:
To go to previous cell we use Go To function Ctrl + G.
22
Which button do you click to add up a series of numbers?
Discuss
Answer & Solution
Answer: Option A
Solution:
AutoSum is a Microsoft Excel function that adds together a range of cells and displays the total in the cell below the selected range.
23
When the formula bar is active, you can see
Discuss
Answer & Solution
Answer: Option D
Solution:
Three buttons Cancel, Enter, and Function Wizard appear in the Formula bar. MS Excel mcq solution image When the formula bar is active, we can see all.
24
To copy formatting from one area in a worksheet and apply it to another area you would use:
Discuss
Answer & Solution
Answer: Option D
Solution:
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.
25
In a worksheet you can select
Discuss
Answer & Solution
Answer: Option D
Solution:
In a worksheet we can select cell or range of cells or rows or columns or entire worksheet.
26
When you link data maintained in an excel workbook to a word document
Discuss
Answer & Solution
Answer: Option B
Solution:
When we link data maintained in an excel workbook to a word document the document contains a reference to the original source application.
27
Which area in an excel window allows entering values and formulas
Discuss
Answer & Solution
Answer: Option C
Solution:
Formula Bar is where data or formulas we enter into a worksheet appear for the active cell. The Formula Bar can also be used to edit data or formula in the active cell.
28
To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Discuss
Answer & Solution
Answer: Option B
Solution:
When we want to scroll down the worksheet, and lock the heading rows in place, so it is always visible, we can use one of the Freeze Panes commands.
29
To edit in an embedded excel worksheet object in a word document
Discuss
Answer & Solution
Answer: Option A
Solution:
Use the excel menu bar and toolbars inside the word application to edit in an embedded excel worksheet object in a word document.
30
To create a formula, you can use:
Discuss
Answer & Solution
Answer: Option D
Solution:
To create a formula, we can use value and cell references both.