The Basics
A single Excel file containing one or more worksheets.
What is a Workbook?
Jack would like the data in Row 10 not to display on his spreadsheet. This option should be selected.
What is Hide?
An example of this is A1:D11
What is a Cell Range?
Examples of this are Arial, Times New Roman, Calibri.
What is a Font?
It is a type of entry you can make when inserting data into worksheet cells.
What is numeric, text, and formulas?
It is located at the intersection of every row and column.
What is a Cell?
This allows you to change the width of a column so that the widest entry will fit.
What is AutoFit?
A tool that will quickly insert a SUM function into the current cell and determine the appropriate cell range to be used.
What is AutoSum?
It allows you to delete the data, formatting and comments in a cell.
What is Clear All?
It locks the text to the left and above the selected cell.
What is a Freeze Pane command?
A field on the screen that displays the contents in the active cell.
What is a Formula Bar?
A rectangle outlined with a moving, dotted line that appears around a cell range that has been cut or copied and can be pasted into a new location.
What is a Marquee?
A feature that allows you to quickly perform a calculation or formula.
What is a Function?
The feature that combines more than one cell into one larger cell.
What is Merge?
It is a key that activates Edit mode in Excel.
What is F2?
It can help you quickly find commands you require to complete a task.
What is a Ribbon?
It is a keyboard combination that allows you to paste.
What is CTRL+V?
It is a type of cell address that adjusts positionally when copied to other cells in a worksheet.
What is Relative Cell Address?
The positioning or placement of content within a cell.
What is Alignment?
It is when a pie chart appears as a separate piece.
What does an Exploded Pie Chart mean?
A method of copying data and formulas or creating data series by dragging the lower right corner of a cell or range.
What is AutoFill?
It is a keyboard combination that allows you to reverse the last command that was executed.
What is CTRl+Z?
An example of this is ='Quarter 4'!F6.
How do you reference other worksheets?
It is a number format that does not allow you to control how negative numbers display.
It is a powerful tool you can use to display the data in cells one way for some values, but another way for others without the effort of manually changing how it is displayed each time you modify data or enter new data into a worksheet.
What is Conditional Formatting?