NEW
Font size
WorksheetsWorking With Number (Microsoft Excel beginner)
Total questions: 25
Worksheet time: 24mins
How do you enter text in a cell?
Press the 'Enter' key to start typing.
Click on the cell and type the text.
Right-click the cell and select 'Edit'.
Double-click the cell to enter text.
How to add a column in Excel?
Press Ctrl + A
Right - Click on the column header and select insert.
Use Shift + Click on the first cell
Right-click and select 'Select All'
How can you add two numbers in different cells?
Add the numbers manually and write the result in a new cell.
Use the 'SUM' function in a different spreadsheet.
Use a formula like '=A1+B1' in a new cell.
Copy and paste the values into a single cell.
What symbol do you use to start a formula?
-
=
+
*
How do you format a cell to show currency?
Right-click the cell, select 'Cell Options', and choose 'Money'.
Select the cell, right-click, choose 'Format Cells', select 'Currency', and click 'OK'.
Highlight the cell, go to 'Home', and click 'Currency Format' in the toolbar.
Select the cell, click 'Insert', choose 'Currency', and press 'Enter'.
What is the result of adding 5 and 3 in a cell?
7
8
10
9
How can you change the font size of text in a cell?
Change the cell color to adjust visibility.
Insert a new cell to change the text size.
Select the cell, then adjust the font size from the toolbar.
Use a different font style to enhance text appearance.
What formula would you use to find the average of numbers in cells A1 to A5?
=MAX(A1:A5)
=AVERAGE(A1:A5)
=COUNT(A1:A5)
=SUM(A1:A5)
How do you insert a number into a cell?
Right-click the cell and select 'Insert Number'.
Double-click the cell and write the number.
Click on the cell, type the number, and press Enter.
Drag and drop the number into the cell.
What happens if you type '5 + 3' in a cell?
The cell displays 5.
The cell displays 3.
The cell displays 53.
The cell displays 8.
How can you make text bold in a cell?
Use 'Ctrl + I' to italicize the text.
Right-click and select 'Underline'.
Press 'Shift + B' to make text bold.
Use the Bold button in the toolbar.
What is the formula to subtract 4 from 10?
= 10 - 4
= 4 - 10
10 - 2 = 8
10 + 4 = 14
How do you copy the contents of one cell to another?
Drag the cell to the desired location.
Right-click and delete the original cell.
Select the cell and press the delete key.
Select the cell, copy it, then paste it into the desired cell.
What is the result of multiplying 6 by 7 in a cell?
36
56
48
42
How can you change the background color of a cell?
Add a border to the cell
Change the font size of the cell
Use the fill color in toolbar
Insert an image into the cell
What formula would you use to add the values in cells B1 and B2?
=B1*B2
=B1+B2
=B1-B2
=SUM(B1,B2)
What is the result of dividing 56 by 8 in a cell?
6
9
7
8
How can you apply a border to a cell?
Use the 'Insert' menu to add a border.
Click on the cell and type 'Border'.
Right-click the cell and select 'Add Border'.
Select the cell, then choose 'Borders' from the formatting options.
How do you merge two cells in a spreadsheet?
Select the cells, right-click, and choose 'Merge Cells'.
Use the 'Insert' menu to merge cells.
Highlight the cells and press 'Ctrl + M'.
Click on the cell and type 'Merge'.
What is the result of subtracting 2 from 9 in a cell?
6
7
5
8
How do you clear the contents of a cell?
Click the cell and press delete on the keyboard.
Select the cell and use the 'Cut' option.
Press the 'Delete' key after selecting the cell.
Click on the cell and type 'Clear'.
What is the result of adding 10 and 15 in a cell?
30
25
20
15
How do you format a cell to display percentages?
Highlight the cell and go to 'Home', then click 'Percentage Format' in the toolbar.
Type '%' after the number in the cell.
Select the cell, right-click, choose 'Format Cells', select 'Percentage', and click 'OK'.
Right-click the cell and select 'Cell Options', then choose 'Percentage'.
What is the result of adding 12 and 8 in a cell?
24
22
18
20
How do you apply a text color to a cell?
Select the cell, then choose 'Font Color' from the toolbar.
Right-click the cell and select 'Change Text Color'.
Type 'Color' in the cell to change the text color.
Use the 'Insert' menu to apply text color.
