MS Excel MCQs

To return the reminder after the number is divided by a divisor in Excel we use the function ?

1. ROUND ( )
2. FACT ( )
3. MOD ( )
4. None

Which of the fol towing can you use to add times to the slides in a presentation?

1. slide show menu
2. rehearse timing button
3. slide transition button
4. all

What type of chart is good for single series of data ? Column Chart Line Chart

1. Pie Chart
2. Line Chart
3. Column Chart
4. None

What MS Excel 2016 feature can you use if you want to work with one record at a time?

1. Autocomplete
2. Auto filter
3. Data Form
4. Data validation

The arrangement of elements such as Title, Subtitle text, picture, tables etc.

1. layout
2. presentation
3. design
4. scheme

Which of following is not a valid data type in MS Excel ?

1. Number
2. character
3. label
4. Date/Time

A feature that displays only the data in column (s) according to specified criteria

1. Filtering
2. Sorting
3. Formula
4. None