MS Excel MCQ with Answers

Adds up cell values based on a condition

Adds all the numbers in a range of cells

Returns a subtotal in a list or database

All of above

All the data markers on a chart

A data series

A selected data marker

All

Allow you to view a different worksheet

Allow you to view additional worksheet row down

Allow you to view additional worksheet columns to the right

Allow you to view additional sheet tabs

Alt

Ctrl

F11

Shift

Alt + 1

Ctrl + 1

Ctrl + Shift + 1

F1