MS Office (Word, Excel, PowerPoint) MCQs – Page 2

Solved MS Office MCQs on Word, Excel and PowerPoint shortcuts, formulas, cell references and features, asked in PPSC clerk and computer operator tests.

1. 21

   How many rows does a worksheet have in Excel 2007 and later versions?

   A16,384B1,048,576C65,536D1,000,000

   Correct answer: B. 1,048,576

   Modern Excel worksheets have 1,048,576 rows and 16,384 columns (A to XFD). Excel 2003 had 65,536 rows.

   mediumShow answer
2. 22

   In MS PowerPoint, which key starts the slide show from the first slide?

   AF7BF5CCtrl + F5DShift + F5

   Correct answer: B. F5

   F5 starts the show from the beginning. Shift + F5 starts it from the current slide.

   easyShow answer
3. 23

   In MS PowerPoint, Ctrl + M is used to:

   AMute audioBMerge slidesCInsert a new slideDOpen the slide master

   Correct answer: C. Insert a new slide

   Ctrl + M adds a new slide after the current one.

   mediumShow answer
4. 24

   The default file extension of a PowerPoint presentation (2007 and later) is:

   A.pptB.pdfC.pptxD.pps

   Correct answer: C. .pptx

   PowerPoint saves presentations as .pptx by default. .ppt was the format of older versions.

   easyShow answer
5. 25

   The default file extension of an Excel workbook (2007 and later) is:

   A.xlsxB.xlsC.csvD.docx

   Correct answer: A. .xlsx

   Excel saves workbooks as .xlsx by default. Workbooks that contain macros use .xlsm.

   easyShow answer
6. 26

   Which shortcut repeats or redoes the last action in MS Office?

   ACtrl + QBCtrl + YCCtrl + RDCtrl + Z

   Correct answer: B. Ctrl + Y

   Ctrl + Y redoes (or repeats) the last action, while Ctrl + Z undoes it.

   easyShow answer