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

Which of the following formulas MS-Excel 2016 will not be able to calculate? =SUM (AI: A5)*.5, =SUM (Sales)-A3, =SUM( AI: A5)/(10-10), =SUM(AI:A5)-10

1. =SUM (AI: A5)*.5
2. =SUM (Sales)-A3
3. =SUM( AI: A5)/(10-10)
4. =SUM(AI:A5)-10

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

When you link data maintained in an excel workbook to a word document

1. The word document contains a copy of the actual data
2. The word document must contain a hyperlink
3. The word document contains a reference to the original source application
4. The word document cannot be edit

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

What is the slide-tittle master pair in MS PowerPoint 2016?

1. The title area and text area of a specific slide.
2. A slide master and title master for a specific design template
3. A slide master and title master merged into a single slide.
4. All of these

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