MS Excel 2010 Expected Practical Questions
- In the given
spreadsheet file, open sheet “Chart 1” change the column chart to a “Doughnut”
chart. Use the default chart and show Legend at top
- Calculate and display Quantity Available in
column H , also calculate the total of Quantity in cell H14 by using function
- Open the file Result.xlsx from the folder C:\Support
and set the spreadsheet to that it prints the first row of the worksheet as a
heading at the top of each page.
- Using logical function , apply as “Good” for student
having total marks less than 600 and “Very Good” for student having total marks
greater than or equal to 600
- Open the file “Time Table.xlsx” from the folder
“C:\Support” and change the heading “Time Table” to “Time Table Summer 2012” in
the table
- Open the file Result.xlsx from folder “C:\Support” and
insert hyperlink to the heading “Student Result” and link this to http://www.google.com web site
- Change the background of cell range B1:C1 to red color
and also apply “Strikethrough” font effect
- Change the font size to the cell “D2” to 16 and its
highlight color to “Blue” also use “format Painter” copy the format of cell
“D2” to cell “F2”
- Insert 1 row before 9th row and change the
height of it “40”
- Insert the text “Take a challenge” in cell B8 and to
find the4 left of the 4 letters in the cell B5 and display the result in the
cell C10 using function
- Insert column after column “B” and change the width of
the column B to “50.57”
- Rename the Sheet from “Product Template” to “Hardware
Template” and change the tab color to “Purple”
- Display the Right 2 letters in B8 by using a function
give the result in K4
- Fill the range A1:A5 with Jan-81-May-81
- Insert he text “Challenge” in cell B5 and to find the
position of the letter g in the cell B5 and display the result in the cell D5
using function
- Cut the content from the cell range C2:C8 and paste it
on to cell range H2:H8
- Insert the values 50, 100, 65, 96 in cells G7 G8 G9
G10 respectively. Calculate the sum of the cell range G7 to G10 and display the
result in cell G13 using function
- Insert a worksheet in given MS-Excel workbook &
name it as “Stationary”
- Display the minimum price in C4:C6 by using function
and give the result in K4
- Change the pattern of the cells C6:C13 as “Thin
Vertical stripe”
- In the given spreadsheet file, change column “J” so
that all the text advertising can be seen
- Inset the number 12 in cell A10 and the number 15 in
cell A11 and display their product in cell A12 and sum in cell A13
- Auto fill numbers 1 to 100 in column A starting from
A1 column wise
- Insert the values 80, 65, 11 in cell G7, G8, G9
respectively. Multiplies the numbers in cell G7:G9 and display it in the cell
G13 using Function
- Fill the column with the number 5001 to 5030 starting
from K1
- Insert the date “15-May 2012” in cell “G5” and to find
the month of the serial number in the cell G5 and display the result in the
cell D5 using Function
- Fill up the cell range A4:A121 by month names starting
with “July”
- Use the “year” function in cell K6 to find the year in
the cell “G5”
- Fill the range A1:A5 with Jan-81-May-81
- Repeat the text “ERA5” five times in cell H1 by using
function
- Change format of “Discount” column to number format up
to 2 decimal places
- Capitalize the first letter in each word in cell C3 by
using function and give result E3
- Format the cells “B3:B12” to horizontal “Right”
alignment and vertical “Center” Alignment
- Calculate the total marks for English subject of all
students and display the result in cell E17 using a function
- Open the file “Fees.xlsx” and save as “PDF” format
- Find the average marks of the students having name
“Aseem Khan” and show it in the cell K6 using function
- In the given spreadsheet file sort the data range “E4:E13”
in descending order by the column name
- Using LEN function, count the characters in B10 and
display the result in B15 cell
- Open the file “Result.xlsx” from the folder C:\Suppor
and sort the column “Roll Number” in Ascending order
- Using UPPER function convert the characters in cell B9
and display the result in B15 cell
- Open the file “Fees.xlsx” from the folder c:\ Folder
and change the header “Fee Details” to “Payment Details” in the center section
of the header
- Using LOWER function convert the characters in B9 cell
and display the result in B15 cell
- Format the cells values from cell C5:G5 and C10: G10
as text alignment horizontal center
- Calculate and display total price of each particular
by using a formula in cell range “E3:E9” also display stock quantity in cell
range “H3:H9”
- Insert the date “11 –August - 2006” in a MS-Excel
sheet in cell C2 and format it to ’31 March,2001’ type
- Calculate the percentage of Pass student out
of Appeared students for the “Mumbai” region and display the result In the cell
E14
- Sort “Qty In Stock” column in ascending order And then
by “Product Name” column in descending order
- Calculate the “Bill Amt.” of item purchased
without discount, amount and Display the answer in G15
- Insert numbers 55.5, 75.5, 85.5, 10, 12 in cell A1 to
A5, Sort numbers in Descending order. Put the same in to the cell starting from
H1 to H5 in ascending order
- Calculate the bill amount with discount for
“Keyboard-iball” and display result in cell H12
- In the given file, clear format of the heading “Student
Result” and Hide the Sheet1.
- Open the file Fees.xlsx from the folder “C:\ Support”
Using MOD function in conditional formatting display value in Red color within
range “F3:F7”
- Auto fill the cell range I3 to I12 by Even number starting with zero
- Using IF statement, apply discount of 2.50%
for items having unit price less then Rs. 50/- and 5.00% for items unit price
greater than Rs. 50/-
- From the given MS-Excel cells “C6 to F6” and “C15 to
F15” values prepare a chart type column with sub type “100% stacked column in
3D”
- Display the book name ,Author & Quantity
in stock in C16 , D16, E16 respectively whose Quantity in stock is minimum by
using function
- In the given Spreadsheet file, open sheet “Chart1” and
apply chart style as “Chart8”
- Display the book name ,Author & Quantity
in stock in C16 , D16, E16 respectively whose Quantity in stock is maximum by
using function
- Insert numbers 55.5, 75.5, 85.5, 10, 12 in cell A1 to
A5, Sort numbers in Descending order. Put the same in to the cell starting from
H1 to H5 in ascending order
- Open the file Result.xlsx from the folder C:\Suppoer
using IF statement, apply remark as “True” for marks of “Advertising” subject
of all students greater than “50” or less than or equal to “50” apply Remark as
False
- From the given MS-Excel set the current worksheet to
fit on 3 pages wide by 2 pages tall also change Top And Bottom margins” 2 inch”
- Use the max function in cell E15 to find the highest
marks in the cell range E4:E14
No comments:
Post a Comment