Microsoft Excel Mcqs with Answers for Test Preparation

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

See also  Analytical Reasoning Questions With Answers

In Ms Excel, which of the following special function keys allow the content in cell?

A. Shift
B. Esc
C. Tab
D. Space

Ctrl+Shift+1 shortcut Keys in excel are used to __________?

A. Format number in comma format
B. Format number in currency format
C. Format number in date format
D. Format number in time format

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

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

Leave a Comment