Font size
WorksheetsIT support Level-1 (MS Excel)
Total questions: 25
Worksheet time: 9mins
Which one shortcut key is use to close spreadsheet?
Ctrl + W
Ctrl + Arrow key
Ctrl + S
Ctrl + C
Give me an example of a cell address-
11 25
A21
911
41A
You accidently erase a record in the sheet.
What command can be to restore it Immediately?
Insert
Copy
Undo
Repair
What is the symbol for multiplying-
>
/
!
*
What is the keyboard shortcut used to go home tab?
Ctrl + W
Ctrl + Arrow key
Alt + H
Ctrl + C
Which of the following all formulas in excel starts-
/
=
+
$
A spreadsheet contains-
Columns
Rows
Rows and Columns
None of above
NOT, AND, OR and XOR are which type of operator-
Logical Operator
Arithmetic Operator
Relational Operator
None of the above
Which is an example of a function?
=Add(A3:A4)
=Deduct(A3:A4)
=(A3:A4)
=sum(A3:A4)
Which of the following will use to find the highest number in a series of number?
=Maximum(B1:83)
=Max(B1:B3)
=High(B1:83)
=Highest(B1:83)
Which of the following is not a term of MS-Excel?
Cells
Documents
Rows
Columns
Which shortcut Key allow you to edit any cell in MS Excel?
F2
F4
F1
F5
Each excel file is called a workbook because-
It can contain text and data
It can be modified
It can contain many sheets including worksheet and chart sheet
You have to work hard to create it
Which types of charts can excel product?
Line graphs
Pie Chart
Bar Chart
All of the above
Which of the Following describes how to select all the cells in a single column?
Right click on column and select pick from list
Use data text to Columns menu item
Left click on the gray column title button
Pressing Ctrl+ A on the Keyboard.
In Microsoft Excel the Maximum Column width-
230 character
255 character
250 character
None of above
What function transfer row data in a column or column data in a row?
Hyperlink
Index
Transpose
Rows
A function inside another function is called a ….. function.
Nested
Round
Sum
Text
Which of the following methods can not be used to enter data in a cell?
Pressing an arrow key
Pressing the Esc key
Pressing the tab key
Clicking the enter button to the formula bar
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
'Ctrl + D' shortcut key in Excel will -
Fill down in the selection
Open the font dialog box
Apply double underline for the active cell
None of above
MS Excel provides the default value for step in Fill Series dialog box -
0
1
5
10
In Excel the maximum row height is ............... point
109
120
308
409
Excel 2007, the number of rows in a sheet is...
(a)
To select an entire column in MS Excel, press-
Ctrl + C
Ctrl + Arrow key
Ctrl + S
Ctrl + Shift + Arrow key
