Chapter 6 Editing and Formatting a Workbook MCQs 25 min Score: 0 Attempted: 0/25 Subscribe 1. . The default alignment of text in Excel is __________. (A) centered (B) left (C) right (D) justifyShow All Answers 2. . The default alignment of numbers in Excel is __________. (A) centered (B) left (C) justify (D) rightShow All Answers 3. . To enter data on a new line within a cell, the shortcut key is used. (A) Ctrl + Enter (B) Alt + Enter (C) Shift + Enter (D) None of aboveShow All Answers 4. . To enter the current date and time in a cell the function is used. (A) None of these (B) Today (C) Date (D) NowShow All Answers 5. . Example of Arithmetic operators is __________. (A) >< = (B) None of above (C) And Or Not (D) + - * / ^Show All Answers 6. . Example of Relational operators is __________. (A) And Or Not (B) + - * / ^ (C) >< = (D) None of theseShow All Answers 7. . Example of Logical operators is __________. (A) >< = (B) + - * / ^ (C) None of these (D) And Or NotShow All Answers 8. . Identify the symbol for exponential power. (A) * (B) ^ (C) / (D) =Show All Answers 9. . Identify the symbol for multiplication.**Answer: (a) *** (A) * (B) / (C) ^ (D) =Show All Answers 10. . Identify the symbol for division. (A) * (B) / (C) ^ (D) \Show All Answers 11. . The correct example of a cell address. (A) 11 22 (B) 911 (C) 15A (D) A15Show All Answers 12. . When you accidentally erased a record in a sheet, the command is used to restore. (A) Insert (B) Copy (C) Undo (D) ReplaceShow All Answers 13. . The shortcut key to edit a cell entry is __________. (A) F1 (B) F2 (C) F3 (D) F4Show All Answers 14. . The keyboard shortcut to open Format Cells dialogue box is __________. (A) Ctrl + 1 (B) Ctrl + 2 (C) Ctrl + 3 (D) Ctrl + 4Show All Answers 15. . Which symbol is used in cells range? (A) ; (B) (C) “ (D) ?Show All Answers 16. . Correct example of cells range from A1 to F10 is __________. (A) A1-F10 (B) A1; F10 (C) A1.F10 (D) A1: F10Show All Answers 17. . You can copy cell formats from one cell to another by using the __________. (A) Backspace key (B) Default (C) Format painter (D) Formatting toolbarShow All Answers 18. . To insert two columns between column C and D you would __________. (A) select column C (B) select column D, E, F (C) select column C, D, E (D) select column DShow All Answers 19. . The default extension of MS Excel file is __________. (A) xlsx (B) xlw (C) xcl (D) exlShow All Answers 20. . The process of arranging the items of a column in some sequence is known as __________. (A) arranging (B) auto fill (C) filtering (D) sortingShow All Answers 21. . The feature of MS Excel quickly completes a series of data. (A) Filtering (B) Auto Complete (C) Sorting (D) Auto FillShow All Answers 22. . The keyboard shortcut to get print out of an Excel sheet is __________. (A) Ctrl + P (B) Ctrl + E (C) Ctrl + R (D) Ctrl + TShow All Answers 23. . If you require more than one hard copies of the worksheet, then enter it in field. (A) Number of Copies (B) Copies (C) Copy (D) none of aboveShow All Answers 24. . You can print __________. (A) Selection (B) An entire workbook (C) All of these (D) A single worksheetShow All Answers 25. . To exit from MS Excel program the shortcut is used. (A) Shift + F4 (B) Ctrl + F4 (C) Alt + F4 (D) Alt + Ctrl + F4Show All Answers