NEW
Font size
WorksheetsExcel Basics for Students
Total questions: 20
Worksheet time: 20mins
What is the first step to create a table in Excel?
Select the range of cells.
Save the document.
Insert a chart.
Open a new workbook.
How do you format a cell to change its background color?
Select the cell, go to 'Home' tab, click 'Fill Color', and choose a color.
Select the cell, go to 'Insert' tab, and add a shape with color.
Double-click the cell, type a color name, and press Enter.
Right-click the cell, select 'Format Cells', and adjust the border.
What formula do you use to calculate the sum of a range of cells?
ADD(range)
SUM(range)
TOTAL(range)
SUMMATION(range)
How can you find the average of a set of numbers in Excel?
Use the AVERAGE function, e.g., =AVERAGE(A1:A10).
Apply the MEAN function, e.g., =MEAN(A1:A10).
Use the SUM function, e.g., =SUM(A1:A10).
Calculate manually by adding and dividing.
What is the shortcut to resize a cell to fit its content?
Double-click the right border of the cell header.
Press Ctrl + R to adjust the cell size.
Drag the bottom border of the cell header.
Right-click the cell and select 'Resize'.
How do you drag a cell to copy its content to adjacent cells?
Click and drag the fill handle to copy the cell's content to adjacent cells.
Use the keyboard shortcut Ctrl+C to copy the cell's content.
Right-click the cell and select 'Copy' to duplicate its content.
Select the cell and press 'Enter' to replicate its content.
What option do you select to create a table from a range of data?
Build Table Structure
Generate Table
Insert Table
Create Data Table
How can you change the font style of text in a cell?
Double-click the cell to edit the font style directly.
Highlight the text and press Ctrl + B to bold it.
Right-click the cell and choose 'Change Font' from the menu.
Select the cell, then use the font style options in the toolbar to change the font.
What function would you use to add up values in cells A1 to A10?
=SUM(A1:A10)
=ADD(A1:A10)
=SUMIF(A1:A10)
=TOTAL(A1:A10)
How do you calculate the average of numbers in cells B1 to B5?
=COUNT(B1:B5)
=MEDIAN(B1:B5)
=AVERAGE(B1:B5)
=SUM(B1:B5)
What is the method to adjust the width of a column in Excel?
Select the column and press 'Ctrl + W' to adjust.
Use the 'Format' menu to set the column width.
Double-click the right border of the column header or drag it to adjust the width.
Right-click the column header and select 'Resize'.
How can you quickly fill a series of numbers in a column?
Use a formula to generate random numbers.
Use the fill handle to drag down after entering the first two numbers.
Enter each number manually in the column.
Copy and paste a list of numbers from another document.
What feature allows you to apply a specific style to a table?
Table formats
Table layouts
Table designs
Table styles
How do you change the text alignment in a cell?
Use the 'Insert' menu to add a text box for alignment.
Drag the cell borders to adjust the text position manually.
Select the cell, then adjust the alignment settings in the toolbar or format menu.
Right-click the cell and choose 'Center' from the context menu.
What is the formula to find the average of cells C1 to C10?
=AVERAGEIF(C1:C10)
=AVERAGE(C1:C10)
=SUM(C1:C10)
=MEAN(C1:C10)
How do you merge two or more cells into one?
Choose the cells, go to 'Data', and click 'Sort'.
Select the cells, click 'Format', and choose 'Align'.
Highlight the cells, right-click, and select 'Delete'.
Select the cells, right-click, and choose 'Merge Cells'.
What is the purpose of the 'Format as Table' option?
To create a visual chart from the data for presentations.
To convert a range of data into a structured table format for better management and analysis.
To apply conditional formatting to highlight specific values.
To merge multiple sheets into a single table for reporting.
How can you clear the contents of a cell without deleting it?
Press the 'Delete' key after selecting the cell.
Select the cell and press 'Ctrl + Z' to undo.
Right-click the cell and select 'Clear All'.
Use the 'Backspace' key after selecting the cell.
What is the function to sum values in a specific range?
SUM(range)
CALCULATE(range)
ADD(range)
TOTAL(range)
How do you use the fill handle to extend a formula?
Double-click the fill handle to automatically fill the formula.
Select the cell and press Ctrl+C to duplicate the formula in adjacent cells.
Click and drag the fill handle from the corner of the cell with the formula to extend it to adjacent cells.
Right-click the fill handle and select 'Copy Formula' to extend it.
