IT App

What is the purpose of spreadsheet applications?

• To play games

• To chat with friends

• To organize and track large quantities of business data

• To watch movies

What is the difference between workbook and worksheet?

• Workbook is a collection of worksheets, while worksheet is a single sheet within a workbook

• Workbook is for beginners, while worksheet is for advanced users

• Workbook is used for calculations, while worksheet is used for data storage

• Workbook is for text, while worksheet is for numbers

Which of the following is a mathematical operator in Excel?

• # (Hashtag)

• $ (Currency)

• & (Concatenation)

• + (Addition)

What are functions in Excel?

• Graphical elements

• Text entries

• Built-in formulas

• User-created formulas

What is Relative Cell Referencing in Excel?

• Cell references that are absolute in nature

• Cell references that change automatically based on the relative position of rows and columns

• Cell references that remain constant when copied across multiple cells

• Cell references that are not linked to any other cells

What is Absolute Cell Referencing in Excel?

• Cell references that change automatically based on the relative position of rows and columns

• Cell references that are not linked to any other cells

• Cell references that remain constant when copied across multiple cells

• Cell references that are relative in nature

How can you save a worksheet in Excel?

• Go to Edit menu and choose Save

• Go to File menu and choose Save As

• Go to View menu and choose Save

• Go to Format menu and choose Save

What is the purpose of the Quick Access Toolbar in Excel?

• To play music while working

• To change the color scheme of the worksheet

• To access the internet quickly

• To assist the user in quickly performing certain tasks

What does the Status Bar in Excel show?

• The latest news updates

• The status of certain selected tasks

• The weather forecast

• The user's social media notifications

What is the purpose of the Layout Selector in Excel?

• To insert images into the worksheet

• To change the font style

• To provide options for the document layout to be shown on screen

• To create animations in the worksheet