WorksheetsExcel 2
Total questions: 32
Worksheet time: 16mins
Name
Class
Date
1.
Bold cell content.
4 lines
2.
Change the font of cell content.
4 lines
3.
Italicize cell content.
4 lines
4.
Change the font color of cell content.
4 lines
5.
Change the fill color of a cell.
4 lines
6.
Insert a picture as a worksheet background
4 lines
7.
Create a formula using arithmetic operators.
4 lines
8.
Select non-adjacent cells.
4 lines
9.
Apply the Currency number format
4 lines
10.
Apply the Accounting number format.
4 lines
11.
Change the number of displayed decimal places.
4 lines
12.
Apply the Comma number format.
4 lines
13.
Apply the Percentage number format.
4 lines
14.
Apply the Date number format.
4 lines
15.
Align cell contents horizontally.
4 lines
16.
Indent cell contents.
4 lines
17.
Align cell contents vertically.
4 lines
18.
Merge and enter cell contents.
4 lines
19.
Rotate cell content to an exact value.
4 lines
20.
Create a formula using AVERAGE function.
4 lines
21.
Add a border with a line style to a cell.
4 lines
22.
Apply ac cell style.
4 lines
23.
Use the format painter.
4 lines
24.
Find and replace text.
4 lines
25.
Find and replace cell fomatting
4 lines
26.
Apply a theme
4 lines
27.
Create a highlight cell conditional formatting rule.
4 lines
28.
Create a conditional formatting rule using the quick analysis tool .
4 lines
29.
Set the print area of a worksheet.
4 lines
30.
Insert a page break.
4 lines
31.
Set print titles for a worksheet.
4 lines
32.
insert a header using header and footer elements
4 lines
100 %
