Here are the best MS Office MCQs with Answers PDF | Free to Download For PPSC, FSPC, NTS Jobs Preparation Tests for all types of Jobs announced in Pakistan and India. Now a days every type of includes the portion of Microsoft Office Mcqs with different percentage. We are providing the best Online Job Preparation Services and Solved MCQS with Answer which are 100% Free to read and Download in PDF Format.
Q1 : . In Excel you can zoom a worksheet
(A) With the mouse pointer in Print Preview
(B) With the zoom button on the Print Preview toolbar
(C) With the Zoom command on the view menu
(D) All of the above
Q2 : You cannot link Excel worksheet data to a Word document
(A) With the right drag method
(B) With a hyperlink
(C) With the copy and paste special commands
(D) With the copy and paste buttons on the standard toolbar
Q3 : In Excel this type of software is similar to an accountant’s worksheet
(A) Word processing
(B) Database
(C) Spreadsheets
(D) Graphics
4. In Excel you can use the format painter multiple times before you turn it off by
(A) You can use the format painter button only one time when you click it
(B) Double clicking the format painter button
(C) Pressing the Ctrl key and clicking the format painter button
(D) Pressing Alt key and clicking the format painter button
Microsoft Excel MCQs Q5. In Excel default header for a worksheet is
(A) Your name
(B) The date and time
(C) None
(D) The sheet tab name
6. In Excel 3-D reference in a formula
(A) Cannot be modified
(B) Only appears on summary worksheets
(C) Limits the formatting options
(D) Spans worksheets
7. In Excel the auto calculate feature
(A) Can only add values in a range of cells
(B) Provides a quick way to view the results of an arithmetic operation on a range of cells
(C) Automatically creates formulas and adds them to a worksheet
(D) None of the above
Q8 : In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ….. ……menu
(A) Edit
(B) Format
(C) Tools
(D) Data
Q9 : In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
(A) Edit
(B) Insert
(C) Format
(D) Tools
10. In Excel which of the following is not a worksheet design criterionx
(A) Efficiency
(B) Auditability
(C) Description
(D) Clarity Correct Answer