Home
What is Auto Sum?
Auto Sum is a tool that when selected adds up all the cells that you have selected
How do you use Date and time tool?
The DATE VALUE function in Excel converts a date in the text format to a serial number that Excel recognizes as a date.
what does hyperlink do?
hyperlink links a website or contact to a certain word or phrase
where is the text to columns?
in the data tools group
where is orientation?
page setup group
What is Wrap Text?
Wrap text is a function that takes the data in the cell and makes it fit with the column width
What does the Text tool do?
Convert's numbers in cells to text
where is the table tool?
in the tables group
what is the group tool?
the group tool, grouping allows users to club rows or columns of any number together so that we can hide or in proper words subset the data under the selected columns and rows.
what does the margins tool do?
In Excel, page margins are used to specify how much white space (blank area) should be left around the information in your worksheet
How do you use the Fill function?
To use the Fill command on the ribbon, enter the first value in a cell and select that cell and all the adjacent cells you want to fill
Where is the Financial tool located?
The Financial tool is located in the function library
how do you insert a chart?
you click insert chart and choose the one you want
how to use get data from other sources?
You can take data from one workbook to another
what is background?
background is what is the white space it can be changed to a picture or something else
What is Find and Select?
Find and Select is a tool that you use to find words or sentences and replace them
What is the Recently Used tool?
The Recently Used tool brings up all the formulas you have used recently
what is the illustrations tool do?
it inserts a picture or drawling on to the spreedsheet
You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file
what is Print Area?
Print area is what will be printed
Where is the font color button?
The font color button is in the Font group
What is Insert Function?
When you click the Insert Function button, Excel displays the Insert Function dialog box. You can then use its options to find and select the function that you want to use and to define the argument or arguments that the function requires in order to perform its calculation.
where is the symbols tool?
in the text group
What is flash fill?
that Flash Fill automatically fills your data when it senses a pattern
what is the Size Tool?
The size tool changes the size of the spreadsheet