Excel Basics
What is the name of the grid in Excel where data is entered?
What is Worksheet?
What symbol must you type first to start a formula?
What is =?
What type of chart is best for showing percentages?
What is Pie Chart?
How do you make text bold in Excel?
What is Use the Bold button or Ctrl+B?
Shat shortcut do you use to copy and paste?
What is Ctrl+C and Ctrl+V?
How do you save a file in Excel?
What is File, Save As or Ctrl+S
What function would you use to calculate the total of a range of numbers?
What is =SUM or Auto SUM?
How do you insert a chart in Excel?
What is Select data, Insert, Choose Chart Type?
How can you automatically adjust column width to fit the content?
What is Double-click the column header's edge?
What shortcut moves to the next sheet in a workbook?
What is Ctrl+Page Down?
What do you call the intersection of a row and a column?
What is Cell?
Which function finds the largest value in a range?
What is =MAX?
What feature allows you to highlight data trends with color bars or icons?
What is Conditional Formatting?
What feature allows you to format a range of data as a structured table?
What is Format as Table?
How do you quickly select all the cells in a worksheet?
What is Ctrl+A?
How do you add a new worksheet to your workbook?
What is Click the + button next to the sheet tabs?
What is the difference between =A1+B1 and =$A$1+B1?
What is $A$1 is an absolute reference and will not change when copied; A1 is relative and will adjust based on its location?
Name two elements you can add to a chart to make it easier to read?
What is Titles and Legends?
What is the difference between a cell's fill color and font color?
What is Fill color is the background color of the cell' font color is the color of the text?
What is the shortcut to undo your last action?
What is Ctrl+Z?
What is the default file format for saving Excel files?
What is .xlsx?
What does the =IF function do?
What is Performs a logical test and returns one value for TRUE and another for FALSE?
What type of chart is ideal for showing trends over time?
What is Line Chart?
How do you Merge multiple cells into one?
What is Select cells, Home, Merge & Center?
What shortcut can you use to quickly create a chart from selected data?
What is Alt+F1?