Excel Basic Level QUIZ

Which of the following Ribbons appear when you open Excel?

• a) Home, Insert, Page Layout, Formulas, Data, Review, View
• b) Home, Insert, Page Setup, Formulas, Data, Review, View
• c) Design, Layout, Formulas, Data, Review, View
• d) Edit, Insert, Formatting, Data, Review, View

Which of the following commands appear under the Home Ribbon?

• a) PivotTables, Slicers, Filters
• b) Insert Table, Chart, Picture
• c) Cell Styles, Conditional Formatting, Sort & Filter
• d) AutoSum, Insert Function, Name Manager

Which of the following commands does the Page Layout Ribbon contain?

• a) Font, Alignment, Number Format
• b) Margins, Orientation, Page Setup
• c) Themes, Colors, Fonts
• d) Sort, Filter, Subtotal

When will you use the DATA Ribbon?

• a) To insert charts and pictures
• b) To format cells and apply styles
• c) To perform calculations and use formulas
• d) To import, export, and analyze data

What is the most common file extension in Excel?

• a) .docx
• b) .pptx
• c) .xlsx
• d) .pdf

What is the difference between a workbook and worksheet?

• a) A workbook contains multiple worksheets, while a worksheet contains multiple workbooks
• b) A workbook is a file that contains one or more worksheets
• c) A worksheet is a file that contains one or more workbooks
• d) A workbook and a worksheet are the same thing

What happens if you delete a worksheet?

• a) The worksheet is permanently deleted and cannot be recovered
• b) The worksheet is moved to the Recycle Bin and can be restored if needed
• c) The data in the worksheet is deleted, but the worksheet itself remains in the workbook
• d) Nothing happens, you cannot delete a worksheet in Excel

What is the shortcut key to save a workbook/Excel file?

• a) Ctrl + S
• Alt + S
• c) Ctrl + C
• d) Ctrl + X

What is the shortcut key to insert a new worksheet in a workbook?

• a) Ctrl + N
• b) Ctrl + Shift + N
• c) Ctrl + W
• d) Ctrl + Shift + W

From which group can you apply number, text, and accounting formatting?

• a) Font
• b) Alignment
• c) Styles
• d) Number