WorksheetsEXCEL EDITING AND FORMATTING
Total questions: 17
Worksheet time: 9mins
The process of making changes to the existing content of the document.
Printing
Retrieving
Editing
Formatting
It is the process of changing the appearance of the document.
Formatting
Editing
Retrieving
Saving
The.................... feature lets you quickly enter a pre-defined series of data.
AutoFill
FlashFill
CustomFill
Copy
..................recognizes the data fill pattern in a worksheet and fills the remaining series according.
AutoFill
Custom Fill
Flash fill
None of These
The Conditional Formatting button is present in the ____________ group on the Home Tab.
Styles
Cells
Editing
Alignment
What are the numbers in spreadsheet called?
Rows
Alphabet
Column
Symbols
Among these AutoFill options which one is used to fill the cell with the next items in the series
Copy Cells
Fill Formatting only
Fill series
Fill without Formatting
Chris wants to update the default Title Style by changing the font color and font style. To accomplish this, on the Home tab, in the Styles Group, Chris should click on the Cell Styles icon, right-click the Title Style, and select which option?
Modify
Apply
Delete
Duplicate
In Excel, Rows are labelled as ______
A, B, C, etc
A1, A2, etc.
1,2,3 etc
1A,2B,3C, etc
How many sheets are there, by default, when we
create a new Excel file ?
3
5
1
10
An Excel file is generally called a / an :
E-Spreadsheet
Worksheet
NoteBook
Workbook
Excel files have a default extension of
.xlsx
.docx
.pptx
.wk1
Which tool you will use to join some cells and place the content at the middle of joined cell?
From Format Cells dialog box click on Merge Cells check box
From Format Cells dialog box select the Centered alignment
From Format Cells dialog box choose Merge and Center check box
Click on Merge and Center tool on formatting toolbar
The Name
box on to the left of formula bar
Shows the name of workbook currently working on
Shows the name of worksheet currently working on
Shows the name of cell or range currently working on
None of above
Which of
the following is not the correct method of editing the cell content?
Press the Alt key
Press the F2 key
Click the formula bar
Double click the cell
Intersection of a row and a column in excel is called a_____________
Value
Address
Cell
None of the above
_____________________refers to the rotation of the text at different angles inside the cell
Indentation
Alignment
Orientation
Merging
