PPSC Lecturer Microsoft Office Quiz No 7 A.J. Bhatti February 22, 2021 Welcome to your PPSC Lecturer Microsoft Office Quiz No 7 Name Email 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 5. 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 Author: A.J. Bhatti
