Excel Functions and Features

This video tutorial by Miguel Vela on the Tio Tech channel introduces the basics of Excel, covering its capabilities, installation, and navigation. It explains the Excel interface, including how to create, save, and print documents. The tutorial also covers basic mathematical operations such as addition, subtraction, multiplication, and division, providing practical examples and tips for efficient data management.

What is one of the primary uses of Excel as mentioned in the introduction?

• Performing accounting tasks

• Creating video games

• Editing photos

• Designing websites

Which of the following is NOT a method to open Excel?

• Double-clicking the Excel icon on the desktop

• Using the Excel voice command

• Using the Windows search bar

• Pressing Windows + R and typing 'excel'

What are the horizontal and vertical lines in Excel called?

• Rows and Columns

• Grids and Columns

• Sheets and Pages

• Cells and Grids

How can you change the color of a sheet tab in Excel?

• Right-click the tab and select 'Change Color'

• Use the 'Format' menu to select 'Tab Color'

• Double-click the tab and type a color name

• Go to the 'View' tab and select 'Color'

What is the first step to perform a basic addition operation in Excel?

• Type an equal sign followed by the numbers

• Type the numbers directly into the cell

• Use the 'Insert' tab to add numbers

• Select the 'Add' function from the menu

Which function is used to sum a range of cells in Excel?

• TOTAL

• ADD

• SUM

• COMBINE

How can you ensure a cell reference remains constant when copying a formula?

• Use a percentage (%) before the column and row

• Use an asterisk (*) before the cell reference

• Use a hashtag (#) before the cell reference

• Use a dollar sign ($) before the column and row

What is the symbol used for multiplication in Excel formulas?

• #

• *

• x

• &

Which of the following is a correct way to format numbers as currency in Excel?

• Select the cells and choose 'Currency' from the 'Format' menu

• Type '$' before each number

• Use the 'Insert' tab to add currency symbols

• Select 'Currency' from the 'Data' tab

What is the purpose of using parentheses in Excel formulas?

• To create a new sheet

• To highlight cells

• To change the order of operations

• To add comments