Microsoft Excel Mcqs with Answers for Test Preparation

Which Shortcut keys are used to strikethrough highlighted selection in Excel?

A. Ctrl+4
B. Ctrl+5
C. Ctrl+6
D. None of the above.

Which of the following is the latest version of MS Excel?

A. Excel 2016
B. Excel 2017
C. Excel 2021
D. Office 365

In MS Excel, Conditional Formatting is in ______ tab?

A. Home
B. View
C. Page Layout
D. Insert

Which of the following you can paste selectively using Paste Special Command?

Validation
Formats
Formulas
All of above

You can set page border in excel from: __________?

A. From Border tab in Format Cells dialog box
B. From Border tool in Formatting toolbar
C. From Line Style tool in Drawing toolbar
D. You can not set page border in Excel

Excel displays the current cells address in the __________?

A. Formula bar
B. Status bar
C. Name box
D. Title bar

The first cell in excel worksheet is labeled as _________?

A. AA
B. A1
C. Aa
D. None of these

See also  Ideology of Pakistan MCQs with Answers

An excel workbook is a collection of __________?

A. Workbooks
B. Worksheets
C. Charts
D. Worksheets and Charts

Which of these key are used in ms excel to insert current time In workbook.

A. Ctrl + Shift + ;
B. Ctrl+!
C. Ctrl+*
D. None of these

Getting data from a cell located In a different sheet is called ___________?

A. Accessing
B. Referencing
C. Updating
D. Functioning

Which element is deficient in milk _________?

A. Iron
B. Phosphorus
C. Sodium
D. Calcium

In Ms Excel Ready made templates are available under _______ tab ?

A. File
B. Insert
C. Design
D. None of Above

You can edit existing Excel data by pressing the:________ key?

A. F1 Key
B. F2 Key
C. F3 Key
D. F4 Key

When you insert an Excel file into a word document, the data are?

A. Hyperlinked
B. placed in a word table
C. linked
D. embedded

The Greater Than sign is an example of ________ operation ?

A. Arithmetic
B. Logical
C. Conditional
D. Greater

Pages ( 5 of 15 ): « Previous1 ... 4 5 6 ... 15Next »

Leave a Comment