5. Worksheets can be deleted from a workbook, including those containing data.
A formula is an equation that performs a calculation.
When a formula contains a cell address, it is called a cell reference.
A function is a predefined formula that performs calculations using specific
values in a particular order.
• Each function has a specific order called syntax
0. Sorting data in Excel basically means that we can arrange the data according
to some specific criteria.
(a) Title
Exercise
Full in the Blanks :
1. An Excel Workbook consists of
(a) Worksheets (b) Rows
(c) Columns (d) Formulas
2. The actual value of a cell is displayed in
bar.
(b) Menu
(c) Formula (d) None of these
3.
Formatting applies one or more rules to any cells we want.
(a) Formula (b) Function
(c) Conditional (d) None of these
4. Format Command is available on
Tab.
(a) Home
(b) Insert
(c) Data
(d) Formulas
5. All Formulas must begin with an
sign.
(a) Sigma (b) Plus
(c) Equal
(d) None of these
6. A data in our worksheet can be arranged in an order using
(a) Formula (b) Function
(c) Filter
(d) Sorting
Tab.
7. Sort & Filter command is available on
(a) Home
(b) Insert
(c) Data
(d) Formulas
Short Answer Type Questions:
1. What is Formatting?
2. Define Number Format in Excel.
4. What are the standard operator used in simple formulas ?
5. What is a cell reference ?
41
Answers
Answered by
4
Explanation:
- (c) .columns
- (b). menu
- (c). conditional
- (a). home
- (c). equal
- (a). formula
- (b). insert
- Formatting refers to the appearance or presentation of your essay.
- You can use number formats to change the appearance of numbers, including dates and times, without changing the actual number.
- Excel uses standard operators for equations, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a carat (^) for exponents.
- A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
hope it will help you...☺ ☺ ☺ ☺
plz mark me as brainliest...
okkkkkk byeeeeeeee.... ♥♥♥♥
see you in next question...
Similar questions