1) What do you mean by A3,B13:B20,C7 reference in Excel?
A. Range
C. Formula
B.
Union
D. General
2) Which view in Excel displays the pages exactly as they appear when printed?
A.
Custom View
C. Full screen View
B. Page Layout view
D. Page Break View
3) Which tab is used for creating, formatting and editing a spread sheet?
A.
Data
C. Insert
B.
Home
D. Review
4) Which function is used to add the values in a range?
A.
Count()
C. ABS()
B.
Sum()
D. Sumif()
5)
Which symbol is used to execute formulas in MS Excel?
A. &
C. @
B.
#
D. =
6)
What is the purpose 'Tab' key in MS Excel?
A. Moves cell pointer to previous column
C. Moves cell pointer previous row
B.
Moves cell pointer to next column
D. Moves cell pointer next row
Answers
Answer:
which data type can hold any type of values in vba
Answer:
Answers of the following is :
Explanation:
(1) Range
A3,B13:B20,C7 reference in Excel is Range .A range is a selected or highlighted group or block of cells in a worksheet. A range can also be defined as a group or block of cell references that are used as an argument for a function, to create a graph, or to bookmark data.
(2) Page Layout view
Page Layout view in Excel displays the pages exactly as they appear when printed. To view a page in Page Layout View, first select the worksheet you want to change in this view and then, on the 'View' tab, select 'Page Layout View' from the 'Views' group.
(3) Home
Home tab is used for creating, formatting and editing a spread sheet. The Home tab's Alignment group contains a number of useful tools for formatting cells in Excel. The Format Painter tool allows you to copy a cell's format (but not its contents) and apply it to other cells.
(4) Sum()
Sum() function is used to add the values in a range. SUM Function combines a set of cells The Excel AutoSum button is the quickest and easiest way to sum a range of cells. It inserts an Excel SUM function into the selected cell. The SUM function adds up one or more numbers from a set of cells.
(5) =
= symbol is used to execute formulas in MS Excel.
Excel formulas all start with an equal sign (=). Following the equal symbol, you enter a calculation or function. To add values in cells B1 through B5, for example, you can either: Complete the equation: =B1+B2+B3+B4+B5. As a result, the correct answer is =.
6) Moves cell pointer to next column
Moves cell pointer to next column is the purpose 'Tab' key in MS Excel When it comes to navigating around your worksheet in Excel, different keys serve different functions. When you press the Tab key, Excel usually moves the cell cursor one column to the right. However, not all spreadsheet program operate in this manner.