Excel Basics
Contains groups or tabs of commonly used commands within Excel
Excel Ribbon
How can you insert a new row or column within an Excel worksheet?
Right-click a row or column to open its context menu and then select "Insert"
How would the user apply a Cell Style?
Select intended cells to format, then select a style with the Cell Styles command under the Styles group of the Home tab in the Excel ribbon.
What keyboard shortcut can you use to insert a table?
What is Ctrl+T
Precedes/Comes before a Function in Excel
= sign
Shortcut that can be used to undo an action
Ctrl + Z
To delete a column in a worksheet, you can select the column header and use which of the following shortcut keys?
Ctrl+Hyphen(-)
How can the user Merge Cells
Select the intended cells, then select the "Merge and Center" command to... Merge and Center the selected cells.
Alternative solution
Right Click on the highlighted cells > Click Format Cells, Then Click the Alignment tab and place a checkmark in the checkbox labeled Merge cells
A table can be converted to which of the following?
What is Data Range
Headers, footers, and margins are all ____ options.
What is page setup
How can the Backstage View be accessed?
Through clicking or entering the File Tab on the Excel Ribbon
To paste copied data from horizontal to vertical, which option would you use from Paste Special?
Transpose
How can the user remove formatting in cells?
The "Clear Formats" command under Clear in the Home tab of the Excel ribbon
Which table row calculates numeric data by using functions?
What is Total row
Used to find the minimum value in a data set/group of values
=MIN
Located at the bottom right corner of the Active Cell; allows the user to drag contents of cell(s) selected to fill other areas of the worksheet
Fill Handle
Which command on the “HOME RIBBON” allows data to be moved from one worksheet location to another?
Cut
Predesigned formatting that can be applied to a range of cells or even to an entire worksheet
Table Styles
What option is a unique combination of borders and shading to change the appearance of the table?
What is Styles
How would the user create an absolute cell reference?
Precede cell address characters with $
e.g. $A$1
Allows the user to locate (and change) specified data within an Excel workbook
Find (& Select) Command/Ctrl+F
The keyboard shortcut to access the Paste Special dialog box is
Ctrl+Alt+V
A type of cell formatting that changes based on the cell value or the outcome of a formula.
Conditional Formatting
Which command creates a table and simultaneously applies a table style?
What is Format as Table
Allows you to enter a number once and copy it through other worksheets
Drilling an entry