What is the purpose of a chart in Excel or Power BI?
Think about turning numbers into a picture.
Which symbol must every Excel formula begin with?
Choose the correct symbol.
Think about the symbol that tells Excel to calculate.
In Excel what do you call a saved collection of rows and columns of data?
It is the grid you enter data into.
Which Excel feature lets you quickly summarize large amounts of data?
Choose the correct feature.
It lets you group and summarize data interactively.
Which Excel function adds up a range of numbers?
Choose the correct function.
The name is exactly what it does.
Which Excel function counts how many cells contain numbers?
Choose the correct function.
The name describes exactly what it does.
What does a cell reference like B2 mean in Excel?
Choose the best explanation.
The letter always comes first and refers to the column.
Which Excel function finds the average of a range of numbers?
Choose the correct function.
The name describes exactly what it calculates.
In Power BI what is used to visually represent data such as bar charts and pie charts?
Think about the charts themselves.
What is Power BI mainly used for?
Think about charts dashboards and reports.
