Q : 1 Fill in the Blanks (05)
(1) _____________ is a rectangular block of selected cells.
(2) _____________ is a range of cells represented from A1 to D4
(3) Shading of a cell can be changed using the _____________ tab in the Format Cells
dialog box.
(4) The default column width is ___________ and the default row height is _______________.
(5) Formula contributed with ________________ performs automatic recalculations.
Q : 2 Answer in one word (05)
(1) Name various types of number formats.
(2) In which manner values can be aligned?
(3) Which bar contains the Sum button?
(4) Which function returns the largest value in a specific cell range?
(5) The copy option is available in which menu?
Q : 3 Identify the Label of the given screen (04)
(1) Name various types of number formats.
(2) Text is oriented to how many degrees.
(3) Name the application that has this
dialog box
(4) Which property from the given dialog
box will make the text to adjust into a
single cell
Q : 4 Answer the following (Any 3) (06)
(1) Differentiate between a workbook and a worksheet.
(2) Write steps to increase the column width.
(3) What are functions?
(4) What is the use of formula in a calc Worksheet? Which two types of arguments are used
in a Calc worksheet?
Answers
data block
:
Patterns tab
height and width for one or more rows and columns
The shortcut F9 performs recalculation in all book formulas on all sheets. There is Combination of hot keys SHIFT + F9 performs recalculation only on the current sheet.
Fixed Point, Date, Boolean, Integer, Suffix, Binary, Exponential, Hexadecimal.
Know your values.
Model those values.
Communicate your values.
Celebrate those employees who live the company's core values.
SUM(D2:D5)
Excel MAX
In Edit Menu
Fixed Point, Date, Boolean, Integer, Suffix, Binary, Exponential, Hexadecimal.
up to 90 degrees
Microsoft I think I'm not sure
You can use this same Font tab to format individual characters.
The worksheet is single page spreadsheet or page in Excel, where you can write, edit and manipulate data, whereas the collection of such worksheets is referred as a workbook.
Set a column to a specific width
Select the column or columns that you want to change.
On the Home tab, in the Cells group, click Format.
Under Cell Size, click Column Width.
In the Column width box, type the value that you want.
Click OK.
3. In mathematics, a function is a binary relation between two sets that associates every element of the first set to exactly one element of the second set. Typical examples are functions from integers to integers, or from the real numbers to real numbers.
4. In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.