Excel Practice Test

โ–ถ

Creating a spreadsheet in Excel is one of the most practical skills you can pick up on a computer. Whether you're tracking a household budget, managing a project timeline, building an inventory list, or analyzing sales numbers, Excel gives you a grid-based workspace where every cell can hold data, a formula, or a label. The result is a living document that calculates, sorts, and displays information dynamically โ€” far more powerful than a paper list or a plain text file. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).

This guide walks you through the complete process: opening Excel and starting a new workbook, naming your spreadsheet, entering and organizing data, formatting cells for clarity, writing basic formulas, and saving and sharing your file. You'll also learn a few features that separate a rough first draft from a clean, professional spreadsheet that's easy for others to read and use. By the end, you'll have the confidence to create a new spreadsheet from scratch for any purpose.

Excel's interface can look overwhelming at first glance โ€” ribbons of buttons, dozens of tabs, thousands of cells stretching off the screen. But the core workflow is simple. Most people creating their first spreadsheet use fewer than twenty of Excel's hundreds of functions. Start with what you need, build from there. Complexity is optional; the basics work for a very wide range of tasks.

Even if you've never opened a spreadsheet before, the fundamental structure is intuitive once you understand the grid. Think of rows as records โ€” one row per item, one row per transaction, one row per person โ€” and columns as attributes โ€” one column per piece of information about each record. A row in an expense tracker holds one expense.

The columns for that row tell you the date, the category, the amount, and the vendor. This row-column structure is the same logic that underlies every database, every table in a report, and every data export you'll ever encounter. Learning to build clean Excel spreadsheets teaches you the mental model that makes all data work more legible.

The good news is you don't need to know Excel deeply before you start. You'll learn the most important 20% of features in the first hour of real use. The rest โ€” pivot tables, Power Query, complex nested formulas โ€” are valuable but entirely optional for most everyday purposes. This guide focuses squarely on that productive 20%: everything you need to build a spreadsheet that actually works and that you can share with confidence.

Excel is available as a desktop application included in Microsoft 365, as a standalone purchase, and as a free browser-based version at office.com. This guide applies to all versions, though the exact location of some menu items varies slightly between Excel for Windows, Excel for Mac, and Excel Online. The core workflow โ€” open, enter data, format, formulate, save โ€” is identical across all three.

Microsoft Excel: upcoming dates and official changes
  • Updated Nov 22, 2026: Exam fee is now $104 per MOS exam voucher (previously $104 per exam voucher (US Certiport Store)).
  • Updated Nov 22, 2026: Retake fee is now $120 for an exam voucher with one retake (previously $120 for exam voucher with one retake).
  • Updated Nov 22, 2026: Delivery is now Proctored, live-in-the-application exam (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).

Facts verified Nov 22, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Facts verified Nov 22, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Microsoft Excel Exam at a Glance

ItemDetailOfficial source
Number of questions (Excel (Microsoft 365 Apps))33-37 questionscertiport.pearsonvue.com
Time limit50 minutes (60 minutes seat time)Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Exam fee$104 per MOS exam voucherstore.certiport.com
Retake fee$120 for an exam voucher with one retakestore.certiport.com
Validity5 yearscertiport.pearsonvue.com
RenewalRenewal assessment extends certification by 3 years; available from March 2030certiport.pearsonvue.com
DeliveryProctored, live-in-the-application examMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Delivery (Excel Associate (MO-210))Proctored; students and educators schedule through CertiportMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
EligibilityAbout 150 hours of instruction and hands-on experience recommendedMicrosoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business
Score releaseScore report provided on completion; also in Certiport profilecertiport.pearsonvue.com

Facts verified Nov 22, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

Fastest way to start: Press Ctrl+N (Windows) or Cmd+N (Mac) to open a new blank workbook instantly. Then click a cell and start typing. You can always format, label, and organize later โ€” getting data into cells is always the first step.

Open Microsoft Excel from your Start menu, Dock, or desktop shortcut. When Excel opens, you'll see a Start screen with recent files and template options. Click Blank Workbook to open a fresh, empty spreadsheet. You'll see a grid of columns labeled A, B, C across the top and rows numbered 1, 2, 3 down the side. Each intersection of a column and row is a cell, identified by its address โ€” A1 is the top-left cell, B3 is the cell in column B, row 3, and so on.

Before entering any data, it helps to plan your layout. Decide what the spreadsheet is for and sketch the columns you'll need. A simple budget spreadsheet might have columns for Date, Category, Description, and Amount. A project tracker might have Task, Owner, Start Date, Due Date, and Status. Naming your columns first โ€” in row 1, using bold text โ€” creates a header row that makes the spreadsheet immediately readable.

Click cell A1 and type your first column header. Press Tab to move to B1 and type the next header. Continue across row 1 until all your headers are in place. Then click cell A2 to start entering data in the first data row. You can navigate with arrow keys, Tab (right), or Enter (down). Each cell holds one piece of information โ€” one date, one number, one label. Resist the temptation to put multiple data points in a single cell, as this breaks sorting and filtering later.

One of the most useful features to add once your data is in place is data validation, which lets you control what users can enter into specific cells. The most common form of this is an excel drop down list, where clicking a cell presents a menu of preset options rather than requiring free-text entry. Drop-down lists are especially valuable in shared spreadsheets โ€” they prevent typos and ensure consistent entries across hundreds of rows.

Keyboard shortcuts speed up data entry enormously once you learn them. Ctrl+C copies, Ctrl+V pastes, Ctrl+Z undoes, and Ctrl+Y redoes. Ctrl+Shift+End jumps to the last used cell in the spreadsheet, which helps you quickly assess the extent of your data. F2 puts the selected cell into edit mode, so you can modify a cell's contents without deleting and retyping. These shortcuts become muscle memory within a day of regular use and make the difference between feeling fast and feeling like you're fighting the software.

When working with a how to create a drop down list in excel in your spreadsheet, remember to build the list of valid options in a separate section or worksheet before setting up the validation rule. Keeping your dropdown options in a named range on a hidden sheet is a clean professional practice โ€” it keeps the main data sheet uncluttered and makes it easy to update the options later by editing just one place.

Four Ways to Start a New Excel Spreadsheet

๐Ÿ”ด Blank Workbook

The most flexible option. Start with an empty grid and build exactly what you need. Best for custom layouts where no template matches your purpose.

๐ŸŸ  Built-In Template

Excel includes dozens of pre-formatted templates: budgets, calendars, invoices, timesheets. Go to File > New and search the template gallery. Templates come with formulas already set up.

๐ŸŸก Excel Online (Free)

Create spreadsheets in a browser at office.com with no software installation. Stores files in OneDrive automatically. Ideal for shared collaboration in real time.

๐ŸŸข From Existing File

Open a previous spreadsheet and save it under a new name (File > Save As). Reuse the structure and formulas from a file that's already working. Good for recurring monthly or weekly reports.

Formatting turns a raw grid of numbers and text into something readable. Select a range of cells by clicking and dragging, then use the Home tab's formatting tools to change font size, apply bold or italic, adjust text alignment, or fill cells with color. For header rows, bold text and a light-colored background (Format > Fill Color) creates a clear visual separation between labels and data.

Cell formatting also controls how numbers are displayed. A number like 45678 looks much clearer as $45,678.00 when formatted as currency, or as 45,678 when formatted as a number with a thousands separator. Select the cells containing numbers, right-click, choose Format Cells, and pick the number format that matches your data. Dates have their own formats โ€” 5/7/2026 or May 7, 2026 โ€” controlled the same way. Getting number formats right before you write formulas prevents confusing results later.

Column widths and row heights are easy to adjust. Hover over the dividing line between two column headers (the letters at the top) until your cursor becomes a double-headed arrow, then drag to resize. Double-clicking that divider auto-fits the column to the widest content in it. You can also right-click a column letter and choose Column Width to type an exact value. Keep column widths consistent enough that the spreadsheet looks balanced when printed or shared as a PDF.

To add a how to create a drop down list in excel to your spreadsheet, select the cells where you want the drop-down, go to Data > Data Validation, set Allow to "List," and type your options separated by commas or reference a range of cells. This feature is powerful for status columns (Open/In Progress/Done), category fields, or any column where only a fixed set of values makes sense. Drop-down validation prevents errors and standardizes data entry across your team.

Borders help readers follow rows across wide spreadsheets without losing their place. Select your data range and use Home > Font > Borders to add lines between rows or around specific cells. A simple bottom border under the header row and outer borders around the entire data range gives a clean, professional appearance. Avoid overdoing it โ€” too many borders make a spreadsheet look cluttered rather than organized.

Text wrapping is useful in description or notes columns where content is longer than the column width. Select those cells and click Home > Alignment > Wrap Text. The row height adjusts automatically to show all the text. Pair this with a fixed column width (about 40 characters is readable) to prevent any single column from overwhelming the layout. For columns with short, consistent entries โ€” like a status field with values like Yes/No or Done/Pending โ€” narrow columns with centered text look cleaner.

Consistent number formatting is especially important when your spreadsheet will be used to make decisions. A column of dollar amounts formatted inconsistently โ€” some as plain numbers, some as currency, some with extra decimal places โ€” creates unnecessary confusion and undermines trust in the data. Select the entire column, apply a single format, and stick with it. Consistency signals that whoever built this spreadsheet pays attention to detail, which matters when the spreadsheet represents your work professionally.

Many readers pair this guide with the excel co-authoring in real time to check their readiness before exam day.

Many readers pair this guide with the excel linear regression to check their readiness before exam day.

Many readers pair this guide with the microsoft excel free download to check their readiness before exam day.

Key Skills for Building Better Spreadsheets

๐Ÿ“‹ Entering & Organizing Data

Good data entry habits at the start save hours of cleanup later. Keep each type of information in its own column โ€” never merge "First Name" and "Last Name" into one cell, because you can't sort by last name if they're combined. Keep each record in its own row. Don't leave blank rows between records; Excel's sort and filter tools work best on a continuous block of data.

Use Freeze Panes (View > Freeze Panes > Freeze Top Row) to keep your header row visible as you scroll down. If your spreadsheet has dozens or hundreds of rows, this alone saves constant scrolling up to remember what each column means. You can also freeze the left column to keep row labels visible while scrolling right.

Convert your data range to a Table (Insert > Table or Ctrl+T) for built-in filtering, automatic formatting, and easier formula references. Tables automatically expand when you add new rows โ€” formulas in table columns replicate themselves without any copy-paste. Named table columns like "=Table1[Amount]" are also much easier to read than "=$D$2:$D$200."

๐Ÿ“‹ Formulas & Calculations

Every formula in Excel starts with an equals sign. Type =SUM(B2:B10) to add up cells B2 through B10. Type =AVERAGE(C2:C20) to find the mean. Type =MAX(D2:D100) or =MIN(D2:D100) to find the highest or lowest value. These five functions โ€” SUM, AVERAGE, MAX, MIN, COUNT โ€” cover the majority of everyday calculation needs.

For conditional calculations, =SUMIF(B:B,"Food",C:C) sums all values in column C where column B says "Food." This is how you build a budget summary that totals spending by category. =COUNTIF(E:E,"Done") counts how many rows in column E say "Done" โ€” perfect for tracking project completion. These functions work on full columns, so they automatically include new rows as you add them.

Cell references in formulas can be relative (adjust when copied) or absolute (stay fixed). Put a dollar sign before the column and/or row to make it absolute: $B$1 always refers to cell B1 no matter where you paste the formula. This matters when you're referencing a fixed rate, a tax percentage, or a lookup value that every row in the spreadsheet should use.

๐Ÿ“‹ Saving, Sharing & Printing

Save your workbook with Ctrl+S (Windows) or Cmd+S (Mac). The first time, Excel asks you to choose a location and name. Save as .xlsx (the default modern format) for full feature compatibility. If someone needs to open the file in an older version of Excel or in another spreadsheet program, .xlsx works fine. Only save as .xls if specifically asked for legacy compatibility.

To share via OneDrive or SharePoint, click File > Share and choose the sharing method. Cloud-saved spreadsheets let multiple users edit simultaneously, with each person's cursor visible in real time. You can also attach the file as an email attachment directly from File > Share > Email.

Before printing, go to File > Print to preview the layout. Use Page Layout > Page Setup to set margins, orientation (landscape often works better for wide spreadsheets), and scaling. "Fit Sheet on One Page" shrinks the spreadsheet to fit the paper โ€” useful for short summaries. For longer spreadsheets, set a print area (Page Layout > Print Area > Set Print Area) to print only the section you need.

Excel by the Numbers

1,048,576
Max rows per worksheet
16,384
Max columns per worksheet
500+
Built-in functions available
~1.1 billion
Excel users worldwide
Limited by RAM
Max worksheets per workbook
1985
Year Excel was first released

Once your spreadsheet is in good shape, there are several features worth exploring to make it more powerful. Conditional formatting (Home > Conditional Formatting) automatically changes cell colors based on values โ€” highlighting cells above a threshold in red, or color-coding a status column so Done rows appear green. This visual layer makes patterns in data immediately obvious without sorting or filtering. A budget where over-budget items automatically turn red is far more actionable than a plain grid of numbers.

Charts and graphs are built directly from spreadsheet data. Select the cells you want to visualize, go to Insert, and choose a chart type. Bar charts, line charts, and pie charts are most commonly used for basic data. Excel previews several chart types before you commit, so it's easy to compare options. Once inserted, a chart updates automatically when the underlying data changes โ€” ideal for dashboards and monthly reports that need to reflect new numbers without manual redesign.

Named ranges make formulas easier to read and manage. Instead of writing =SUM(D2:D200), you can name that range "MonthlyExpenses" and write =SUM(MonthlyExpenses). Go to Formulas > Name Manager to create and manage named ranges. This is especially useful in workbooks with multiple sheets where formulas cross-reference data from one sheet to another. A formula like =Sheet2!MonthlyBudget-Sheet1!MonthlyExpenses is far easier to debug than one built entirely of cell addresses.

If your spreadsheet will be filled in by others, consider adding a how to add drop down list in excel to columns that should only accept specific values. This technique, combined with cell protection (Review > Protect Sheet) that locks your formula cells while leaving data-entry cells editable, creates a spreadsheet that guides users toward correct input rather than hoping they enter data correctly. Well-protected, validated spreadsheets produce clean data sets that are reliable for analysis.

When your spreadsheet is complete, a final review catches common issues before you share it: confirm all formulas are calculating correctly, check that no data is hidden in filtered rows, verify that column headers are in row 1 (not row 2 or 3, which breaks some Excel features), and make sure no cells contain formula errors like #REF! or #VALUE!. The Formula > Error Checking tool scans the workbook automatically. A clean spreadsheet with consistent formatting and validated data is one of the most transferable professional deliverables you can produce.

Excel Spreadsheet Quality Checklist

Headers are bold and in row 1 โ€” not row 2 or 3
Number columns are formatted as currency, date, or number (not plain text)
No merged cells in the data range (they break sorting and filtering)
Formulas reference cell ranges, not hardcoded values that will go stale
Drop-down validation added to columns that accept only specific values
File saved with a clear, descriptive name including a version or date

Version control is a practical concern for any spreadsheet that multiple people edit over time. Excel doesn't have built-in version history in the same way Google Sheets does, unless the file is saved to OneDrive or SharePoint. If you're passing files by email, maintain a naming convention like Budget_v1.xlsx, Budget_v2.xlsx to keep older copies accessible. For high-stakes spreadsheets โ€” financial models, project trackers, data submissions โ€” saving a dated copy before making major changes is a simple safeguard against accidental data loss.

Finally, consider who will use this spreadsheet after you. A well-documented spreadsheet includes a brief notes sheet explaining the structure, any assumptions behind formulas, and where data comes from. Even a few comments (right-click a cell > Insert Comment) explaining a complex formula or a non-obvious value can save the next person hours of confusion. Spreadsheets that outlive their creators are a staple of office life โ€” designing yours to be understood by future users is a mark of professional quality that sets your work apart.

Testing your spreadsheet before sharing it is a step most beginners skip but experienced users always take. Enter a few rows of known test data and verify that every formula produces the expected result. Try edge cases: what happens if a cell is left empty? Does the formula show zero, an error, or something unexpected?

What if a value is negative? A formula that works for 100 rows of normal data may break on the 101st row with unusual input. A brief test pass before you hand over the file prevents the embarrassing scenario of discovering a formula error after someone has made a decision based on it.

Sorting and filtering are two features every spreadsheet creator needs to know. Select any cell in your data range and go to Data > Sort to rearrange rows by any column โ€” alphabetically, numerically, by date, ascending or descending. Add a filter (Data > Filter) to show only rows matching specific criteria: all expenses above $500, all tasks assigned to one person, all entries from a particular month. Filtering doesn't delete data โ€” it just hides rows that don't match, so the full data is always one click away when you clear the filter.

Test Your Excel KnowledgeExcel Formulas Practice Quiz

Excel vs. Google Sheets for Creating Spreadsheets

Pros

  • Excel handles larger datasets with better performance than Google Sheets
  • More advanced formula options and Power Query for data transformation
  • Better offline functionality โ€” full features without internet access
  • Widely used in professional environments, especially finance and operations
  • Richer formatting and charting options for polished presentations

Cons

  • Requires a Microsoft 365 subscription or one-time purchase for full features
  • Real-time collaboration less seamless than Google Sheets in browser
  • Files can become corrupt or lose formatting when shared across different Excel versions
  • Learning curve steeper than Google Sheets for new users
  • Mobile version has significant feature limitations compared to desktop

Pros and Cons at a Glance

ProsCons
Excel handles larger datasets with better performance than Google SheetsReal-time collaboration less seamless than Google Sheets in browser
More advanced formula options and Power Query for data transformationFiles can become corrupt or lose formatting when shared across different Excel versions
Better offline functionality โ€” full features without internet accessLearning curve steeper than Google Sheets for new users
Widely used in professional environments, especially finance and operationsMobile version has significant feature limitations compared to desktop
โŒจ๏ธ โŒจ๏ธ What is the fastest way to open a new blank workbook in Excel?
Press Ctrl+N on Windows or Cmd+N on Mac to open a new blank workbook instantly, then click a cell and start typing โ€” formatting and labels can always come later.
๐Ÿ”  ๐Ÿ”  How are cells identified in an Excel spreadsheet?
Every cell has an address made of its column letter and row number โ€” A1 is the top-left cell, B3 is column B, row 3. This addressing is how formulas and functions reference data.
๐Ÿ“‹ ๐Ÿ“‹ What is the first step when creating a basic Excel spreadsheet from scratch?
Plan your columns before entering data, then type headers across row 1 in bold โ€” for example Date, Category, Description, Amount for a budget tracker. A clear header row makes the sheet readable immediately.
๐Ÿ”’ ๐Ÿ”’ What does converting a data range to a Table (Ctrl+T) give you?
Built-in filtering, automatic formatting, and formulas that expand automatically as new rows are added. Named table columns like Table1[Amount] are also easier to read than cell ranges like $D$2:$D$200.
โž— โž— Which five functions cover most everyday Excel calculations?
SUM, AVERAGE, MAX, MIN, and COUNT handle the majority of basic spreadsheet math. SUMIF and COUNTIF add conditional logic, such as totaling spending by category.
๐Ÿ”ฝ ๐Ÿ”ฝ How do you add a drop-down list to a cell in Excel?
Select the cells, go to Data > Data Validation, set Allow to "List," then type comma-separated options or reference a range. Drop-downs prevent typos and keep data entry consistent across a shared sheet.
๐Ÿ“Œ ๐Ÿ“Œ What does Freeze Panes do in a long Excel spreadsheet?
View > Freeze Panes > Freeze Top Row keeps your header row visible while you scroll through hundreds of rows, so you never lose track of what each column means.
๐Ÿ’พ ๐Ÿ’พ What file format should you save a new Excel spreadsheet in?
.xlsx is the modern default format with full feature compatibility across current versions of Excel. Only use the legacy .xls format if someone specifically needs it for an older program.
๐ŸŽจ ๐ŸŽจ How can you make a new spreadsheet look more professional right away?
Bold the header row with a light fill color, format numbers as currency or dates instead of plain numbers, keep column widths consistent, and remove gridlines before printing (View > Show > uncheck Gridlines).
๐ŸŒ ๐ŸŒ Can you create an Excel spreadsheet for free without installing software?
Yes โ€” Excel Online at office.com is free with a Microsoft account, runs in your browser, and saves files automatically to OneDrive. It covers formulas, formatting, and basic data entry.

Official Resources

Sample Excel Practice Questions

Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.

  1. Which of the following is NOT a valid cell reference style in Excel?

    • A. A1
    • B. R1C1
    • C. AA100
    • D. 1A

    Answer: D. 1A

    Cell references in the A1 style must begin with the column letter(s) followed by the row number.

  2. Which of the following is a primary characteristic of a Waterfall chart in Excel?

    • A. It displays data points as a percentage of a whole, represented by slices.
    • B. It shows the cumulative effect of a series of positive and negative values on an initial starting value.
    • C. It is used to plot data using two value axes to show the relationship between sets of data.
    • D. It represents data as tiny charts embedded within individual cells.

    Answer: B. It shows the cumulative effect of a series of positive and negative values on an initial starting value.

    A Waterfall chart (also known as a bridge chart) is specifically designed to show how a starting value is increased or decreased by a series of subsequent values, showing a running total. This makes it very useful for financial analysis, such as visualizing the components of a profit and loss statement.

  3. In Excel, the shortcut key Ctrl + D will

    • A. Apply double underline for the active cell
    • B. Fill down in the selection
    • C. Open the font dialog box

    Answer: B. Fill down in the selection

    Ctrl + D fills the cell beneath with the contents of the selected cell in column. To fill more than one cell, select the source cell and press Ctrl+Shift+Down to select all cells. Then press Ctrl+D to fill them with the contents of the original cell.

  4. What is the main difference between a PivotChart and a standard Excel chart?

    • A. A PivotChart cannot display a legend
    • B. A PivotChart is linked to a PivotTable and updates as fields change
    • C. A PivotChart only supports pie charts
    • D. A PivotChart cannot be formatted

    Answer: B. A PivotChart is linked to a PivotTable and updates as fields change

    PivotCharts are bound to PivotTable data and include interactive field buttons.

Take the full Excel practice test

How to Create a Spreadsheet Questions and Answers

How do I create a spreadsheet in Excel for beginners?

Open Excel, click Blank Workbook, and click cell A1. Type your first column header, press Tab to move to the next column, and continue across row 1. Then click A2 to start entering data. Use bold text for headers, format number cells as currency or dates as needed, and press Ctrl+S to save. That's the complete basic process.

How do I create a spreadsheet in Excel from a template?

Open Excel and go to File > New (on a Mac, File > New from Template). Browse the featured templates or type a keyword such as budget, invoice, or calendar into the search box, pick a template, and click Create. Excel opens a new workbook with headers, formulas, and formatting already set up. Replace the sample data with your own and save it under a new file name.

What is the difference between a workbook and a spreadsheet in Excel?

A workbook is the entire Excel file โ€” the .xlsx file you open, save, and send. A spreadsheet (or worksheet) is one tab within that workbook. A single workbook can contain multiple worksheets โ€” Sheet1, Sheet2, Sheet3 โ€” accessible via the tabs at the bottom of the screen. Most people use these terms interchangeably in everyday conversation.

How do I add a formula to my Excel spreadsheet?

Click an empty cell where you want the result, type an equals sign (=), then type your formula. For example, =SUM(B2:B10) adds all values in cells B2 through B10. =A2*B2 multiplies the values in A2 and B2. Press Enter to confirm. Excel recalculates the result automatically whenever the referenced cells change.

How do I make my spreadsheet look professional?

Apply consistent formatting: a bold header row with a light fill color, right-aligned numbers, left-aligned text, even column widths, and number formats (currency, dates) that match your data. Format as Table (Ctrl+T) adds banded rows for readability. To hide gridlines on screen, uncheck View > Gridlines; they do not print unless you turn on Page Layout > Gridlines > Print. Keep one font throughout.

How do I save an Excel spreadsheet, and which file format should I use?

Press Ctrl+S (Cmd+S on a Mac), choose a location such as OneDrive or a folder on your computer, type a file name, and click Save. Use the default .xlsx format, Excel's standard since Excel 2007, which keeps every sheet, formula, and format. Choose .xlsm only if the workbook contains macros, and .csv only to export plain data, because CSV saves just the active sheet without formatting.

Can I create a spreadsheet in Excel for free?

Yes. Excel for the web (formerly Excel Online) is free with a Microsoft account at office.com. It runs in your browser, saves files to OneDrive automatically, and handles data entry, formulas, charts, and basic formatting. It cannot run or edit VBA macros and offers fewer advanced data tools than the desktop app, but for creating and editing an everyday spreadsheet it works well.

How do I share an Excel spreadsheet with others?

Save the file to OneDrive or SharePoint, then click Share in the top-right corner. Enter email addresses and choose whether people can edit or only view. Collaborators can then edit the same file at the same time in Excel for the web or the desktop app. To send a separate copy instead, attach the file to an email; recipients' changes will not affect your original.

How many questions are on the Microsoft Excel?

The Microsoft Office Specialist Excel exam (Microsoft 365 Apps) has 33-37 questions. (Verified Nov 22, 2026 against certiport.pearsonvue.com.)

How long is the Microsoft Excel?

The Microsoft Office Specialist Excel exam gives candidates 50 minutes to complete it, with 60 minutes of seat time. (Verified Nov 22, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business.)

How much does the Microsoft Excel cost?

A Microsoft Office Specialist (MOS) exam voucher costs $104.00 in the US Certiport Store. (Verified Nov 22, 2026 against store.certiport.com.)
โ–ถ Start Quiz