Module 4 + Module 5 EXCEL

How do you create a table and apply a table style at the same time?

What keyboard shortcut opens up a dialog box launcher?

What order of operation acronym does Excel use for formulas?

What is a cell reference RANGE?

What operator is used to add in Excel?

Which of these is a relative cell reference?

When you want to highlight the first row of table by using a header, what command should you use?

What is used to multiply in Excel?

What operator is used to divide in Excel?

Which of these are table style CATEGORIES?

What operator is used to subtract in Excel?

What row adds up numeric data using a function?

What keyboard shortcut can you use to create a table?

What is used to start a formula in Excel?

Which function adds up all the numbers in a cell range for you?

What is the definition of a FUNCTION in Excel?

Which function finds the average of a cell range for you?

How do you display all formulas in a worksheet?

When you want to highlight the last column of a table, what command should you use?

Table Styles do which of the following:

What function is used to find the lowest number in a cell range?

What keyboard shortcut toggles Total Row? (On/off)

What is the definition of a cell reference?

On which tab can you find the Insert Sheet Columns and Insert Sheet Rows commands?

When you want to highlight every other row, what command should you use?

Can a table be converted into a data range?

When you want to highlight the first column of a table, what command should you use?

What contextual tab appears when selecting a table?

What is an OPERATOR in Excel?

When you want to make columns easier to see and work with, what command should you utilize?