NEW
Font size
WorksheetsExcel Essentials
Total questions: 10
Worksheet time: 10mins
The way to freeze a particular row and column is by
Selecting the particular row and clicking on freeze pane option
Selecting the particular column and clicking on freeze pane option
Selecting the cell that lies on the intersection of the particular row and column and clicking on freeze pane option
Selecting the cell besides the cell that lies on the intersection of the desired row and column and clicking on freeze pane option
The way to copy the formatting of a cell is by selecting the ____________ option
Copy
Format Painter
Drag and Drop the cell into the desired cell
Copy and Paste
The __ feature of ms excel quickly completes a series of data.
Auto Filter
Auto Complete
Auto Fill
Auto Sum
Which one is not a function in ms excel?
RIGHT
MID
LEFT
CLEAR
What does COUNTA function do?
Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells
In the formula, which symbol specifies the locked columns or rows?
$
*
%
;
You can auto fit the width of column by
Double clicking on the column name on column header
Double click on the cell pointer in worksheet
Double clicking on column right border on column header
Double clicking on the column left border of column header
Long text can be broken down into many lines within a cell. You can do this through
Wrap Text in Format > Cells
Justify in Edit > Cells
None of the above
All of the above
Which area in an Excel window allows entering values and formulas?
Title Bar
Menu Bar
Formula Bar
Standard Tool Bar
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________.
Auto Fill
Auto Correct
Auto Sum
Auto Format
