Creating and Opening Workbooks
A shortcut that can open an existing workbook in the Excel Application
What is Ctrl + O?
It allows you to save an existing workbook with a different name
What is File > Save as?
Directly below the ribbon, to the left side of the screen
What is the Name Box?
Special formatting applied to a cell that displays various criteria. This is done by applying different gradients to cells, adding data bars, etc
What is Conditional Formatting?
A file format created by Adobe that a workbook in Excel can be exported as
What is a PDF?
An area of the Excel application that has the following three commands: Save, Undo, and Redo
What is the Quick-Access tool bar?
The file extension of workbooks from 97-2003
What is .xls?
The keyboard shortcut to use the Go To command
What is Ctrl + G?
The shortcut used to access the replace feature in Excel
What is Ctrl + H?
An alternative to using the Go To command to find a cell / range with a specific name
If you were to click the drop down arrow below the name box, simply select the name of the item you would like to find (ignore the formatting)
It's directly below the ribbon, you can edit the contents of a cell by typing in it
What is the Formula Bar?
The default (current) file extension of Excel workbooks
What is .xlsx?
When a cell or range has a defined name
What is a named range?
Pressing these two keys will move one cell above
What is Shift + Enter?
It moves one cell to the left if you hold down these two keys
What is Shift + Tab?
When a Ribbon Tab is double-clicked
What causes the Ribbon to auto-hide?
The key that when pressed, moves one cell to the right
What is the tab key?
It can be used to only highlight cells containing formulas
What is Ctrl + G?
An expression that operates on values in a range of cells
What is a formula?
The keyboard shortcut for the "Redo" command
What is Ctrl + Y?
(Can't do the classic, purist jeopardy format here) When you access File > Open, you can switch between workbooks and...?
Folders
It is next to the formula bar and is used to complete a data entry while remaining in the same cell
What is the check mark?
You'll see this when you autofill Quarter One in cell A1 down to A5
When will you see Quarter 1 during autofill?
DOUBLE JEOPARDY!
Answer this question correctly, and you'll get twice as many points! Answer wrong, and you lose half of your points!
Question : If I have the date in A1 (20-01-23) and I have the time in cell B1 (9:00 AM), what would be the correct function to combine both cells into cell C1 separated by a comma and space?
An option found in the "Find" dialog box. It has an arrow located beside it that is used to search in the current sheet or in the entire workbook
What is the "Within" feature?