Font size
WorksheetsTabulation Activity
Total questions: 18
Worksheet time: 18mins
What is the purpose of using a spreadsheet?
To develop formulae for calculations
To create charts based on instructions
To apply basic formatting
It spreads or shows all of the cost, income taxes and other related data on a single sheet for management to examine when making decisions
What is a worksheet in Excel?
A collection of related spreadsheets
A single working area in a spreadsheet file
A means of arranging data
A mode of causal communication
How can you move around a spreadsheet/worksheet?
Press ctrl+G to open the Go To box
Press a tab key to move to the next column
Press the navigation arrow keys
Click on a cell with the mouse to make it active
all the bove
What is the purpose of merging cells in Excel?
To enter data in a cell
To apply borders to cells
To center the heading
To create charts
How can you enter data in a cell in Excel?
Click in the cell and type the data
Click on another cell to finish
Press the arrow key to move to the next row
Press the tab key to move to the next column
What is the purpose of a workbook in Excel?
A collection of related spreadsheets saved as one file
A single working area in a spreadsheet file
A means of arranging data
A mode of causal communication
What is the function of the fill handle in Excel?
To copy formulas to other cells
To merge cells and center headings
To enter data in a cell
To apply borders to cells
What is the purpose of the formula bar in Excel?
To create charts based on instructions
To move around the spreadsheet/worksheet
To confirm data entry in a cell
To apply basic formatting
What is the default name given to a new workbook in Excel?
Book1
Workbook1
Sheet1
Excel1
What is the purpose of the outside border option in Excel?
To enter data in a cell
To create charts
To merge cells and center headings
To apply borders around a cell range
How can you format cells in Excel?
By using the fill handle
By pressing the delete key
By clicking on a cell
By pressing the tab key
What is the purpose of conditional formatting in Excel?
To create charts based on data
To apply formatting based on specific conditions
To merge cells and center headings
To enter data in a cell
What is the purpose of the SUM function in Excel?
To create charts based on data
To apply basic formatting
To calculate the total of a range of cells
To merge cells and center headings
What is the purpose of the AutoSum function in Excel?
To create charts based on data
To apply basic formatting
To calculate the total of a range of cells
To merge cells and center headings
The Act or process of tabulating or arranging in tabular form that is, into a table.
(a)
=(C3*C6)/C7 is an example of a
formula
function
calculation
data
=Min(C1:G1) is an example of a
formula
function
data
caculation
The area where the mouse turn into a plus sign is a tool in Microsoft Excel that allows users to quickly copy formulas or data down a column or across a row is known as the
point
litte square
fill hand
drag amd drop
