Skill Quiz-1 Level-1

_____________ data type takes the values in the form of 0 and 1 in the database.

• Integer

• Text

• Boolean

• Memo

In database _________ helps us to retrieve the filtered data based upon some conditions.

• Forms

• Reports

• Queries

• Table

______________ uses the keyboard as a pointing device instead of a mouse.

• MouseKeys

• Toggle key

• Filter key

• Sticky key

 ___________ is a tool to test “what-if” questions.

• Scenario

• Solver

• Macro

• Average

Amrita is celebrating her 14th birthday. She wants to invite her friends and family members to the party. Which feature will she use to send the same invite to many people with different addresses without typing it again and again? 

• Mail Merge

• Letter wizard

• Document Type

• None of these

Hema is a chartered accountant. She used to maintain the accounts in a spreadsheet on everyday basis. There are number of steps which she needs to follow every time. Can you suggest her a feature of spreadsheet through which she can perform these tasks quickly without repeating the steps every time? Record Changes

• Record Changes

• Track Changes

• Goal Seek

• Using Macros

By default, sheets tabs are present at the ________ of the spreadsheet

• Top

• Bottom

• Centre

• Right

An ________ link will stop working only if the target is moved while a _______ link will stop working only if the start and target location change relative to each other.

• Absolute, fixed

• Relative, absolute

• Absolute, relative

• Permanent, absolute

_______ means combining data in a spreadsheet from different worksheets into master worksheet.

• Hyperlink

• Consolidationg

• Linking

• Filter

_____________, total/adds data arranged in a array – that is, a group of cells with labels for columns and/or rows which step one must should follow before using the Subtotal option?

• Consolidate

• Rename Data

• Filter Data

• Subtotal