Part 1: Excel Basics Quiz – Introduction to Excel (20 MCQ)

Correct answer: B. Managing, organizing, and analyzing data

★ Key Takeaway: Excel is built for structured data work, including calculations and analysis.

Explanation: Excel stores information in a grid of rows and columns, making it easy to calculate totals, compare values, and summarize data using formulas and built-in tools like sorting and filtering.

Why other options are incorrect:

• A. Creating slide presentations – This is primarily done in PowerPoint, which is designed for slides and visual presentations, not spreadsheets.
• C. Editing photos and videos – This requires media editing software; Excel focuses on data and calculations rather than image or video production.
• D. Writing long documents – This is the main job of Word, which supports advanced text layout and document formatting.

Tip: Want to master Excel basics quickly? Hire a 1-on-1 Excel tutor on Fiverr for personalized guidance. Explore 1-on-1 Excel tutoring on Fiverr →

Correct answer: C. An Excel file that can contain one or more worksheets

★ Key Takeaway: A workbook is the full Excel file you save and reopen.

Explanation: When you save an Excel file, you are saving a workbook. That workbook can hold multiple worksheets so you can separate different topics or datasets inside one file.

Why other options are incorrect:

• A. A single cell – A cell is one small box where data goes, not the entire file.
• B. A single worksheet only – A workbook can include many worksheets, not just one.
• D. A chart made from data – A chart is an object created inside a worksheet; it is not the workbook itself.

Correct answer: B. A single sheet or page inside a workbook

★ Key Takeaway: A worksheet is one working page where you enter and edit data.

Explanation: A worksheet is the grid of rows and columns where you type values, create tables, and build formulas. A workbook can hold multiple worksheets for better organization.

Why other options are incorrect:

• A. The entire Excel application – Excel is the software program; a worksheet is just one page inside an Excel file.
• C. A saved Excel file – The saved file is called a workbook, not a worksheet.
• D. A built-in formula – Formulas are typed into cells; they are not worksheets.

Correct answer: B. The intersection of a row and a column

★ Key Takeaway: Cells are the basic building blocks where Excel stores data.

Explanation: A cell is identified by its address, such as A1, based on column letter and row number. Cells can contain text, numbers, dates, or formulas.

Why other options are incorrect:

• A. A complete worksheet – A worksheet contains many cells; a cell is just one location within the worksheet.
• C. A group of worksheets – Multiple worksheets together are part of a workbook, not a cell.
• D. A formatting command – Formatting changes appearance; it is not the place where data is stored.

Correct answer: A. A group of cells selected together

★ Key Takeaway: A range is multiple cells treated as one unit.

Explanation: Ranges are used in formulas and formatting, such as A1:A10 or B2:D5. Many Excel tools work on ranges rather than a single cell.

Why other options are incorrect:

• B. A single selected cell – A single cell is one address; a range includes two or more cells.
• C. An entire workbook – A workbook is the saved file that contains worksheets, not a selection of cells.
• D. A type of Excel file – File types are formats like XLSX or CSV; a range is inside a worksheet.

Correct answer: D. Ribbon

★ Key Takeaway: The Ribbon is the main command center in Excel.

Explanation: The Ribbon groups tools into tabs so you can quickly find commands for formatting, inserting charts, managing data, and reviewing work.

Why other options are incorrect:

• A. Formula Bar – The Formula Bar is for viewing and editing the contents of the active cell.
• B. Name Box – The Name Box shows the active cell reference and can jump to a cell or range.
• C. Status Bar – The Status Bar shows quick information like sum, count, and modes at the bottom.

Correct answer: D. To view and edit the content of the active cell

★ Key Takeaway: The Formula Bar is the clearest place to edit long values and formulas.

Explanation: Cells may show only part of their content, but the Formula Bar shows the full value or formula. This makes editing complex formulas much easier and more accurate.

Why other options are incorrect:

• A. To show worksheet names – Worksheet names appear on the sheet tabs at the bottom of the workbook.
• B. To create charts automatically – Charts are created through the Insert tab after selecting data.
• C. To save the workbook – Saving is done via the Save command or shortcuts like Ctrl + S.

Correct answer: C. .xlsx

★ Key Takeaway: XLSX is the standard modern workbook format for Excel.

Explanation: The XLSX format supports multiple worksheets, formulas, formatting, and charts. It is the default format for most Excel versions today.

Why other options are incorrect:

• A. .docx – DOCX is used for Word documents, not Excel spreadsheets.
• B. .pptx – PPTX is used for PowerPoint presentations, not Excel workbooks.
• D. .html – HTML is used for web pages, not for saving Excel workbooks.

Correct answer: C. Stores your recent changes in the file

★ Key Takeaway: Save updates the file so your latest work is not lost.

Explanation: Saving writes your changes to storage. For a new file, the first Save typically asks for a file name and location.

Why other options are incorrect:

• A. Deletes the workbook – Deleting is a separate action handled by your file system, not the Save command.
• B. Prints the workbook – Printing uses the Print command; saving does not send anything to a printer.
• D. Creates a new worksheet automatically – Adding worksheets is a workbook editing task, unrelated to saving.

Tip: If saving, naming, and organizing files feels confusing, an Excel tutor can help you build the right habits quickly. Find an Excel tutor on Fiverr →

Correct answer: A. Ctrl + S

★ Key Takeaway: Ctrl + S is the fastest habit for protecting your work.

Explanation: Saving frequently helps prevent losing progress due to crashes or accidental closure, especially during longer editing sessions.

Why other options are incorrect:

• B. Ctrl + O – This shortcut opens an existing file; it does not save.
• C. Ctrl + P – This shortcut opens print options; it does not save changes.
• D. Ctrl + N – This shortcut creates a new workbook; it does not save the current one.

Correct answer: A. The address of the active cell

★ Key Takeaway: The Name Box helps you know exactly where you are on the sheet.

Explanation: When you click a cell, the Name Box shows its reference (such as B7). You can also type a reference in the Name Box to jump directly to that cell or range.

Why other options are incorrect:

• B. The number of worksheets in the workbook – Worksheet count is managed through sheet tabs and workbook structure, not shown in the Name Box.
• C. The file extension of the workbook – File extensions belong to the file name and are not a Name Box feature.
• D. The last saved time of the workbook – Save time may appear in file properties, not in the Name Box.

Correct answer: B. Numbers

★ Key Takeaway: Rows run left to right and are numbered.

Explanation: Row numbers appear on the left side of the worksheet. Cell addresses combine a column letter and row number, such as A1.

Why other options are incorrect:

• A. Letters – Letters label columns, not rows.
• C. Colors – Colors are formatting choices and do not label rows.
• D. Symbols – Excel does not label rows using symbols.

Correct answer: C. Letters

★ Key Takeaway: Columns run top to bottom and use letter labels.

Explanation: Columns start at A and continue through Z, then AA, AB, and so on. This letter system is part of how Excel builds cell references.

Why other options are incorrect:

• A. Numbers – Numbers label rows, not columns.
• B. Dates – Dates can be entered as values, but they are not column labels.
• D. Icons – Excel does not label columns with icons.

Correct answer: D. The cell currently selected

★ Key Takeaway: The active cell is where your next action will apply.

Explanation: Excel highlights the active cell with a border. Any typing, pasting, or formatting you do will affect the active cell or selected range.

Why other options are incorrect:

• A. The cell with the largest number – A cell becomes active by selection, not by its value.
• B. A cell that contains only text – Any cell can be active regardless of whether it contains text, numbers, or formulas.
• C. A cell that is hidden – Hidden cells are not typically selected as the active cell during normal use.

Correct answer: C. Home

★ Key Takeaway: Home is the go-to tab for everyday spreadsheet tasks.

Explanation: The Home tab contains common tools like font formatting, alignment, number formatting, and clipboard actions because these are used in most Excel work.

Why other options are incorrect:

• A. Insert – Insert is mainly for adding things like tables, charts, and pictures.
• B. Data – Data focuses on sorting, filtering, and analysis tools rather than basic formatting.
• D. Review – Review is for comments, spelling, and protection features, not the main formatting tools.

Correct answer: B. Quick statistics like sum and count for selected cells

★ Key Takeaway: The Status Bar gives instant feedback about your selection.

Explanation: When you select a range with numbers, Excel can show quick calculations like sum, count, and average on the Status Bar, helping you verify results without writing a formula.

Why other options are incorrect:

• A. Only the workbook file name – The file name appears in the title bar, not the Status Bar.
• C. A list of all formulas in the workbook – Excel does not list all formulas on the Status Bar; formulas are viewed in cells or formula tools.
• D. The file extension of the workbook – File extensions are part of the file name, not a Status Bar feature.

Correct answer: D. Excel loads the saved data, formulas, and formatting

★ Key Takeaway: Opening a workbook restores it as it was last saved.

Explanation: Excel reads the workbook file from storage and displays the same worksheets, values, formulas, and formatting you previously saved.

Why other options are incorrect:

• A. A new blank workbook replaces it – A blank workbook opens only when you choose New, not when you open a saved file.
• B. Excel automatically deletes old worksheets – Excel does not remove worksheets automatically when opening a file.
• C. Excel converts the file into a text document – Opening a workbook does not change its format into a text document.

Correct answer: B. To stop working on the file while keeping it saved for later

★ Key Takeaway: Closing ends your current session with the file, not the file itself.

Explanation: Closing removes the workbook window from view, while the file stays stored on your device. If there are unsaved changes, Excel typically prompts you to save.

Why other options are incorrect:

• A. To delete the workbook from the computer – Deleting is done through the file system; closing does not remove the file.
• C. To remove all formulas from the worksheet – Closing does not change the workbook contents or remove formulas.
• D. To permanently lock all cells – Locking cells requires protection settings; closing does not apply protection.

Correct answer: A. Cell content

★ Key Takeaway: Anything you type into a cell becomes its content.

Explanation: Cell content can be a value, text label, date, or a formula like =A1+B1. Excel interprets the content to calculate results or display it in a format you choose.

Why other options are incorrect:

• B. Ribbon command – Ribbon commands are buttons and tools you click, not information stored inside a cell.
• C. Workbook layout – Layout refers to arrangement and formatting, not the actual data entered into a cell.
• D. File template – A template is a starting file setup; it is not the content stored in a cell.

Correct answer: D. It helps store, calculate, and analyze data efficiently

★ Key Takeaway: Excel is a practical tool for real-world data tasks.

Explanation: Excel is used for budgets, tracking, reporting, and basic analysis because it can organize data clearly and automate calculations with formulas and functions.

Why other options are incorrect:

• A. It replaces email software – Email tools are for communication; Excel is for working with data.
• B. It is mainly for graphic design – Graphic design requires design tools; Excel is built for spreadsheets and calculations.
• C. It works only for students – Excel is used by professionals across industries, not only students.