Microsoft Excel Mcqs with Answers for Test Preparation

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

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

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

See also  Islamic Studies MCQs With Answers

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

Which function displays row data into column or column data into row?

A. Hyperlink
B. Index
C. Transpose
D. Rows

Microsoft Office InterConnect is:

A. An application that supports editing scanned documents
B. None of these
C. Business-relationship database
D. A scanning and OCR application

Microsoft Office Accounting is:

A. A tool for managing business finances
B. None of these
C. Project management software to keep track of events and to create network charts and Gantt charts
D. Diagram and flow-charting software

Microsoft Office Suite spreadsheet program is _________?

A. None of these
B. Microsoft Word
C. Microsoft Excel
D. Microsoft PowerPoint

Move to Next Sheet in MS Excel:

A. Ctrl + Page Down
B. Shift + Page Down
C. Page Down
D. None of these

Move to next cell in row in MS Excel:

A. Tab
B. Shift
C. Space
D. None of these

Pages ( 7 of 15 ): « Previous1 ... 6 7 8 ... 15Next »

Leave a Comment