Crowdly

AutoFill

Conditional Formatting

AutoSum

Which function would you use to calculate the total of a range of numbers?

You can apply formatting such as bold, font colour, and cell background colour in Google Sheets.

Which of the following is used to count only numerical values in a range?

SUM()

COUNTIF()

COUNT()

COUNTA()

AVERAGE()

SUM()

MIN()

COUNT()

After filtering the PivotTable (or source data) to show only students with Attendance % > 85, how many students meet this threshold?

From the dataset, which Student IDs remain visible after this filter? (Select all that apply.)

You apply a filter (or slicer) on Attendance % to show only students with Attendance % > 85.

1001 – Attendance 90

1002 – Attendance 75

1003 – Attendance 95

1004 – Attendance 80

1005 – Attendance 85

1005

1002

1003

1001

You need a PivotTable that shows the number of students per Course. Which field configuration correctly produces this?

Rows: Course; Values: Average of Grade

Rows: Student ID; Values: Count of Course

Rows: Course; Values: Sum of Grade

Rows: Course; Values: Count of Student ID

You create a PivotTable to summarize average Grade by Department and Semester. How should you arrange the fields?

Rows: Department; Columns: Grade; Values: Average of Semester

Rows: Department; Columns: Semester; Values: Average of Grade

Rows: Semester; Columns: Department; Values: Sum of Grade

Rows: Course; Columns: Semester; Values: Count of Student ID

You want to create a PivotTable from this dataset in Excel. Which sequence of steps is most appropriate?

Select the data range → Insert tab → PivotTable

Select the data range → Data tab → Filter

Select the data range → Home tab → Format as Table

Select the data range → Review tab → New Comment

Deep learning differs from traditional machine learning in:

It costs more

It uses layered neural networks

It's always more accurate

It requires less data