Excel Basics Quiz

Who are the inventors of the first electronic spreadsheet, VisiCalc?

• Bill Gates and Paul Allen

• Dan Bricklin and Bob Frankton

• Steve Jobs and Steve Wozniak

• Mark Zuckerberg and Eduardo Saverin

What is the primary purpose of a spreadsheet?

• To store large amounts of text data

• To organize data in rows and columns

• To edit images

• To send emails

Which of the following is an example of a spreadsheet program?

• Microsoft Word

• Microsoft Excel

• Adobe Photoshop

• Mozilla Firefox

What is the number of rows in an Excel 2007 worksheet?

• 1,048,576

• 256

• 512,000

• 10,000

Which key can you press to move to the next cell in the same row when entering data in Excel?

• Shift

• Enter

• Tab

• Space

What is the function of the "Fill Handle" in Excel?

• To create new worksheets

• To copy a cell’s contents to adjacent cells or to create a series

• To insert a column

• To delete a row

Which option allows you to edit data in a cell in Excel?

• Double-click the cell

• Press the Delete key

• Right-click and select "Edit"

• Click the Formula bar

How can you format data in MS-Excel?

• By changing fonts and colors

• By adding more rows

• By deleting columns

• By saving the workbook

What is the first step in inserting a column in MS-Excel?

• Click Insert → Column

• Select the cell before which you want to insert the column

• Right-click and select Insert

• Type "Insert" in the Formula bar

What happens when you delete a row in Excel?

• The row is permanently removed

• The row is replaced with a blank row

• The data from the row is moved up

• The row becomes hidden