Excel Quiz 4

What does the OR() function return?

• TRUE if any condition is TRUE

• FALSE always

• The opposite of NOT

• FALSE if one is false

Which error indicates a divide-by-zero problem?

• #NAME?

• #VALUE!

• #DIV/0!

• #REF!

Which function returns the current time only (without date)?

• =TEXT(NOW(),"hh:mm:ss")

• =NOW()

• =TIME()

• =TODAY()

What is the main purpose of a PivotTable in Excel?

• To create complex formulas and calculations

• To organize and summarize large amounts of data

• To create data visualizations using charts and graphs

• To apply cell formatting to selected ranges

What is a PivotChart in Excel?

• A way to filter data in a worksheet

• A tool for merging cells

• A type of data validation rule

• A visual representation of PivotTable data

What are functions and their codes in the context of subtotals in Excel?

• Descriptions of different subtotal functions available in Excel

• Formulas used to calculate subtotals and the corresponding color codes

• Shortcut keys to apply subtotals to selected data

• Codes used to hide subtotals in a worksheet

In Excel, what is the working principle of 'Interim Results' in subtotals?

• It adds cell formatting to the subtotal results

• It calculates intermediate totals at various levels of grouping.

• It calculates an average of data points

• It performs a multiplication operation

What is the purpose of using slices in Excel's PivotTables?

• To divide the data into equal parts

• To provide a user-friendly way to filter and interact with data

• To perform calculations within the PivotTable

• To create pie charts

How can you display dates and times more effectively in a PivotTable using a graphical representation?

• By using a Sparkline

• By adding a Timeline

• By creating a Slicer

• By adding a Data Bar

What is the correct cell address for the cell located at the intersection of column B and row 5?

• B4

• A5

• C5

• B5