MS Excel Quiz

What is the purpose of MS Excel?

• Data analysis

• Word processing

• Email communication

• Graphic design

Where can you find the Ribbon in MS Excel?

• On the left side of the window

• On the right side of the window

• At the bottom of the window

• At the top of the window

What is the file extension for MS Excel workbooks?

• .docx

• .xlsx

• .pdf

• .pptx

How can you close a file in MS Excel?

• Shut down the computer

• Click on the X button at the top right corner

• Go to the File tab and select Close

• Press Ctrl + S

What is the purpose of creating a profile in MS Excel?

• To watch videos

• To organize data

• To send emails

• To play games

What is the shortcut to insert a new worksheet in MS Excel?

• Ctrl + N

• Ctrl + W

• Ctrl + Shift + N

• Ctrl + Shift + W

Where can you change the page orientation in MS Excel?

• In the Home tab

• In the Insert tab

• In the Page Layout tab

• In the Formulas tab

What is the function of the VLOOKUP formula in MS Excel?

• To find and return values from a vertical lookup table

• To calculate the sum of a range of cells

• To create a virtual lookup table

• To validate data in a cell

What is the purpose of using conditional formatting in MS Excel?

• To change the font style

• To highlight specific data based on certain conditions

• To create a new worksheet

• To insert a new row

Where can you find the Sort and Filter options in MS Excel?

• In the Home tab

• In the Insert tab

• In the Data tab

• In the Review tab